[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!