Page 1 of 1
error after taking a quiz
Posted: Fri Mar 02, 2007 1:51 pm
by GaVrA
Code: Select all
An Error Occurred
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE quiz_id = 4' at line 1
Line : 165
File : functions_quiz.php
other quizes work, but for the newest one i had to put max # of questions to 50 so maybe thats a problem?
Posted: Sat Mar 03, 2007 6:47 am
by battye
What were you doing at the time of the error?
Posted: Sat Mar 03, 2007 5:58 pm
by GaVrA
sitting beside my pc?
i was taking a quiz and i finnished it, i clicked submit and then this error came up...
Posted: Sun Mar 04, 2007 11:08 am
by battye
GaVrA wrote:sitting beside my pc?
Ah alright, if you stand up rather than sit down the error will go away
.....
i was taking a quiz and i finnished it, i clicked submit and then this error came up...
Has this ever happened to you before, or does it happen every time you take a quiz? If it happens often, are you sure every table has been created in the database?
Posted: Sun Mar 04, 2007 9:48 pm
by GaVrA
it happends only for this new quiz...
i enter any other quiz and click submit and it works, but i click in this quiz submit and i get that error....
these quizes that work are Multiple Choice Quiz and the one that doesnt work is Multiple Checkbox Quiz... any more info i need to submit?
Posted: Mon Mar 05, 2007 5:56 am
by battye
the one that doesnt work is Multiple Checkbox Quiz
Don't know what that is, certainly isn't a part of the default package
Posted: Mon Mar 05, 2007 6:49 pm
by garmabeaneth
GaVrA wrote:sitting beside my pc?
next time put your right hand in and shake it about, do the hokey pokey and turn yourself around. that should work
Posted: Tue Mar 06, 2007 11:10 am
by GaVrA
Unable to delete quiz data
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE quiz_id = 4' at line 1
DELETE FROM WHERE quiz_id = 4
Line : 343
File : quiz_cp.php
now i cant delet taht god damn quiz!!!
Posted: Tue Mar 06, 2007 11:10 am
by GaVrA
ups! i can, but i got this error...
anyway ill try to put it again and see if it will work...
Posted: Thu Mar 08, 2007 12:36 pm
by battye
Multiple Checkbox Quiz sounds like an addon to the Ultimate Quiz MOD. It is quite likely that that is the cause of your problems.
Posted: Sat Mar 10, 2007 12:02 pm
by GaVrA
hmmm ok, i think i made these changes:
http://www.phpbb.com/phpBB/viewtopic.ph ... 34#2838634
can u tell me whats the best way for me to do?
is there some newest version or something to download?
Posted: Wed Mar 21, 2007 11:24 am
by GaVrA
hmmm it seems that i have forgoten to put something into includes/constants.php
muliple checkbox now works but i cant delete quiz with id 4... i had 1 quiz with multiple checkbox that didnt work, then i have deleted it, but it seems that it didnt go form the db, couse next quiz someone submited merged with that deleted one...
and now after all that i cant delete that quiz with id 4
help?