Errors runnign the Quiz Install

All web design discussion, including Ultimate Quiz MOD support.

Moderator: CricketMX Forum Moderators

Post Reply
VMars
Greenhorn
Greenhorn
Posts: 4
Joined: Mon Sep 18, 2006 11:47 am

I got the following list of errors when i tried to run the quiz install:
CREATE TABLE phpbb_quiz_statistics ( `stats_id` int(5) NOT NULL default '', `quiz_id` int(10) NOT NULL default '', `user_id` int(10) NOT NULL default '', `stats_correct` INT(5) NOT NULL default '0', `stats_incorrect` INT(5) NOT NULL default '0', `stats_percentage` INT(3) NOT NULL default '0');
CREATE TABLE phpbb_quiz_multiple_choice_data ( `quiz_id` int(10) NOT NULL default '0', `question_id` int(10) NOT NULL default '0', `quiz_question` text NOT NULL, `quiz_alternates` text NOT NULL, `quiz_answer` text NOT NULL);
CREATE TABLE phpbb_quiz_true_false_data ( `quiz_id` int(10) NOT NULL default '0', `question_id` int(10) NOT NULL default '0', `quiz_question` text NOT NULL, `quiz_answer` text NOT NULL);
CREATE TABLE phpbb_quiz_input_data ( `quiz_id` int(10) NOT NULL default '0', `question_id` int(10) NOT NULL default '0', `quiz_question` text NOT NULL, `quiz_answer` text NOT NULL)
ALTER TABLE phpbb_sessions ADD `session_quiz_categories` VARCHAR( 255 ) NOT NULL;
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_show_answers', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Register_Play', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Post_Count_Play', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Post_Requirement', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Play_Once', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Author_Play', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Min_Max_Questions', '5,10')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Author_Mod', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Banned', '')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Moderators', '')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Stats_Display', '10')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Mod_Submit', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Cash_Currency', 'user_points')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Cash_Incorrect', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Cash_Correct', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_Cash_Tax', '2')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_CashMOD_On', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_packs_category', '1')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_packs_bot', 'Quartz')
INSERT INTO phpbb_config (config_name, config_value) VALUES ('Quiz_timeout', '10')
I did all the manual updating first, and was updating form a previous version....

Please help :)
User avatar
battye
Site Admin
Site Admin
Posts: 14391
Joined: Sun Jan 11, 2004 8:26 am
Location: Australia
Contact:

How many of them were red?
CricketMX.com in 2022: Still the home of bat's, rat's and other farmyard animals!

"OK, life [as you chose to define it] repeats until there are no more lessons to be learned." - nrnoble (June 12, 2005)
"the new forum looks awesome, it's getting bigger & better" - p2p-sharing-rules (11 Jan, 2008)
"Looks like CMX is not only getting bigger...but, also getting better!!" - moongirl (14 Dec, 2007)
VMars
Greenhorn
Greenhorn
Posts: 4
Joined: Mon Sep 18, 2006 11:47 am

battye wrote:How many of them were red?
all except the last 4
User avatar
battye
Site Admin
Site Admin
Posts: 14391
Joined: Sun Jan 11, 2004 8:26 am
Location: Australia
Contact:

If you were upgrading from 1.2.0 -> 1.3.x, that that is normal behaviour as those rows already exist.
CricketMX.com in 2022: Still the home of bat's, rat's and other farmyard animals!

"OK, life [as you chose to define it] repeats until there are no more lessons to be learned." - nrnoble (June 12, 2005)
"the new forum looks awesome, it's getting bigger & better" - p2p-sharing-rules (11 Jan, 2008)
"Looks like CMX is not only getting bigger...but, also getting better!!" - moongirl (14 Dec, 2007)
VMars
Greenhorn
Greenhorn
Posts: 4
Joined: Mon Sep 18, 2006 11:47 am

The problem is that i cant view the quizes that are created (yet they show up in the quiz statitics and they can be played).

Also no points are added to people for correct answers.

here is the main quiz screen:
Image

and here in the quiz statistics it shows the quiz that isn't listed in the other:
Image
User avatar
battye
Site Admin
Site Admin
Posts: 14391
Joined: Sun Jan 11, 2004 8:26 am
Location: Australia
Contact:

Have you got the Cash MOD installed?
CricketMX.com in 2022: Still the home of bat's, rat's and other farmyard animals!

"OK, life [as you chose to define it] repeats until there are no more lessons to be learned." - nrnoble (June 12, 2005)
"the new forum looks awesome, it's getting bigger & better" - p2p-sharing-rules (11 Jan, 2008)
"Looks like CMX is not only getting bigger...but, also getting better!!" - moongirl (14 Dec, 2007)
VMars
Greenhorn
Greenhorn
Posts: 4
Joined: Mon Sep 18, 2006 11:47 am

Yeah, and it is running fine.....

I have no idea what the issue is?
Post Reply