Quiz Mod Sql Warning

phpBB2.de User Anmeldungsdatum: 18.08.2004 Beiträge: 1

Hi everybody,

I tried install quiz hack 0.2.1 to phpbb 2.0.22 and i didn't.
Error is :

Code:

Could not get quiz config information

DEBUG MODE

SQL Error : 1146 Table 'd002946d.phpbb_quiz_config' doesn't exist

SELECT config_name, config_value FROM phpbb_quiz_config WHERE config_name IN ('next_quiz','last_start_time','disable')

Line : 239
File : common.php

I tried manuel run sql query

Code:

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)
);
CREATE TABLE phpbb_quiz_answer (
topic_id mediumint(8) unsigned DEFAULT '0' NOT NULL,
user_id mediumint(8) DEFAULT '0' NOT NULL
);
CREATE TABLE phpbb_quiz_config (
config_name varchar(255) NOT NULL,
config_value text NOT NULL,
PRIMARY KEY (config_name)
);
INSERT INTO phpbb_quiz_config (config_name, config_value) VALUES ('quizbot_id', '2'),
('forum_id', '1'),
('next_quiz', '1032591540'),
('next_quiz_step', '1'),
('next_quiz_step_mode', '1'),
('disable', '1'),
('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";}}');
ALTER TABLE phpbb_users ADD quiz_points MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_topics ADD topic_quiz MEDIUMINT(8) DEFAULT '0' NOT NULL ;
ALTER TABLE phpbb_posts_text ADD quiz_answer VARCHAR(100) NOT NULL;

and didn't it.

Error is :

Code:

#1067 - Invalid default value for 'quiz_id'

What am i can ? Sad

Excuse me for my bad english Embarassed