Page 1 of 1

Bug, bad insert into zz_replay1 table

Posted: 21 January 2018, 21:49
by quietmint
In studio, I changed dbmodel.sql (removed two columns `player_id and `bldg_cnt` from table `board`). I quit all games and built new version, but still I get this error. The framework is running a bad insert statement, referring to old column that no longer exists. Nowhere in my code refers to `bldg_cnt` anymore and it doesn't exist in any database table anymore, so why is this happening? How do I fix this?
Unexpected error: Error while processing SQL request: INSERT INTO zz_replay1_board (`id`,`x`,`y`,`z`,`r`,`face`,`player_id`,`bldg_type`,`bldg_cnt`) SELECT `id`,`x`,`y`,`z`,`r`,`face`,`player_id`,`bldg_type`,`bldg_cnt` FROM board Unknown column 'player_id' in 'field list'
Studio table ebd_taluva_44275. phpMyAdmin shows correct table definition for both `board` and `zz_replay1_board` (columns are removed). It's just this INSERT statement that's still referring to old columns.

Re: Bug, bad insert into zz_replay1 table

Posted: 21 January 2018, 22:20
by quietmint
Actually, this might be related to SVN error. It appears something is wrong with the "modules" directory for my project. Admins, can you fix this?
svn: E200009: Commit failed (details follow):
svn: E200009: '/var/tournoi/games/taluva/modules' is not under version control

Re: Bug, bad insert into zz_replay1 table

Posted: 22 January 2018, 20:07
by Een
Hello,
I have fixed the commit trouble, and reloaded apache (this looked like a caching trouble). I was able to start a game, so it looks like it's fixed. :)

Re: Bug, bad insert into zz_replay1 table

Posted: 23 January 2018, 01:35
by quietmint
I get permission denied error when trying to upload files to modules/ folder. Is ownership wrong?

Re: Bug, bad insert into zz_replay1 table

Posted: 23 January 2018, 09:06
by Een
Yes indeed, should be good now.