Error when loading game state from bug id

[somiryu]

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}

[Een]

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.

[Een]

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

[somiryu]

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!

[Een]

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!