Moodle

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.9.4
• Fix Version/s: None
• Component/s: Other
• Labels:

  None
• Environment:

  Moodle 1.9.4 build 20090414, postgresql 8.3.4 php 5.2.5, windows 2000, apache 2.2.8

I opened an existing Millionaire Quiz game that I use for testing and answered the first question correctly. The errors below where then displayed. I don't know if this reflects issues with the lib files that handle postgresql or with the game module or both.

Kind regards

Johnathan

ERROR: syntax error at or near "r" LINE 1: SELECT id,repetitions r FROM mdl_game_repetitions WHERE game... ^

SELECT id,repetitions r FROM mdl_game_repetitions WHERE gameid=28 AND userid='5' AND questionid='2' AND glossaryentryid='0'

• line 686 of lib\dmllib.php: call to debugging()
• line 481 of lib\dmllib.php: call to get_recordset_sql()
• line 531 of lib\dmllib.php: call to get_record_sql()
• line 263 of mod\game\locallib.php: call to get_record_select()
• line 301 of mod\game\millionaire\play.php: call to game_question_selectrandom()
• line 252 of mod\game\millionaire\play.php: call to game_millionaire_SelectQuestion()
• line 544 of mod\game\millionaire\play.php: call to game_millionaire_ShowNextQuestion()
• line 59 of mod\game\millionaire\play.php: call to game_millionaire_OnAnswer()
• line 19 of mod\game\millionaire\play.php: call to game_millionaire_play()
• line 117 of mod\game\attempt.php: call to game_millionaire_continue()
• line 85 of mod\game\attempt.php: call to game_create()

ERROR: syntax error at or near "r" LINE 1: SELECT id,repetitions r FROM mdl_game_repetitions WHERE game... ^

SELECT id,repetitions r FROM mdl_game_repetitions WHERE gameid=28 AND userid='5' AND questionid='2' AND glossaryentryid='0'

• line 686 of lib\dmllib.php: call to debugging()
• line 481 of lib\dmllib.php: call to get_recordset_sql()
• line 531 of lib\dmllib.php: call to get_record_sql()
• line 286 of mod\game\locallib.php: call to get_record_select()
• line 279 of mod\game\locallib.php: call to game_update_repetitions()
• line 301 of mod\game\millionaire\play.php: call to game_question_selectrandom()
• line 252 of mod\game\millionaire\play.php: call to game_millionaire_SelectQuestion()
• line 544 of mod\game\millionaire\play.php: call to game_millionaire_ShowNextQuestion()
• line 59 of mod\game\millionaire\play.php: call to game_millionaire_OnAnswer()
• line 19 of mod\game\millionaire\play.php: call to game_millionaire_play()
• line 117 of mod\game\attempt.php: call to game_millionaire_continue()
• line 85 of mod\game\attempt.php: call to game_create()

ERROR: duplicate key value violates unique constraint "mdl_gamerepe_gamusequeglo_uix"

INSERT INTO mdl_game_repetitions ( ID, GAMEID, USERID, QUESTIONID, GLOSSARYENTRYID, REPETITIONS ) VALUES ( 3, 28, 5, 2, 0, 1 )

• line 1554 of lib\dmllib.php: call to debugging()
• line 307 of mod\game\locallib.php: call to insert_record()
• line 279 of mod\game\locallib.php: call to game_update_repetitions()
• line 301 of mod\game\millionaire\play.php: call to game_question_selectrandom()
• line 252 of mod\game\millionaire\play.php: call to game_millionaire_SelectQuestion()
• line 544 of mod\game\millionaire\play.php: call to game_millionaire_ShowNextQuestion()
• line 59 of mod\game\millionaire\play.php: call to game_millionaire_OnAnswer()
• line 19 of mod\game\millionaire\play.php: call to game_millionaire_play()
• line 117 of mod\game\attempt.php: call to game_millionaire_continue()
• line 85 of mod\game\attempt.php: call to game_create()

stdClass Object ( [gameid] => 28 [userid] => 5 [questionid] => 2 [glossaryentryid] => 0 [repetitions] => 1 [id] => 3 )
Insert page: new page game_repetitions not inserted
Stack trace:

• line 1666 of lib\deprecatedlib.php: call to debugging()
• line 310 of mod\game\locallib.php: call to error()
• line 279 of mod\game\locallib.php: call to game_update_repetitions()
• line 301 of mod\game\millionaire\play.php: call to game_question_selectrandom()
• line 252 of mod\game\millionaire\play.php: call to game_millionaire_SelectQuestion()
• line 544 of mod\game\millionaire\play.php: call to game_millionaire_ShowNextQuestion()
• line 59 of mod\game\millionaire\play.php: call to game_millionaire_OnAnswer()
• line 19 of mod\game\millionaire\play.php: call to game_millionaire_play()
• line 117 of mod\game\attempt.php: call to game_millionaire_continue()
• line 85 of mod\game\attempt.php: call to game_create()

• Assignee:

  moodle.com

  Reporter:

  Johnathan Kemp

  Participants:

  Johnathan Kemp, moodle.com

• Created:

  15/Apr/09 8:36 PM

  Updated:

  08/Nov/11 1:16 PM