28.11.2005, 19:00
Bei der Installation bricht die Installationsroutine mit folgender Fehlermeldung ab:
Ich habe daraufhin mittels PhPMyAdmin versucht, die Tabelle manuell anzulegen. Von wegen ... nächste Fehlermeldung:Wo ist das Problem?
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'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