Quiz Admin Error

All web design discussion, including Ultimate Quiz MOD support.

Moderator: CricketMX Forum Moderators

Post Reply
honie
Greenhorn
Greenhorn
Posts: 2
Joined: Thu Apr 13, 2006 4:02 pm

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
User avatar
battye
Site Admin
Site Admin
Posts: 14391
Joined: Sun Jan 11, 2004 8:26 am
Location: Australia
Contact:

Did you upgrade or was it a fresh install?
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)
honie
Greenhorn
Greenhorn
Posts: 2
Joined: Thu Apr 13, 2006 4:02 pm

It was a fresh install
Angel Wood
User avatar
freddie
Greenhorn
Greenhorn
Posts: 23
Joined: Mon Nov 27, 2006 8:39 pm
Location: Leuven, Belgium
Contact:

same problem here ...

took a look in sql manager, found this

Image

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 ...
User avatar
freddie
Greenhorn
Greenhorn
Posts: 23
Joined: Mon Nov 27, 2006 8:39 pm
Location: Leuven, Belgium
Contact:

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
Last edited by freddie on Tue Jun 19, 2007 12:47 pm, edited 1 time in total.
User avatar
freddie
Greenhorn
Greenhorn
Posts: 23
Joined: Mon Nov 27, 2006 8:39 pm
Location: Leuven, Belgium
Contact:

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 ?
User avatar
freddie
Greenhorn
Greenhorn
Posts: 23
Joined: Mon Nov 27, 2006 8:39 pm
Location: Leuven, Belgium
Contact:

error in belgian language file:

"Voeg quiz toe" should be "Verzend"
User avatar
battye
Site Admin
Site Admin
Posts: 14391
Joined: Sun Jan 11, 2004 8:26 am
Location: Australia
Contact:

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 :D
http://forums.cricketmx.com/viewforum.php?f=25
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)
User avatar
freddie
Greenhorn
Greenhorn
Posts: 23
Joined: Mon Nov 27, 2006 8:39 pm
Location: Leuven, Belgium
Contact:

lol, true, my mistake ;)
Post Reply