We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
MODX Community Forums Archive

Installer fails at Chuncks

    • 13986
    • 90 Posts
    jeremy Reply #1, 16 years, 2 months ago
    Trying to install a fresh copy of modx evo 1.0.4

    Installer says all is well (except that register globals is on but I don’t think this is the issue).

    Then fails during "Chunck" install section:

    Install results

Setup will now attempt to setup the database:

Creating connection to the database: OK!

Selecting database `stratt`: OK!

Checking table prefix `modx_`: OK!

Creating database tables: OK!

Writing configuration file: OK!

Templates:

  MODxHost: Installed
Chunks:

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 `s


    The hosting account is running php4 and MySQL client version: 4.0.27

    Edit: of course now I check the requirements and see that MySQL 4.1.20 or newer is required, would this be causing the install problem?

    I’d just like to verify before seeing if the host will upgrade MySQL.

    Thanks
      Jeremy Foster
      • 13986
      • 90 Posts
      jeremy Reply #2, 16 years, 2 months ago
      can anyone confirm this is the issue? the host said they won’t upgrade mysql. so I would have to get the client to move their hosting to a new provider to get an upgraded mysql. Would like to know if that’s the issue before suggesting they do move.

      huh
        Jeremy Foster
        • 22303 MODX Staff
        • 10,725 Posts
        opengeek Reply #3, 16 years, 2 months ago
        That is indeed the issue. And I would suggest to anyone who is still using a host running PHP 4 and/or MySQL 4 to get a new host.
          Jason Coward
          Chief Architect @ MODX
          http://www.jasoncoward.com | http://twitter.com/drumshaman | https://github.com/opengeek
          • 24683
          • 1 Posts
          recmund Reply #4, 16 years, 2 months ago
          I can confirm it. Using PHP 4 MySQL 4. Any other solutions than changing host?