Zone.exe errors, eq.tributes and Commands.pl missing?(FIXED)

[Lanfo]

Hello everyone,

I am having trouble setting up my EQemu server, I have spent allot of time searching these forums and have found answers to most of the problems I have had so far. But I am still getting two errors no matter what I try. I've started the entire install process over 4 times, uninstalled and deleted everything for EQemu, Mysql, db files and Perl, then re-downloaded everything and followed the install guides very closely.

But I am obviously still doing something wrong, I just cannot figure out what it is.

Perl seems to install just fine, the scalar module seems to install just fine, I have tried restarting my PC after running perl -MCPAN -e shell but before running install IO::ScalarWorld.exe starts up ok, with no errors but when I start zone.exe it seems to fail on loading tributes (says eq.tributes dose not exist) and also says commands.pl dose not exist, but I can't find commands.pl anywhere for download, anyway I assume that it was supposed to be installed with Perl or scalar, but I don't know, this is my first time using perl. I can log into my server, and it runs stable, doors seem okay, but there are no npc's.

I tried this command but it did not fix things;
ALTER TABLE npc_types ADD npc_aggro TINYINT NOT NULL DEFAULT '0';

Error messages:
[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 loot tables
[Status] Loading doors
[Status] Loading Doors from database...
[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 file 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 file or directory at (eval 3) line 1.

[Status] Entering sleep mode
Connected to worldserver: XX.XXX.XXX.XXX:XXXX
(That is all the errors I get when booting the server, everything else seems to load ok)

I get tons of these while PC's are logged in...
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.

Anyways here is my info, system specs, software versions error messages ect.
Mysql 4.0.22
PEQ_Kunark_RC1.sql
PEQ_Kunark_RC1_keep_accts.sql
merchantlist_temp.sql
doors_update.sql
doorsdata.sql
tributes.sql
tl.sql
(Sourced in that order)
EQemu EQEMu 0.6.0-DR2
Perl v5.8.2

Thanks for taking the time to read this :)

system specs:
Windows 2000 sp4
AXP Barton 3200
Asus A7N8X-E Dlx. BIOS 1013
1 GB CorsairXMS DDR PC3200(2x512mb Dual Channel)
XFX Geforce 6600GT AGP
SB Audigy 2 ZX
Norton AV Pro 2003 (disabled during installs)
ZoneAlarm 4

[Spike]

This is baffeling to me...

sourcing tributes.sql should make it work.... on mine I didnt even bother sourcing tributes just the TL.sql that cisyouc sent me and that made my errors with tribute_levels work. Try sourcing tributes.sql again...

[Lanfo]

Thanks for your help.

I tried to source tributes.sql again, no luck with it fixing my problem though, got some error messages when I tried to do it though, here they are below.

Microsoft Windows 2000 [Version 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.

C:\>cd c:\mysql\bin

C:\mysql\bin>mysql -u root mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 4.0.22-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> source tributes.sql;
ERROR 1050: Table 'tributes' already exists
ERROR 1062: Duplicate entry '1' for key 1
ERROR 1062: Duplicate entry '2' for key 1
ERROR 1062: Duplicate entry '3' for key 1
ERROR 1062: Duplicate entry '4' for key 1
ERROR 1062: Duplicate entry '5' for key 1
ERROR 1062: Duplicate entry '6' for key 1
ERROR 1062: Duplicate entry '7' for key 1
ERROR 1062: Duplicate entry '8' for key 1
ERROR 1062: Duplicate entry '9' for key 1
ERROR 1062: Duplicate entry '10' for key 1
ERROR 1062: Duplicate entry '11' for key 1
ERROR 1062: Duplicate entry '12' for key 1
ERROR 1062: Duplicate entry '13' for key 1
ERROR 1062: Duplicate entry '14' for key 1
ERROR 1062: Duplicate entry '15' for key 1
ERROR 1062: Duplicate entry '16' for key 1
ERROR 1062: Duplicate entry '17' for key 1
ERROR 1062: Duplicate entry '18' for key 1
ERROR 1062: Duplicate entry '19' for key 1
ERROR 1062: Duplicate entry '20' for key 1
ERROR 1062: Duplicate entry '21' for key 1
ERROR 1062: Duplicate entry '22' for key 1
ERROR 1062: Duplicate entry '23' for key 1
ERROR 1062: Duplicate entry '24' for key 1
ERROR 1062: Duplicate entry '25' for key 1
ERROR 1062: Duplicate entry '26' for key 1
ERROR 1062: Duplicate entry '27' for key 1
ERROR 1062: Duplicate entry '28' for key 1
ERROR 1062: Duplicate entry '29' for key 1
ERROR 1062: Duplicate entry '30' for key 1
ERROR 1062: Duplicate entry '31' for key 1
ERROR 1062: Duplicate entry '32' for key 1
ERROR 1062: Duplicate entry '33' for key 1
ERROR 1062: Duplicate entry '34' for key 1
ERROR 1062: Duplicate entry '35' for key 1
ERROR 1062: Duplicate entry '36' for key 1
ERROR 1062: Duplicate entry '37' for key 1
ERROR 1062: Duplicate entry '38' for key 1
ERROR 1062: Duplicate entry '39' for key 1
ERROR 1062: Duplicate entry '40' for key 1
ERROR 1062: Duplicate entry '41' for key 1
ERROR 1062: Duplicate entry '42' for key 1
Query OK, 1 row affected (0.00 sec)

ERROR 1062: Duplicate entry '48' for key 1
ERROR 1062: Duplicate entry '49' for key 1
ERROR 1062: Duplicate entry '50' for key 1
ERROR 1062: Duplicate entry '51' for key 1
ERROR 1062: Duplicate entry '52' for key 1
ERROR 1062: Duplicate entry '53' for key 1
Query OK, 1 row affected (0.00 sec)

ERROR 1062: Duplicate entry '59' for key 1
Query OK, 1 row affected (0.00 sec)

ERROR 1062: Duplicate entry '0' for key 1
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

mysql>

[Muuss]

mysql -u root mysql

When you sourced tributes.sql, you created the tributes table into the mysql database, not in the eq database, that's why you get the error message saying tributes table doesn't exist.

log in with that command instead :

mysql -u root eq

ps : don't forget to drop the tributes table from your mysql database.

use mysql;
drop tributes;

[Lanfo]

Thank you:)

That little bit of info really helped allot....

[Muuss]

I m about to review some of the tutorials, there's a few errors of that kind that i d like to fix.

[Lanfo]

Thanks everyone, I got it running now with your help.

I still get commands.pl error though, anyone have any ideas about what could be causing that?


BTW:

the command I had to use in MySQL 4.0.22 was:

drop table tributes;

instead of just, "drop tributes;"

[Muuss]

yeah drop table, and not only drop... sorry:)

Do you have a commands.pl file in your server directory ?

[Lanfo]

I did not have the commands.pl file but I found a thread telling how to make one.

Said this is the only line of code I needed to have in it, I have not had a chance to try it out yet though. I will tonight.


sub commands_init {}