Recompile and reload of DB now doors don't work

[Xelaan]

I know I have been asking a lot of questions, sorry about that I am learning as fast as I can.

I recompiled this morning in an attempt to work on bots. Now I no longer have doors and working lifts in Gfaydark.

I reloaded a fresh copy of the latest database and recompiled the latest code using the svn up command to obtain.

12975 [05.26. - 08:10:25] Starting Log: logs/eqemu_error_zone.log
12975 [05.26. - 08:10:25] Error Loading Objects from DB: #1054: Unknown column 'linked_list_addr_01' in 'field list'
12975 [05.26. - 08:10:25] Loading World Objects failed. continuing.
12975 [05.26. - 08:10:25] ... Failed to load doors.

I am using peq db Rev 553

Any thoughts on why doors won't load?

[Xelaan]

Looks like something changed in the new db and is not working right.

[Status] Loading Ground Spawns from DB...
[Status] Loading World Objects from DB...
[Error] Error Loading Objects from DB: #1054: Unknown column 'linked_list_addr_01' in 'field list'
[Error] Loading World Objects failed. continuing.
[Status] Loading doors for potranquility ...
[Status] Loading Doors from database...
Error in DBLoadDoors query 'SELECT id,doorid,zone,name,pos_x,pos_y,pos_z,heading,opentype,guild,lockpick,keyitem,nokeyring,triggerdoor,triggertype,dest_zone,dest_x,dest_y,dest_z,dest_heading,door_param,invert_state,incline,size FROM doors WHERE zone='potranquility' ORDER BY doorid asc' #1054: Unknown column 'nokeyring' in 'field list'
[Error] ... Failed to load doors.

There was some change in the keyring, maybe something to do with the key check is making my doors not work. Any of the experts have any thoughts?

[Andrew80k]

Check to make sure you sourced all the updated sql as well. This is usually found in the svn repository under utils/sql/svn

[Xelaan]

I actually deleted my old DB entirely and recreated it from the new package. I then ran through the updates to be sure, they were all in the DB already though. The only thing from the old DB was I reloaded the characters from the backup I had.

[Xelaan]

I am sorry, you were correct, in the EQEmu source I missed one of the SQL updates. I had added all the ones included with the DB. Once I sourced in the missing nokeyring.sql the doors all came back.

However, now I can't hit or cast spells on anything. Never a dull moment after an upgrade.

I target a mob and try to cast a spell it tells me I cannot see it, if I try melee I just keep missing, and the mob keeps missing me as well.

[Shendare]

That new problem is generally the case of missing or corrupted .map files on the server.

You should have .map (and sometimes .wtr) files for each zone in the Maps folder of your EQEmu server installation.

If you don't have a .map file for a zone, the server doesn't know how the zone is laid out and can't process "can X see Y" checks.

- Shendare

[Andrew80k]

This is usually due to missing map files. Is this in one zone or all zones?