Error with History processing

Archived from the LCMS Discussion forum.

njw — Tue Oct 03, 2006 10:15 pm

When I tried to save a changed index.php page I got this error:

Fatal error: 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 ‘using hash (id), KEY datekeys using btree (`history__modif in /home/qsgi2ec/public_html/dataface0p6p9/Dataface/HistoryTool.php on line 304

I am running under:

Apache 1.3.33
PHP 4.3.10
MySQL 4.0.27-standard

Any thoughts?

Thanks

Neil

---

shannah — Tue Oct 03, 2006 11:16 pm

Evidently I have some SQL for the history feature that is incompatible with MySQL 4.0. It shouldn’t be doing anything fancy so I believe I can make it work on 4.0… however, in the mean time, probably best to just turn off history in the conf.ini file by commenting out the [history] section.

-Steve