Page 1 of 1
Quiz Admin Error
Posted: Thu Apr 13, 2006 4:06 pm
by honie
I searched and was unable find the answer, forgive me if I missed something.
After install, when I go to admin and choose quiz I get the following error -
Could not obtain quiz category data
An Error Occurred
DEBUG MODE
SQL Error : 1054 Unknown column 'quiz_category' in 'where clause'
Line : 151
File : functions_quiz.php
I double checked my install and all file changes were made and the install script ran. Any help would be great
Posted: Fri Apr 14, 2006 1:28 am
by battye
Did you upgrade or was it a fresh install?
Posted: Fri Apr 14, 2006 1:37 am
by honie
It was a fresh install
Posted: Tue Jun 19, 2007 12:09 pm
by freddie
same problem here ...
took a look in sql manager, found this
renamed them to phpbb_, in lower case, removed _TABLE at the and.
that made it possible to edit my settings.
but when i try to click the link on my board, i got this error:
Er is een fout opgetreden
DEBUG MODE
SQL Error : 1146 Table 'friends.phpbb_quiz' doesn't exist
Line : 151
File : functions_quiz.php
what are the values for phpbb_quiz ? so i can add them myself ...
Posted: Tue Jun 19, 2007 12:32 pm
by freddie
found it
rename
QUIZ_GENERAL_TABLE to phpbb_quiz
QUIZ_CATEGORY_TABLE' to phpbb_quiz_categories
QUIZ_MULTIPLE_CHOICE_TABLE to phpbb_quiz_multiple_choice_data
QUIZ_INPUT_TABLE' to phpbb_quiz_input_data
QUIZ_TRUE_FALSE_TABLE to phpbb_quiz_true_false_data
QUIZ_STATISTICS_TABLE to phpbb_quiz_statistics
now everything works
my board is version phpbb 2.0.22, don't know why the install was so messed up
Posted: Tue Jun 19, 2007 12:34 pm
by freddie
on the bottom of admin page is still the message: The latest version of the Ultimate Quiz MOD: 1.2.0
should be 1.3.x ?
Posted: Tue Jun 19, 2007 12:48 pm
by freddie
error in belgian language file:
"Voeg quiz toe" should be "Verzend"
Posted: Tue Jun 19, 2007 1:02 pm
by battye
To explain your error freddie, it sounds like you ran the quiz_install.php file before you had made the file edits to constants.php
BTW, please do introduce yourself in the introductory forum
http://forums.cricketmx.com/viewforum.php?f=25
Posted: Tue Jun 19, 2007 1:08 pm
by freddie
lol, true, my mistake