Version 2 MYSQL install error

[iainlee]

Script URL:
Version of script: 2.0
Hosting company:
URL of phpinfo.php:
URL of session_test.php:
What terms did you try when SEARCHING for a solution:

MYSQL version 4.0.21 on Solaris

A similar problem to that of tonynl. Performing a fresh install of 2.0, I get the following error. However, the tables hesk_attachments, hesk_categories and ticket_id do get created:

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, `votes` mediumint(8) unsigned NOT NULL, `views` mediumint(8) unsigned NOT NULL, `type` enum('0','1','2') NOT NULL, `html` enum('0','1') NOT NULL default '0', `art_order` smallint(5) unsigned NOT NULL, `history` text NOT NULL, PRIMARY KEY (`id`), KEY `catid` (`catid`), KEY `type` (`type`), FULLTEXT KEY `subject` (`subject`,`content`) ) ENGINE=MyISAM

MySQL said:
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 'CURRENT_TIMESTAMP, `author` smallint(5) unsigned NOT NULL,

[Klemen]

Works fine on MySQL 4.1.x and MySQL 5, could be a problem with too old version (4.0)? Can you try upgrading your MySQL to at least 4.1 if not 5?

[iainlee]

I upgraded to MYSQL 5.0 which has resolved the problem. Many thanks.

Version 2 is looks very good