Welcome, Guest
Username: Password: Remember me

TOPIC: ComfortUpdater problem

ComfortUpdater problem 2 years 10 months ago #62357

  • mark
  • mark's Avatar
  • OFFLINE
  • Senior Lime
  • Posts: 74
  • Karma: 0
I host with SiteGround. I tried to upgrade to the latest build using ComfortUpgrader. Everything seemed to work well until I tried entering Limesurvey again. I get the following error report -

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

Any suggestions? I do have the files & database backups.
I use an uploaded template "Clear" - could this be the problem?
Regards
Mark
The administrator has disabled public write access.

Re: ComfortUpdater problem 2 years 10 months ago #62361

  • ljarbeau
  • ljarbeau's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 12
  • Karma: 0
same thing just happened to me .... :( Subscribing to thread
The administrator has disabled public write access.

Re: ComfortUpdater problem 2 years 9 months ago #62404

  • tobyrhodes
  • tobyrhodes's Avatar
  • OFFLINE
  • Junior Lime
  • Posts: 20
  • Thank you received: 1
  • Karma: 0
Hi Mark

I encountered this a couple of weeks ago.

I have found the problem ... it is to do with the collation of individual fields and some tables of the MySQL database ... these all need setting to utf8_unicode_ci (using PHPMyAdmin)

If you follow this thread www.limesurvey.org/en/forum/installation...pgrade-problem#61781
and this bugs.limesurvey.org/view.php?id=4725, then you should find the solution.

cheers
Toby

:)
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.119 seconds
Donation Image