[ows]

Bei der Installation bricht die Installationsroutine mit folgender Fehlermeldung ab:

Code:

Finish Setup

Creating Administrator account...done

Building data cache's...mySQL error: 1146
Table 'xxx_xxxx_x.forum_threads' doesn't exist
Query: SELECT * FROM forum_threads WHERE visible='1'

Ich habe daraufhin mittels PhPMyAdmin versucht, die Tabelle manuell anzulegen. Von wegen ... nächste Fehlermeldung:

Code:

Fehler

SQL-Befehl :

CREATE TABLE forum_threads(
tid int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
fid smallint( 5 ) unsigned NOT NULL default '0',
subject varchar( 120 ) NOT NULL default '',
icon smallint( 5 ) unsigned NOT NULL default '0',
poll int( 10 ) unsigned NOT NULL default '0',
uid int( 10 ) unsigned NOT NULL default '0',
username varchar( 80 ) NOT NULL default '',
dateline bigint( 30 ) NOT NULL default '0',
firstpost int( 10 ) unsigned NOT NULL default '0',
lastpost bigint( 30 ) NOT NULL default '0',
lastposter varchar( 120 ) NOT NULL default '',
views int( 100 ) NOT NULL default '0',
replies int( 100 ) NOT NULL default '0',
closed varchar( 30 ) NOT NULL default '',
sticky int( 1 ) NOT NULL default '0',
numratings smallint( 5 ) unsigned NOT NULL default '0',
totalratings smallint( 5 ) unsigned NOT NULL default '0',
notes text NOT NULL ,
visible int( 1 ) NOT NULL default '0',
messageindex text NOT NULL ,
subjectindex text NOT NULL ,
PRIMARY KEY ( tid ) ,
KEY subject( subject ) ,
FULLTEXT KEY subject_2( subject )
) TYPE = MYISAM

MySQL meldet:

#1064 - You have an error in your SQL syntax near 'KEY subject_2( subject )  ) TYPE  =  MYISAM ' at line 24

Wo ist das Problem?

[Michael]

Das Problem trat bereits bei der letzten MyBB-Version auf. Ursache ist eine Inkompatibilität mit bestimmten Versionen von MySQL. Folgender SQL-Befehl sollte die Tabelle aber anlegen:

Code:

CREATE TABLE forum_threads(
tid int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
fid smallint( 5 ) unsigned NOT NULL default '0',
subject varchar( 120 ) NOT NULL default '',
icon smallint( 5 ) unsigned NOT NULL default '0',
poll int( 10 ) unsigned NOT NULL default '0',
uid int( 10 ) unsigned NOT NULL default '0',
username varchar( 80 ) NOT NULL default '',
dateline bigint( 30 ) NOT NULL default '0',
firstpost int( 10 ) unsigned NOT NULL default '0',
lastpost bigint( 30 ) NOT NULL default '0',
lastposter varchar( 120 ) NOT NULL default '',
views int( 100 ) NOT NULL default '0',
replies int( 100 ) NOT NULL default '0',
closed varchar( 30 ) NOT NULL default '',
sticky int( 1 ) NOT NULL default '0',
numratings smallint( 5 ) unsigned NOT NULL default '0',
totalratings smallint( 5 ) unsigned NOT NULL default '0',
notes text NOT NULL ,
visible int( 1 ) NOT NULL default '0',
messageindex text NOT NULL ,
subjectindex text NOT NULL ,
PRIMARY KEY ( tid )
) TYPE = MYISAM

[ows]

Genau das war´s ... jetzt funktionierts.

Danke!