Hi Guys,
I moved web host and TxNewsletters has stopped working.
php version 5.3.27. SQL Client API version 5.5.32
My modx evo version is 1.0.10 - I upgraded and the error stopped displaying its now a blank page and same for the module, see old error below.
« 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 =
