wp_wsal_options not created with plugin update

Resolved

(@endymion00)

Using v 1.5

After updating the 1.5, it appears that the new wp_wsal_options table is not created.

This causes various error_log messages. Disabling and re-enabling the plugin appears to create the table.

[18-Mar-2015 23:58:40 UTC] WordPress database error Table 'wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-excluded-users' made by wp_signon, do_action('wp_login'), call_user_func_array, WSAL_Sensors_LogInOut->EventLogin, WSAL_AlertManager->Trigger, WSAL_AlertManager->CheckEnableUserRoles, WSAL_AlertManager->IsDisabledUser, WSAL_AlertManager->GetDisabledUsers, WSAL_Settings->GetExcludedMonitoringUsers, WpSecurityAuditLog->GetGlobalOption, WSAL_DB_Option->GetOptionValue, WSAL_DB_Option->GetNamedOption, WSAL_DB_ActiveRecord->Load
[18-Mar-2015 23:58:40 UTC] WordPress database error Table 'wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-excluded-roles' made by wp_signon, do_action('wp_login'), call_user_func_array, WSAL_Sensors_LogInOut->EventLogin, WSAL_AlertManager->Trigger, WSAL_AlertManager->CheckEnableUserRoles, WSAL_AlertManager->IsDisabledRole, WSAL_AlertManager->GetDisabledRoles, WSAL_Settings->GetExcludedMonitoringRoles, WpSecurityAuditLog->GetGlobalOption, WSAL_DB_Option->GetOptionValue, WSAL_DB_Option->GetNamedOption, WSAL_DB_ActiveRecord->Load
[18-Mar-2015 23:58:43 UTC] WordPress database error Table 'wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-hide-plugin' made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), call_user_func_array, WpSecurityAuditLog->Load, WSAL_Settings->IsIncognito, WpSecurityAuditLog->GetGlobalOption, WSAL_DB_Option->GetOptionValue, WSAL_DB_Option->GetNamedOption, WSAL_DB_ActiveRecord->Load
[18-Mar-2015 23:58:43 UTC] WordPress database error Table 'wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-hide-plugin' made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), call_user_func_array, WpSecurityAuditLog->Load, WSAL_Settings->IsIncognito, WpSecurityAuditLog->GetGlobalOption, WSAL_DB_Option->GetOptionValue, WSAL_DB_Option->GetNamedOption, WSAL_DB_ActiveRecord->Load
[18-Mar-2015 23:58:43 UTC] WordPress database error Table 'wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-dev-options' made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, WpSecurityAuditLog->Init, WSAL_SensorManager->HookEvents, WSAL_Sensors_PhpErrors->HookEvents, WSAL_Settings->IsPhpErrorLoggingEnabled, WSAL_Settings->IsDevOptionEnabled, WpSecurityAuditLog->GetGlobalOption, WSAL_DB_Option->GetOptionValue, WSAL_DB_Option->GetNamedOption, WSAL_DB_ActiveRecord->Load

https://wordpress.org/plugins/wp-security-audit-log/

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

Plugin Support robertabela
(@robert681)

11 years, 2 months ago

HI Endymion00,

Thank you for showing interest in our plugin.

First of all I am glad you solved the issue. Just to recap what happened here, it seems that during the first activation the new settings table was not created. I would have said it is a permissions problem though it is not since during the second activation it was created.

If you had debug enabled can you please check if there are any errors related to this issue?

Thank you very much.
Thread Starter Endymion00
(@endymion00)

