|
linguarum
|
May 29, 2023 at 12:03 pm
I was receiving notices urging me to switch to PayPal Commerce integration instead of PayPal Express. So I went to Settings / Payment Methods and all I get is an error message:
A RuntimeException was thrown! code: EE_Admin_Page – _route_admin_request – 1150
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 and class/method details
/home/774273.cloudwaysapps.com/jptjgsehnn/public_html/wp-content/plugins/event-espresso-core-reg/core/admin/EE_Admin_Page.core.php ( line no: 1150 )
Can you help?
Thank you!
|
|
Tony
|
May 30, 2023 at 7:51 am
Hi there,
This is related to your database tables rather than the code itself.
Some of your tables are using utf8mb4_unicode_ci and at least one is using utf8mb4_unicode_520_ci
Before moving forward create a full database backup just to be safe.
Then you try using a plugin like this to convert the collections:
https://wordpress.org/plugins/database-collation-fix/
That should fix the table collection and the above should then work.
As mentioned, be sure to have a DB backup before using the above just incase. Converting the collections should be fine but always better to be safe than sorry.
|
