New Installation Error at Step 3

[merlinweb]

Script URL: http://www.staywhite.co.uk/support
Version of script: 2.2
Hosting company: Webfusion
URL of phpinfo.php: http://www.staywhite.co.uk/support
URL of session_test.php: http://www.staywhite.co.uk/support

What terms did you try when SEARCHING for a solution:
You have an error in your SQL syntax near 'ENGINE=MyISAM ' at line 10
&
Can't execute SQL: CREATE TABLE `hesk_attachments` ( `att_id` mediumint(8) unsigned NOT NULL

Write your message below:

On reaching Step 3 of a new installation the error message below was returned.
Have searched Knowledgebase & Google and the only solutions coming up related to errors with upgrades.

Can you offer any suggestions.

Thanks

Julian


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 10

WARNING
Debug mode is enabled. Make sure you disable debug mode in settings once HESK is installed and working properly.

[merlinweb]

Hi,

Found another article in the board and tried changing ENGINE=MyISAM to TYPE=MyISAM

The following error below came up; I am starting to assume that the mySQL version of 3.23.56 is going to be the problem here?

Julian

Error:

Can't execute SQL: CREATE TABLE `hesk_kb_articles` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `catid` smallint(5) unsigned NOT NULL, `dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `author` smallint(5) unsigned NOT NULL, `subject` varchar(255) NOT NULL, `content` text NOT NULL, `rating` float NOT NULL DEFAULT '0', `votes` mediumint(8) unsigned NOT NULL DEFAULT '0', `views` mediumint(8) unsigned NOT NULL DEFAULT '0', `type` enum('0','1','2') NOT NULL DEFAULT '0', `html` enum('0','1') NOT NULL DEFAULT '0', `art_order` smallint(5) unsigned NOT NULL DEFAULT '0', `history` text NOT NULL, `attachments` text NOT NULL, PRIMARY KEY (`id`), KEY `catid` (`catid`), KEY `type` (`type`), FULLTEXT KEY `subject` (`subject`,`content`) ) TYPE=MyISAM

MySQL said:
You have an error in your SQL syntax near 'CURRENT_TIMESTAMP, `author` smallint(5) unsigned NOT NULL, `subject` varchar' at line 5



WARNING
Debug mode is enabled. Make sure you disable debug mode in settings once HESK is installed and working properly.

[Klemen]

It's because of a very old version of MySQL, yes. Although it might work, MySQL 3 isn't officially supported by HESK as it has been tested on MySQL 4 onwards.

I would *strongly* recommend that you ask your hosting company to update your MySQL. Having such an old version is not secure at all - it has numerous known bugs and security issues.