Error message Table ‘.wp_wsal_metadata’ doesn’t exist

  • Hi – After interaction with MainWP support, it is clear that your plugin seems to be the source of this error message below that flooded my log. The moment I deactivated your plugin the messages stopped:

    WordPress database error Table '<dbname>.wp_wsal_metadata' doesn't exist for query SHOW FULL COLUMNS FROMwp_wsal_metadatamade by do_action('wp_ajax_mainwp_upgradeplugintheme'), WP_Hook->do_action, WP_Hook->apply_filters, MainWP\Dashboard\MainWP_Post_Plugin_Theme_Handler->mainwp_upgrade_plugintheme, MainWP\Dashboard\MainWP_Updates_Handler::upgrade_plugin_theme_translation, MainWP\Dashboard\MainWP_Updates_Handler::update_plugin_theme_translation, MainWP\Dashboard\MainWP_Connect::fetch_url_authed, MainWP\Dashboard\MainWP_Sync::sync_information_array, do_action('mainwp_site_synced'), WP_Hook->do_action, WP_Hook->apply_filters, WSAL\MainWPExtension\Sensors\Sensor_MainWP->site_synced, WSAL\MainWPExtension\AlertManager->trigger, WSAL\MainWPExtension\AlertManager->commit_event, WSAL\MainWPExtension\AlertManager->log, WSAL\MainWPExtension\Loggers\Database->log, WSAL\MainWPExtension\Models\Occurrence->SetMeta, WSAL\MainWPExtension\Models\Occurrence->SetMetaValue, WSAL\MainWPExtension\Models\Meta->SaveMeta, WSAL\MainWPExtension\Adapters\MySQL\ActiveRecord->Save

    • This topic was modified 2 years, 1 month ago by stefhz. Reason: db name removed
Viewing 3 replies - 1 through 3 (of 3 total)

  • Hello @stefhz

    Thank you for using our plugin.

    I am sorry to read about your issue. Indeed, the table ‘wp_wsal_metadata’ is created and used by our plugin. To start off with, can you please confirm if that table exists in your database?

    Also, do you know when this error is being reported? As in are you doing something in particular to reproduce this error?

    Looking forward to hearing from you.

    Thread Starter stefhz

    (@stefhz)

    Hi Robert – Thx for the response.

    I can confirm: that table is missing in that DB.

    I cannot tell you of any specific activity. This is my admin WordPress install, and it’s most of the time in the MainWP environment, i.e., I rarely look at the WP admin dashboard.

    What I can tell you though is that I recently moved hosts, i.e., the DB was set up newly. I do not recall if the error showed up before the migration (I had a ton of sites to migrate…)

    Would re-activating the plugin create the table?

    Sorry that I cannot be of more service.

    Your answer explains the issue: the website was moved and the database is new – so the web host did not create the tables for the plugin.

    Yes, simply deactivating and reactivating the plugin should do the trick. Can you please try it and advise?

    Thank you.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Error message Table ‘.wp_wsal_metadata’ doesn’t exist’ is closed to new replies.