MySQL 4 error on installer using 1.0.2

During installation / upgrade (possibly just upgrade) I received errors related to the following SQL statement: SELECT (CASE COUNT(*) WHEN 0 THEN 0 ELSE `id` END)

This statement exists in several places in the instprocessor.php file and through errors for each time it was encountered.

Seeing that it was only related to updating categories for various chunks, snippets, etc. I commented out the offending blocks and completed the upgrade successfully.

My hosted server is running MySQL 4.0.7-max-log though the interface claims to be MySQL 5.0+ in php info.

Any comments on whether I truncated my install by commenting out those blocks or why those statements are throwing errors?

You are most likely going to hit ongoing problems with that version of MySQL as the minimum version officially supported by MODx is 4.1.20 or newer.