Seite 1 von 1

fehler bei chtspot DB Installation

Verfasst: 27.08.2006 16:01
von Morphyman
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...

Verfasst: 02.09.2006 06:10
von wicked-disorder
Verlinke mal die chatspot_config.php als *.txt Datei.

Kannst Du die fehlenden SQL Befehle über phpmyadmin manuell ausführen.

lg

wicked