phpBB.de

Could not insert data into users table

DEBUG MODE

SQL Error : 1364 Field 'chatspot_colour' doesn't have a default value

INSERT INTO phpbb_users (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_sig_bbcode_uid, user_avatar, user_avatar_type, user_viewemail, user_aim, user_yim, user_msnm, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_timezone, user_dateformat, user_lang, user_style, user_level, user_allow_pm, user_active, user_actkey) VALUES (3, 'mafksmd f', 1181986240, 'cb42e130d1471239a27fca6228094f0e', 'cocm@djsfkla.at', '', '', '', '', '', '', '', '', 0, 0, '', '', '', 1, 1, 0, 1, 1, 0, 1, 1, 0, 'd.m.Y, H:i', 'german', 2, 0, 1, 1, '')

Line : 647
File : usercp_register.php

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', `mode` tinyint (1) NOT NULL default '0' ) 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 ;

[ERROR] line: 14, ALTER TABLE phpbb_users ADD `chatspot_img_height` SMALLINT( 4 ) NOT NULL default '300' ;

[ERROR] line: 15, ALTER TABLE phpbb_users ADD `chatspot_img_width` SMALLINT( 4 ) NOT NULL default '300' ;

[ERROR] line: 16, ALTER TABLE phpbb_users ADD `chatspot_max_file` SMALLINT( 4 ) NOT NULL default '75' ;

[ERROR] line: 17, ALTER TABLE phpbb_users ADD `chatspot_img_flag` TINYINT( 1 ) NOT NULL default '1' ;

[ERROR] line: 18, ALTER TABLE phpbb_users ADD `chatspot_icon` VARCHAR( 20 ) NOT NULL default 'mini_profile.gif' ;

[Executed successfully] line: 19, UPDATE phpbb_users SET chatspot_colour = '000000';

[Executed successfully] line: 20, UPDATE phpbb_users SET chatspot_alert = 'e';

[Executed successfully] line: 21, UPDATE phpbb_users SET chatspot_ignores = '';

[Executed successfully] line: 22, UPDATE phpbb_users SET chatspot_kick = 'a:1:{i:1;a:1:{i:0;s:1:"0";}}';

[Executed successfully] line: 23, INSERT INTO phpbb_chatspot_options VALUES('log', '0,1,1,3,2,n,0,n');

[Executed successfully] line: 24, INSERT INTO phpbb_chatspot_options VALUES('kickinv', '1,1,0,15 minutes,10 minutes,');

Complete.

mateg5 hat geschrieben:allgemein -> können Fehlermeldungen auftreten, wenn Ordner eine Schreibe und Leseberechtigung für alle user erforden, diese aber noch nicht zugewiesen wurde??