Page 1 of 1

PostPosted: Tue Oct 03, 2006 10:15 pm
by njw
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?



PostPosted: Tue Oct 03, 2006 11:16 pm
by shannah
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.