Login | Sign up | Toll-Free: 1-800-752-0455
 
 

Forum

 

7 posts by 2 authors in: Forums > CMS Builder
Last Post: 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

Hi Karls,

What version of CMSB and PHP are you running with?

Leo - PHP Programmer (in training)
interactivetools.com

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

Leo - PHP Programmer (in training)
interactivetools.com

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

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.

Leo - PHP Programmer (in training)
interactivetools.com

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