Welcome, Guest
Username: Password: Remember me

TOPIC: "Illegal mix of collations" Error on Upgrade

"Illegal mix of collations" Error on Upgrade 3 years 2 months ago #63575

  • dhudiburg
  • dhudiburg's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 1
  • Karma: 0
I'm upgrading to limesurvey191plus-build10494-20110712

I just did a fresh install with Fantastico and it was working, but I don't remember the version.

First I tried the comfort upgrade, then deleted everything and re-installed and tried the manual upgrade.

In both cased, I get this after logging in:

Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=': SELECT a.*, surveyls_title, surveyls_description, surveyls_welcometext, surveyls_url FROM `lime_surveys` AS a INNER JOIN `lime_surveys_languagesettings` on (surveyls_survey_id=a.sid and surveyls_language=a.language) order by active DESC, surveyls_title


I searched the forum and bug tracker and didn't find anything related.

Any suggestions?
The administrator has disabled public write access.

Aw: "Illegal mix of collations" Error on Upgrade 3 years 2 months ago #63588

  • jelo
  • jelo's Avatar
  • OFFLINE
  • Platinum Lime
  • Posts: 467
  • Thank you received: 52
  • Karma: 16
With delete everything you didn't mean the database, right?

utf8_general_ci vs. utf8_unicode_ci

The collations are different.

I would start from scratch and create a new database and tables.

To fix your current installation you have to execute sql queries.

www.interworks.com/blogs/bbausili/2010/0...llegal-mix-collation

If you have phpmyadmin you might easily fix it with a few clicks.
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.100 seconds
Donation Image