Error with the plugin while moving the SQL DB to a different hosting

Ticket for: Accordions
0
Error with the plugin while moving the SQL DB to a different hosting 1
Nikil Jose
Apr 05, 2025 06:52 AM 1 Answers
Member Since Jan 1970
Unsolved Solved Mark as Solved Mark as Unsolved
Subscribed Subscribe Not subscribe
Flag(0)

Error

SQL query:

CREATE ALGORITHM=UNDEFINED DEFINER=`mpamqrmy_n9`@`localhost` SQL SECURITY DEFINER VIEW `FfO_uap_action_logs_view` AS SELECT `a`.`automator_action_id` AS `automator_action_id`, `a`.`date_time` AS `action_date`, `a`.`completed` AS `action_completed`, `a`.`error_message` AS `error_message`, `a`.`automator_recipe_id` AS `automator_recipe_id`, `a`.`ID` AS `action_log_id`, `a`.`automator_recipe_log_id` AS `recipe_log_id`, `r`.`date_time` AS `recipe_date_time`, `r`.`completed` AS `recipe_completed`, `r`.`run_number` AS `recipe_run_number`, `pa`.`post_title` AS `action_title`, `am`.`meta_value` AS `action_sentence`, `p`.`post_title` AS `recipe_title`, `u`.`ID` AS `user_id`, `u`.`user_email` AS `user_email`, `u`.`display_name` AS `display_name` FROM (((((`FfO_uap_action_log` `a` left join `FfO_uap_recipe_log` `r` on((`a`.`automator_recipe_log_id` = `r`.`ID`))) left join `FfO_posts` `p` on((`p`.`ID` = `a`.`automator_recipe_id`))) join `FfO_posts` `pa` on((`pa`.`ID` = `a`.`automator_action_id`))[...]

MySQL said: 

#1227 - Access denied; you need (at least one of) the SUPER or SET_USER_ID privilege(s) for this operation

0 Subscribers
Submit Answer
Please login to submit answer.
1 Answers
Sort By:
Best Answer
0
Error with the plugin while moving the SQL DB to a different hosting 2
PickPlugins
Apr 06, 2025
Flag(0)

Welcome to PickPlugins

I guess this is not related to our plugins, its probably SQL version issue, i would suggest try updraftplus for moving sites.

https://wordpress.org/plugins/updraftplus/

Regards

Sign in to Reply
Replying as Submit