Watchdog flooded with PHP column not found messages

Created on 23 August 2021, over 3 years ago
Updated 15 April 2025, 9 days ago

After upgrading to the latest release, Watchdog is flooded with PHP error messages such as this one:

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'source' in 'field list': SELECT network, mask, status, source FROM cleantalk_sfw WHERE network IN (1509949440,1518338048,1522532352,1523056640,1523187712,1523253248,1523269632,1523277824,1523278848,1523279104,1523279232,1523279264,1523279272,1523279274,1523279275) AND network = 1523279275 & mask AND 83881 <> 0 ORDER BY status DESC; Array ( ) in Cleantalk\ApbctDrupal\DB->fetch_all() (line 78 of /public_html/modules/contrib/cleantalk/src/lib/Cleantalk/ApbctDrupal/DB.php)
#0 /public_html/core/lib/Drupal/Core/Database/Connection.php(665): Drupal\Core\Database\Connection->handleQueryException(Object(PDOException), 'SELECT\n\t\t\t\tnetw...', Array, Array)
#1 /public_html/core/lib/Drupal/Core/Database/Driver/mysql/Connection.php(357): Drupal\Core\Database\Connection->query('SELECT\n\t\t\t\tnetw...', Array, Array)
#2 /public_html/modules/contrib/cleantalk/src/lib/Cleantalk/ApbctDrupal/DB.php(78): Drupal\Core\Database\Driver\mysql\Connection->query('SELECT\n\t\t\t\tnetw...')
#3 /public_html/modules/contrib/cleantalk/src/lib/Cleantalk/Common/Firewall/Modules/SFW.php(93): Cleantalk\ApbctDrupal\DB->fetch_all('SELECT\n\t\t\t\tnetw...')
#4 /public_html/modules/contrib/cleantalk/src/lib/Cleantalk/Common/Firewall/Firewall.php(174): Cleantalk\Common\Firewall\Modules\SFW->check()
#5 /public_html/modules/contrib/cleantalk/src/EventSubscriber/BootSubscriber.php(204): Cleantalk\Common\Firewall\Firewall->run()
#6 /public_html/core/modules/ban/src/BanMiddleware.php(50): Drupal\cleantalk\EventSubscriber\BootSubscriber->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#7 /public_html/core/lib/Drupal/Core/StackMiddleware/ReverseProxyMiddleware.php(47): Drupal\ban\BanMiddleware->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#8 /public_html/core/lib/Drupal/Core/StackMiddleware/NegotiationMiddleware.php(52): Drupal\Core\StackMiddleware\ReverseProxyMiddleware->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#9 /vendor/stack/builder/src/Stack/StackedHttpKernel.php(23): Drupal\Core\StackMiddleware\NegotiationMiddleware->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#10 /public_html/core/lib/Drupal/Core/DrupalKernel.php(708): Stack\StackedHttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#11 /public_html/index.php(19): Drupal\Core\DrupalKernel->handle(Object(Symfony\Component\HttpFoundation\Request))
#12 {main}

🐛 Bug report
Status

Fixed

Version

9.1

Component

Miscellaneous

Created by

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

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

No activities found.

Production build 0.71.5 2024