Oiy...
A long time ago, I had added a custom Module to count page hits. Well, today I deleted it because I wasn’t using it (so I thought). Now I can’t see my site! I get :
« 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 ' 1) ON DUPLICATE KEY UPDATE page_count=page_count+1' at line 1 »
SQL: INSERT INTO page_hit_counter (page_id, page_count) VALUES (, 1) ON DUPLICATE KEY UPDATE page_count=page_count+1
I deleted the module using the manager control panel, and I deleted the directory that was added in the assets/modules/ folder.
I grep’ed through my code-base for any instances of "page_hit_counter" or "page_count", and I only found:
/assets/cache/siteCache.idx.php
I deleted the custom hack that was in that file for the module.... but each time I refresh the page, that file reverts to where it was (which includes the page_hit_count hack).
AACK!! This thing won’t die. Where is it being resurrected from? Anyone have any experience with this?
Many, many thanks.
I emptied the cache using the Manager control panel... but still the site is down.
☆ A M B ☆
MODX Staff
