Hi People,
Something strange has happened. I have a snippet that has not been modified ( nor the snippet, nor the page that call it ).
Everything has been working fine for more than a year.
The project started using 0.9.6 and recently was migrated to EVO 1.0.4. Now I am having problems. I don’t exactly know if it was caused by the upgrade, but I think no, because the upgrade was a month ago and users has reported problems since yesterday.
Each time the page calling the snippet is requested, a parser error is generated:
« Execution of a query to the database failed - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' »
SQL: SELECT * FROM `salapara_modx`.`modx_site_snippets` WHERE `salapara_modx`.`modx_site_snippets`.name='?Y?u#n`??F??w e?\n?P?9(F\r?????OO????\0jz??½&???vz??d???t?u?Q???|?&_PHX_INTERNAL_091_&go_???|Y?\Z-O?????N??P???&_PHX_INTERNAL_091_&?a&_PHX_INTERNAL_091_&G?????g';
I’ve changed the collation of database and all the tables to utf8_general_ci and nothing.
I’ve repaired tables and nothing.
It is strange to see: PHX_INTERNAL ( PHx Installed ) 2.1.3
With PHx disabled I get this 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 (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' »
SQL: SELECT * FROM `salapara_modx`.`modx_site_snippets` WHERE `salapara_modx`.`modx_site_snippets`.name='??E??p6? t?h??????n??Vv?v?hÞ??#?g?,?z_?F???a?g?~ ? $??o>?;?m1??\\??P ??|??~?_???%?&??:t?g??\r?W??E{1??~5g?I???W/?Q@6????u???5?*????@\Z????v???.?v?]??/?_?oi????@ ?Ji????-????????\\??A_[?&????&9U?u??Yp?B??O?a?Yg???kjS?9\n7lE ?\'?w?|???????P???t??M?????A b!?Fv?u??d???4???#?-?\"x?_?+ ?Y6???-??J???????????u,??h???|?k?/}???xw?N???|???9??@?/?\\ex??+?K?~??????u?jV?^?AE??$f;F?6??????%??:M????q]??c?.?Vd???\0????';
PHP Version 5.2.14
MySQL 5.0.91
MODx 1.0.4
PHx 2.1.3
PHP.ini
-----------------
max_execution_time=600
max_input_time=600
memory_limit=1024M
post_max_size=20M
upload_max_filesize=20M
pcre.backtrack_limit=200000
Any help please? It is so important, this script is needed to show the users tickets they have to print before thursday and I don’t know what else to do
Thank you for your help!
