08/10/12 13:05:11
ローカル環境でMODx稼働させるようにWebサーバーから移行したいんだけど
こんなエラーが出て移行できない・・・だれか助けてヽ( `Д´)ﾉ
MODx Parse Error
MODx encountered the following error while attempting to parse the requested resource:
Execution of a query to the database failed - You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY tv.name ASC' at line 1
SQL: SELECT tv.id,tv.name, IF(tvc.value!='',tvc.value,tv.default_text) as value FROM `hogehoge`.`modx_site_tmplvars` tv INNER JOIN `hogehoge`.
`modx_site_tmplvar_templates` tvtpl ON tvtpl.tmplvarid = tv.id LEFT JOIN `hogehoge`.
`modx_site_tmplvar_contentvalues` tvc ON tvc.tmplvarid=tv.id AND tvc.contentid = '1' WHERE tv.id<>0 AND tvtpl.templateid = ORDER BY tv.name ASC