Life is Feudal Official Forum

[Iomega0318]

So I have been trying for a few days and can't seem to get anything to stick, any changes I make including deleting the dump.sql file seem to cause the server to crash.. I have tested my query on the database itself and it works fine with no errors but if I try to add it anywhere in the dump.sql file the server will always crash and prevent it from staring..

I have done 100's of searches both here and through Google and can't find any solutions or reasons for this.. I love and hate this game sometimes..

Any ideas on how to solve this?

[Larainan]

Ive never had issue making changes to my dump sql file however these will revert after a patch. you start first by making the changes in new.sql and running that query in heidi. Any time I wanted to permanently change the dump file I had to do the new first then manually make the same changes in dump, save the changes then before restarting my server I do an extended maintenance on my LIF database looking for changed files then I restart the server.

The new sql file is the place you are supposed to be making changes but running the maintenance seems to let heidi know that changes have been made to all the files before a restart.

[Iomega0318]

I can run my query against the database just fine and it adds my custom changes, now here's what happens:

Server runs and starts fine with unedited dumpl.sql,
I modify and add my custom changes to dump.sql, server fails to start and just force closes,
I undo my changes to dump.sql, or revert the file, server starts fine again.

No matter what any changes to dump.sql are preventing the server from starting and I can't for the life of me figure out why, there are no errors in the log it just starts to run the file and then force quits. I assume it's checking the file against itself somewhere else but I can't find where if it is?

[Iomega0318]

Just thought I would bump this as I'm still waiting for assistance in figuring this out. Granted it's a pitmfa! to test out right now since I don't have internet..

[Alakar]

It works just fine, just make sure all your SQL statements are correct.

[Tobias0412]

