ALTER TABLE 'player'

[Oermelie]

Hi everybody,

evertime I use the ALTER TABLE 'player' to add some custom fields to the table.

ALTER TABLE `player` ADD `beer` INT UNSIGNED NOT NULL DEFAULT '0';

my game doesnt start with some kind of error:

Unexpected error: Propagating error from gameserver 1 (method: createGame): BGA service error (reference: GS1 27/07 17:47:57) (reference: GS0 27/07 17:47:57)

After that the only way to start the game is to "Overwrite working copy with this revision"

[RicardoRix]

I just added that line to my game, and it works fine.

file: dbmodel.sql

You can comment out a line with the double dash. You don't need to restore the last version.
So maybe there is something else you have broken.

Code: Select all

--ALTER TABLE `player` ADD `beer` INT UNSIGNED NOT NULL DEFAULT '0';

[Oermelie]

my game is fully working until I comment out this line

[RicardoRix]

start from a place where your code works and the game starts.

Then make changes. When it doesn't work anymore you've inadvertently broken something. The dbmodel.sql is only used when you start a new game and the DB is created.

[Tisaac]

my game is fully working until I comment out this line

You very likely just forgot to change the INSERT statement with that extra field.

[toddcarson]

Afterwards, make the necessary edits. You broke it by accident the last time it stopped working. The dbmodel.sql file is used when you start a new game and create the database. geometry dash

[snugglecactus]

my game is fully working until I comment out this line

You very likely just forgot to change the INSERT statement with that extra field.

Shouldn't be a problem with the `DEFAULT` clause there.