Table &#8216;wp_wsal_options&#8217; doesn&#8217;t exist errors

After receiving a WP5.3 automated debug report about an E_ERROR.

I looked at a similar ticket where you suggested removing and reinstalling the plugin.

This I did.

How?

I purged the activity log. Chose delete all on uninstall from advanced settings. Then deactivated and deleted the app.

I reinstalled the plugin from repo and upon activation got slammed with PHP errors…

[26-Nov-2019 11:29:58 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-timezone' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->load_defaults, require_once('/plugins/wp-security-audit-log/defaults.php'), wsaldefaults_wsal_init, WSAL_AlertManager->__construct, WSAL_Settings->GetTimezone, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[26-Nov-2019 11:29:58 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-log-404' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->load_wsal, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[26-Nov-2019 11:29:58 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-log-404' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->load_wsal, WpSecurityAuditLog->SetGlobalOption, WSAL_Models_Option->SetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[26-Nov-2019 11:29:58 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SHOW FULL COLUMNS FROM <code>wp_wsal_options</code> made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->load_wsal, WpSecurityAuditLog->SetGlobalOption, WSAL_Models_Option->SetOptionValue, WSAL_Models_Option->Save, WSAL_Adapters_MySQL_ActiveRecord->Save
[26-Nov-2019 11:29:58 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-purge-404-log' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->load_wsal, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[26-Nov-2019 11:29:58 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-purge-404-log' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->load_wsal, WpSecurityAuditLog->SetGlobalOption, WSAL_Models_Option->SetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[26-Nov-2019 11:29:58 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SHOW FULL COLUMNS FROM <code>wp_wsal_options</code> made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->load_wsal, WpSecurityAuditLog->SetGlobalOption, WSAL_Models_Option->SetOptionValue, WSAL_Models_Option->Save, WSAL_Adapters_MySQL_ActiveRecord->Save
[26-Nov-2019 11:29:58 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-scan-file-changes' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->__construct, WSAL_SensorManager->AddFromFile, apply_filters('wsal_before_sensor_load'), WP_Hook->apply_filters, WSAL_SensorManager->check_sensor_before_load, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[26-Nov-2019 11:29:58 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-scan-frequency' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->__construct, WSAL_SensorManager->AddFromFile, WSAL_SensorManager->AddFromClass, WSAL_Sensors_FileChanges->__construct, WSAL_Sensors_FileChanges->load_file_change_settings, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[26-Nov-2019 11:29:58 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-scan-hour' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->__construct, WSAL_SensorManager->AddFromFile, WSAL_SensorManager->AddFromClass, WSAL_Sensors_FileChanges->__construct, WSAL_Sensors_FileChanges->load_file_change_settings, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[26-Nov-2019 11:29:58 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-scan-day' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->__construct, WSAL_SensorManager->AddFromFile, WSAL_SensorManager->AddFromClass, WSAL_Sensors_FileChanges->__construct, WSAL_Sensors_FileChanges->load_file_change_settings, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[26-Nov-2019 11:29:58 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-scan-date' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->__construct, WSAL_SensorManager->AddFromFile, WSAL_SensorManager->AddFromClass, WSAL_Sensors_FileChanges->__construct, WSAL_Sensors_FileChanges->load_file_change_settings, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[26-Nov-2019 11:29:58 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-scan-directories' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->__construct, WSAL_SensorManager->AddFromFile, WSAL_SensorManager->AddFromClass, WSAL_Sensors_FileChanges->__construct, WSAL_Sensors_FileChanges->load_file_change_settings, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[26-Nov-2019 11:29:58 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-scan-excluded-directories' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->__construct, WSAL_SensorManager->AddFromFile, WSAL_SensorManager->AddFromClass, WSAL_Sensors_FileChanges->__construct, WSAL_Sensors_FileChanges->load_file_change_settings, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[26-Nov-2019 11:29:58 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-scan-excluded-extensions' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->__construct, WSAL_SensorManager->AddFromFile, WSAL_SensorManager->AddFromClass, WSAL_Sensors_FileChanges->__construct, WSAL_Sensors_FileChanges->load_file_change_settings, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[26-Nov-2019 11:29:58 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-scan_excluded_files' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->__construct, WSAL_SensorManager->AddFromFile, WSAL_SensorManager->AddFromClass, WSAL_Sensors_FileChanges->__construct, WSAL_Sensors_FileChanges->load_file_change_settings, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[26-Nov-2019 11:29:58 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-last-scanned' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->__construct, WSAL_SensorManager->AddFromFile, WSAL_SensorManager->AddFromClass, WSAL_Sensors_FileChanges->__construct, WSAL_Sensors_FileChanges->load_file_change_settings, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[26-Nov-2019 11:29:58 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-scan-file-size-limit' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->__construct, WSAL_SensorManager->AddFromFile, WSAL_SensorManager->AddFromClass, WSAL_Sensors_FileChanges->__construct, WSAL_Sensors_FileChanges->load_file_change_settings, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[26-Nov-2019 11:29:58 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-events-nav-type' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_ViewManager->__construct, WSAL_ViewManager->AddFromFile, WSAL_ViewManager->AddFromClass, WSAL_Views_AuditLog->__construct, WSAL_Settings->is_infinite_scroll, WSAL_Settings->get_events_type_nav, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[26-Nov-2019 11:29:58 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-wsal-setup-complete' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_ViewManager->__construct, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[26-Nov-2019 11:29:58 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-adapter-type' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->HookEvents, WSAL_Sensors_Database->HookEvents, WpSecurityAuditLog->IsInstalled, WpSecurityAuditLog::getConnector, WSAL_Connector_ConnectorFactory::GetConnector, WSAL_Connector_ConnectorFactory::GetConfig, WSAL_Settings->GetAdapterConfig, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[26-Nov-2019 11:29:58 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-dev-options' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->HookEvents, WSAL_Sensors_PhpErrors->HookEvents, WSAL_Settings->IsPhpErrorLoggingEnabled, WSAL_Settings->IsDevOptionEnabled, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[26-Nov-2019 11:29:58 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-site_content' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->HookEvents, WSAL_Sensors_PluginsThemes->HookEvents, WSAL_Sensors_PluginsThemes->set_site_plugins, WSAL_Sensors_PluginsThemes->set_site_content, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[26-Nov-2019 11:29:58 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-site_content' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->HookEvents, WSAL_Sensors_PluginsThemes->HookEvents, WSAL_Sensors_PluginsThemes->set_site_plugins, WSAL_Sensors_PluginsThemes->set_site_content, WpSecurityAuditLog->SetGlobalOption, WSAL_Models_Option->SetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[26-Nov-2019 11:29:58 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SHOW FULL COLUMNS FROM <code>wp_wsal_options</code> made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->HookEvents, WSAL_Sensors_PluginsThemes->HookEvents, WSAL_Sensors_PluginsThemes->set_site_plugins, WSAL_Sensors_PluginsThemes->set_site_content, WpSecurityAuditLog->SetGlobalOption, WSAL_Models_Option->SetOptionValue, WSAL_Models_Option->Save, WSAL_Adapters_MySQL_ActiveRecord->Save
[26-Nov-2019 11:29:58 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-archiving-e' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_Settings->IsArchivingEnabled, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[26-Nov-2019 11:29:58 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-hide-plugin' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_Settings->IsIncognito, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[26-Nov-2019 11:29:58 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-version' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WpSecurityAuditLog->GetOldVersion, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[26-Nov-2019 11:29:58 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-version' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WpSecurityAuditLog->Update, WpSecurityAuditLog->SetGlobalOption, WSAL_Models_Option->SetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[26-Nov-2019 11:29:58 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SHOW FULL COLUMNS FROM <code>wp_wsal_options</code> made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WpSecurityAuditLog->Update, WpSecurityAuditLog->SetGlobalOption, WSAL_Models_Option->SetOptionValue, WSAL_Models_Option->Save, WSAL_Adapters_MySQL_ActiveRecord->Save
[26-Nov-2019 11:29:58 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-adapter-use-buffer' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, do_action('wsal_init'), WP_Hook->do_action, WP_Hook->apply_filters, WSAL_AlertManager->schedule_log_events, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load

The page I need help with: [log in to see the link]

Viewing 14 replies - 1 through 14 (of 14 total)

williampatton

(@williampatton)

Hi there @snaphappyme,

Sorry that you are having this issue. I am working to find the cause and a fix. If you could share some of the details about your setup that could speed up me finding where the issue us.

Some information that would be useful to know is the WP version, the plugin version (I assume latest 3.5.2 since you downloaded from repo) and the mysql version. You may not know these details yourself however there is a plugin called ‘Health Check’ that you could use to get the info from. https://www.ads-software.com/plugins/health-check/

Thank you for the report and once again sorry for the troubles you are having.

Thread Starter

(@snaphappyme)

I did mention the WP version.

But the other info is:

WordPress version 5.3
Current plugin: WP Security Audit Log (version 3.5.2)
PHP version 7.1.33
mysqli Server version 5.7.25-28-log

I also have WordFence installed.

Thanks again.

FYI I have deactivated the plugin until fix found.

Plugin Support

(@robert681)

@snaphappyme

By any chance do you have a staging or testing website where this issue can be reproduced? Most of today’s WordPress web host have staging functionality. If you do, can you please send us an email on [email protected] so we can troubleshoot the issue?

Thread Starter

(@snaphappyme)

The original error I was trying to address that made me uninstall and reinstall the application was:

An error of type E_ERROR was caused in line 98 of the file /PATHNAME/geoffmckinnon.com.au/public_html/wp-content/plugins/wp-security-audit-log/classes/Update/Task/CronNameRemap.php. 

Error message: Uncaught Error: Call to a member function GetArchivingRunEvery() on null in /PATHNAME/geoffmckinnon.com.au/public_html/wp-content/plugins/wp-security-audit-log/classes/Update/Task/CronNameRemap.php:98

Thread Starter

(@snaphappyme)

I have uninstalled V3.5.2.

And installed V3.5.2.1 you released overnight.

On activation a message appeared above plugin list, saying:

The plugin generated 7843 characters of unexpected output during activation. If you notice “headers already sent” messages, problems with syndication feeds or other issues, try deactivating or removing this plugin.

This also appeared on activating v3.5.2.

Again got slammed with a list of errors at activation.

[27-Nov-2019 01:21:35 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-timezone' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->load_defaults, require_once('/plugins/wp-security-audit-log/defaults.php'), wsaldefaults_wsal_init, WSAL_AlertManager->__construct, WSAL_Settings->GetTimezone, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[27-Nov-2019 01:21:35 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-log-404' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->load_wsal, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[27-Nov-2019 01:21:35 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-log-404' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->load_wsal, WpSecurityAuditLog->SetGlobalOption, WSAL_Models_Option->SetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[27-Nov-2019 01:21:35 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SHOW FULL COLUMNS FROM <code>wp_wsal_options</code> made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->load_wsal, WpSecurityAuditLog->SetGlobalOption, WSAL_Models_Option->SetOptionValue, WSAL_Models_Option->Save, WSAL_Adapters_MySQL_ActiveRecord->Save
[27-Nov-2019 01:21:35 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-purge-404-log' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->load_wsal, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[27-Nov-2019 01:21:35 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-purge-404-log' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->load_wsal, WpSecurityAuditLog->SetGlobalOption, WSAL_Models_Option->SetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[27-Nov-2019 01:21:35 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SHOW FULL COLUMNS FROM <code>wp_wsal_options</code> made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->load_wsal, WpSecurityAuditLog->SetGlobalOption, WSAL_Models_Option->SetOptionValue, WSAL_Models_Option->Save, WSAL_Adapters_MySQL_ActiveRecord->Save
[27-Nov-2019 01:21:35 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-scan-file-changes' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->__construct, WSAL_SensorManager->AddFromFile, apply_filters('wsal_before_sensor_load'), WP_Hook->apply_filters, WSAL_SensorManager->check_sensor_before_load, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[27-Nov-2019 01:21:35 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-scan-frequency' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->__construct, WSAL_SensorManager->AddFromFile, WSAL_SensorManager->AddFromClass, WSAL_Sensors_FileChanges->__construct, WSAL_Sensors_FileChanges->load_file_change_settings, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[27-Nov-2019 01:21:35 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-scan-hour' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->__construct, WSAL_SensorManager->AddFromFile, WSAL_SensorManager->AddFromClass, WSAL_Sensors_FileChanges->__construct, WSAL_Sensors_FileChanges->load_file_change_settings, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[27-Nov-2019 01:21:35 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-scan-day' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->__construct, WSAL_SensorManager->AddFromFile, WSAL_SensorManager->AddFromClass, WSAL_Sensors_FileChanges->__construct, WSAL_Sensors_FileChanges->load_file_change_settings, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[27-Nov-2019 01:21:35 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-scan-date' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->__construct, WSAL_SensorManager->AddFromFile, WSAL_SensorManager->AddFromClass, WSAL_Sensors_FileChanges->__construct, WSAL_Sensors_FileChanges->load_file_change_settings, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[27-Nov-2019 01:21:35 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-scan-directories' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->__construct, WSAL_SensorManager->AddFromFile, WSAL_SensorManager->AddFromClass, WSAL_Sensors_FileChanges->__construct, WSAL_Sensors_FileChanges->load_file_change_settings, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[27-Nov-2019 01:21:35 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-scan-excluded-directories' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->__construct, WSAL_SensorManager->AddFromFile, WSAL_SensorManager->AddFromClass, WSAL_Sensors_FileChanges->__construct, WSAL_Sensors_FileChanges->load_file_change_settings, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[27-Nov-2019 01:21:35 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-scan-excluded-extensions' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->__construct, WSAL_SensorManager->AddFromFile, WSAL_SensorManager->AddFromClass, WSAL_Sensors_FileChanges->__construct, WSAL_Sensors_FileChanges->load_file_change_settings, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[27-Nov-2019 01:21:35 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-scan_excluded_files' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->__construct, WSAL_SensorManager->AddFromFile, WSAL_SensorManager->AddFromClass, WSAL_Sensors_FileChanges->__construct, WSAL_Sensors_FileChanges->load_file_change_settings, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[27-Nov-2019 01:21:35 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-last-scanned' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->__construct, WSAL_SensorManager->AddFromFile, WSAL_SensorManager->AddFromClass, WSAL_Sensors_FileChanges->__construct, WSAL_Sensors_FileChanges->load_file_change_settings, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[27-Nov-2019 01:21:35 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-scan-file-size-limit' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->__construct, WSAL_SensorManager->AddFromFile, WSAL_SensorManager->AddFromClass, WSAL_Sensors_FileChanges->__construct, WSAL_Sensors_FileChanges->load_file_change_settings, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[27-Nov-2019 01:21:35 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-events-nav-type' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_ViewManager->__construct, WSAL_ViewManager->AddFromFile, WSAL_ViewManager->AddFromClass, WSAL_Views_AuditLog->__construct, WSAL_Settings->is_infinite_scroll, WSAL_Settings->get_events_type_nav, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[27-Nov-2019 01:21:35 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-wsal-setup-complete' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_ViewManager->__construct, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[27-Nov-2019 01:21:35 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-adapter-type' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->HookEvents, WSAL_Sensors_Database->HookEvents, WpSecurityAuditLog->IsInstalled, WpSecurityAuditLog::getConnector, WSAL_Connector_ConnectorFactory::GetConnector, WSAL_Connector_ConnectorFactory::GetConfig, WSAL_Settings->GetAdapterConfig, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[27-Nov-2019 01:21:35 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-dev-options' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->HookEvents, WSAL_Sensors_PhpErrors->HookEvents, WSAL_Settings->IsPhpErrorLoggingEnabled, WSAL_Settings->IsDevOptionEnabled, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[27-Nov-2019 01:21:35 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-site_content' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->HookEvents, WSAL_Sensors_PluginsThemes->HookEvents, WSAL_Sensors_PluginsThemes->set_site_plugins, WSAL_Sensors_PluginsThemes->set_site_content, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[27-Nov-2019 01:21:35 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-site_content' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->HookEvents, WSAL_Sensors_PluginsThemes->HookEvents, WSAL_Sensors_PluginsThemes->set_site_plugins, WSAL_Sensors_PluginsThemes->set_site_content, WpSecurityAuditLog->SetGlobalOption, WSAL_Models_Option->SetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[27-Nov-2019 01:21:35 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SHOW FULL COLUMNS FROM <code>wp_wsal_options</code> made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->HookEvents, WSAL_Sensors_PluginsThemes->HookEvents, WSAL_Sensors_PluginsThemes->set_site_plugins, WSAL_Sensors_PluginsThemes->set_site_content, WpSecurityAuditLog->SetGlobalOption, WSAL_Models_Option->SetOptionValue, WSAL_Models_Option->Save, WSAL_Adapters_MySQL_ActiveRecord->Save
[27-Nov-2019 01:21:35 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-archiving-e' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_Settings->IsArchivingEnabled, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[27-Nov-2019 01:21:35 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-hide-plugin' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_Settings->IsIncognito, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[27-Nov-2019 01:21:35 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-version' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WpSecurityAuditLog->GetOldVersion, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[27-Nov-2019 01:21:35 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-version' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WpSecurityAuditLog->Update, WpSecurityAuditLog->SetGlobalOption, WSAL_Models_Option->SetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[27-Nov-2019 01:21:35 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SHOW FULL COLUMNS FROM <code>wp_wsal_options</code> made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WpSecurityAuditLog->Update, WpSecurityAuditLog->SetGlobalOption, WSAL_Models_Option->SetOptionValue, WSAL_Models_Option->Save, WSAL_Adapters_MySQL_ActiveRecord->Save
[27-Nov-2019 01:21:35 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-adapter-use-buffer' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, do_action('wsal_init'), WP_Hook->do_action, WP_Hook->apply_filters, WSAL_AlertManager->schedule_log_events, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load

Thread Starter

(@snaphappyme)

I looked at the database we have three tables:

Wp-wsal_metadata
wp_wsal_occurrences
wp_wsal_options

There are 5 records in options.

id,option_name,option_value
1,wsal-disabled-alerts,”2099,2126″
2,wsal-log-404,on
3,wsal-purge-404-log,on
4,wsal-site_content,”JSON list deleted for safety”
5,wsal-version,3.5.2.1

The other tables appear to have captured the recent activity since activation.

Plugin Support

(@robert681)

Thank you for the feedback @snaphappyme

If you deactivate the plugin, delete the wp_wsal_options table and reactivate the plugin what happens please? Basically by doing so you are resetting the plugin’s settings and the plugin should recreate the table.

Thread Starter

(@snaphappyme)

@robert681 I am confused at your request. This post has all that info and a reset is what I have done each time.

Each time I have uninstalled the v3.5.2 plugin (which is twice now) I have gone to advanced settings and checked [remove data] on deactivation.

On the second run through of plugin removal (info starts at 3 posts above this message) I also remotely viewed the database tables and can confirm all tables with prefix wsal were removed on deactivation.

So both times I have done a complete uninstall and start-over.

This is not where the problems happen. It is on activation of the newly installed plugin that these errors appear. AND you can see from my message above the activation step re-created your 3 db tables.

The wsal_options table does exist after activation and has 5 option parameters assigned (see above message info).

Plugin Support

(@robert681)

Sorry, misread the previous messages.

Can you please enable WordPress debug and reproduce the problem? If there are logs in the debug.log please copy them here.

Thank you for your cooperation.

Thread Starter

(@snaphappyme)

@robert681 again I have already done this and these are the errors already posted in above messages. All messages in the CODE portion of above posts are from DEBUG

Thread Starter

(@snaphappyme)

@robert681

I have done again as you asked. Even though I already supplied this info in two messages posted.

I cleared the error_logs so the information provided is only about your plugin and the steps to deinstall and reinstall your plugin.

The cycle I went through step by step is as follows.

From the plugin settings ADVANCED page:

Reset plugin settings to default
cleared log entries
and remove all data on deactivation.

From the WP PLUGINS page:

Deactivated plugin
Deleted plugin
Installed plugin from wordpress repo (not local file)
Activated the plugin

I then downloaded the debug error log for the above (only changing database name).

[28-Nov-2019 23:23:40 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-timezone' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->load_defaults, require_once('/plugins/wp-security-audit-log/defaults.php'), wsaldefaults_wsal_init, WSAL_AlertManager->__construct, WSAL_Settings->GetTimezone, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[28-Nov-2019 23:23:40 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-log-404' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->load_wsal, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[28-Nov-2019 23:23:40 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-log-404' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->load_wsal, WpSecurityAuditLog->SetGlobalOption, WSAL_Models_Option->SetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[28-Nov-2019 23:23:40 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SHOW FULL COLUMNS FROM <code>wp_wsal_options</code> made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->load_wsal, WpSecurityAuditLog->SetGlobalOption, WSAL_Models_Option->SetOptionValue, WSAL_Models_Option->Save, WSAL_Adapters_MySQL_ActiveRecord->Save
[28-Nov-2019 23:23:40 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-purge-404-log' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->load_wsal, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[28-Nov-2019 23:23:40 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-purge-404-log' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->load_wsal, WpSecurityAuditLog->SetGlobalOption, WSAL_Models_Option->SetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[28-Nov-2019 23:23:40 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SHOW FULL COLUMNS FROM <code>wp_wsal_options</code> made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->load_wsal, WpSecurityAuditLog->SetGlobalOption, WSAL_Models_Option->SetOptionValue, WSAL_Models_Option->Save, WSAL_Adapters_MySQL_ActiveRecord->Save
[28-Nov-2019 23:23:40 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-scan-file-changes' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->__construct, WSAL_SensorManager->AddFromFile, apply_filters('wsal_before_sensor_load'), WP_Hook->apply_filters, WSAL_SensorManager->check_sensor_before_load, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[28-Nov-2019 23:23:40 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-scan-frequency' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->__construct, WSAL_SensorManager->AddFromFile, WSAL_SensorManager->AddFromClass, WSAL_Sensors_FileChanges->__construct, WSAL_Sensors_FileChanges->load_file_change_settings, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[28-Nov-2019 23:23:40 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-scan-hour' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->__construct, WSAL_SensorManager->AddFromFile, WSAL_SensorManager->AddFromClass, WSAL_Sensors_FileChanges->__construct, WSAL_Sensors_FileChanges->load_file_change_settings, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[28-Nov-2019 23:23:40 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-scan-day' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->__construct, WSAL_SensorManager->AddFromFile, WSAL_SensorManager->AddFromClass, WSAL_Sensors_FileChanges->__construct, WSAL_Sensors_FileChanges->load_file_change_settings, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[28-Nov-2019 23:23:40 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-scan-date' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->__construct, WSAL_SensorManager->AddFromFile, WSAL_SensorManager->AddFromClass, WSAL_Sensors_FileChanges->__construct, WSAL_Sensors_FileChanges->load_file_change_settings, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[28-Nov-2019 23:23:40 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-scan-directories' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->__construct, WSAL_SensorManager->AddFromFile, WSAL_SensorManager->AddFromClass, WSAL_Sensors_FileChanges->__construct, WSAL_Sensors_FileChanges->load_file_change_settings, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[28-Nov-2019 23:23:40 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-scan-excluded-directories' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->__construct, WSAL_SensorManager->AddFromFile, WSAL_SensorManager->AddFromClass, WSAL_Sensors_FileChanges->__construct, WSAL_Sensors_FileChanges->load_file_change_settings, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[28-Nov-2019 23:23:40 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-scan-excluded-extensions' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->__construct, WSAL_SensorManager->AddFromFile, WSAL_SensorManager->AddFromClass, WSAL_Sensors_FileChanges->__construct, WSAL_Sensors_FileChanges->load_file_change_settings, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[28-Nov-2019 23:23:40 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-scan_excluded_files' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->__construct, WSAL_SensorManager->AddFromFile, WSAL_SensorManager->AddFromClass, WSAL_Sensors_FileChanges->__construct, WSAL_Sensors_FileChanges->load_file_change_settings, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[28-Nov-2019 23:23:40 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-last-scanned' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->__construct, WSAL_SensorManager->AddFromFile, WSAL_SensorManager->AddFromClass, WSAL_Sensors_FileChanges->__construct, WSAL_Sensors_FileChanges->load_file_change_settings, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[28-Nov-2019 23:23:40 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-scan-file-size-limit' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->__construct, WSAL_SensorManager->AddFromFile, WSAL_SensorManager->AddFromClass, WSAL_Sensors_FileChanges->__construct, WSAL_Sensors_FileChanges->load_file_change_settings, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[28-Nov-2019 23:23:40 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-events-nav-type' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_ViewManager->__construct, WSAL_ViewManager->AddFromFile, WSAL_ViewManager->AddFromClass, WSAL_Views_AuditLog->__construct, WSAL_Settings->is_infinite_scroll, WSAL_Settings->get_events_type_nav, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[28-Nov-2019 23:23:40 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-wsal-setup-complete' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_ViewManager->__construct, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[28-Nov-2019 23:23:40 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-adapter-type' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->HookEvents, WSAL_Sensors_Database->HookEvents, WpSecurityAuditLog->IsInstalled, WpSecurityAuditLog::getConnector, WSAL_Connector_ConnectorFactory::GetConnector, WSAL_Connector_ConnectorFactory::GetConfig, WSAL_Settings->GetAdapterConfig, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[28-Nov-2019 23:23:40 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-dev-options' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->HookEvents, WSAL_Sensors_PhpErrors->HookEvents, WSAL_Settings->IsPhpErrorLoggingEnabled, WSAL_Settings->IsDevOptionEnabled, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[28-Nov-2019 23:23:40 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-site_content' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->HookEvents, WSAL_Sensors_PluginsThemes->HookEvents, WSAL_Sensors_PluginsThemes->set_site_plugins, WSAL_Sensors_PluginsThemes->set_site_content, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[28-Nov-2019 23:23:40 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-site_content' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->HookEvents, WSAL_Sensors_PluginsThemes->HookEvents, WSAL_Sensors_PluginsThemes->set_site_plugins, WSAL_Sensors_PluginsThemes->set_site_content, WpSecurityAuditLog->SetGlobalOption, WSAL_Models_Option->SetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[28-Nov-2019 23:23:40 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SHOW FULL COLUMNS FROM <code>wp_wsal_options</code> made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_SensorManager->HookEvents, WSAL_Sensors_PluginsThemes->HookEvents, WSAL_Sensors_PluginsThemes->set_site_plugins, WSAL_Sensors_PluginsThemes->set_site_content, WpSecurityAuditLog->SetGlobalOption, WSAL_Models_Option->SetOptionValue, WSAL_Models_Option->Save, WSAL_Adapters_MySQL_ActiveRecord->Save
[28-Nov-2019 23:23:40 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-archiving-e' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_Settings->IsArchivingEnabled, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[28-Nov-2019 23:23:40 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-hide-plugin' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WSAL_Settings->IsIncognito, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[28-Nov-2019 23:23:40 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-version' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WpSecurityAuditLog->GetOldVersion, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[28-Nov-2019 23:23:40 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-version' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WpSecurityAuditLog->Update, WpSecurityAuditLog->SetGlobalOption, WSAL_Models_Option->SetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
[28-Nov-2019 23:23:40 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SHOW FULL COLUMNS FROM <code>wp_wsal_options</code> made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, WpSecurityAuditLog->Update, WpSecurityAuditLog->SetGlobalOption, WSAL_Models_Option->SetOptionValue, WSAL_Models_Option->Save, WSAL_Adapters_MySQL_ActiveRecord->Save
[28-Nov-2019 23:23:40 UTC] WordPress database error Table 'MYDATABASENAME.wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-adapter-use-buffer' made by activate_plugin, do_action('activate_wp-security-audit-log/wp-security-audit-log.php'), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->Install, WpSecurityAuditLog->setup, WpSecurityAuditLog->init, do_action('wsal_init'), WP_Hook->do_action, WP_Hook->apply_filters, WSAL_AlertManager->schedule_log_events, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load

Thread Starter

(@snaphappyme)

Activation has added 3 database tables.

The wsal_options table was populated as follows:

XML format

<rows>
  <row id="1" option_name="wsal-disabled-alerts" option_value="2099,2126"/>
  <row id="2" option_name="wsal-log-404" option_value="on"/>
  <row id="3" option_name="wsal-purge-404-log" option_value="on"/>
  <row id="4" option_name="wsal-site_content" option_value="O:8:&quot;stdClass&quot;:4:{s:7:&quot;plugins&quot;;a:42:{i:0;s:12:&quot;antispam-bee&quot;;i:1;s:11:&quot;autoptimize&quot;;i:2;s:21:&quot;better-search-replace&quot;;i:3;s:42:&quot;bookly-responsive-appointment-booking-tool&quot;;i:4;s:17:&quot;bookly-addon-cart&quot;;i:5;s:20:&quot;bookly-addon-coupons&quot;;i:6;s:26:&quot;bookly-addon-custom-fields&quot;;i:7;s:26:&quot;bookly-addon-group-booking&quot;;i:8;s:16:&quot;bookly-addon-pro&quot;;i:9;s:35:&quot;bookly-addon-recurring-appointments&quot;;i:10;s:22:&quot;host-analyticsjs-local&quot;;i:11;s:24:&quot;master-popups-cookieplus&quot;;i:12;s:26:&quot;easy-social-share-buttons3&quot;;i:13;s:9:&quot;edit-flow&quot;;i:14;s:20:&quot;enable-media-replace&quot;;i:15;s:24:&quot;flow-flow-social-streams&quot;;i:16;s:31:&quot;duracelltomi-google-tag-manager&quot;;i:17;s:7:&quot;imagify&quot;;i:18;s:18:&quot;better-wp-security&quot;;i:19;s:13:&quot;master-popups&quot;;i:20;s:25:&quot;php-compatibility-checker&quot;;i:21;s:16:&quot;project-panorama&quot;;i:22;s:10:&quot;psp-delays&quot;;i:23;s:19:&quot;psp-frontend-editor&quot;;i:24;s:19:&quot;psp-frontend-upload&quot;;i:25;s:9:&quot;psp-pages&quot;;i:26;s:20:&quot;psp-sequential-tasks&quot;;i:27;s:13:&quot;psp-sub-tasks&quot;;i:28;s:6:&quot;quform&quot;;i:29;s:21:&quot;regenerate-thumbnails&quot;;i:30;s:20:&quot;rs-system-diagnostic&quot;;i:31;s:18:&quot;search-and-replace&quot;;i:32;s:13:&quot;sg-cachepress&quot;;i:33;s:11:&quot;wp-slimstat&quot;;i:34;s:20:&quot;stop-xml-rpc-attacks&quot;;i:35;s:18:&quot;transients-manager&quot;;i:36;s:11:&quot;updraftplus&quot;;i:37;s:10:&quot;insert-php&quot;;i:38;s:9:&quot;wordfence&quot;;i:39;s:13:&quot;wp-spamshield&quot;;i:40;s:21:&quot;wp-security-audit-log&quot;;i:41;s:13:&quot;wordpress-seo&quot;;}s:12:&quot;skip_plugins&quot;;a:42:{i:0;s:12:&quot;antispam-bee&quot;;i:1;s:11:&quot;autoptimize&quot;;i:2;s:21:&quot;better-search-replace&quot;;i:3;s:42:&quot;bookly-responsive-appointment-booking-tool&quot;;i:4;s:17:&quot;bookly-addon-cart&quot;;i:5;s:20:&quot;bookly-addon-coupons&quot;;i:6;s:26:&quot;bookly-addon-custom-fields&quot;;i:7;s:26:&quot;bookly-addon-group-booking&quot;;i:8;s:16:&quot;bookly-addon-pro&quot;;i:9;s:35:&quot;bookly-addon-recurring-appointments&quot;;i:10;s:22:&quot;host-analyticsjs-local&quot;;i:11;s:24:&quot;master-popups-cookieplus&quot;;i:12;s:26:&quot;easy-social-share-buttons3&quot;;i:13;s:9:&quot;edit-flow&quot;;i:14;s:20:&quot;enable-media-replace&quot;;i:15;s:24:&quot;flow-flow-social-streams&quot;;i:16;s:31:&quot;duracelltomi-google-tag-manager&quot;;i:17;s:7:&quot;imagify&quot;;i:18;s:18:&quot;better-wp-security&quot;;i:19;s:13:&quot;master-popups&quot;;i:20;s:25:&quot;php-compatibility-checker&quot;;i:21;s:16:&quot;project-panorama&quot;;i:22;s:10:&quot;psp-delays&quot;;i:23;s:19:&quot;psp-frontend-editor&quot;;i:24;s:19:&quot;psp-frontend-upload&quot;;i:25;s:9:&quot;psp-pages&quot;;i:26;s:20:&quot;psp-sequential-tasks&quot;;i:27;s:13:&quot;psp-sub-tasks&quot;;i:28;s:6:&quot;quform&quot;;i:29;s:21:&quot;regenerate-thumbnails&quot;;i:30;s:20:&quot;rs-system-diagnostic&quot;;i:31;s:18:&quot;search-and-replace&quot;;i:32;s:13:&quot;sg-cachepress&quot;;i:33;s:11:&quot;wp-slimstat&quot;;i:34;s:20:&quot;stop-xml-rpc-attacks&quot;;i:35;s:18:&quot;transients-manager&quot;;i:36;s:11:&quot;updraftplus&quot;;i:37;s:10:&quot;insert-php&quot;;i:38;s:9:&quot;wordfence&quot;;i:39;s:13:&quot;wp-spamshield&quot;;i:40;s:21:&quot;wp-security-audit-log&quot;;i:41;s:13:&quot;wordpress-seo&quot;;}s:6:&quot;themes&quot;;a:5:{i:0;s:4:&quot;divi&quot;;i:1;s:14:&quot;twentynineteen&quot;;i:2;s:15:&quot;twentyseventeen&quot;;i:3;s:13:&quot;twentysixteen&quot;;i:4;s:12:&quot;twentytwenty&quot;;}s:11:&quot;skip_themes&quot;;a:5:{i:0;s:4:&quot;divi&quot;;i:1;s:14:&quot;twentynineteen&quot;;i:2;s:15:&quot;twentyseventeen&quot;;i:3;s:13:&quot;twentysixteen&quot;;i:4;s:12:&quot;twentytwenty&quot;;}}"/>
  <row id="5" option_name="wsal-version" option_value="3.5.2.1"/>
  <row id="6" option_name="wsal-delete-data" option_value="0"/>
  <row id="7" option_name="wsal-dev-options" option_value=""/>
  <row id="8" option_name="wsal-hide-plugin" option_value="0"/>
  <row id="9" option_name="wsal-restrict-admins" option_value=""/>
  <row id="10" option_name="wsal-plugin-editors" option_value=""/>
  <row id="11" option_name="wsal-mwp-child-stealth-mode" option_value="no"/>
</rows>

Plugin Support

(@robert681)

Unfortunately we cannot reproduce these issues @snaphappyme

However, if you can help us test this, we can send you some test builds with which you can do some more tests and produce more logs for us, which will hopefully help us solve the issue.

Would you be willing to help us? If yes, please send us an email at [email protected].

Plugin Support