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

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:

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