Issue Specified column is not in the row

[S2W]

Server operating system version

ubuntu 22.04

Plesk version and microupdate number

18.0.59

Hello

for the last 3 days my server, which I haven't touched, has started to cause problems with wptoolkit and performance booster.

In WP toolkit it is impossible to display the list of plugins for all the sites on the server, and it is impossible to refresh a site.

PleskExt\WpToolkit\Db\Row\Vulnerability::getFingerprint(): Return value must be of type string, null returned
Could not update vulnerabilities database: Specified column "mitigations" is not in the row
An error occurred during full-update of vulnerability database: Specified column "mitigations" is not in the row
Failed to retrieve report data: PleskExt\WpToolkit\Db\Row\Vulnerability::getFingerprint(): Return value must be of type string, null returned
#0 /opt/psa/admin/plib/modules/wp-toolkit/library/Feature/Vulnerability/Provider/VulnerabilitiesProvider.php(123): PleskExt\WpToolkit\Db\Row\Vulnerability->getFingerprint()
#1 [internal function]: PleskExt\WpToolkit\Feature\Vulnerability\Provider\VulnerabilitiesProvider:leskExt\WpToolkit\Feature\Vulnerability\Provider\{closure}(Object(PleskExt\WpToolkit\Db\Row\Vulnerability))
#2 /opt/psa/admin/plib/modules/wp-toolkit/library/Feature/Vulnerability/Provider/VulnerabilitiesProvider.php(123): array_map(Object(Closure), Array)
#3 /opt/psa/admin/plib/modules/wp-toolkit/library/Feature/Vulnerability/Provider/VulnerabilitiesProvider.php(97): PleskExt\WpToolkit\Feature\Vulnerability\Provider\VulnerabilitiesProvider->findByFingerprints(Array)
#4 /opt/psa/admin/plib/modules/wp-toolkit/library/Feature/Vulnerability/Provider/VulnerabilitiesProvider.php(35): PleskExt\WpToolkit\Feature\Vulnerability\Provider\VulnerabilitiesProvider->composeVulnerabilities(Array)
#5 /opt/psa/admin/plib/modules/wp-toolkit/library/Feature/Vulnerability/Provider/CachingVulnerabilitiesProvider.php(37): PleskExt\WpToolkit\Feature\Vulnerability\Provider\VulnerabilitiesProvider->findByVulnerabilityIds(Array)
#6 /opt/psa/admin/plib/modules/wp-toolkit/library/Statistics/ReportBuilder/SiteReportBuilder.php(265): PleskExt\WpToolkit\Feature\Vulnerability\Provider\CachingVulnerabilitiesProvider->findByVulnerabilityIds(Array)
#7 /opt/psa/admin/plib/modules/wp-toolkit/library/Statistics/ReportBuilder/SiteReportBuilder.php(85): PleskExt\WpToolkit\Statistics\ReportBuilder\SiteReportBuilder->getItem(Object(PleskExt\WpToolkit\Db\Row\Instance), 'vulnerabilityCu...', Object(PleskExt\WpToolkit\Statistics\ReportBuilder\ErrorsQueue))
#8 /opt/psa/admin/plib/modules/wp-toolkit/library/Statistics/ReportBuilder/ReportBuilderHelper.php(20): PleskExt\WpToolkit\Statistics\ReportBuilder\SiteReportBuilder->PleskExt\WpToolkit\Statistics\ReportBuilder\{closure}()
#9 /opt/psa/admin/plib/modules/wp-toolkit/library/Statistics/ReportBuilder/SiteReportBuilder.php(84): PleskExt\WpToolkit\Statistics\ReportBuilder\ReportBuilderHelper->safeGet(Object(Closure), NULL, Object(PleskExt\WpToolkit\Statistics\ReportBuilder\ErrorsQueue))
#10 /opt/psa/admin/plib/modules/wp-toolkit/library/Statistics/ReportBuilder/SiteReportBuilder.php(60): PleskExt\WpToolkit\Statistics\ReportBuilder\SiteReportBuilder->get(Object(PleskExt\WpToolkit\Db\Row\Instance), Array, Object(PleskExt\WpToolkit\Statistics\ReportBuilder\ErrorsQueue))
#11 /opt/psa/admin/plib/modules/wp-toolkit/library/Service/Statistics/ReportService.php(258): PleskExt\WpToolkit\Statistics\ReportBuilder\SiteReportBuilder->getFull(Object(PleskExt\WpToolkit\Db\Row\Instance), Object(PleskExt\WpToolkit\Statistics\ReportBuilder\ErrorsQueue))
#12 /opt/psa/admin/plib/modules/wp-toolkit/library/Service/Statistics/ReportService.php(248): PleskExt\WpToolkit\Service\Statistics\ReportService->createInstanceReport(Object(PleskExt\WpToolkit\Db\Row\Instance))
#13 /opt/psa/admin/plib/modules/wp-toolkit/library/Service/Statistics/ReportService.php(126): PleskExt\WpToolkit\Service\Statistics\ReportService->safeIterateInstanceReports(Object(PleskExt\WpToolkit\Statistics\ReportBuilder\ErrorsQueue))
#14 /opt/psa/admin/plib/modules/wp-toolkit/library/Service/Statistics/ReportService.php(101): PleskExt\WpToolkit\Service\Statistics\ReportService->sendReportUnsafe()
#15 /opt/psa/admin/plib/modules/wp-toolkit/library/Service/Statistics/DailyReportStatisticsTask.php(48): PleskExt\WpToolkit\Service\Statistics\ReportService->sendDailyReport()
#16 /opt/psa/admin/plib/modules/wp-toolkit/library/Maintainer.php(179): PleskExt\WpToolkit\Service\Statistics\DailyReportStatisticsTask->run(1711759444)
#17 /opt/psa/admin/plib/modules/wp-toolkit/scripts/maintenance.php(18): PleskExt\WpToolkit\Maintainer->run()
#18 /opt/psa/admin/plib/modules/wp-toolkit/library/Helper/FileLockCaller.php(22): {closure}()
#19 /opt/psa/admin/plib/modules/wp-toolkit/scripts/maintenance.php(13): PleskExt\WpToolkit\Helper\FileLockCaller::call(Object(Closure), '/opt/psa/admin/...', Object(PleskExt\WpToolkit\Service\Logger\ContextValueStringifyDecorator))
#20 {main}

