Install error version 2.0

[tonynl]

Version of script: 2.0

Write your message below:

I tried installing version 2.0 as a new installation. I do have a working 0.94.1 version but decided not to upgrade but start a brand new one just for testing.
On installation I get this error:

Code: Select all

Can't execute SQL: CREATE TABLE `hsk2_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. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ENGINE=MyISAM' at line 9

What could this be?

[Klemen]

Have you tried:
viewtopic.php?t=2296

[tonynl]

I didn't try it, because I'm not upgrading. It's a fresh new install.
The

Code: Select all

$hesk_settings['hesk_version']='2.0';

in my case.

[tonynl]

After a few tries, it does work if I take the "ENGINE=MyISAM" of the query.
What does that tell?

[tonynl]

And after another try and a suggestion on a Drupal site:
if you change ENGINE into TYPE it does work. I suppose that should be the code that is generated.

[tonynl]

I changed all ENGINE to TYPE. Now the attachments and categories tables are created. The following error is"

Code: Select all

CREATE TABLE `hsk2_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`) ) TYPE=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,

I'm running mysql version 3.23.49, could that be part of the problem?

[Klemen]

I'm running mysql version 3.23.49, could that be part of the problem?

That's exactly the problem. Try upgrading MySQL to 4.1.x or 5.x

[tonynl]

For now I removed

Code: Select all

default CURRENT_TIMESTAMP

from the query and it all worked fine.