SQL Error

All web design discussion, including Ultimate Quiz MOD support.

Moderator: CricketMX Forum Moderators

leagcooks
Greenhorn
Greenhorn
Posts: 12
Joined: Wed Feb 27, 2008 1:52 pm

hi, Please can you help.

Ive installed the Ultimate Quiz Mode, Ive done all the sql updates and added all the files, But when i click on quizzes i get this error....
An Error Occurred

DEBUG MODE

SQL Error : 1054 Unknown column 'quiz_category' in 'where clause'

Line : 151
File : functions_quiz.php
More details here....

http://www.tbppbguideforums.info/bpb/quiz.php

Thanks in advance ;-)

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

Now it says:

Code: Select all

An Error Occurred

DEBUG MODE

SQL Error : 1054 Unknown column 'category_permissions' in 'where clause'

Line : 1017
File : quiz.php
Have you been making more alterations, or does the error you posted only appear once you are logged in?
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)
leagcooks
Greenhorn
Greenhorn
Posts: 12
Joined: Wed Feb 27, 2008 1:52 pm

Hi Battye,

Sorry i am logged in when it says that error.

So it must also have the error you show when your not logged in.

Lea.
leagcooks
Greenhorn
Greenhorn
Posts: 12
Joined: Wed Feb 27, 2008 1:52 pm

Nobody help then ???? :( :(

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

Was this a fresh install or were you upgrading from a previous version?
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)
leagcooks
Greenhorn
Greenhorn
Posts: 12
Joined: Wed Feb 27, 2008 1:52 pm

Hi Battye,

This was a fresh install.

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

When you say you've done the SQL updates, how did you do them?
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)
leagcooks
Greenhorn
Greenhorn
Posts: 12
Joined: Wed Feb 27, 2008 1:52 pm

The same i do all sql updates on mods, I used a FTP client and uploaded the Install file.

Went off the Install notes to install.

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

Did you get the green messages to show that it was successful?
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)
leagcooks
Greenhorn
Greenhorn
Posts: 12
Joined: Wed Feb 27, 2008 1:52 pm

No Got some red messages aswell.

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

Did you note down which were the red ones (these are the ones that failed)?
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)
leagcooks
Greenhorn
Greenhorn
Posts: 12
Joined: Wed Feb 27, 2008 1:52 pm

No didint sorry, Normally they can be fixed by seeing the error it says when you try and load the page..

Ive never wrote down the red errors, Sorry.

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

Do you have phpMyAdmin? It is a program so you can view what is in your database.
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)
leagcooks
Greenhorn
Greenhorn
Posts: 12
Joined: Wed Feb 27, 2008 1:52 pm

yes i can view everything in the databse battye

Lea.
leagcooks
Greenhorn
Greenhorn
Posts: 12
Joined: Wed Feb 27, 2008 1:52 pm

This is what i get in red ;-)
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')
Post Reply