It is also impossible to access the plugin or theme page.
Cannot read properties of null (reading 'map')

Performance booster also crashes completely
Long task executor: id=12097 completed with error: Specified column "enabled_with_booster" is not in the row:
0: /opt/psa/admin/plib/Task/Async/Executor.php:54
Task_Async_Executor->execute()
1: /opt/psa/admin/plib/scripts/task-async-executor.php:6


I've also noticed other errors in the plesk log

External exception. Index is under processing now
0: /opt/psa/admin/plib/Upgrade/Command/DeferredCommand.php:32
Plesk\Upgrade\Command\DeferredCommand->run()
1: /opt/psa/admin/plib/Upgrade/upgrade.php:29

I don't understand what's going on, the server is up to date 18.0.59 on ubuntu 22.04
WPtoolkit is also up to date 6.3.1-8205

I've already tried to reboot server
I've already tried a #plesk repair all -y
It didn't find anything wrong and the problem is still there.

I have another server with the same version of plesk and WP toolkit and I have no problems on this server.

Can you please help me ?

 

[Peter Debik]

I think there is something wrong with the SQLite database where the WP Toolkit extension stores some values, but it's hard to say what. If there are not too many websites on the server, maybe removing WP Toolkit and reinstalling it can help. Otherwise or if you have doubts about taking that shot, please contact Plesk support so that an engineer can check it directly on your server.

To sign-in to support please go to https://support.plesk.com

If you experience login issues, please see this KB article:
https://support.plesk.com/hc/en-us/...rt-plesk-com-and-password-reset-does-not-work

If you bought your license from a reseller, your reseller should provide support for you. If the reseller does not provide support, here is an alternative:
https://support.plesk.com/hc/en-us/articles/12388090147095-How-to-get-support-directly-from-Plesk-