vBQuiz

I just recently installed vBQuiz, but once i did and tried to access it, this came up

Database error in vBulletin 2.2.6:

Invalid SQL: SELECT quizid, quiztitle, description, timestamp, userid, catid, imagename
FROM quiz
WHERE approve = 1
ORDER BY timestamp DESC
LIMIT
mysql error: You have an error in your SQL syntax near '' at line 5

mysql error number: 1064

Date: Wednesday 28th of August 2002 10:10:50 PM
Script: http://www.oswparadox.com/gcaforums/gcaforums/quiz.php
Referer: http://www.oswparadox.com/gcaforums/


How would i get rid of this

[g-force2k2]

ULTIMATESSJ its seems from the query that you have posted that its not collecting a LIMIT value... maybe be something wrong with the coding... can you post the code from that section? regards...

g-force2k2

[ULTIMATESSJ]

well there hasen't been any real file modifications in the hack, all the stuff is done thru the install file which comes with the zip file, and the other files which come with it

[ExAvIoUr]

well most of the time ppl forget to put a comma. try to put a comme after imagename. just a thought.

[ULTIMATESSJ]

Originally posted by ExAvIoUr
well most of the time ppl forget to put a comma. try to put a comme after imagename. just a thought.

i don't really get it, i haven't added any queries manually, they were all done thru the install script, so i don't know what i gotta do

[kevP]

came across this problem myself, i found the fix by searching the forums.

try this.

add the below line to the top of quiz.php
$mainquizlimit="10";

fixed it for me.