PHPJunkyard support forum

Script URL: www.sacomaine.org/helpdesk
Version of script: 2.1
Hosting company: Oneworldhosting
URL of phpinfo.php:
URL of session_test.php:
What terms did you try when SEARCHING for a solution:

Write your message below: I'm getting the following SQL error on installation:

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' 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`) ) ENGINE=MyISAM

You may disregard -- I found the solution to this in another posting on this site.