Quizmod geinstalleerd, fout bij queries uitvoeren
Geplaatst: 07 okt 2005, 09:21
Support template:
Overige opmerkingen:[/code]
- Wat is het probleem? ik heb alle bestanden geinstalleerd, en geupload. Geen fouten geconstateerd in het forum zelf, maar als ik daarna de queries wil doen krijg ik een fout en wel deze:
Wanneer ontstond het probleem?gelijk bij het proberen van de install_quiz_hack.php
Code: Selecteer alles
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', '1128672616'), ('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 NULL
Adres van je forum: http://www.about-us.nl/joa
Geïnstalleerde mods:EZ Portal - Statestieken - Last visit - Gender mod - Gastenboek - birthday mod - add to favorits mod - cu2 mod - usernotes - helpdesk mod - report posts - who viewed my profile - quick reply mod - kennisbank - index icons - Ip look up mod - hidden/offline/online mod
Huidige template:
phpBB versie: 2.0.17
Host:http://www.phpbbhost.nl
Heb je onlangs een mod of stijl geïnstalleerd?ja, hidden/online/offline mod
Heb je gezocht naar een antwoord?
Overige opmerkingen:[/code]
, maar toen kreeg ik die fout
..