Record search error
I'm getting MySQL Error: Illegal mix of collations for operation 'like'
when trying to search records in the "orders" table.
In the Search Fields having:
What version of CMSB and PHP are you running with?
Try to upgrade to the newest version of cmsb and go to section editors page (for updating schema) and see if the issue is still there. Here is a guide on how to update cmsb just in case: https://www.interactivetools.com/docs/cmsbuilder/upgrade.html
This is not a good solution right now.
With the latest version I need to upgrade host, php version, scripts and this is not a good time for all of that.
Other ideas on what do I need to check about the issue?
I assume the error is to do with character sets. In the newer cmsb we added code to upgrade all tables to utf8mb4 so that all special characters are supported.