Errors on Installation

All web design discussion, including Ultimate Quiz MOD support.

Moderator: CricketMX Forum Moderators

Post Reply
Schwingep
Greenhorn
Greenhorn
Posts: 2
Joined: Thu Nov 30, 2006 4:15 am

Beginner here, but I completely understand programming.

Install errors.

I'm running php 2.0.18 and was installing Mod 1.2.0

After doing all the changes I uploaded all files...when I ran the quiz_install i get this.

What am I missing?

Thanks in advance

below code was in Red

- Pete

Code: Select all

Ultimate Quiz MOD v1.2 Series
The script is now going to alter your forum database so the Ultimate Quiz MOD can function!
Any queries which are shown in green were executed successfully, those in red however, encountered a problem. It is absolutely vital that you have made all code changes already, and uploaded all quiz files to their respective locations.

CREATE TABLE phpbb_quiz ( `quiz_id` int(10) NOT NULL default '0', `quiz_name` varchar(200) NOT NULL default '', `quiz_author` int(10) NOT NULL default '0', `quiz_enabled` int(1) NOT NULL default '0', `quiz_category` int(5) NOT NULL default '0', `quiz_type` varchar(20) NOT NULL default '0', `quiz_plays` int(5) NOT NULL default '0');
CREATE TABLE phpbb_quiz_categories ( `category_id` int(5) NOT NULL default '0', `category_password` VARCHAR( 100 ) NOT NULL default '', `category_name` varchar(140) NOT NULL default '', `category_permissions` int(1) NOT NULL default '0', `category_description` varchar(255) NOT NULL default '');
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')

Installation is complete, however, some errors were encountered. It is suggested that you rectify these problems before attempting to use the Ultimate Quiz MOD!





When I go into quiz in my admin sidebar I get

Code: Select all

Could not get category data

DEBUG MODE

SQL Error : 1146 Table 'phpbb_2.phpbb_quiz_categories' doesn't exist

SELECT * FROM phpbb_quiz_categories

Line : 338
File : admin_quiz.php
User avatar
battye
Site Admin
Site Admin
Posts: 14391
Joined: Sun Jan 11, 2004 8:26 am
Location: Australia
Contact:

If you go into phpMyAdmin do you see the tables?

eg, do you see phpbb_quiz, phpbb_quiz_categories and so.
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)
Schwingep
Greenhorn
Greenhorn
Posts: 2
Joined: Thu Nov 30, 2006 4:15 am

battye wrote:If you go into phpMyAdmin do you see the tables?

eg, do you see phpbb_quiz, phpbb_quiz_categories and so.

I don't see them under the php databases...did I maybe install into the wrong directory???

Pardon, I'm a novice at this ;)
Post Reply