fehler bei chtspot DB Installation
Verfasst: 27.08.2006 16:01
hi...
Ich hab ein problem: ich habe chatbox installiert un jetzt kommt da immer soeine Fehlermeldung (wenn ich die "chatbox_db_install.php" auführe):
This script will update the database for the Chatspot MOD. Executing...
[Executed successfully] line: 1, DROP TABLE IF EXISTS `phpbb_chatspot_messages`
[Executed successfully] line: 2, CREATE TABLE `phpbb_chatspot_messages` ( `message_id` int(11) unsigned NOT NULL auto_increment, `room_id` int(11) NOT NULL default '0', `username` varchar(25) NOT NULL default '', `msg` text NOT NULL, `msg_type` tinyint(1) unsigned NOT NULL default '0', `timestamp` int(11) unsigned NOT NULL default '0', `to_user_id` mediumint(8) unsigned NOT NULL default '0', `from_user_id` mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (`message_id`) ) TYPE=MyISAM
[Executed successfully] line: 3, DROP TABLE IF EXISTS `phpbb_chatspot_rooms`
[Executed successfully] line: 4, CREATE TABLE `phpbb_chatspot_rooms` ( `room_id` mediumint(11) NOT NULL auto_increment, `room_name` varchar(20) NOT NULL default '', `room_type` tinyint(1) unsigned NOT NULL default '0', `room_access` mediumint(8) unsigned NOT NULL default '0', `room_password` varchar(20) default NULL, `room_creator_id` mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (`room_id`) ) TYPE=MyISAM
[Executed successfully] line: 5, INSERT INTO `phpbb_chatspot_rooms` VALUES ('1', 'Lobby', '1', '0', NULL, '0')
[Executed successfully] line: 6, DROP TABLE IF EXISTS `phpbb_chatspot_sessions`
[Executed successfully] line: 7, CREATE TABLE `phpbb_chatspot_sessions` ( `user_id` mediumint(8) unsigned NOT NULL default '0', `username` varchar(25) NOT NULL default '', `room_id` mediumint(11) NOT NULL default '0', `last_active` int(11) NOT NULL default '0', `last_status` tinyint(1) unsigned NOT NULL default '1' ) TYPE=MyISAM
[Executed successfully] line: 8, DROP TABLE IF EXISTS `phpbb_chatspot_options`;
[Executed successfully] line: 9, CREATE TABLE `phpbb_chatspot_options` ( `id` varchar(255) NOT NULL, `value` varchar(255) NOT NULL ) TYPE=MyISAM;
[ERROR] line: 10, ALTER TABLE phpbb_users ADD `chatspot_colour` VARCHAR( 6 ) NOT NULL ;
[ERROR] line: 11, ALTER TABLE phpbb_users ADD `chatspot_alert` VARCHAR( 30 ) NOT NULL ;
[ERROR] line: 12, ALTER TABLE phpbb_users ADD `chatspot_ignores` VARCHAR( 100 ) NOT NULL ;
[ERROR] line: 13, ALTER TABLE phpbb_users ADD `chatspot_kick` TEXT NOT NULL ;
[Executed successfully] line: 14, UPDATE phpbb_users SET chatspot_colour = '000000';
[Executed successfully] line: 15, UPDATE phpbb_users SET chatspot_alert = 'e';
[Executed successfully] line: 16, UPDATE phpbb_users SET chatspot_ignores = '';
[Executed successfully] line: 17, UPDATE phpbb_users SET chatspot_kick = 'a:1:{i:1;a:1:{i:0;s:1:"0";}}';
[Executed successfully] line: 18, INSERT INTO phpbb_chatspot_options VALUES('log', '0,1,1,3,2,n,0,n');
[Executed successfully] line: 19, INSERT INTO phpbb_chatspot_options VALUES('kickinv', '1,1,0,15 minutes,10 minutes,');
Complete.
Oben steht noch:
Warning: include_once(./language/lang_english/lang_chatspot.php) [function.include-once]: failed to open stream: No such file or directory in S:\ROOT\forum\chatspot\chatspot_config.php on line 39
Warning: include_once() [function.include]: Failed opening './language/lang_english/lang_chatspot.php' for inclusion (include_path='.;C:\php5\pear') in S:\ROOT\forum\chatspot\chatspot_config.php on line 39
Warning: Cannot modify header information - headers already sent by (output started at S:\ROOT\forum\chatspot\chatspot_config.php:39) in S:\ROOT\forum\includes\page_header.php on line 493
Warning: Cannot modify header information - headers already sent by (output started at S:\ROOT\forum\chatspot\chatspot_config.php:39) in S:\ROOT\forum\includes\page_header.php on line 495
Warning: Cannot modify header information - headers already sent by (output started at S:\ROOT\forum\chatspot\chatspot_config.php:39) in S:\ROOT\forum\includes\page_header.php on line 496
vllt ein bisien zu viel text, sorry...Aber trotzdem danke, falls mir jemand antwortet...
Ich hab ein problem: ich habe chatbox installiert un jetzt kommt da immer soeine Fehlermeldung (wenn ich die "chatbox_db_install.php" auführe):
This script will update the database for the Chatspot MOD. Executing...
[Executed successfully] line: 1, DROP TABLE IF EXISTS `phpbb_chatspot_messages`
[Executed successfully] line: 2, CREATE TABLE `phpbb_chatspot_messages` ( `message_id` int(11) unsigned NOT NULL auto_increment, `room_id` int(11) NOT NULL default '0', `username` varchar(25) NOT NULL default '', `msg` text NOT NULL, `msg_type` tinyint(1) unsigned NOT NULL default '0', `timestamp` int(11) unsigned NOT NULL default '0', `to_user_id` mediumint(8) unsigned NOT NULL default '0', `from_user_id` mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (`message_id`) ) TYPE=MyISAM
[Executed successfully] line: 3, DROP TABLE IF EXISTS `phpbb_chatspot_rooms`
[Executed successfully] line: 4, CREATE TABLE `phpbb_chatspot_rooms` ( `room_id` mediumint(11) NOT NULL auto_increment, `room_name` varchar(20) NOT NULL default '', `room_type` tinyint(1) unsigned NOT NULL default '0', `room_access` mediumint(8) unsigned NOT NULL default '0', `room_password` varchar(20) default NULL, `room_creator_id` mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (`room_id`) ) TYPE=MyISAM
[Executed successfully] line: 5, INSERT INTO `phpbb_chatspot_rooms` VALUES ('1', 'Lobby', '1', '0', NULL, '0')
[Executed successfully] line: 6, DROP TABLE IF EXISTS `phpbb_chatspot_sessions`
[Executed successfully] line: 7, CREATE TABLE `phpbb_chatspot_sessions` ( `user_id` mediumint(8) unsigned NOT NULL default '0', `username` varchar(25) NOT NULL default '', `room_id` mediumint(11) NOT NULL default '0', `last_active` int(11) NOT NULL default '0', `last_status` tinyint(1) unsigned NOT NULL default '1' ) TYPE=MyISAM
[Executed successfully] line: 8, DROP TABLE IF EXISTS `phpbb_chatspot_options`;
[Executed successfully] line: 9, CREATE TABLE `phpbb_chatspot_options` ( `id` varchar(255) NOT NULL, `value` varchar(255) NOT NULL ) TYPE=MyISAM;
[ERROR] line: 10, ALTER TABLE phpbb_users ADD `chatspot_colour` VARCHAR( 6 ) NOT NULL ;
[ERROR] line: 11, ALTER TABLE phpbb_users ADD `chatspot_alert` VARCHAR( 30 ) NOT NULL ;
[ERROR] line: 12, ALTER TABLE phpbb_users ADD `chatspot_ignores` VARCHAR( 100 ) NOT NULL ;
[ERROR] line: 13, ALTER TABLE phpbb_users ADD `chatspot_kick` TEXT NOT NULL ;
[Executed successfully] line: 14, UPDATE phpbb_users SET chatspot_colour = '000000';
[Executed successfully] line: 15, UPDATE phpbb_users SET chatspot_alert = 'e';
[Executed successfully] line: 16, UPDATE phpbb_users SET chatspot_ignores = '';
[Executed successfully] line: 17, UPDATE phpbb_users SET chatspot_kick = 'a:1:{i:1;a:1:{i:0;s:1:"0";}}';
[Executed successfully] line: 18, INSERT INTO phpbb_chatspot_options VALUES('log', '0,1,1,3,2,n,0,n');
[Executed successfully] line: 19, INSERT INTO phpbb_chatspot_options VALUES('kickinv', '1,1,0,15 minutes,10 minutes,');
Complete.
Oben steht noch:
Warning: include_once(./language/lang_english/lang_chatspot.php) [function.include-once]: failed to open stream: No such file or directory in S:\ROOT\forum\chatspot\chatspot_config.php on line 39
Warning: include_once() [function.include]: Failed opening './language/lang_english/lang_chatspot.php' for inclusion (include_path='.;C:\php5\pear') in S:\ROOT\forum\chatspot\chatspot_config.php on line 39
Warning: Cannot modify header information - headers already sent by (output started at S:\ROOT\forum\chatspot\chatspot_config.php:39) in S:\ROOT\forum\includes\page_header.php on line 493
Warning: Cannot modify header information - headers already sent by (output started at S:\ROOT\forum\chatspot\chatspot_config.php:39) in S:\ROOT\forum\includes\page_header.php on line 495
Warning: Cannot modify header information - headers already sent by (output started at S:\ROOT\forum\chatspot\chatspot_config.php:39) in S:\ROOT\forum\includes\page_header.php on line 496
vllt ein bisien zu viel text, sorry...Aber trotzdem danke, falls mir jemand antwortet...