[SOLVED] INSERT INTO zz_replay1

[Rudolf]

Hello again,
I changed a bit the dbSQL file, I get this

Code: Select all

Unexpected error: Error while processing SQL request: INSERT INTO zz_replay1_tdo (`id`,`tdo_loc`,`tdo_y`,`tdo_card`) SELECT `id`,`tdo_loc`,`tdo_y`,`tdo_card` FROM tdo Unknown column 'tdo_card' in 'field list'

I've deleted the field tdo_card from tdo, express stop and I restart a new game, and each time I've got this message.

How I get ride of this error message? ... cannot continue with this.

thanks.

[pikiou]

zz_replay1 tables are duplicates of tables that you created at the start of the game. They are ment to be used for undos or loading a saved state or whatever.
Anyway if you modify the structures of your MySQL tables, you should modify their zz_replayX duplicates as well. Or just start another table.

[Rudolf]

yes I understood it's Save/Load 1 DB, but
yesterday, even starting a new table, I had this problem... don't know why... but today it's ok...

[Rudolf]

I understood why...
the behaviour is like that if you:
- save an actual state of the game
- don't close the game
- change dbmodel
- close the game.

even you restart a new table, you've got this error.
even closing browser.
you wait some minutes, and it seems to be corrected. maybe a daemon that corrects this?

To avoid this bahaviour,
before changing dbmodel, close current game.

[czuger]

Hello,

Thanks for this info. At least I know how to avoid it.

Any clue to fix the issue (other than wait )