Propagating error from GS 1 : BGA service error

[Ottoreg]

Hello,

I'm working on the integration of the database for my first game on BGA (BossQuest).
I'm not 100% fluent in web languages, so maybe I'm missing obvious issues.

The problem is an error message that I get since I first launch the game after writing my database code in dbmodel.sql.

The error message is : Unexpected error: Propagating error from GS 1 (method: createGame): BGA service error (1.studio.boardgamearena.com 06/04 14:51:25)

I read from https://boardgamearena.com/doc/Troubleshooting that this error is coming from a syntax error in my database code or from a statistic of my game. I used SqlDBM to generate the sql code so I believe there is no syntax error and I did not alter any part of the stats.inc.php.

From now this error happens every time I try to start a quick game (even if I comment out the database code).

After checking in mysql, the tables from my code were not created.

I also checked the project with the Check Project tool in Control panel section. And no error was displayed in relation to the error message.

I tried my best to troubleshoot the issue as much as possible, but I reached a point where I cannot think of anything else.

If anyone has an idea to solve this it would be very appreciated! :^)

here's my DB code :

Code: Select all

CREATE TABLE IF NOT EXISTS `boss_card`
(
 `bcard_id` int(10) NOT NULL  AUTO_INCREMENT,
 `bcard_type` varchar(16) NOT NULL,
 `bcard_type_arg` int(11) NOT NULL,
 `bcard_location` varchar(16) NOT NULL,
 `bcard_location_arg` int(11) NOT NULL,

PRIMARY KEY (`bcard_id`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS `weapon_card`
(
 `wcard_id` int(10) NOT NULL  AUTO_INCREMENT,
 `wcard_type` varchar(16) NOT NULL,
 `wcard_type_arg` int(11) NOT NULL,
 `wcard_location` varchar(16) NOT NULL,
 `wcard_location_arg` int(11) NOT NULL,

PRIMARY KEY (`wcard_id`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS `spell_card`
(
 `scard_id` int(10) NOT NULL  AUTO_INCREMENT,
 `scard_type` varchar(16) NOT NULL,
 `scard_type_arg` int(11) NOT NULL,
 `scard_location` varchar(16) NOT NULL,
 `scard_location_arg` int(11) NOT NULL,


PRIMARY KEY (`scard_id`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
 
  ALTER TABLE `player` ADD `player_hearts` int UNSIGNED NOT NULL DEFAULT '3';
  ALTER TABLE `player` ADD `player_keys` int UNSIGNED NOT NULL DEFAULT '0';
  

[thoun]

With same error, I've been advised to place die('ok here'), at various places during setup, to see if you get it on network result. If so, remove the first and retry, until you get which line is in error.

[Ottoreg]

Thanks thoun it helped a lot !

I found out that I was trying to create deck of cards from tables that were not created yet.

The Unexpected error doesn't happen anymore !