Inatall error "1064 You have an error in your SQL syntax"

Hi, Hopefully someone can help me with a clean install of the latest version of the ZenCart v1.3.9h

On the installer after completing the MySQL info i recieve the following error:

"Installation In Progress...
1064 You have an error in your SQL syntax near 'ENGINE=MyISAM' at line 1
in:
[CREATE TABLE upgrade_exceptions ( upgrade_exception_id smallint(5) NOT NULL auto_increment, sql_file varchar(50) default NULL, reason varchar(200) default NULL, errordate datetime default '0001-01-01 00:00:00', sqlstatement text, PRIMARY KEY (upgrade_exception_id) ) ENGINE=MyISAM;]"

Here is some info about the host serverI trying to install on and believe it meets requirements (only just) Can you confirm this too please.

Thanks

From webhost
Operating system: RedHat linux 7.3
Web server: Apache 1.3.27
Scripting language: PHP 4.3.10
Scripting language: SunONE ASP 3.6.2
CGI Scripting language: Perl 5.6.1
Database server: MySQL 3.23.56
Mail server: Exim 3.36

From installer
Webserver = Apache/1.3.29 (Unix) (Red-Hat/Linux) Chili!Soft-ASP/3.6.2 mod_ssl/2.8.14 OpenSSL/0.9.6b PHP/4.4.9 FrontPage/5.0.2.2510
HTTP Host = y******.co.uk
Path_Translated = /home/ACCOUNTNAME/public_html/mysharedaccounts/ACCOUNTNAME/store/zc_install/index.php(SCRIPT_FILENAME)
Real Path = /home/ACCOUNTNAME/public_html/mysharedaccounts/ACCOUNTNAME/store
Server Free Disk Space = 161.3 GB
PHP O/S = Linux
PHP API Mode = cgi
PHP Max Execution Time per page = 30