Life is Feudal Official Forum

[Alsonotan0rc]

When I try to start up my Lif server (using Maria DB), it encounters an error and shuts down. The end of the log file, beginning at the first warning, shows me this:

"ERRR 2015-10-11 18:16:56.745 {02} <initServer> ### DB error #1305: PROCEDURE lif_1.sp_checkForeignKeys does not exist. Query: CALL sp_checkForeignKeys('animal_breeds', 1, 1);
WARN 2015-10-11 18:16:56.761 {02} <initServer> ### DB::mfRS(31 ms) CALL sp_checkForeignKeys('animal_breeds', 1, 1);
ERRR 2015-10-11 18:16:56.776 {02} <initServer> ### CmServerInfoManager::_applyDbPatch() - call to sp_checkForeignKeys failed
ERRR 2015-10-11 18:16:56.776 {02} <initServer> ### CmServerInfoManager::processLocalWorlds() - can't access to db for world id=1
ERRR 2015-10-11 18:16:56.776 {02} <initServer> ### Fatal: Can't init local world (id=). Terminating.
ECHO 2015-10-11 18:16:56.776 {00} <NOSCOPE> # Engine initialized...
core/scripts/server/server.cs (78): Unable to find function destroyWorld
INFO 2015-10-11 18:16:56.776 {01} <onExit> ## The server has been shut down!"

I have opened the appropriate ports and made the appropriate software exceptions.

I'm not at all experienced with databases or servers, so it's quite possible I'm missing something obvious. Even so, a couple other people with the same error posted on the official forum here and other LiF forums, but none of them had a solution. Can anyone tell me how to fix this?

[Alakar]

Well the most obvious thing I can see right now is the world ID=

it should be like world ID=1
if its trying to load and then it would be using database lif_1

-Alakar

[Alsonotan0rc]

Thanks for the reply. I appreciate you looking over it Unfortunately I'm not DB-savvy enough to figure out how to fix the = [null] thing. I ended up starting over, using a different tutorial. It held my hand enough to get my server up and running.

If any one viewing this thread has issues setting up your database or getting your server to talk to the database you made, I highly recommend checking out this video tutorial I found at https://www.youtube.com/watch?v=k0Ssrh8lBVA

Now my problem is that I can only connect computers on my LAN to my server. I have opened the two sets of ports, allowed incoming WAN connections, and turned off antivirus and software firewall. There is no password set on the server, and it's supposed to be public. In spite of all that, my server doesn't appear on the list and I can't get other PCs to connect to it except using 10.0.0.x:28000

Anybody have any suggestions?