The LimeSurvey Fund-Raiser 2012 is complete. Thank you for donating a total of 25,000 USD!     List of donors »
Welcome, Guest
Username: Password: Remember me
Forgot your password? Forgot your username?
  • Page:
  • 1

TOPIC: MYSQL Error

MYSQL Error 2 months 2 weeks ago #93371

  • jonespr1
  • jonespr1's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
Hi

Following an upgrade of PHP by my host I was forced to upgrade from v1.85+ to v2.00+.

The upgrade seemed to go well, however as soon as I choose a survey I now get this error, so can't access any of my existing surveys.
---
Internal Server Error

CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='

An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem.

Thank you.
---

Any ideas on how to fix?

Thanks

Robert
The administrator has disabled public write access.

MYSQL Error 2 months 2 weeks ago #93375

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 4431
  • Thank you received: 460
  • Karma: 167
Hello,

Did you have access to your DB via a PHP script like phpMyAdmin ?
If yes, have you ability to copy/create another DB (because ALLWAYS make a copy before doing update ;).
If yes: you can update all table:
ALTER TABLE `dbname`.`tablename` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci
Last Edit: 2 months 2 weeks ago by DenisChenu. Reason: utf8_unicode_ci because default installer use utf8_unicode_ci
The administrator has disabled public write access.

MYSQL Error 2 months 2 weeks ago #93397

  • jonespr1
  • jonespr1's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
Hi

Thanks for responding, I tried a script which used this approach and it didn't work unfortunately, but had some external support and now fixed.

Thanks

Robert
The administrator has disabled public write access.
  • Page:
  • 1
Moderators: DenisChenu, ITEd
Time to create page: 0.200 seconds
Donation Image