Board Game Arena

Hi. I get this error when I try to load a game state from a bug id report. How can I try this to debug an error in production?

Sorry, an unexpected error has occurred...

Error while processing SQL request: SELECT COALESCE( MAX( gamelog_packet_id ), 0 ) last_packet_id, COALESCE( MAX( gamelog_move_id ), 0 ) move_nbr FROM gamelog WHERE gamelog_player IS NULL OR gamelog_player='2317649' Table 'ebd_xanadu_167120.gamelog' doesn't exist

#0 /var/tournoi/release/tournoi-200603-1012-gs/www/include/APP_DbObject.inc.php(573): APP_DbObject::DbQuery('SELECT COALESCE...', NULL)
#1 /var/tournoi/release/tournoi-200603-1012-gs/www/game/module/table/table.game.php(2853): APP_DbObject->getObjectFromDB('SELECT COALESCE...')
#2 /var/tournoi/release/tournoi-200603-1012-gs/www/game/module/table/table.game.php(247): Table->getCurrentNotificationNextNo('2317649')
#3 /var/tournoi/release/tournoi-200603-1012-gs/www/view/common/game.view.php(417): Table->getAllTableDatas()
#4 /var/tournoi/release/tournoi-200603-1012-gs/www/view/common/game.view.php(341): game_view->post_generate(Array)
#5 /var/tournoi/release/tournoi-200603-1012-gs/www/view/common/ebg.view.php(23): game_view->generate_content(Array)
#6 /var/tournoi/release/tournoi-200603-1012-gs/www/include/webActionCore.inc.php(231): ebg_view->generate(Array)
#7 /var/tournoi/release/tournoi-200603-1012-gs/www/index.php(230): launchWebAction('xanadu', 'action_xanadu', '__default', false, false, NULL, true, false)
#8 {main}

Looks like a mistake on my part. When saving state in prod, I exclude the gamelog table as it's only useful for the replay and makes a bigger dump.
But it looks like it's needed. I'll have to add some code to create it empty when reloading a state on the studio. I did it manually for your case.

NB: you still need to fix the player ids as described in the documentation to get a working state on the studio, but if you just wanted to check the database it's now possible from the go to database link below the game zone.

Fixed so that next game state reload won't have this issue.

Didn't find that documentation, but I managed to make it work by changing all player ids to my own player account ids! Thanks for the help!

Oh, should have linked it, but I thought you were already working from there:http://en.doc.boardgamearena.com/Practi ... bug_report

Glad it worked anyway!