[SOLVED] dump.sql and server stops

Place for sharing your game modifications for Life is Feudal: Your Own

Durgrim
 
Posts: 42
Joined: 24 Nov 2015, 19:51

[SOLVED] dump.sql and server stops

Post by Durgrim » 30 Dec 2015, 23:21

Hey guys.
Little technique question here:

the unmodified dump.sql has 244kb.
I modify it with these lines:

update objects_types set MaxContSize = 30000000 WHERE id = 131;
update objects_types set MaxContSize = 200000000 WHERE id = 132;
update objects_types set MaxContSize = 50000000 WHERE id = 516;
update objects_types set MaxContSize = 15000000 WHERE id = 169;
update objects_types set MaxContSize = 2500000 WHERE id = 168;
update objects_types set MaxContSize = 1500000 WHERE id = 101;

then i save the file and everything is good.
The dump has 237kb now in FTP.

When I start my server up, it automatically shuts down again instantly.

It will first run, when i check the box "Autoupdate on startup" and he replaces the old dump.sql file with the fresh-patched one without my lines.

What is wrong there? Basically, he doesnt keep the capacity changes serverside.

Have the IDs changed since last patch? or do i have a mistake in these lines? I used them pre-patch and everything was fine
Last edited by Durgrim on 31 Dec 2015, 08:46, edited 1 time in total.
Image


Durgrim
 
Posts: 42
Joined: 24 Nov 2015, 19:51

Re: dump.sql and server stops

Post by Durgrim » 30 Dec 2015, 23:50

update:
1) i take the server offline
2) i edit objects_type in sql via Heidi to above mentioned numbers
3) i fire the server up again without autoupdate
4) server is available but ingame no changes
5) i take it offline again
6) i check heidisql and voila....old numbers in the objects_type
7) i am like "WTH????"


what is happening there? Any settings i forgot? Any new coding since patch?
Image


Durgrim
 
Posts: 42
Joined: 24 Nov 2015, 19:51

Re: dump.sql and server stops

Post by Durgrim » 31 Dec 2015, 08:46

[SOLVED] apparently... :)

1. I checked changing dump.sql with GameServer.com, used FireFTP
2. worked , changes were valid after restart
3. On my other server, hosted by Zap-Hosting, coming with its own ftp-upload-solution, dump.sql was always reset even when unchecked "auto-update" on startup.
4. So I used FireFTP with zap-hosting, uploaded my modified dump.sql and voila..it worked.
Image

Return to Game mods