Queue Error

[luke-]

Probably during installer, following error is logged.

Info  Sun, 12 Jan 2025 13:49:48 +0100 application
$_GET = []

$_SERVER = [
'HUMHUB_CONFIG__RUNTIME_PATH' => '/var/www/html/protected/runtime'
'HUMHUB_CONFIG__COMPONENTS__SESSION__CLASS' => 'yii\\redis\\Session'
'HUMHUB_CONFIG__PARAMS__MODULE_AUTOLOAD_PATHS' => '[\"/var/lib/humhub/modules-custom\"]'
'SUPERVISOR_GROUP_NAME' => 'humhub-worker'
'HOSTNAME' => 'a6f98df68b80'
'SHLVL' => '1'
'HOME' => '/root'
'OLDPWD' => '/opt/humhub'
'HUMHUB_CONFIG__MODULES__MARKETPLACE__MODULE_BLACKLIST' => '[\"updater\"]'
'LC_CTYPE' => 'C.UTF-8'
'HUMHUB_FIXED_SETTINGS__BASE__CACHE_CLASS' => 'yii\\redis\\Cache'
'HUMHUB_CONFIG__COMPONENTS__REDIS__PORT' => '6379'
'HUMHUB_CONFIG__COMPONENTS__DB__USERNAME' => 'root'
'_' => '/usr/bin/php'
'HUMHUB_ALIASES__HUMHUB' => '/var/www/html/protected/humhub'
'HUMHUB_CONFIG__COMPONENTS__REDIS__DATABASE' => '0'
'HUMHUB_FIXED_SETTINGS__BASE__BASE_URL' => 'https://static.239.196.235.167.clients.your-server.de'
'HUMHUB_ALIASES__APP' => '/var/www/html/protected'
'HUMHUB_CONFIG__COMPONENTS__URL_MANAGER__ENABLE_PRETTY_URL' => 'true'
'PATH' => '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin'
'HUMHUB_CONFIG__COMPONENTS__REDIS__HOSTNAME' => 'redis'
'HUMHUB_CONFIG__COMPONENTS__URL_MANAGER__SHOW_SCRIPT_NAME' => 'false'
'HUMHUB_CONFIG__COMPONENTS__REDIS__CLASS' => 'yii\\redis\\Connection'
'HUMHUB_WEB_CONFIG__COMPONENTS__REQUEST__TRUSTED_HOSTS' => '[\"0.0.0.0/0\"]'
'SUPERVISOR_ENABLED' => '1'
'HUMHUB_CONFIG__COMPONENTS__DB__DSN' => 'mysql:host=db;dbname=humhub'
'HUMHUB_ALIASES__WEBROOT' => '/var/www/html'
'SUPERVISOR_PROCESS_NAME' => 'humhub-worker_01'
'PWD' => '/var/www/html'
'HUMHUB_DEBUG' => 'false'
'HUMHUB_CONFIG__COMPONENTS__DB__PASSWORD' => '***'
'HUMHUB_CONFIG__MODULES__INSTALLER__ENABLE_AUTO_SETUP' => 'true'
'HUMHUB_ALIASES__CONFIG' => '/var/www/html/protected/config'
'PHP_SELF' => '/var/www/html/protected/yii'
'SCRIPT_NAME' => '/var/www/html/protected/yii'
'SCRIPT_FILENAME' => '/var/www/html/protected/yii'
'PATH_TRANSLATED' => '/var/www/html/protected/yii'
'DOCUMENT_ROOT' => ''
'REQUEST_TIME_FLOAT' => 1736686188.5231
'REQUEST_TIME' => 1736686188
'argv' => [
0 => '/var/www/html/protected/yii'
1 => 'queue/exec'
2 => '1'
3 => '300'
4 => '1'
5 => '114'
6 => '--verbose=1'
7 => '--color=0'
]
'argc' => 8
]
[ Collapse](http://static.239.196.235.167.clients.your-server.de/admin/logging#)
Error  Sun, 12 Jan 2025 13:49:48 +0100 queue
Could not execute queued job! Message: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'state' in 'WHERE'
The SQL being executed was: SELECT * FROM `content` WHERE (`state`=20) AND (`scheduled_at` <= '2025-01-12 12:49:48') Trace:#0 /opt/humhub/protected/vendor/yiisoft/yii2/db/Command.php(1325): yii\db\Schema->convertException()
#1 /opt/humhub/protected/vendor/yiisoft/yii2/db/Command.php(1186): yii\db\Command->internalExecute()
#2 /opt/humhub/protected/vendor/yiisoft/yii2/db/Command.php(417): yii\db\Command->queryInternal()
#3 /opt/humhub/protected/vendor/yiisoft/yii2/db/Query.php(249): yii\db\Command->queryAll()
#4 /opt/humhub/protected/vendor/yiisoft/yii2/db/ActiveQuery.php(133): yii\db\Query->all()
#5 /opt/humhub/protected/humhub/modules/content/jobs/PublishScheduledContents.php(29): yii\db\ActiveQuery->all()
#6 /opt/humhub/protected/humhub/modules/queue/ActiveJob.php(32): humhub\modules\content\jobs\PublishScheduledContents->run()
#7 /opt/humhub/protected/vendor/yiisoft/yii2-queue/src/Queue.php(243): humhub\modules\queue\ActiveJob->execute()
#8 /opt/humhub/protected/vendor/yiisoft/yii2-queue/src/cli/Queue.php(162): yii\queue\Queue->handleMessage()
#9 /opt/humhub/protected/vendor/yiisoft/yii2-queue/src/cli/Command.php(146): yii\queue\cli\Queue->execute()
#10 [internal function]: yii\queue\cli\Command->actionExec()
#11 /opt/humhub/protected/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array()
#12 /opt/humhub/protected/vendor/yiisoft/yii2/base/Controller.php(178): yii\base\InlineAction->runWithParams()
#13 /opt/humhub/protected/vendor/yiisoft/yii2/console/Controller.php(180): yii\base\Controller->runAction()
#14 /opt/humhub/protected/vendor/yiisoft/yii2/base/Module.php(552): yii\console\Controller->runAction()
#15 /opt/humhub/protected/vendor/yiisoft/yii2/console/Application.php(180): yii\base\Module->runAction()
#16 /opt/humhub/protected/vendor/yiisoft/yii2/console/Application.php(147): yii\console\Application->runAction()
#17 /opt/humhub/protected/vendor/yiisoft/yii2/base/Application.php(384): yii\console\Application->handleRequest()
#18 /var/www/html/protected/yii(38): yii\base\Application->run()
#19 {main}
[ Collapse](http://static.239.196.235.167.clients.your-server.de/admin/logging#)

[ArchBlood]

Seems related to a missing migration for state column in content, could be related to #1