Title: Table ‘wp_wsal_options’ doesn’t exist errors Last modified: November 26, 2019 --- # Table ‘wp_wsal_options’ doesn’t exist errors * Resolved [snaphappyme](https://wordpress.org/support/users/snaphappyme/) * (@snaphappyme) * [6 years, 6 months ago](https://wordpress.org/support/topic/table-wp_wsal_options-doesnt-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 wp_wsal_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->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 wp_wsal_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->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 wp_wsal_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_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 wp_wsal_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, 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](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Ftable-wp_wsal_options-doesnt-exist-errors%2F%3Foutput_format%3Dmd&locale=en_US) to see the link]_ Viewing 14 replies - 1 through 14 (of 14 total) * [williampatton](https://wordpress.org/support/users/williampatton/) * (@williampatton) * [6 years, 6 months ago](https://wordpress.org/support/topic/table-wp_wsal_options-doesnt-exist-errors/#post-12176502) * Hi there [@snaphappyme](https://wordpress.org/support/users/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://wordpress.org/plugins/health-check/](https://wordpress.org/plugins/health-check/) * Thank you for the report and once again sorry for the troubles you are having. * Thread Starter [snaphappyme](https://wordpress.org/support/users/snaphappyme/) * (@snaphappyme) * [6 years, 6 months ago](https://wordpress.org/support/topic/table-wp_wsal_options-doesnt-exist-errors/#post-12176575) * 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 [robertabela](https://wordpress.org/support/users/robert681/) * (@robert681) * [6 years, 6 months ago](https://wordpress.org/support/topic/table-wp_wsal_options-doesnt-exist-errors/#post-12176824) * [@snaphappyme](https://wordpress.org/support/users/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 [support@wpwhitesecurity.com](https://wordpress.org/support/topic/table-wp_wsal_options-doesnt-exist-errors/support@wpwhitesecurity.com?output_format=md) so we can troubleshoot the issue? * Thread Starter [snaphappyme](https://wordpress.org/support/users/snaphappyme/) * (@snaphappyme) * [6 years, 6 months ago](https://wordpress.org/support/topic/table-wp_wsal_options-doesnt-exist-errors/#post-12178659) * 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](https://wordpress.org/support/users/snaphappyme/) * (@snaphappyme) * [6 years, 6 months ago](https://wordpress.org/support/topic/table-wp_wsal_options-doesnt-exist-errors/#post-12179164) * 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 wp_wsal_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->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 wp_wsal_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->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 wp_wsal_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_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 wp_wsal_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, 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](https://wordpress.org/support/users/snaphappyme/) * (@snaphappyme) * [6 years, 6 months ago](https://wordpress.org/support/topic/table-wp_wsal_options-doesnt-exist-errors/#post-12179173) * I looked at the database we have three tables: 1. Wp-wsal_metadata 2. wp_wsal_occurrences 3. 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 [robertabela](https://wordpress.org/support/users/robert681/) * (@robert681) * [6 years, 6 months ago](https://wordpress.org/support/topic/table-wp_wsal_options-doesnt-exist-errors/#post-12179638) * Thank you for the feedback [@snaphappyme](https://wordpress.org/support/users/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](https://wordpress.org/support/users/snaphappyme/) * (@snaphappyme) * [6 years, 6 months ago](https://wordpress.org/support/topic/table-wp_wsal_options-doesnt-exist-errors/#post-12183300) * [@robert681](https://wordpress.org/support/users/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 [robertabela](https://wordpress.org/support/users/robert681/) * (@robert681) * [6 years, 6 months ago](https://wordpress.org/support/topic/table-wp_wsal_options-doesnt-exist-errors/#post-12186649) * Sorry, misread the previous messages. * Can you please [enable WordPress debug](https://www.wpsecurityauditlog.com/wordpress-admin/enabling-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](https://wordpress.org/support/users/snaphappyme/) * (@snaphappyme) * [6 years, 6 months ago](https://wordpress.org/support/topic/table-wp_wsal_options-doesnt-exist-errors/#post-12186843) * [@robert681](https://wordpress.org/support/users/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](https://wordpress.org/support/users/snaphappyme/) * (@snaphappyme) * [6 years, 6 months ago](https://wordpress.org/support/topic/table-wp_wsal_options-doesnt-exist-errors/#post-12187123) * [@robert681](https://wordpress.org/support/users/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**: 1. Reset plugin settings to default 2. cleared log entries 3. and remove all data on deactivation. * From the **WP PLUGINS page**: 1. Deactivated plugin 2. Deleted plugin 3. Installed plugin from wordpress repo (not local file) 4. 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 wp_wsal_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->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 wp_wsal_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->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 wp_wsal_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_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 wp_wsal_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, 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](https://wordpress.org/support/users/snaphappyme/) * (@snaphappyme) * [6 years, 6 months ago](https://wordpress.org/support/topic/table-wp_wsal_options-doesnt-exist-errors/#post-12187128) * Activation has added 3 database tables. * The **wsal_options** table was populated as follows: * XML format * ``` ``` * Plugin Support [robertabela](https://wordpress.org/support/users/robert681/) * (@robert681) * [6 years, 6 months ago](https://wordpress.org/support/topic/table-wp_wsal_options-doesnt-exist-errors/#post-12188047) * Unfortunately we cannot reproduce these issues [@snaphappyme](https://wordpress.org/support/users/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 [support@wpwhitesecurity.com](https://wordpress.org/support/topic/table-wp_wsal_options-doesnt-exist-errors/support@wpwhitesecurity.com?output_format=md). * Plugin Support [robertabela](https://wordpress.org/support/users/robert681/) * (@robert681) * [6 years, 5 months ago](https://wordpress.org/support/topic/table-wp_wsal_options-doesnt-exist-errors/#post-12305897) * Hello [@snaphappyme](https://wordpress.org/support/users/snaphappyme/) * We have just released version 4 in which we improved the database connector. Can you please try it and advice? * Looking forward to hearing from you. Viewing 14 replies - 1 through 14 (of 14 total) The topic ‘Table ‘wp_wsal_options’ doesn’t exist errors’ is closed to new replies. * ![](https://ps.w.org/wp-security-audit-log/assets/icon-256x256.png?rev=2961534) * [WP Activity Log](https://wordpress.org/plugins/wp-security-audit-log/) * [Frequently Asked Questions](https://wordpress.org/plugins/wp-security-audit-log/#faq) * [Support Threads](https://wordpress.org/support/plugin/wp-security-audit-log/) * [Active Topics](https://wordpress.org/support/plugin/wp-security-audit-log/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/wp-security-audit-log/unresolved/) * [Reviews](https://wordpress.org/support/plugin/wp-security-audit-log/reviews/) * 14 replies * 3 participants * Last reply from: [robertabela](https://wordpress.org/support/users/robert681/) * Last activity: [6 years, 5 months ago](https://wordpress.org/support/topic/table-wp_wsal_options-doesnt-exist-errors/#post-12305897) * Status: resolved