YaBB SE Version: 1.5.4
PHP Version: 4.1.2
MySQL Version: 3.23.x
Server Plattform: Windows
Link zum Forum: Problem Beschreibung:hallo da draussen, bekomme bei der installation auf localhost folgende fehler in step 3:
------------------------------------------------
Error: Column 'year' is used with UNIQUE or INDEX but is not defined as NOT NULL
In CREATE TABLE yabbse_calendar_holiday ( id int(10) unsigned NOT NULL auto_increment, title char(30) NOT NULL default '', month tinyint(4) NOT NULL default '0', day tinyint(4) NOT NULL default '0', year smallint(6) default NULL, PRIMARY KEY (id), KEY idx_month (month), KEY idx_year (year)) TYPE=MyISAM;
Executing package #6... unsuccessful!
Error: Table 'yabbse.yabbse_calendar_holiday' doesn't
Executing package #10... unsuccessful!
Error: Column 'msgtime' is used with UNIQUE or INDEX but is not defined as NOT NULL
In CREATE TABLE yabbse_instant_messages ( ID_IM bigint(20) NOT NULL auto_increment, ID_MEMBER_FROM int(11) NOT NULL default '0', ID_MEMBER_TO int(11) NOT NULL default '0', deletedBy int(11) NOT NULL default '-1', fromName tinytext NOT NULL, toName tinytext NOT NULL, msgtime bigint(20) default NULL, subject tinytext, body text, readBy tinyint(4) NOT NULL default '0', PRIMARY KEY (ID_IM), KEY ID_MEMBER_FROM (ID_MEMBER_FROM), KEY ID_MEMBER_TO (ID_MEMBER_TO), KEY deletedBy (deletedBy), KEY msgtime (msgtime), KEY readBy (readBy)) TYPE=MyISAM;
Executing package #16... unsuccessful!
Error: BLOB column 'ip' can't be used in key specification with the used table type
In CREATE TABLE yabbse_log_floodcontrol ( ip tinytext NOT NULL, logTime bigint(20) default NULL, PRIMARY KEY (ip(16))) TYPE=MyISAM;
Executing package #19... unsuccessful!
Error: Column 'logTime' is used with UNIQUE or INDEX but is not defined as NOT NULL
In CREATE TABLE yabbse_log_online ( identity int(11) unsigned NOT NULL, logTime bigint(20) default NULL, KEY logTime (logTime), PRIMARY KEY (identity)) TYPE=MyISAM;
Executing package #23... unsuccessful!
Error: Column 'dateRegistered' is used with UNIQUE or INDEX but is not defined as NOT NULL
Executing package #24... unsuccessful!
Error: Column 'posterTime' is used with UNIQUE or INDEX but is not defined as NOT NULL
In CREATE TABLE yabbse_messages ( ID_MSG int(11) NOT NULL auto_increment, ID_TOPIC int(11) NOT NULL default '0', ID_MEMBER int(11) NOT NULL default '0', subject tinytext, posterName tinytext NOT NULL, posterEmail tinytext, posterTime bigint(20) default NULL, posterIP tinytext NOT NULL, smiliesEnabled tinyint(4) NOT NULL default '1', modifiedTime bigint(20) default NULL, modifiedName tinytext, body text, icon tinytext, attachmentSize mediumint(9) NOT NULL default '0', attachmentFilename tinytext, PRIMARY KEY (ID_MSG), KEY ID_TOPIC (ID_TOPIC), KEY ID_MEMBER (ID_MEMBER), KEY posterTime (posterTime)) TYPE=MyISAM;
Executing package #25... unsuccessful!
Error: Table 'yabbse.yabbse_messages' doesn't exist
In INSERT INTO yabbse_messages VALUES (1, 1, -1, 'Welcome to YaBB SE!', 'YaBB SE Dev Team', '
[email protected]', 1007831725, '65.93.102.203', 1, NULL, NULL, 'Welcome to YaBB SE!\n\nWe hope you enjoy using your new forum.', 'xx', 0, NULL);
Executing package #29... unsuccessful!
Error: BLOB column 'variable' can't be used in key specification with the used table type
In CREATE TABLE yabbse_settings ( variable tinytext NOT NULL, value text NOT NULL, PRIMARY KEY (variable(30))) TYPE=MyISAM;
Executing package #30... unsuccessful!
Warning: Some of the queries failed!!
Your installation may not work correctly!
es werden einige packages installiert, andere nicht..
weiss jemand woran das liegt?
safe_mode off=OFF / magic_quotes = OFF, hier also alles ok.
viele,vlielen dank!
Author