Code: Alles auswählen
Error list:
SQL Error: 1067 Invalid default value for 'quiz_id'
SQL Query: CREATE TABLE phpbb_quiz ( quiz_id mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment, question text NOT NULL, answer varchar(100) NOT NULL, answer2 varchar(100) NOT NULL, answer3 varchar(100) NOT NULL, answer4 varchar(100) NOT NULL, answer_explain text NOT NULL, quiz_points tinyint(2) DEFAULT '1' NOT NULL, quiz_type tinyint(1) DEFAULT '0' NOT NULL, quiz_status tinyint(1) DEFAULT '0' NOT NULL, quiz_from_user_id mediumint(8) DEFAULT '0' NOT NULL, quiz_topic_id mediumint(8) unsigned DEFAULT '0' NOT NULL, quiz_bot_post_id mediumint(8) unsigned DEFAULT '0' NOT NULL, answered_by_user_id mediumint(8) DEFAULT '0' NOT NULL, PRIMARY KEY (quiz_id), KEY quiz_status (quiz_status), KEY quiz_topic_id (quiz_topic_id) )
SQL Error: 1062 Duplicate entry 'quizbot_id' for key 1
SQL Query: INSERT INTO phpbb_quiz_config (config_name, config_value) VALUES ('quizbot_id', '2'), ('forum_id', '1'), ('next_quiz', '1173612244'), ('next_quiz_step', '1'), ('next_quiz_step_mode', '1'), ('disable', '1'), ('subject', 'Quiz question #{NUM} ...'), ('message', 'Here is the new quiz querstion: {QUIZ} This querstion was suggested by {USERNAME} '), ('subject2', 'Quiz answered'), ('message2', 'The querstion was correctly answered by [i]{USERNAME}[/i]. The quiz is finished.'), ('subject3', 'Failed'), ('message3', 'The answer of [i]{USERNAME}[/i] was marked as right inadvertently. Excuse me, but I am also only a bot. The quiz is already finished and will not be restarted. '), ('next_quiz_number', '1'), ('quiz_points_disable', '0'), ('banned_users', ''), ('banned_groups', ''), ('admin_user_id', '2'), ('allow_admin_in_quiz', '0'), ('allow_mod_in_quiz', '0'), ('allow_quiz_from_user_in_quiz', '0'), ('html', '1'), ('bbcode', '1'), ('smilies', '1'), ('imported_files', ''), ('last_start_time', '1034790108'), ('version', '0.2.1'), ('notify_admin_on_new_suggestions', '1'), ('show_mod_answer_in_quiz', '1'), ('libraries', 'a:3:{s:5:"count";i:1;s:7:"version";i:0;i:1;a:2:{i:0;s:36:"Standart Biblothek / default library";i:1;s:46:"http://sphm.sourceforge.net/quiz_lib/index.txt";}}')
SQL Error: 1060 Duplicate column name 'quiz_points'
SQL Query: ALTER TABLE phpbb_users ADD quiz_points MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL
SQL Error: 1060 Duplicate column name 'topic_quiz'
SQL Query: ALTER TABLE phpbb_topics ADD topic_quiz MEDIUMINT(8) DEFAULT '0' NOT NULL
SQL Error: 1060 Duplicate column name 'quiz_answer'
SQL Query: ALTER TABLE phpbb_posts_text ADD quiz_answer VARCHAR(100) NOT NULLKann mir momentan nicht erklären woran es liegt!?
MfG
Tim[/code]
