Hi Guys,
I recently moved hosts for 130 off clients. Mostly good but a few sites use TxNewsletters.
This is the error I see - looks to be the coding thats not suitable for my MySQL version.
Anyone know what version is best - I might be able to up/down grade. Or is there a code fix to make it compatible?
« 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 '' at line 1 »
SQL: SELECT tv.*, IF(tvc.value!='',tvc.value,tv.default_text) as value FROM `MYDBNAME_modx`.`modx_site_tmplvars` tv INNER JOIN `MYDBNAME_modx`.`modx_site_tmplvar_templates` tvtpl ON tvtpl.tmplvarid = tv.id LEFT JOIN `MYDBNAME_modx`.`modx_site_tmplvar_contentvalues` tvc ON tvc.tmplvarid=tv.id AND tvc.contentid = '' WHERE tv.name IN ('encryption') AND tvtpl.templateid = 
