Database problem and Zone

[darkdonno]

Infomation
Database is 5.8 classic
Server Version: 0.6.0-DR1
Database Name = eq


Minilogin and World have no errors, byt my zone.exe comes up with the following.

Below is what it says in my Zone window.


[quote]
[Status] CURRENT_ZONE_VERSION: EQEMu 0.6.0-DR1
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading npcs
[Status] Loading npc faction lists
[Status] Loading NPC Faction Lists from database...
[Status] Loading loot tables
[Status] Loading Loot tables from database...
[Status] Loading doors
[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,triggerdoor,trigg ertype,dest_zone,dest_x,dest_y
,dest_z,dest_heading,liftheight,invert_state,incli ne from doors' #1054: Unknown
column 'liftheight' in 'field list'
Error: EMuShareMem: DLLLoadDoors: !cbDBLoadDoors
[Status] FileLoadSPDat() Loading spells from ./spells_us.txt
[Status] FileLoadSPDat() spells loaded: 6299
[Status] Loading guilds
[Status] Loading factions
[Status] Loading AA effects
[Error] Error in LoadAAEffects query 'SELECT aaid,rank,reuse_time,spell_id,targe
t,nonspell_action,nonspell_mana,nonspell_duration, redux_aa,redux_rate FROM aa_ac
tions': #1146: Table 'eq.aa_actions' doesn't exist
[Status] Loading swarm spells
[Error] Error in LoadSwarmSpells query 'SELECT spell_id,count,npc_id,duration FR
OM aa_swarmpets': #1146: Table 'eq.aa_swarmpets' doesn't exist
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] command_init(): Warning: Command 'hp' defaulting to access level 0!
[Status] command_init(): Warning: Command 'pf' defaulting to access level 0!
[Status] command_init(): Warning: Command 'bestz' defaulting to access level 0!
[Status] command_init(): Warning: Command 'ginfo' defaulting to access level 0!
[Status] 175 commands loaded
[Status] Loading embedded perl
[Status] Loading perlemb plugins.
[Status] Entering sleep mode
Connected to worldserver: 127.0.0.1:9000
[quote]


Help would be much appricated.
:P :P

[Sarepean]

Okay--- first things first, you need to source in your aa_swarmpets.sql from CVS. Secondly, I think you may have sourced in a door fix that isn't compatible with your database???

What files did you source for your database?

-Sarepean

[darkdonno]

Infomation you requested
I have also sourced merchantlist_temp.sql, aa_levels.sql,
I sourced in the door_update from
http://www.eqemulator.net/sql/doors_update.sql


Thanks I sourced the aa_swarmpets.sql and it fixed it. Thanks


I just sourced the AA_ACTIONS.sql from the Eqemu CVS and it fixed the problem below
<quote>
[Status] Loading AA effects
[Error] Error in LoadAAEffects query 'SELECT aaid,ra
t,nonspell_action,nonspell_mana,nonspell_duration, re
tions': #1146: Table 'eq.aa_actions' doesn't exist
</quote>

The only problems now is Doors
<quote>
[Status] Loading Doors from database...
Error in DBLoadDoors query 'SELECT id,doorid,zone,
,opentype,guild,lockpick,keyitem,triggerdoor,trigg
,dest_z,dest_heading,liftheight,invert_state,incli
column 'liftheight' in 'field list'
Error: EMuShareMem: DLLLoadDoors: !cbDBLoadDoors
</quote>[/quote]

[Sarepean]

I'm not sure, but I think that the doors_update was meant with the Kunark database--- not classic. Did you happen to source doors.sql before you sourced the update??

[darkdonno]

I did not source doors.sql

Is there anyway to fix it?


Such as remove the doors table then re-source doors.sql

[Sarepean]

I think I'd try just sourcing in the doors.sql file and then seeing if that works--- if not, maybe you could source in the doors.sql followed by the update or maybe you WILL have to remove that table.

-Sarepean

[darkdonno]

I tried sourcing in the DOORS.SQL but it comes up with a lots of error, also it is causing my PC speaker to beep alot.

ERROR 1136: Column count doesn't match value count at row 1
ERROR 1136: Column count doesn't match value count at row 1



I think I will have to try to remove the doors table.

But How Do you do it?

[Sarepean]

Not sure--- personally, I always just resourced a new database when I had problems.

Try 'drop table doors;'

-Sarepean