- Posts: 8
- Thank you received: 0
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'
- wsge
- Topic Author
- Offline
- New Member
Less
More
8 years 1 week ago #134627
by wsge
SQL: SQLSTATE[HY000]: General error: 1273 Unknown collation: 'utf8mb4_bin' was created 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?
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.
- wsge
- Topic Author
- Offline
- New Member
Less
More
- Posts: 8
- Thank you received: 0
7 years 11 months ago #135651
by wsge
Replied by wsge on topic SQL: SQLSTATE[HY000]: General error: 1273 Unknown collation: 'utf8mb4_bin'
Nobody? Any tip? Anything to solve the problem?
The topic has been locked.
- Drewskie
- Offline
- Junior Member
Less
More
- Posts: 21
- Thank you received: 1
7 years 11 months ago - 7 years 11 months ago #135653
by Drewskie
Replied by Drewskie on topic SQL: SQLSTATE[HY000]: General error: 1273 Unknown collation: 'utf8mb4_bin'
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.
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.
- wsge
- Topic Author
- Offline
- New Member
Less
More
- Posts: 8
- Thank you received: 0
7 years 11 months ago #135655
by wsge
Replied by wsge on topic SQL: SQLSTATE[HY000]: General error: 1273 Unknown collation: 'utf8mb4_bin'
How it is possible this happened after a ComfortUpdate?
Anybody has another opinion or idea?
Anybody has another opinion or idea?
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13643
- Thank you received: 2491
7 years 11 months ago #135684
by DenisChenu
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.
Replied by DenisChenu on topic SQL: SQLSTATE[HY000]: General error: 1273 Unknown collation: 'utf8mb4_bin'
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)
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.
- minerva1961
- Offline
- New Member
Less
More
- Posts: 5
- Thank you received: 0
7 years 11 months ago #136055
by minerva1961
Replied by minerva1961 on topic SQL: SQLSTATE[HY000]: General error: 1273 Unknown collation: 'utf8mb4_bin'
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..
"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.
- wsge
- Topic Author
- Offline
- New Member
Less
More
- Posts: 8
- Thank you received: 0
7 years 10 months ago #137936
by wsge
Replied by wsge on topic SQL: SQLSTATE[HY000]: General error: 1273 Unknown collation: 'utf8mb4_bin'
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,?
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.