Propagating error from GS 1 : BGA service error
Posted: 06 April 2021, 14:55
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 :
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';