PDA

View Full Version : Boot5Zones problem


Linera
12-10-2004, 01:08 PM
I had a problem with the boot5zones.bat file evertime it runs i get this:

[Status] CURRENT_ZONE_VERSION: EQEMu 0.6.0-DR2
[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,door_param,invert_state,incli ne,size from doors' #1054: Unk
nown column 'door_param' in 'field list'
If you get an error about door_param and size, run the following queries:
ALTER TABLE `doors` CHANGE `liftheight` `door_param` INT(4) DEFAULT "0" NOT NUL
L;
ALTER TABLE `doors` ADD `size` SMALLINT(5) UNSIGNED DEFAULT "100" NOT NULL;
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
[Status] Loading swarm spells
[Status] Loading tributes
[Error] Error in LoadTributes first query 'SELECT id,name,descr FROM tributes':
#1146: Table 'eq.tributes' doesn't exist
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] 176 commands loaded
[Status] Loading embedded perl XS
[Quest] Loading perlemb plugins.
[Quest] Loading perl commands...
[Quest] Warning - commands.pl: Perl runtime error: open 'commands.pl' No such fi
le or directory at (eval 3) line 1.

[Error] Starting command queue Mapping...

[Quest] Loading perlemb plugins.
[Quest] Loading perl commands...
[Quest] Warning - commands.pl: Perl runtime error: open 'commands.pl' No such fi
le or directory at (eval 3) line 1.

[Status] Entering sleep mode
Connected to worldserver: 127.0.0.1:9000

mattmeck
12-10-2004, 01:37 PM
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,door_param,invert_state,incli ne,size from doors' #1054: Unk
nown column 'door_param' in 'field list'

Answeres right after that.

If you get an error about door_param and size, run the following queries:
ALTER TABLE `doors` CHANGE `liftheight` `door_param` INT(4) DEFAULT "0" NOT NUL
L;

[Error] Error in LoadTributes first query 'SELECT id,name,descr FROM tributes':
#1146: Table 'eq.tributes' doesn't exist

Isnt there an SQL file tio run to fix this? look for tributs.sql or some such on the DL page

[Quest] Warning - commands.pl: Perl runtime error: open 'commands.pl' No such fi
le or directory at (eval 3) line 1.

isnt there the perl files you need to DL and add to the proper directory?

Linera
12-10-2004, 02:16 PM
I dunno where to find the commands.pl file

Lanfo
12-11-2004, 10:02 PM
Hi,

I am having similar problems,

I found tributes.sql here, and sourced it into my db. But that did not fix the tributes error.

tributes.sql (http://cvs.sourceforge.net/viewcvs.py/*checkout*/eqemulator/EQEmuCVS/SQL-Files/tributes.sql?)

I ran both of the commands for the doors error, but I have no idea what files I need to fix that, tried searching the forums, but didn’t have any luck. (It has probably been covered; I am just not typing the right search parameters)

I could not find command.pl either.

I can login to my server and it runs well, but theres a ton of npc errors.


[Status] Loading Temporary Merchant Lists...
Error in LoadTempMerchantData query 'select ml.npcid,ml.slot,ml.itemid,ml.charges from merchantlist_temp ml, npc_types nt,
spawnentry se, spawn2 s2 where nt.id=ml.npcid and nt.id=se.npcid and se.spawngroupid=s2.spawngroupid and s2.zone='neriakc
' group by ml.npcid,slot order by npcid,slot asc' #1146: Table 'eq.merchantlist_temp' doesn't exist
[Status] Zone Bootup: NeriakC (42)
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.



mysql> ALTER TABLE `doors` CHANGE `liftheight` `door_param` INT(4) DEFAULT "0" NOT NULL;
ERROR 1146: Table 'mysql.doors' doesn't exist
mysql> ALTER TABLE `doors` ADD `size` SMALLINT(5) UNSIGNED DEFAULT "100" NOT NULL;
ERROR 1146: Table 'mysql.doors' doesn't exist



[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.0-DR2
[Status] Loading variables..
[Status] Loading zones..
[Status] Clearing groups..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=36965
[Status] ./LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading ./addon.ini..
[Status] Loading EQ time of dayi
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Assassinating people that whine about horses...done
TCP listening on: 68.230.212.149:9000
World server listening on: 68.230.212.149:9000
Connected to LoginServer: newlogin1.eqemulator.net:5994
35047 New TCP connection: 68.230.212.149:1758
New zoneserver: #1 68.230.212.149:1758
Zoneserver SetConnectInfo: 68.230.212.149:1758: 68.230.212.149:7995
334937 New TCP connection: 68.230.212.149:1759

Lanfo
12-11-2004, 11:04 PM
I'm beggining to wonder if there was a problem when I installed perl and scalar, gonna try reinstalling, and starting from scratch.

I can log in but now I get NPC errors, (no npcs) and doors are messed up.