EQEmulator Forums - Boot5Zones problem

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - Boot5Zones problem (https://www.eqemulator.org/forums/showthread.php?t=17323)

Boot5Zones problem

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

Quote:

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.

Quote:

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;

Quote:

[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

Quote:

[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?

I dunno where to find the commands.pl file

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

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.

Code:

[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.

Code:

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

Code:

[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

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.