Warnings encountered

  • Resolved jasperdemann

    (@jasperdemann)


    1 year, 6 months ago

    Hi

    My backup is always successful, but I regularly (not every backup though) receive this error:
    Warnings encountered: * Failed to backup database table: (View ‘u821715260_migration.wp_uap_recipe_logs_view’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them) (table_details_error)

    Is it anything to worry about?

    Jasper

    The page I need help with: [log in to see the link]

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Contributor bcrodua

    (@bcrodua)

    Hi Jasper,

    It appears that UpdraftPlus doesn’t have the necessary privileges or permissions to backup the table. Confirm that the user has the required privileges to access the view and the underlying tables.

    Thanks,
    Bryle

    Thread Starter jasperdemann

    (@jasperdemann)

    Okay, thanks.

    Would I do that in Updraft or somewhere else….in layman’s terms, please!

    Plugin Contributor bcrodua

    (@bcrodua)

    Hi,

    Try this tutorial I found by searching on Google – https://shorturl.at/cqIK7

    I hope it helps.

    Thanks,
    Bryle

    Thread Starter jasperdemann

    (@jasperdemann)

    Many thanks.

    I tried searching for help, but I couldn’t find anything for a beginner like myself!

    Thread Starter jasperdemann

    (@jasperdemann)

    Hi
    I’m now working with my hosting provider to try to fix this issue.
    I’ve checked the permissions and all looks good.
    I’ve also deactivated all plugins except UpdraftPlus and rolled back to PHP 7.4 but the warning message is still there after a fresh backup.
    The guy from Hostinger has asked me to find out from you….
    “It seems that DEFINER is mentioned. Would it be possible to check with the plugin developers if DEFINER commands that may require super user privileges are used perhaps?”
    …and……
    The best path seems to be to contact the plugin developer to see if an option may have been configured that may need super user privileges/ root access to MySQL for commands such as DEFINER if used and if so, if possible to disable the option to use super user commands.

    Plugin Support vupdraft

    (@vupdraft)

    Can you try running the following command in php MyAdmin

    Essentially, all you need to do is delete this view.

    DROP VIEW u821715260_migration.wp_uap_recipe_logs_view;

    Thread Starter jasperdemann

    (@jasperdemann)

    That worked perfectly.
    Many thanks.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Warnings encountered’ is closed to new replies.