11 years, 2 months ago
On a separate test site with Debug ouput, the only errors that appear upgrading from 1.41 to 1.5 are:
```
[19-Mar-2015 14:06:12 UTC] WordPress database error Table 'wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-hide-plugin' made by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), call_user_func_array, WpSecurityAuditLog->Load, WSAL_Settings->IsIncognito, WpSecurityAuditLog->GetGlobalOption, WSAL_DB_Option->GetOptionValue, WSAL_DB_Option->GetNamedOption, WSAL_DB_ActiveRecord->Load
[19-Mar-2015 14:06:12 UTC] WordPress database error Table 'wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-dev-options' made by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, WpSecurityAuditLog->Init, WSAL_SensorManager->HookEvents, WSAL_Sensors_PhpErrors->HookEvents, WSAL_Settings->IsPhpErrorLoggingEnabled, WSAL_Settings->IsDevOptionEnabled, WpSecurityAuditLog->GetGlobalOption, WSAL_DB_Option->GetOptionValue, WSAL_DB_Option->GetNamedOption, WSAL_DB_ActiveRecord->Load
[19-Mar-2015 14:06:12 UTC] WordPress database error Table 'wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-plugin-viewers' made by require_once('wp-admin/admin.php'), require('wp-admin/menu.php'), require_once('wp-admin/includes/menu.php'), do_action('admin_menu'), call_user_func_array, WSAL_ViewManager->AddAdminMenus, WSAL_Settings->CurrentUserCan, WSAL_Settings->UserCan, WSAL_Settings->GetAccessTokens, WSAL_Settings->GetAllowedPluginViewers, WpSecurityAuditLog->GetGlobalOption, WSAL_DB_Option->GetOptionValue, WSAL_DB_Option->GetNamedOption, WSAL_DB_ActiveRecord->Load
[19-Mar-2015 14:06:12 UTC] WordPress database error Table 'wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-plugin-editors' made by require_once('wp-admin/admin.php'), require('wp-admin/menu.php'), require_once('wp-admin/includes/menu.php'), do_action('admin_menu'), call_user_func_array, WSAL_ViewManager->AddAdminMenus, WSAL_Settings->CurrentUserCan, WSAL_Settings->UserCan, WSAL_Settings->GetAccessTokens, WSAL_Settings->GetAllowedPluginEditors, WpSecurityAuditLog->GetGlobalOption, WSAL_DB_Option->GetOptionValue, WSAL_DB_Option->GetNamedOption, WSAL_DB_ActiveRecord->Load
[19-Mar-2015 14:06:12 UTC] WordPress database error Table 'wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-restrict-admins' made by require_once('wp-admin/admin.php'), require('wp-admin/menu.php'), require_once('wp-admin/includes/menu.php'), do_action('admin_menu'), call_user_func_array, WSAL_ViewManager->AddAdminMenus, WSAL_Settings->CurrentUserCan, WSAL_Settings->UserCan, WSAL_Settings->GetAccessTokens, WSAL_Settings->IsRestrictAdmins, WpSecurityAuditLog->GetGlobalOption, WSAL_DB_Option->GetOptionValue, WSAL_DB_Option->GetNamedOption, WSAL_DB_ActiveRecord->Load
[19-Mar-2015 14:06:12 UTC] WordPress database error Table 'wp_wsal_options' doesn't exist for query SELECT * FROM wp_wsal_options WHERE option_name = 'wsal-restrict-admins' made by require_once('wp-admin/admin.php'), require('wp-admin/menu.php'), require_once('wp-admin/includes/menu.php'), do_action('admin_menu'), call_user_func_array, WSAL_ViewManager->AddAdminMenus, WSAL_Settings->CurrentUserCan, WSAL_Settings->UserCan, WSAL_Settings->GetAccessTokens, WSAL_Settings->IsRestrictAdmins, WpSecurityAuditLog->GetGlobalOption, WSAL_DB_Option->GetOptionValue, WSAL_DB_Option->GetNamedOption, WSAL_DB_ActiveRecord->Load
```
If I read correctly, the activation hook is not called on plugin updates so if the table creation is only on activation, that would be the issue. The upgrade process needs to check the database for the previous plugin version or look for the table and trigger the table creation if needed.

Deactivating the plugin triggers some more table does not exists errors from the shutdown_action_hook, but once I re-activate the plugin I do not see any further errors.
Julie
(@habannah)

11 years, 2 months ago

Hi Robert,

Just to let you know that I had the same issue. I was coming to report the problem when I saw this thread and the solution offered. Simply deactivating and reactivating the plugin seems to have worked for me as well. So many thanks to Endymion00 for posting the fix 🙂

I’m not sure why it would be related to permissions since I’m the only admin on the site; however, the info from my php error log leads me to suspect you may be right. Here are some of the entries in my error log — I hope this can help you!

WordPress database error Table wsal_options' doesn't exist for query SELECT * FROM wsal_options WHERE option_name = 'wsal-hide-plugin' made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'), call_user_func_array, WpSecurityAuditLog->Load, WSAL_Settings->IsIncognito, WpSecurityAuditLog->GetGlobalOption, WSAL_DB_Option->GetOptionValue, WSAL_DB_Option->GetNamedOption, WSAL_DB_ActiveRecord->Load, QM_DB->query

WordPress database error Table 'wsal_options' doesn't exist for query SELECT * FROM wsal_options WHERE option_name = 'wsal-dev-options' made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, WpSecurityAuditLog->Init, WSAL_SensorManager->HookEvents, WSAL_Sensors_PhpErrors->HookEvents, WSAL_Settings->IsPhpErrorLoggingEnabled, WSAL_Settings->IsDevOptionEnabled, WpSecurityAuditLog->GetGlobalOption, WSAL_DB_Option->GetOptionValue, WSAL_DB_Option->GetNamedOption, WSAL_DB_ActiveRecord->Load, QM_DB->query

WordPress database error Table 'wsal_options' doesn't exist for query SELECT * FROM wsal_options WHERE option_name = 'wsal-plugin-viewers' made by require_once('wp-admin/admin.php'), require('wp-admin/menu.php'), require_once('wp-admin/includes/menu.php'), do_action('admin_menu'), call_user_func_array, WSAL_ViewManager->AddAdminMenus, WSAL_Settings->CurrentUserCan, WSAL_Settings->UserCan, WSAL_Settings->GetAccessTokens, WSAL_Settings->GetAllowedPluginViewers, WpSecurityAuditLog->GetGlobalOption, WSAL_DB_Option->GetOptionValue, WSAL_DB_Option->GetNamedOption, WSAL_DB_ActiveRecord->Load, QM_DB->query

WordPress database error Table 'wsal_options' doesn't exist for query SELECT * FROM wsal_options WHERE option_name = 'wsal-plugin-editors' made by require_once('wp-admin/admin.php'), require('wp-admin/menu.php'), require_once('wp-admin/includes/menu.php'), do_action('admin_menu'), call_user_func_array, WSAL_ViewManager->AddAdminMenus, WSAL_Settings->CurrentUserCan, WSAL_Settings->UserCan, WSAL_Settings->GetAccessTokens, WSAL_Settings->GetAllowedPluginEditors, WpSecurityAuditLog->GetGlobalOption, WSAL_DB_Option->GetOptionValue, WSAL_DB_Option->GetNamedOption, WSAL_DB_ActiveRecord->Load, QM_DB->query

WordPress database error Table 'wsal_options' doesn't exist for query SELECT * FROM wsal_options WHERE option_name = 'wsal-restrict-admins' made by require_once('wp-admin/admin.php'), require('wp-admin/menu.php'), require_once('wp-admin/includes/menu.php'), do_action('admin_menu'), call_user_func_array, WSAL_ViewManager->AddAdminMenus, WSAL_Settings->CurrentUserCan, WSAL_Settings->UserCan, WSAL_Settings->GetAccessTokens, WSAL_Settings->IsRestrictAdmins, WpSecurityAuditLog->GetGlobalOption, WSAL_DB_Option->GetOptionValue, WSAL_DB_Option->GetNamedOption, WSAL_DB_ActiveRecord->Load, QM_DB->query

WordPress database error Table 'wsal_options' doesn't exist for query SELECT * FROM wsal_options WHERE option_name = 'wsal-licenses' made by require_once('wp-admin/admin-header.php'), do_action('all_admin_notices'), call_user_func_array, WSAL_Views_AuditLog->AdminNoticesNotificationsExtension, WSAL_LicenseManager->IsLicenseValid, WSAL_Settings->GetLicenseStatus, WSAL_Settings->GetLicense, WSAL_Settings->GetLicenses, WpSecurityAuditLog->GetGlobalOption, WSAL_DB_Option->GetOptionValue, WSAL_DB_Option->GetNamedOption, WSAL_DB_ActiveRecord->Load, QM_DB->query

WordPress database error Table 'wsal_options' doesn't exist for query SELECT * FROM wsal_options WHERE option_name = 'wsal-excluded-users' made by shutdown_action_hook, do_action('shutdown'), call_user_func_array, WSAL_Sensors_PluginsThemes->EventAdminShutdown, WSAL_AlertManager->Trigger, WSAL_AlertManager->CheckEnableUserRoles, WSAL_AlertManager->IsDisabledUser, WSAL_AlertManager->GetDisabledUsers, WSAL_Settings->GetExcludedMonitoringUsers, WpSecurityAuditLog->GetGlobalOption, WSAL_DB_Option->GetOptionValue, WSAL_DB_Option->GetNamedOption, WSAL_DB_ActiveRecord->Load, QM_DB->query

