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()