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
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
Many thanks.
I tried searching for help, but I couldn’t find anything for a beginner like myself!
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.
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;
That worked perfectly.
Many thanks.
