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 10 months 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
8 years 9 months ago #135651 by wsge
Nobody? Any tip? Anything to solve the problem?
The topic has been locked.
More
8 years 9 months ago - 8 years 9 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: 8 years 9 months ago by Drewskie.
The topic has been locked.
More
8 years 9 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 & Official Partner
  • LimeSurvey Community Team & Official Partner
More
8 years 9 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 support - Plugins, theme and development .
I don't answer to private message.
The topic has been locked.
More
8 years 9 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
8 years 8 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.
Moderators: holchtpartner

Lime-years ahead

Online-surveys for every purse and purpose