WordPress database error Table 'wsal_options' doesn't exist for query SELECT * FROM wsal_options WHERE option_name = 'wsal-excluded-roles' made by shutdown_action_hook, do_action('shutdown'), call_user_func_array, WSAL_Sensors_PluginsThemes->EventAdminShutdown, WSAL_AlertManager->Trigger, WSAL_AlertManager->CheckEnableUserRoles, WSAL_AlertManager->IsDisabledRole, WSAL_AlertManager->GetDisabledRoles, WSAL_Settings->GetExcludedMonitoringRoles, WpSecurityAuditLog->GetGlobalOption, WSAL_DB_Option->GetOptionValue, WSAL_DB_Option->GetNamedOption, WSAL_DB_ActiveRecord->Load, QM_DB->query

WordPress database error Table 'wsal_options' doesn't exist for query SELECT * FROM wsal_options WHERE option_name = 'wsal-disabled-alerts' made by shutdown_action_hook, do_action('shutdown'), call_user_func_array, WSAL_Sensors_PluginsThemes->EventAdminShutdown, WSAL_AlertManager->Trigger, WSAL_AlertManager->_CommitItem, WSAL_AlertManager->IsEnabled, WSAL_AlertManager->GetDisabledAlerts, WSAL_Settings->GetDisabledAlerts, WpSecurityAuditLog->GetGlobalOption, WSAL_DB_Option->GetOptionValue, WSAL_DB_Option->GetNamedOption, WSAL_DB_ActiveRecord->Load, QM_DB->query

WordPress database error Table 'wsal_options' doesn't exist for query SELECT * FROM wsal_options WHERE option_name = 'wsal-use-proxy-ip' made by shutdown_action_hook, do_action('shutdown'), call_user_func_array, WSAL_Sensors_PluginsThemes->EventAdminShutdown, WSAL_AlertManager->Trigger, WSAL_AlertManager->_CommitItem, WSAL_AlertManager->Log, WSAL_Settings->GetMainClientIP, WSAL_Settings->IsMainIPFromProxy, WpSecurityAuditLog->GetGlobalOption, WSAL_DB_Option->GetOptionValue, WSAL_DB_Option->GetNamedOption, WSAL_DB_ActiveRecord->Load, QM_DB->query

WordPress database error Table 'wsal_options' doesn't exist for query SELECT * FROM wsal_options WHERE option_name = 'wsal-filter-internal-ip' made by shutdown_action_hook, do_action('shutdown'), call_user_func_array, WSAL_Sensors_PluginsThemes->EventAdminShutdown, WSAL_AlertManager->Trigger, WSAL_AlertManager->_CommitItem, WSAL_AlertManager->Log, WSAL_Settings->GetMainClientIP, WSAL_Settings->ValidateIP, WSAL_Settings->IsInternalIPsFiltered, WpSecurityAuditLog->GetGlobalOption, WSAL_DB_Option->GetOptionValue, WSAL_DB_Option->GetNamedOption, WSAL_DB_ActiveRecord->Load, QM_DB->query

There are a lot of entries and I’m still clearing out the log, so it’s tough to tell if there are any other different ones. If I find more, I can come back to let you know, if you like.

I’m also not 100% sure that the error log doesn’t still have new entries being added. Once I’m done clearing out the log, I’ll know. But at this point, Query Monitor isn’t showing any more errors, which is how I found out about the problem in the first place.

Cheers!

Julie
(@habannah)

11 years, 2 months ago

Oops, seems I was typing at the same time as Endymion00 — apologies for any repetition!

WPWhiteSecurity
(@wpwhitesecurity)

11 years, 2 months ago

No worries. Thanks for both updates. Will definitely look into this.

Kate Newbill
(@clnewbill)

11 years, 2 months ago

Good to know that there is an easy fix. I had one site with a 15MB error log created in just three days from this error.

WPWhiteSecurity
(@wpwhitesecurity)

11 years, 2 months ago

Sorry for any inconvenience caused. I can confirmed we identified the issue and a fix should be available shortly (for those installing or still upgrading).

WPWhiteSecurity
(@wpwhitesecurity)

11 years, 2 months ago

Hello all,

We just released version 1.5.1 which addresses all these issues in this ticket. Can you please update the plugin?

Thank you very much for reporting these issues and do not hesitate to get in touch in case of further queries.

Sorry for any inconvenience the plugin might have caused.

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

The topic ‘wp_wsal_options not created with plugin update’ is closed to new replies.