Execution of a query to the database failed - Illegal mix of collations

Hello friends!

I have installed v 1.0.0

After this I tried to create the new template and there was such an error appeared:

Warning: Cannot modify header information - headers already sent by (output started at /var/sites/f/fridaycat.com/public_html/fridaycat/manager/includes/header.inc.php:6) in /var/sites/f/fridaycat.com/public_html/fridaycat/manager/includes/document.parser.class.inc.php on line 2730
« MODx Parse Error »
MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation ’if’ »


Can you help me with this?
Thank you!

Alex

What version of MySQL are you running?

The first part of that error can pop up if you try to start a session twice in one script:

The first error will occur any time there is a fatal PHP error that overrides the MODx error reporting. Since PHP will establish its own headers for displaying its errors, MODx cannot set headers for what it wants to send.

Quote from: garryn at Sep 05, 2009, 11:58 PM

What version of MySQL are you running?

I use MySQL 5. I also have there MSSQL 2005.

In this error there was also this text:
SQL: SELECT `fridayca_f`.`fridaycat_site_templates`.templatename as name, `fridayca_f`.`fridaycat_site_templates`.id, `fridayca_f`.`fridaycat_site_templates`.description, `fridayca_f`.`fridaycat_site_templates`.locked, if(isnull(`fridayca_f`.`fridaycat_categories`.category),’Без категории’,`fridayca_f`.`fridaycat_categories`.category) as category FROM `fridayca_f`.`fridaycat_site_templates` left join `fridayca_f`.`fridaycat_categories` on `fridayca_f`.`fridaycat_site_templates`.category = `fridayca_f`.`fridaycat_categories`.id ORDER BY 5,1

MySQL 5 what? There are countless versions of MySQL 5.

Regardless, the problem is as the error states, you have an illegal mixture of collations. I’d check your database container’s collation and the collations of the tables in it. It seems as though they are not set properly.

Quote from: OpenGeek at Sep 06, 2009, 03:44 PM

MySQL 5 what? There are countless versions of MySQL 5.

What do you mean?

Regardless, the problem is as the error states, you have an illegal mixture of collations. I’d check your database container’s collation and the collations of the tables in it. It seems as though they are not set properly.

So how can I fix that?
Sorry, I am not so good in coding

Quote from: OpenGeek at Sep 06, 2009, 03:44 PM

I’d check your database container’s collation and the collations of the tables in it. It seems as though they are not set properly.

How can I make this correct? What collation would I set there?

Quote from: OpenGeek at Sep 06, 2009, 03:44 PM

MySQL 5 what? There are countless versions of MySQL 5.

5.0.45

SOLVED
_______________


I’ve made a new database, changed collation first and then reinstall modx to it. Now everything is ok

Thank you!

Alex