We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 24712
    • 1 Posts
    I’m trying to update my old MODX CMS website, version 0.9.6, to version 1.0.4

    No matter what I do, I keep getting error messages on the last page with title "Install results":

    Modules:
    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 ’SELECT (CASE COUNT(*) WHEN 0 THEN 0 ELSE `id` END) `id` FROM `d

    First I got this error message with "Chunks", so I tried another install without Chunks and with only two modules selected, Wayfinder and Ditto.

    I also tried to update and I tried a clean install, but no matter what I trie, I always see this error message. I’m switching back to 0.9.6 now.

    Does anybody know how to solve this problem?

    My hosting specs are:
    Server version: 4.0.24_Debian-10sarge1-log
    MySQL client version: 5.0.32
    PHP Version 4.4.4-9