DB error #1305: PROCEDURE lif_1.sp_checkForeignKeys does not exist

General discussion about Life is Feudal MMO and Life is Feudal: Your Own, The main section and backbone of the forums.

Deathbows2me
 
Posts: 4
Joined: 31 Dec 2015, 02:01

DB error #1305: PROCEDURE lif_1.sp_checkForeignKeys does not exist

Post by Deathbows2me » 31 Dec 2015, 02:04

ECHO 2015-12-30 17:56:11.381 {02} <initServer> ### Validating database...
ERRR 2015-12-30 17:56:11.382 {02} <initServer> ### DB error #1305: PROCEDURE lif_1.sp_checkForeignKeys does not exist. Query: CALL sp_checkForeignKeys('animal_breeds', 1, 1);
WARN 2015-12-30 17:56:11.386 {02} <initServer> ### DB::mfRS(4 ms) CALL sp_checkForeignKeys('animal_breeds', 1, 1);
ERRR 2015-12-30 17:56:11.387 {02} <initServer> ### CmServerInfoManager::_applyDbPatch() - call to sp_checkForeignKeys failed
ERRR 2015-12-30 17:56:11.390 {02} <initServer> ### CmServerInfoManager::processLocalWorlds() - can't access to db for world id=1
ERRR 2015-12-30 17:56:11.395 {02} <initServer> ### Fatal: Can't init local world (id=). Terminating.
ECHO 2015-12-30 17:56:11.409 {00} <NOSCOPE> # Engine initialized...
ECHO 2015-12-30 17:56:11.411 {00} <NOSCOPE> # Thread pool initialized, threads: 7
core/scripts/server/server.cs (78): Unable to find function destroyWorld
INFO 2015-12-30 17:56:11.415 {01} <onExit> ## The server has been shut down!
ECHO 2015-12-30 17:56:11.422 {00} <NOSCOPE> # Thread pool shut down



Server does not launch because of the above error. I have redone the SQL 3 times.

Any help would be great!


Reyanth
 
Posts: 1
Joined: 01 Jan 2016, 19:39

Re: DB error #1305: PROCEDURE lif_1.sp_checkForeignKeys does not exist

Post by Reyanth » 01 Jan 2016, 19:41

We're having this same issue. Before we tried to reboot the server our monument upgrade bugged this resulting the monument being not accessible. A bark box also bugged when it was being moved, after you couldn't do anything to it.

Hope you fix this issue soon! It's really killing us.


Deathbows2me
 
Posts: 4
Joined: 31 Dec 2015, 02:01

Re: DB error #1305: PROCEDURE lif_1.sp_checkForeignKeys does not exist

Post by Deathbows2me » 03 Jan 2016, 21:11

Yeah ive reinstalled and remade an SQL 3 times with the same error. I am starting from scratch.

My gaming community would love to play this game but it's so broken, yet so interesting.


User avatar
Arrakis
 
Posts: 5453
Joined: 25 Oct 2013, 14:11
Location: Space

Re: DB error #1305: PROCEDURE lif_1.sp_checkForeignKeys does not exist

Post by Arrakis » 11 Jan 2016, 11:37

Please, refer to this post (server-will-not-work-t16347/#p66426) and say whether it helped or not.


Deathbows2me
 
Posts: 4
Joined: 31 Dec 2015, 02:01

Re: DB error #1305: PROCEDURE lif_1.sp_checkForeignKeys does not exist

Post by Deathbows2me » 12 Jan 2016, 22:17

@Arrakis09

Ive already done that multiple times. unfortunately it didn't work.

Arrakis09 wrote:Please, refer to this post (server-will-not-work-t16347/#p66426) and say whether it helped or not.


Doesn't work. When you remove the DB it will puke more errors, as it should. But with no DB you have no game so whats the point at removing it and removing it? I have recreated the DB 3 times. Could it be the SQL file you get from the DL?

User avatar
HolyCrusader
Beta Tester
 
Posts: 251
Joined: 24 Nov 2014, 15:47

Re: DB error #1305: PROCEDURE lif_1.sp_checkForeignKeys does not exist

Post by HolyCrusader » 12 Jan 2016, 23:08

Deathbows2me wrote:@Arrakis09

Ive already done that multiple times. unfortunately it didn't work.

Arrakis09 wrote:Please, refer to this post (server-will-not-work-t16347/#p66426) and say whether it helped or not.


Doesn't work. When you remove the DB it will puke more errors, as it should. But with no DB you have no game so whats the point at removing it and removing it? I have recreated the DB 3 times. Could it be the SQL file you get from the DL?

When you remove the DB, I believe what happens is that the server runs the new.sql file in the /sql/ which will recreate your databse

Other things to check for:
- make sure you followed the instructions for the my.ini file and that it is placed in the proper MariaDB folder
- double-check that you have -world # in the target line / parameters
- ensure that in your /config/ folder you have world_#.xml (# has to be the same as -world # above)
- open the world_#.xml file and ensure that the world ID # matches
- make sure you use the right USER/PW combination in the config_local.cs file (find this file in the /docs/ folder and then move it to the game installation's root directory

Return to General Discussion