Error with History processing

A place to discuss and receive support for LCMS (Little Content Management System)

Postby 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?


Posts: 280
Joined: Wed Dec 31, 1969 5:00 pm

Postby 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 Hannah
@shannah78 (on twitter) blog
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm

Return to LCMS Discussion

Who is online

Users browsing this forum: No registered users and 1 guest

Powered by Dataface
© 2005-2007 Steve Hannah All rights reserved