|
haysmacintyre
|
January 24, 2024 at 9:31 am
Hi in our payment area of event espresso we are receiving the following error prompt:
A RuntimeException was thrown! code: EE_Admin_Page – _route_admin_request – 1156
Page route “_payment_methods_list” with the supplied arguments () threw the following exception: WPDB Error: “Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation ‘='”
click to view backtrace
|
|
Sam
|
January 24, 2024 at 10:34 am
Hi Mike,
Can you please try troubleshooting by following the below link:
https://eventespresso.com/wiki/troubleshooting-checklist/
If you are still facing the issue, please share your login information so that we can investigate further.
please fill out this form.
https://eventespresso.com/send-login-details/
thanks
|
|
Tony
|
January 24, 2024 at 3:36 pm
Hi there,
The above can happen when MySQL has been updated since your site was installed and now creating a new table uses a different collation than the others.
The first thing to do fro here is to create a database backup, there are many options for this but one option is to use UpDraft:
https://wordpress.org/plugins/updraftplus/
Once you have a backup, a quick fix is to use this plugin:
https://wordpress.org/plugins/database-collation-fix/
That will update the database to all use the same collation and should fix the above error for you.
|
