Hi there,
I’m running modx 0.95 rev 2106
on windows server 2003 (lan located whilst I get this little lot sorted)
apache 2.0.55
php 5.1.1
mysql 4.1.7
and whenever I un-publish a document now I’m getting this error whenever I preview the article in the backend. As soon as I re-publish it all seems well. Is there any Javascript dependancies on the Mysql handling on these pages since I have altered the basic javascript engines (aka updated some of them) about the same time.
« 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 fullname FROM `modx`.modx_user_attributes WHERE `modx`.modx_user_attributes.id =
Is there a lot I can do about this? I’m keen to be able to allow users to review and edit un-published work before I have to set it live.
cheers
TXRX
[solved] There was the author snippet in a footer chunk of the articles that wasn’t behaving. Once I removed that from the footers all is well. Thanks for looking sorry if I’ve wasted anyones time
