MODx Parse Error

Hi ,

I have the following problem - the error appears no matter what on my site.


« 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 ’WHERE `best4vil_Best4Villas`.modx_site_content.pub_date < 1162424902 AND `best4v’ at line 1 »
SQL: UPDATE `best4vil_Best4Villas`.modx_site_content SET published=1, publishedon=1162399702, publishedby= WHERE `best4vil_Best4Villas`.modx_site_content.pub_date < 1162424902 AND `best4vil_Best4Villas`.modx_site_content.pub_date!=0
[Copy SQL to ClipBoard]

I have been developing the site for 7 weeks and thought I would try and use the NewsListing snippet and sample pages. What I did immediately before this error happened was create a new article then the above appeared I have checked and repaired the mySQL database and it has made no difference.


Help!!!

This is fixed in 0.9.5 betas, so you could update to that or search the forums for a fix.. you can probably find one in the "known issues and resolutions" thread..

EDIT: newslisting is deprecated in 0.9.5 btw.. it’s been replaced by Ditto.