Install Hesk error

[gfi]

Hi!

I am a Newbie from Austria. I have hosted Web space from a local provider and wanted to try out the HESK Help Desk on the server. This Server has no Cpanel installed. On the 4th Install Step I got always the same error messages, trying to install Hesk!

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' 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

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,

=PLEASE CAN YOU HELP ME==
gfi

[Klemen]

Your host could be running an old version of MySQL. Upload the phpinfo file to your server and post a link to it here, I will have a look at the settings. You will find the phpinfo file in this topic:
viewtopic.php?t=138

[gfi]

Hi Klemen!

Thank you very much offering me Your help and support me!
I am really fascinated about Your Help Desk System and want to install it for my future Web site.

I have made the tests with uploading the testfile to the server!
Here are the results:

PHP Version 5.2.0-8+etch13
MySQL : 5.0.51a

Session Test:
Session started successfully!
CLICK HERE FOR PAGE 2

$_SESSION['test'] is set to: TRUE

Thanks for your help!
gfi

[Klemen]

Try this:

1. delete any tables Hesk has generated from the database

2. open file "install/install.php" in notepad

3. change

Code: Select all

CURRENT_TIMESTAMP

to

Code: Select all

'CURRENT_TIMESTAMP'

4. Save changes, upload the new install.php file to the server, close all browser windows then try to install Hesk again.