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?

Leo - PHP Programmer (in training)
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

Leo - PHP Programmer (in training)
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.

Leo - PHP Programmer (in training)
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