What do u try to change ? Because there are some things u can not change at all...
For example if u try to make a movable object unmovable or opposite, thats not that easy and u can not just change it in dump.sql.
In dump sql u can execute own SQL`s or edit some values like owner timeout, size....

U cant change object types in dump.sql...

[Iomega0318]

It works just fine, just make sure all your SQL statements are correct.

Hmm could it be that because I am using the server download from Steam then that's causing an issue? I have tried a plethora of different types of edits to try and get it to work but even changing one letter in the comments will cause it to fail which is why I said I believe it's validating the file somewhere, somehow.. Here are two of what I have tried both of which can be run on the database manually and work perfect with no errors..

Code: Select all

-- Custom Server Database Edits

INSERT INTO `objects_types` (`ID`, `ParentID`, `Name`, `IsContainer`, `IsMovableObject`, `IsUnmovableobject`, `IsTool`, `IsDevice`, `IsDoor`, `MaxContSize`, `Length`, `MaxStackSize`, `UnitWeight`, `BackgndImage`, `WorkAreaTop`, `WorkAreaLeft`, `WorkAreaWidth`, `WorkAreaHeight`, `BtnCloseTop`, `BtnCloseLeft`, `FaceImage`, `Description`, `BasePrice`, `OwnerTimeout`) VALUES
(5000,63,'Storage Barrel',1,1,0,0,0,0,30000000,6,0,5,'art\\images\\universal',0,0,0,0,0,0,'art\\2D\\Objects\\barrel.png','',10,150);

INSERT INTO `recipe` (`ID`, `Name`, `Description`, `StartingToolsID`, `SkillTypeID`, `SkillLvl`, `ResultObjectTypeID`, `SkillDepends`, `Quantity`, `Autorepeat`, `IsBlueprint`) VALUES
(5000,'Storage Barrel','',36,8,0,5000,35,1,0,0);

INSERT INTO `recipe_requirement` (`ID`, `RecipeID`, `MaterialObjectTypeID`, `Quality`, `Influence`, `Quantity`, `IsRegionItemRequired`) VALUES
(10000,5000,282,0,15,2,0),
(10001,5000,327,0,30,5,0),
(10002,5000,281,0,10,20,0),
(10003,5000,36,0,10,30,0);

-- Custom Server Database Edits

insert into objects_types(`ID`, `ParentID`, `Name`, `IsContainer`, `IsMovableObject`, `IsUnmovableobject`, `IsTool`, `IsDevice`, `IsDoor`, `MaxContSize`, `Length`, `MaxStackSize`, `UnitWeight`, `BackgndImage`, `WorkAreaTop`, `WorkAreaLeft`, `WorkAreaWidth`, `WorkAreaHeight`, `BtnCloseTop`, `BtnCloseLeft`, `FaceImage`, `Description`, `BasePrice`, `OwnerTimeout`) values
   (5000,63,'Storage Barrel',1,1,0,0,0,0,30000000,6,0,5,'art\\images\\universal',0,0,0,0,0,0,'art\\2D\\Objects\\barrel.png','',10,150)
   on duplicate key update
   `ID`=5000, `ParentID`=63, `Name`='Storage Barrel', `IsContainer`=1, `IsMovableObject`=1, `IsUnmovableobject`=0, `IsTool`=0, `IsDevice`=0, `IsDoor`=0, `MaxContSize`=30000000, `Length`=6, `MaxStackSize`=0, `UnitWeight`=5, `BackgndImage`='art\\images\\universal', `WorkAreaTop`=0, `WorkAreaLeft`=0, `WorkAreaWidth`=0, `WorkAreaHeight`=0, `BtnCloseTop`=0, `BtnCloseLeft`=0, `FaceImage`='art\\2D\\Objects\\barrel.png', `Description`='', `BasePrice`=10, `OwnerTimeout`=150;

insert into recipe(`ID`, `Name`, `Description`, `StartingToolsID`, `SkillTypeID`, `SkillLvl`, `ResultObjectTypeID`, `SkillDepends`, `Quantity`, `Autorepeat`, `IsBlueprint`) values
   (5000,'Storage Barrel','',36,8,0,5000,35,1,0,0)
   on duplicate key update
   `ID`=5000, `Name`='Storage Barrel', `Description`='', `StartingToolsID`=36, `SkillTypeID`=8, `SkillLvl`=0, `ResultObjectTypeID`=5000, `SkillDepends`=35, `Quantity`=1, `Autorepeat`=0, `IsBlueprint`=0;

insert into recipe_requirement(`ID`, `RecipeID`, `MaterialObjectTypeID`, `Quality`, `Influence`, `Quantity`, `IsRegionItemRequired`) values
   (10000,5000,282,0,15,2,0)
   on duplicate key update
   `ID`=10000, `RecipeID`=5000, `MaterialObjectTypeID`=282, `Quality`=0, `Influence`=15, `Quantity`=2, `IsRegionItemRequired`=0;

insert into recipe_requirement(`ID`, `RecipeID`, `MaterialObjectTypeID`, `Quality`, `Influence`, `Quantity`, `IsRegionItemRequired`) values
   (10001,5000,327,0,30,5,0)
   on duplicate key update
   `ID`=10001, `RecipeID`=5000, `MaterialObjectTypeID`=327, `Quality`=0, `Influence`=30, `Quantity`=5, `IsRegionItemRequired`=0;

insert into recipe_requirement(`ID`, `RecipeID`, `MaterialObjectTypeID`, `Quality`, `Influence`, `Quantity`, `IsRegionItemRequired`) values
   (10002,5000,281,0,10,20,0)
   on duplicate key update
   `ID`=10002, `RecipeID`=5000, `MaterialObjectTypeID`=281, `Quality`=0, `Influence`=10, `Quantity`=20, `IsRegionItemRequired`=0;

insert into recipe_requirement(`ID`, `RecipeID`, `MaterialObjectTypeID`, `Quality`, `Influence`, `Quantity`, `IsRegionItemRequired`) values
   (10003,5000,36,0,10,30,0)
   on duplicate key update
   `ID`=10003, `RecipeID`=5000, `MaterialObjectTypeID`=36, `Quality`=0, `Influence`=10, `Quantity`=30, `IsRegionItemRequired`=0;

This was meant to just test things out and make sure I can make any other changes/items I wanted, this is pretty much a copy of the Barrel with a different name, weight, and "length".

What do u try to change ? Because there are some things u can not change at all...
For example if u try to make a movable object unmovable or opposite, thats not that easy and u can not just change it in dump.sql.
In dump sql u can execute own SQL`s or edit some values like owner timeout, size....

U cant change object types in dump.sql...

Well everything I have tried as well as my explanations should be up there ^, but afaik from reading you could change anything correct? From what you just stated if I can't add objects to the database then that's probably why it is failing.. How else would one go about adding something then?