Record search error
7 posts by 2 authors in: Forums > CMS Builder
Last Post: May 14, 2018 (RSS)
By ht1080z - May 14, 2018
Hi,
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:
_all_
Κατάσταση|status|match
Client|client|match
Please advise,
Karls
By leo - May 14, 2018
Hi Karls,
What version of CMSB and PHP are you running with?
interactivetools.com
By ht1080z - May 14, 2018
Hi Leo,
cmsB v3.06 (Build 2101) & PHP v5.6.36 & MySQL v5.6.39
Thank you,
Karls
By leo - May 14, 2018
Hi Karls,
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
interactivetools.com
By ht1080z - May 14, 2018
Hi Leo,
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?
Karls
By leo - May 14, 2018
Hi Karls,
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.
interactivetools.com
By ht1080z - May 14, 2018
Thank you Leo for the suggestion, I'll look into it in the near future to upgrade the cmsB and all the related systems.
I'll update this post with results.
Karls