#339 Quiz: MySQL error returned when attempting to save a option

Unknown
closed
nobody
5
2003-07-15
2003-06-12
Matthew Thorley
No

When attempting to edit an already saved option of a
quiz I was given this error upon pressing the save
button. I tried different options with different
content in the fields and they all returned the error.

Warning: MYSQL error: DB Error: syntax error in query:
update tiki_quiz_question_options set points=0, option
= 'All of the above' where optionId = 19 and questionId=6
in /home/apache/htdocs/tiki/lib/tikilib.php on line 71

I FOUND the problem a fixed it on my system. The bug is
on line 316 of quizlib.php
'tikit/lib/quizzes.quizlib.php. In the mysql query the
line reads option = '$option' and is SHOULD read
optionText = '$option'

-matthew
ruach AT chpc DOT utah (dot) edu

Discussion

  • Dennis Daniels
    Dennis Daniels
    2003-06-12

    Logged In: YES
    user_id=403318

    tested and works in 1.7

    admin please close

     
  • Dave Sanders
    Dave Sanders
    2003-07-06

    • labels: --> 544455
    • milestone: --> Unknown
     
  • Dave Sanders
    Dave Sanders
    2003-07-06

    Logged In: YES
    user_id=6717

    Updating this item for category / group / subject line or other
    data. No real change to the item, just house-keeping.

     
  • Dennis Daniels
    Dennis Daniels
    2003-07-06

    Logged In: YES
    user_id=403318

    admin please close

     
  • Dave Sanders
    Dave Sanders
    2003-07-06

    • labels: 544455 --> Database Error
    • summary: MySQL error returned when attempting to save a quiz option --> Quiz: MySQL error returned when attempting to save a option
     
  • teedog
    teedog
    2003-07-15

    • status: open --> closed