07/07/14 13:43:29
XREAで使ってますが、ページを表示しようとするとこんなエラーが出ます。
何が悪いのでしょうか？
≪ 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,IMPLICIT) and (ujis_japanese_ci,COERCIBLE) for operation 'if' ≫
SQL: SELECT DISTINCT sc.id, sc.menutitle, sc.pagetitle, sc.introtext,
sc.menuindex, sc.published, sc.hidemenu, sc.parent, sc.isfolder, sc.description,
sc.alias, sc.longtitle, sc.type,if(sc.type='reference',sc.content,'') as content,
sc.template, sc.link_attributes FROM `ancosme`.`modx_site_content` sc LEFT JOIN
`ancosme`.`modx_document_groups` dg ON dg.document = sc.id WHERE sc.published=1
AND sc.deleted=0 AND (sc.privateweb=0) AND sc.hidemenu=0 AND sc.id IN (1,2,5,7,8,11,15,33,39,32,4,37,46,6,9,3,18,16,22,14,24,44,42,43) GROUP BY sc.id
ORDER BY sc.menuindex ASC ;
[Copy SQL to ClipBoard]