After upgrading wpDataTables I got the following error on all my tables. My website is now no longer showing data because of this collation error. I have checked the queries in the database, and they still work fine, because nothing has changed there. What can I do?Error
No data fetched! If you are trying to save table for the first time, please enter some date before saving so table could be set accurately. You can remove it later if you need empty table to start with.
Rendered query: SELECT vw_wpforms_report_topticker_1_header.`value_Ticker`, vw_wpforms_report_topticker_1_header.`value_Date` FROM vw_wpforms_report_topticker_1_header LIMIT 10 MySQL said: Illegal mix of collations (utf8mb4_unicode_520_ci,COERCIBLE) and (utf8mb4_unicode_ci,COERCIBLE) for operation '<'
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
I honestly did not encounter this error before, but i will reach out to senior colleagues from our 2nd level Team, they will help us see what's the best approach to tackle the issue.
-
Please provide me a temporary WP-admin (administrator) user for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue.
We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties.
And if you can allow us access to your database, please?
Either a link with credentials for PHPMyAdmin or cPanel access.
You can write credentials here just check PRIVATE Reply so nobody can see them except us.
No data fetched! If you are trying to save table for the first time, please enter some date before saving so table could be set accurately. You can remove it later if you need empty table to start with.
Rendered query: SELECT vw_wpforms_report_topticker_1_header.`value_Ticker`, vw_wpforms_report_topticker_1_header.`value_Date` FROM vw_wpforms_report_topticker_1_header LIMIT 10 MySQL said: Illegal mix of collations (utf8mb4_unicode_520_ci,COERCIBLE) and (utf8mb4_unicode_ci,COERCIBLE) for operation '<'
I know that the issue is, but it does have to do with an upgrade.
I am checking a datetime being smaller than '10:00:00' .. that is giving an error in the wpDataTables, but not in the database itself.
Hi, Glen
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
I honestly did not encounter this error before, but i will reach out to senior colleagues from our 2nd level Team, they will help us see what's the best approach to tackle the issue.
-
Please provide me a temporary WP-admin (administrator) user for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue.
We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties.
And if you can allow us access to your database, please?
Either a link with credentials for PHPMyAdmin or cPanel access.
You can write credentials here just check PRIVATE Reply so nobody can see them except us.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi, Glen
I might have a small update, i was searching online for users who had this same issue, and perhaps i found something useful.
Can you please check out this Post from Stack Overflow?
https://stackoverflow.com/questions/10859966/how-to-convert-all-tables-in-database-to-one-collation
-
Let me know if this helped, please. Thank you
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables