PHPJunkyard support forum

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.

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.

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.