We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 16773
    • 18 Posts
    help! Getting this error on a modx site that was working fine:

    The url is www.everetts.co.uk/site2

    The error, is:

    -------
    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 near ’WHERE `everetts`.modx_site_content.pub_date < 1164989677 AND `everetts`.modx_sit’ at line 1 »
    SQL: UPDATE `everetts`.modx_site_content SET published=1, publishedon=1164989677, publishedby= WHERE `everetts`.modx_site_content.pub_date < 1164989677 AND `everetts`.modx_site_content.pub_date!=0

    -------
      • 25663 MODX Staff
      • 12,272 Posts
      What version of MODx are you running and are you using scheduled publishing events?
        Ryan Thrash, MODX Co-Founder
        Follow me on Twitter at @rthrash or catch my occasional unofficial thoughts at thrash.me
        • 16773
        • 18 Posts
        Using MODx 0.9.2.1 (rev 1005) and I don’t understand the scheduled thing you mention - fairly new to modx!!

        Thanks
          • 16773
          • 18 Posts
          This issue is now resolved through use of another post - http://modxcms.com/forums/index.php/topic,6850.msg47974.html