I am on Ubuntu server, LAMP, WP6.01, with php7.4-fpm. I just extracted a number of sites from the same multisite installation and during the wp-cli search and replace command to replace the urls and the paths on 4 out of 7 sites I got the following error:
PHP Warning: mysqli_query(): (HY000/1356): View 'username_wordpress.wp_12_uap_action_logs_view' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them in /home/username/public_html/wp-includes/wp-db.php on line 2169
Warning: mysqli_query(): (HY000/1356): View 'username_wordpress.wp_12_uap_action_logs_view' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them in /home/username/public_html/wp-includes/wp-db.php on line 2169
PHP Warning: mysqli_query(): (HY000/1356): View 'username_wordpress.wp_12_uap_api_logs_view' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them in /home/username/public_html/wp-includes/wp-db.php on line 2169
Warning: mysqli_query(): (HY000/1356): View 'username_wordpress.wp_12_uap_api_logs_view' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them in /home/username/public_html/wp-includes/wp-db.php on line 2169
PHP Warning: mysqli_query(): (HY000/1356): View 'username_wordpress.wp_12_uap_recipe_logs_view' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them in /home/username/public_html/wp-includes/wp-db.php on line 2169
Warning: mysqli_query(): (HY000/1356): View 'username_wordpress.wp_12_uap_recipe_logs_view' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them in /home/username/public_html/wp-includes/wp-db.php on line 2169
PHP Warning: mysqli_query(): (HY000/1356): View 'username_wordpress.wp_12_uap_trigger_logs_view' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them in /home/username/public_html/wp-includes/wp-db.php on line 2169
Warning: mysqli_query(): (HY000/1356): View 'username_wordpress.wp_12_uap_trigger_logs_view' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them in /home/username/public_html/wp-includes/wp-db.php on line 2169
Prior to wp db import oldmultisitedb.sql for each site, I used nano to search and replace the DEFINER=olduser and replace it with the new user (or else db import would be impossible), therefore I don't understand why the warnings above popped up? 🤔🤔
I have tested the sites and everything seems to be working correctly....
Can I safe ignore the warnings? Or is this a problem that is going to come back to haunt me?
