Report generation fails on SQLite

Created on 12 June 2023, over 1 year ago

I am running a local test server with site audit and it is failing:

The website encountered an unexpected error. Please try again later.

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[HY000]: General error: 1 no such table: information_schema.TABLES: SELECT SUM(ist.data_length + ist.index_length) AS "expression" FROM information_schema.TABLES "ist" WHERE "ist"."table_schema" = :db_condition_placeholder_0 GROUP BY "ist"."table_schema"; Array ( [:db_condition_placeholder_0] => database.sqlite ) in Drupal\site_audit\Plugin\SiteAuditCheck\DatabaseSize->calculateScore() (line 62 of modules/contrib/site_audit/src/Plugin/SiteAuditCheck/DatabaseSize.php).
Drupal\sqlite\Driver\Database\sqlite\Statement->getStatement() (Line: 181)
Drupal\Core\Database\StatementPrefetch->execute() (Line: 90)
Drupal\sqlite\Driver\Database\sqlite\Statement->execute() (Line: 765)
Drupal\Core\Database\Connection->query() (Line: 525)
Drupal\Core\Database\Query\Select->execute() (Line: 62)
Drupal\site_audit\Plugin\SiteAuditCheck\DatabaseSize->calculateScore() (Line: 273)
Drupal\site_audit\Plugin\SiteAuditCheckBase->getScore() (Line: 124)
Drupal\site_audit\Plugin\SiteAuditChecklistBase->__construct() (Line: 25)
Drupal\Core\Plugin\Factory\ContainerFactory->createInstance() (Line: 83)
Drupal\Component\Plugin\PluginManagerBase->createInstance() (Line: 83)
Drupal\site_audit\Controller\SiteAuditController->audit()
call_user_func_array() (Line: 123)
Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}() (Line: 580)
Drupal\Core\Render\Renderer->executeInRenderContext() (Line: 124)
Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->wrapControllerExecutionInRenderContext() (Line: 97)
Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}() (Line: 163)
Symfony\Component\HttpKernel\HttpKernel->handleRaw() (Line: 74)
Symfony\Component\HttpKernel\HttpKernel->handle() (Line: 58)
Drupal\Core\StackMiddleware\Session->handle() (Line: 48)
Drupal\Core\StackMiddleware\KernelPreHandle->handle() (Line: 106)
Drupal\page_cache\StackMiddleware\PageCache->pass() (Line: 85)
Drupal\page_cache\StackMiddleware\PageCache->handle() (Line: 48)
Drupal\Core\StackMiddleware\ReverseProxyMiddleware->handle() (Line: 51)
Drupal\Core\StackMiddleware\NegotiationMiddleware->handle() (Line: 51)
Drupal\Core\StackMiddleware\StackedHttpKernel->handle() (Line: 686)
Drupal\Core\DrupalKernel->handle() (Line: 19)
require('/home/jonpugh/Projects/ox/web/index.php') (Line: 46)

Checks should try/catch or handle SQLite databases.

πŸ› Bug report
Status

Active

Version

4.0

Component

Code

Created by

πŸ‡ΊπŸ‡ΈUnited States Jon Pugh Newburgh, NY

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Production build 0.71.5 2024