0.9 database error

16 years 4 months ago #52233 by kikkeraap
0.9 database error was created by kikkeraap
When I try to install the 0.9 version I recieve the error:
[code:1] CREATE TABLE IF NOT EXISTS `jos_uddeim` (
`id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`fromid` int( 11 ) NOT NULL default '0',
`toid` int( 11 ) NOT NULL default '0',
`message` text NOT NULL ,
`datum` int( 11 ) default NULL ,
`toread` int( 1 ) NOT NULL default '0',
`totrash` int( 1 ) NOT NULL default '0',
`totrashdate` int( 11 ) default NULL ,
`totrashoutbox` int( 1 ) NOT NULL default '0',
`totrashdateoutbox` int( 11 ) default NULL ,
`expires` int( 11 ) default NULL ,
`disablereply` int( 1 ) NOT NULL default '0',
`systemmessage` varchar( 60 ) ,
`archived` int( 1 ) NOT NULL default '0',
`cryptmode` int( 1 ) NOT NULL default '0',
`crypthash` varchar( 32 ) default NULL ,
PRIMARY KEY ( `id` ) ,
KEY `toid_toread` ( `toid` , `toread` ) ,
KEY `datum` ( `datum` ) ,
KEY `totrashdate` ( `totrashdate` ) ,
KEY `totrashdateoutbox` ( `totrashdateoutbox` ) ,
KEY `toread_totrash_datum` ( `toread` , `totrash` , `datum` ) ,
KEY `totrash_totrashdate` ( `totrash` , `totrashdate` )
) ENGINE = MYISAM

MySQL retourneerde: Documentatie
#1064 - 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 25 [/code:1]

from a fresh install, how should I solve the matter?

Please Log in to join the conversation.

16 years 4 months ago #52240 by slabbi
Replied by slabbi on topic Re:0.9 database error
IMHO you are using an outdated version of MySQL:

ENGINE was added in MySQL 4.0.18 (for 4.0) and 4.1.2 (for 4.1).

The syntax is fine and it installs here without any problems. You can try to replace ENGINE=MyISAM with TYPE=MyISAM but this statement is deprecated in later versions.

uddeIM & uddePF Development
CB Language Workgroup
CB 3rd Party Developer

Please Log in to join the conversation.

16 years 4 months ago #52250 by kikkeraap
Replied by kikkeraap on topic Re:0.9 database error
Thanks!! this did the trick! B)

Please Log in to join the conversation.

16 years 4 months ago #52295 by slabbi
Replied by slabbi on topic Re:0.9 database error
Thanks for the feedback. I made a "silent" update and replaced the archives.

uddeIM & uddePF Development
CB Language Workgroup
CB 3rd Party Developer

Please Log in to join the conversation.

Moderators: beatnantslabbikrileon
Time to create page: 0.379 seconds

Facebook Twitter LinkedIn