Database error

  • Resolved PetZe

    (@petze)


    3 years, 4 months ago

    Hi.

    I keep getting the SQL query error even after uninstalling the plugin – how can it be solved?

    Thank you.

    error messages:

    DESC wpstg0_uap_action_logs_view

    View ‘d214522_f8tqnd.wpstg0_uap_action_logs_view’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use themqmdb

    DESC wpstg0_uap_api_logs_view

    View ‘d214522_f8tqnd.wpstg0_uap_api_logs_view’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use themqmdb

    DESC wpstg0_uap_recipe_logs_view

    View ‘d214522_f8tqnd.wpstg0_uap_recipe_logs_view’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use themqmdb

    DESC wpstg0_uap_trigger_logs_view

    View ‘d214522_f8tqnd.wpstg0_uap_trigger_logs_view’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use themqmdb

    • This topic was modified 3 years, 4 months ago by PetZe.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Rene Hermenau

    (@renehermi)

    3 years, 4 months ago

    Hi,

    These are staging site tables. So is it correct that you get the errors on the staging site?

    Recreating the staging site should fix it. If you get the same error, please open a support ticket on that page https://wp-staging.com/support/

    The errors indicate that the mentioned views contain references to a different table.
    Did you manually migrate your staging site to a live site, or did this issue happen from the beginning after creating the staging site?

    • This reply was modified 3 years, 4 months ago by Rene Hermenau.
    Thread Starter PetZe

    (@petze)

    3 years, 1 month ago

    Sorry for the late reply – I had an accident.
    I’m not sure when the error messages first appeared. I only found them when I started to troubleshoot the performance issue.
    FYI the error still occurs even when the plugin is disabled.<font _mstmutation=”1″></font>

    • This reply was modified 3 years, 1 month ago by PetZe.
    Plugin Author Rene Hermenau

    (@renehermi)

    3 years, 1 month ago

    Hey @petze,

    I am sorry to hear about your accident. I hope all is back to normal again.

    As already said, these tables are usually wp staging tables and they can be safely removed.

    To do that, you can install wp staging again and then go to wp staging > actions > delete to delete the staging site and the connected wpstg0* database tables.

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

The topic ‘Database error’ is closed to new replies.