PHP Errors after Update to Version 4.1.3.2

  • Resolved sally

    (@sallyruchman)


    5 years, 9 months ago

    Hello,

    after Update i get the following PHP Errors:

    [17-Aug-2020 08:57:58 UTC] WordPress database error Table ‘wordpress_m.Xxxxxxx_wsal_options’ doesn’t exist for query SELECT * FROM Xxxxxxx_wsal_options WHERE option_name = ‘wsal-version’ made by require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->init, WpSecurityAuditLog->GetOldVersion, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
    [17-Aug-2020 08:57:59 UTC] WordPress database error Table ‘wordpress_m.Xxxxxxx_wsal_options’ doesn’t exist for query SELECT * FROM Xxxxxxx_wsal_options WHERE option_name = ‘wsal-version’ 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’), WP_Hook->do_action, WP_Hook->apply_filters, WpSecurityAuditLog->init, WpSecurityAuditLog->GetOldVersion, WpSecurityAuditLog->GetGlobalOption, WSAL_Models_Option->GetOptionValue, WSAL_Adapters_MySQL_Option->GetNamedOption, WSAL_Adapters_MySQL_ActiveRecord->Load
    [17-Aug-2020 08:58:11 UTC] WordPress database error Table ‘wordpress_m.Xxxxxxx_wsal_options’ doesn’t exist for query SELECT * FROM Xxxxxxx_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

    How to fix these??
    Thx

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Support robertabela

    (@robert681)

    5 years, 9 months ago

    Hello @sallyruchman

    Between version 4.1.2 and 4.1.3 we have migrated the plugin’s settings from a custom table to the default WordPress options table. You can read more about this in the release notes.

    So this issue was kind of expected in some setups. Can you please deactivate and activate the plugin again? Can you please advise if that helps?

    Looking forward to hearing from you.

    Thread Starter sally

    (@sallyruchman)

    5 years, 9 months ago

    Hello Robertabela,

    thanks for the information. Restart did not help. I would like to reinstall fresh the actual Version. Are the following tables all where Activity Log store the old information:

    _wsal_metadata
    _wsal_occurrences
    _wsal_options

    Thx
    Sally

    Thread Starter sally

    (@sallyruchman)

    5 years, 9 months ago

    Deleted yet the 3 tables above, installed the Plugin fresh, now I get again the error message sorry you are not allowed when I try to open the settings.

    Created Table wsal_options is now complete empty..

    Where do I find now the wsal_restrict-plugin-settings exactly??

    Thx

    Plugin Support robertabela

    (@robert681)

    5 years, 9 months ago

    Hello @sallyruchman

    Sorry, I misread your previous message. Here is the fix: delete the setting wsal_restrict-plugin-settings from the

    wp_options

    table.

    This is a setting used in version pre 4.1.3 and unfortunately in some cases the plugin is unable to delete it during the upgrade process.

    Can you please keep us updated about the fix?

    Thread Starter sally

    (@sallyruchman)

    5 years, 9 months ago

    Hello Robertabela,

    thanks for the information. I deleted yet under wp_options the wsal_restrict-plugin-settings , and now I can adapt the settings again, perfect.

    Im just wondering, as the settings are moved now from wsal_options to wp_options table, can the still existing / empty table wsal_options be deleted ???

    Thx
    Sally

    Plugin Support robertabela

    (@robert681)

    5 years, 9 months ago

    Glad to hear that the issue is sorted @sallyruchman

    The old table is no longer required so yes it can be deleted. We did not delete it automatically since it is a high risk task, however, we are planning of releasing a patch which you can install separately to have it deleted.

    I hope the above helps. Can you please rate our plugin and service here: https://ww.wp.xz.cn/plugins/wp-security-audit-log/#reviews ? These reviews really help us.

    Thank you very much.

    Thread Starter sally

    (@sallyruchman)

    5 years, 9 months ago

    Hello Robertabela,

    i deleted the old table wsal_options . When i deactivate / activate again WP Activity Log, the old empty table wsal_options is recreated in the Database…

    Can you please let me know, how i can get rid of the old wsal_options table persistent?

    Thx
    Sally

    Plugin Support robertabela

    (@robert681)

    5 years, 9 months ago

    Hello @sallyruchman

    The plugin is still creating that table as a precaution for now, since the migration was done in this update. In one of the upcoming updates we will take care of this.

    I hope that answers your question. Should you have any other questions, please do not hesitate to ask.

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

The topic ‘PHP Errors after Update to Version 4.1.3.2’ is closed to new replies.