Random bug : inaccessible site

Hi,

I got this problem since the upgrade from 0.9.1 to 0.9.2 . The site is going well but I often have this error message instead of 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 `database`.modx_site_content.pub_date < 1157115786 AND `r »
SQL: UPDATE `database`.modx_site_content SET published=1,publishedon=1157115786,publishedby= WHERE `database`.modx_site_content.pub_date < 1157115786 AND `database`.modx_site_content.pub_date!=0
[Copy SQL to ClipBoard]

I clear the cache, and the site is ok again. There is nothing in the modx logs, nothing in apache logs, and nothing in mysql logs. I really dont understand what is going on. Did one of you already have this problem ?

Thank you

Hi daria:

Yes, this is a known issue. Check this thread: http://modxcms.com/forums/index.php/topic,6634.msg46731.html#msg46731 -- there may be some other related threads to, but that should get you started.