almost there

[cerbere]

ok after a few hours, i finally succeeded on getting to character select, create a character, then i have the following after i try to enter world
eqemu_error_zone.log

---------------------------------------------
5459 [05.10. - 23:20:21] Starting Log: logs/eqemu_error_zone.log
5459 [05.10. - 23:20:21] Error in ZoneDatabase::LoadAAs query 'SELECT skill_id, level, cost from aa_required_level_cost order by skill_id': #1146: Table 'peq.aa_required_level_cost' doesn't exist

in zone-dynamic_05.log i got the following :

[Status] Booting tutorialb (189:0)
[Debug] The next weather check for zone: tutorialb will be in 13470 seconds.
[Status] Loading spawn conditions...
[Status] Loading static zone points...
[Status] Loading spawn groups...
[Status] Loading spawn2 points...
[Status] Loading player corpses...
[Status] Loading traps...
[Status] Loading adventure flavor text...
[Status] Loading ground spawns...
[Status] Loading Ground Spawns from DB...
[Status] Loading World Objects from DB...
[Status] Loading Objects from DB...
[Status] Loading doors for tutorialb ...
[Status] Loading Doors from database...
[Status] Loading AA information...
[Error] Starting Log: logs/eqemu_error_zone.log
[Error] Error in ZoneDatabase::LoadAAs query 'SELECT skill_id, level, cost from aa_required_level_cost order by skill_id': #1146: Table 'peq.aa_required_level_cost' doesn't exist
[Status] Loading AA Effects...
[Status] Loaded 361 AA Effects.
[Status] Loading Merchant Lists...
[Status] Loading Temporary Merchant Lists...
[Status] Successfully loaded Zone Config.
[Status] Loading timezone data...
[Status] Init Finished: ZoneID = 189, Time Offset = 0
Map header: 334289 faces, 486 nodes, 361871 facelists
Loaded map: 1002867 vertices, 334289 faces
Map BB: (-2005.89 -> 416.15, -1280.41 -> 876.96, -268.30 -> 147.17)
Map ./Maps/tutorialb.map loaded.
Water region map has 1893 nodes.
Water Map ./Maps/tutorialb.wtr loaded.
[Status] Path File Header: Version 2, PathNodes 373
[Status] Path File ./Maps/tutorialb.path loaded.
[Debug] Zone: tutorialb has weather of type 1.
[Debug] Zone: tutorialb(189) has weather type = 1. The weather timer has been enabled.
[Normal] Starting Log: logs/eqemu_zone.log
[Normal] ---- Zone server tutorialb, listening on port:7004 ----
[Status] Zone Bootup: tutorialb (189: 0)
Received Message SyncWorldTime
Time Broadcast Packet: EQTime [10:20 am]
Error in AddNPCSpells query1 'SELECT spellid, type, minlevel, maxlevel, manacost, recast_delay, priority, resist_adjust from npc_spells_entries where npc_spells_id=6 ORDER BY minlevel' #1054: Unknown column 'resist_adjust' in 'field list'
Error in AddNPCSpells query1 'SELECT spellid, type, minlevel, maxlevel, manacost, recast_delay, priority, resist_adjust from npc_spells_entries where npc_spells_id=218 ORDER BY minlevel' #1054: Unknown column 'resist_adjust' in 'field list'
Error in AddNPCSpells query1 'SELECT spellid, type, minlevel, maxlevel, manacost, recast_delay, priority, resist_adjust from npc_spells_entries where npc_spells_id=1 ORDER BY minlevel' #1054: Unknown column 'resist_adjust' in 'field list'
Error in AddNPCSpells query1 'SELECT spellid, type, minlevel, maxlevel, manacost, recast_delay, priority, resist_adjust from npc_spells_entries where npc_spells_id=8 ORDER BY minlevel' #1054: Unknown column 'resist_adjust' in 'field list'
[Status] Zone Shutdown: tutorialb (189)
[Normal] Zone shutdown: going to sleep

I have the revision 52 of http://code.google.com/p/projecteqdb/
I unzipped and sourced the peqdb_rev1751.sql
if I can post further logs to help I would be glad to do it, I felt so frustrated to be so close yet so far time to go to bed now !
i'm lost here, seems like I have a database issue but I cant see where i wouldnt have the latest with the svn.
nonethless before I could reach char select i had to apply this change :
http://www.eqemulator.org/forums/sho...07&postcount=2
it references a 1711 update and i dont see it in the updates folder of the trunk, that's why i'm wondering if i'm not mixing different things.
well thanks for your help in advance

[KLS]

The database isn't 100% current with the current db schema. What you want to do is go find the svn and in ./utils/sql/svn/ you'll have to source all the required SQL (the ones that don't have optional in the file name) that are past that revision.

eg 1753_required_sql_healing_adept_aa.sql through 1847_required_doors_dest_zone_size_32.sql

[cerbere]

thanks for your reply
I wrote a little script, not perfect but did the job

#!/bin/bash
LASTREV=1751
DIR=eqemulator/projecteqemu/utils/sql/svn/

#cd $DIR

for f in *.sql
do
TT="$(echo $f | sed -e "s/_.*//")"
#echo $TT
if [ "$TT" -gt "$LASTREV" ]
then
echo $TT
mysql --user=YOURUSER--password=YOURPASS peq < $f
fi
done