BookStack icon indicating copy to clipboard operation
BookStack copied to clipboard

production.ERROR: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'action' in 'where clause'

Open ranjanmanishr opened this issue 8 months ago • 1 comments

Describe the Bug

2025-04-30 19:31:48] production.ERROR: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'action' in 'where clause' in /var/www/bookstack/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:67 Stack trace:

Details

#0 /var/www/bookstack/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(67): PDO->prepare('select count(*)...', Array)
#1 /var/www/bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php(331): Doctrine\DBAL\Driver\PDOConnection->prepare('select count(*)...')
#2 /var/www/bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php(662): Illuminate\Database\Connection->Illuminate\Database\{closure}('select count(*)...', Array)
#3 /var/www/bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php(629): Illuminate\Database\Connection->runQueryCallback('select count(*)...', Array, Object(Closure))
#4 /var/www/bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php(338): Illuminate\Database\Connection->run('select count(*)...', Array, {"exception":"[object] (Symfony\\Component\\Debug\\Exception\\FatalErrorException(code: 1): Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'action' in 'where clause' in /var/www/bookstack/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:67
Stack trace:
#0 /var/www/bookstack/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(67): PDO->prepare('select count(*)...', Array)
#1 /var/www/bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php(331): Doctrine\\DBAL\\Driver\\PDOConnection->prepare('select count(*)...')
#2 /var/www/bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php(662): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('select count(*)...', Array)
#3 /var/www/bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php(629): Illuminate\\Database\\Connection->runQueryCallback('select count(*)...', Array, Object(Closure))
#4 /var/www/bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php(338): Illuminate\\Database\\Connection->run('select count(*)...', Array, at /var/www/bookstack/vendor/laravel/framework/src/Illuminate/Database/Connection.php:669)
[stacktrace]

Steps to Reproduce

  1. load the home page

Expected Behaviour

page shud load

Screenshots or Additional Context

its not laoding

Browser Details

No response

Exact BookStack Version

not sure

ranjanmanishr avatar Apr 30 '25 19:04 ranjanmanishr

Hi @ranjanmanishr,

Please can you detail your scenario:

  • Is this a new installation? Or an upgrade?
  • What method of installation did you use?
  • What operating system is BookStack installed onto here?

ssddanbrown avatar Apr 30 '25 21:04 ssddanbrown

Since there's been no further follow-up I'm going to close this off.

ssddanbrown avatar Sep 03 '25 12:09 ssddanbrown