Page 1 of 1

error after submitting thr mysql setting

Posted: Wed Apr 15, 2009 6:42 pm
by asilveri
Script URL:
Version of script:Hesk 2.0
Hosting company:
URL of phpinfo.php:
URL of session_test.php:
What terms did you try when SEARCHING for a solution:

Write your message below:

Im getting this error message. Anyone have any idea why?

Error
Can't execute SQL: CREATE TABLE `hesk_attachments` ( `att_id` mediumint(8) unsigned NOT NULL auto_increment, `ticket_id` varchar(10) NOT NULL default '', `saved_name` varchar(255) NOT NULL default '', `real_name` varchar(255) NOT NULL default '', `size` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`att_id`), KEY `ticket_id` (`ticket_id`) ) ENGINE=MyISAM

MySQL said:
You have an error in your SQL syntax near 'ENGINE=MyISAM' at line 9

Please notify webmaster at support@domain.com

Posted: Wed Apr 15, 2009 6:51 pm
by Klemen
Seems like you are running an old MySQL version (3.23?). I would strongly recommend that you contact your host and ask them to upgrade MySQL to the latest stable version.

You can probably avoid this error by changing all instances of

Code: Select all

ENGINE=MyISAM
to

Code: Select all

TYPE=MyISAM
in the install.php file but I cannot guarantee a 100% compatibility of Hesk with MySQL 3.23 so upgrading to a newer (more stable and secure version than this one from 2001!).