Page 1 of 2
SQL Error
Posted: Wed Feb 27, 2008 1:54 pm
by leagcooks
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.
Re: SQL Error
Posted: Wed Feb 27, 2008 3:01 pm
by battye
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?
Re: SQL Error
Posted: Wed Feb 27, 2008 3:29 pm
by leagcooks
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.
Re: SQL Error
Posted: Thu Feb 28, 2008 4:15 pm
by leagcooks
Nobody help then ????
Lea.
Re: SQL Error
Posted: Fri Feb 29, 2008 3:29 pm
by battye
Was this a fresh install or were you upgrading from a previous version?
Re: SQL Error
Posted: Sat Mar 01, 2008 8:08 pm
by leagcooks
Hi Battye,
This was a fresh install.
lea.
Re: SQL Error
Posted: Sun Mar 02, 2008 3:06 am
by battye
When you say you've done the SQL updates, how did you do them?
Re: SQL Error
Posted: Sun Mar 02, 2008 9:18 pm
by leagcooks
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.
Re: SQL Error
Posted: Mon Mar 03, 2008 1:40 am
by battye
Did you get the green messages to show that it was successful?
Re: SQL Error
Posted: Mon Mar 03, 2008 11:58 am
by leagcooks
No Got some red messages aswell.
Lea.
Re: SQL Error
Posted: Mon Mar 03, 2008 11:09 pm
by battye
Did you note down which were the red ones (these are the ones that failed)?
Re: SQL Error
Posted: Sat Mar 08, 2008 11:59 am
by leagcooks
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.
Re: SQL Error
Posted: Sat Mar 08, 2008 1:19 pm
by battye
Do you have phpMyAdmin? It is a program so you can view what is in your database.
Re: SQL Error
Posted: Sat Mar 08, 2008 1:22 pm
by leagcooks
yes i can view everything in the databse battye
Lea.
Re: SQL Error
Posted: Sat Mar 08, 2008 3:16 pm
by leagcooks
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')