Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

SQL: SQLSTATE[HY000]: General error: 1273 Unknown collation: 'utf8mb4_bin'

More
8 years 1 week ago #134627 by wsge
Hello,
after a ComfortUpdate I did a month ago I see such error:
CDbCommand SQL: SQLSTATE[HY000]: General error: 1273 Unknown collation: 'utf8mb4_bin'
I did it the update from 2.50+ version, before the update the LS worked fine.

Unfortunately I am not a PHP whatsoever specialist. Any clue?
The topic has been locked.
More
7 years 11 months ago #135651 by wsge
Nobody? Any tip? Anything to solve the problem?
The topic has been locked.
More
7 years 11 months ago - 7 years 11 months ago #135653 by Drewskie
collation is related to the database, not sure if that helps.

Think it may be the charset in the config file but not an expert here either.
Last edit: 7 years 11 months ago by Drewskie.
The topic has been locked.
More
7 years 11 months ago #135655 by wsge
How it is possible this happened after a ComfortUpdate?
Anybody has another opinion or idea?
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
7 years 11 months ago #135684 by DenisChenu
MySQL have issue with emoji. This van break db . we nées to use emoji collation.

I think 2.06 dont use emoji collation. Try to install a 2.06 version. Or Update tour mysl server ( sée manual for minimum)

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
More
7 years 11 months ago #136055 by minerva1961
Having the same issue, turns out my MYSQL is too old.

"Your mysql version is too old, place it with the 5.6"

Tried various solutions like this stackoverflow.com/questions/29916610/127...b4-unicode-ci-cpanel but to no avail. Looks like I have to bite the bullet..
The topic has been locked.
More
7 years 10 months ago #137936 by wsge
I did not solve this problem yet.
Where can I find the file having this line:
SQL: SQLSTATE[HY000]: General error: 1273 Unknown collation: 'utf8mb4_bin'

I came up to an idea, please correct me if I think wrong: my default admin language is Polish.
If I only could switch to English would that error still pop up?
Is there any way to change language setting directly in config files?
Or it make no sense and the error will appear anyways?

Oh, and I noticed LS has been installed on MySQL 5.0, that would be my solution here?
How can I take save and backup old surveys with all answers, tokens etc,?
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose