HESK2.0 keeps giving errors during installation.
Posted: Sun May 31, 2009 7:00 pm
Script URL: http://www.globalchat.nl/chatroomservice/
Version of script: HESK 2.0
Hosting company: Rapide Internet
URL of phpinfo.php: http://www.globalchat.nl/chatroomservice/phpinfo.php
URL of session_test.php: http://www.globalchat.nl/chatroomservic ... n_test.php
What terms did you try when SEARCHING for a solution:
HESK You have an error in your SQL syntax near 'CURRENT_TIMESTAMP, `author` smallint(5) unsigned NOT NULL, `subject` varch' at line 4
Write your message below:
When i tried to install a complete new HESK2.0. i keep getting the following error after step 4:
Version of script: HESK 2.0
Hosting company: Rapide Internet
URL of phpinfo.php: http://www.globalchat.nl/chatroomservice/phpinfo.php
URL of session_test.php: http://www.globalchat.nl/chatroomservic ... n_test.php
What terms did you try when SEARCHING for a solution:
HESK You have an error in your SQL syntax near 'CURRENT_TIMESTAMP, `author` smallint(5) unsigned NOT NULL, `subject` varch' at line 4
Write your message below:
When i tried to install a complete new HESK2.0. i keep getting the following error after step 4:
After this error, i try to refresh and then i get the following error: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, 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` varch' at line 4
I hope someone want to help me with this. Existing topics did not help me much on this.Setup database tables
-> Testing database connection... SUCCESS
-> Installing database tables... ERROR: Database tables already exist!
Hesk database tables with hesk_ prefix already exist in this database. If you are trying to upgrade from a previous version please run the installation program again and select Update existing install from the installation page. If you are trying to install a new copy of Hesk in the same database make sure you change table prefix to a unique one.
Click here to continue