TL.sql question

Astartae · #1 05-25-2005, 05:00 AM

I am using 6.0 DR2 and my eqgame.exe is from 11/17/04 and running it on XP Home Ed. I had a working emu but recently lost mysql and had to reinstall it. Since then I've been trying to reinstall.

The database files I have sourced are:
PEQ_Kunark_RC1.sql
merchantlist_temp.sql
doors_update.sql
zonepoints.sql
tributes.sql
npc.sql (ALTER TABLE npc_types ADD npc_aggro TINYINT NOT NULL DEFAULT '0';)

I have also used quest_globals.sql and DBUpdate.sql but didn't source them this time. None of the databases I've put together so far have worked. I don't have tl.sql. How important is this file? Does anyone know what this database file contains and if it is really needed for a successfully running server? I've done a search on the forum for this file. There are exactly six posts referenced. Only one of those has a link to the file and that link is no longer working. Below are the problems I've been having.

EQemu problems:
1. EQ crashes when entering world for the first time (see 7)
2. PC and NPC skins are often vampire white instead of their correct color.
3. [Error] Error in LoadTributes level query 'SELECT id,name,descr FROM tributes':#1146: Table 'eq2.tribute_levels' doesn't exist (all errors are in world.exe)
4. [Error] Starting command queue Mapping... (no maps)
5. Logged in: FirstLogin Account #2: USERNAME_HERE (showed up in world.exe on char creation)
6. Received unknown opcode: 0x02eb size:0 bytes and zoneID is NULL in Client::Clearance!!
7. Received unknown opcode: 0x0376 size:0 bytes (client disconnects and eq crashes here)

If anyone can troubleshoot this for me and give me some clue to why I'm getting these errors, that would make my day! Thanks in advance, Astartae

PS - I'll post the world and zone outputs if you think it will help.

Astartae · #2 05-26-2005, 05:01 AM

Here is a picture of a partially white-skinned character:

I have been trying to post my world and zone outputs but the forum doesn't like the code so I guess I won't.

Astartae · #3 05-26-2005, 05:41 AM

This is what I'm getting on my world.exe:

Quote:

[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 day..
[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: 127.0.0.1:9000
World server listening on: 127.0.0.1:9000
Setting World to MiniLogin Server type
Connected to LoginServer: 127.0.0.1:5999
44955 New TCP connection: 127.0.0.1:1135
New zoneserver: #1 127.0.0.1:1135
Zoneserver SetConnectInfo: 127.0.0.1:1135: 127.0.0.1:7997
45756 New TCP connection: 127.0.0.1:1136
45756 New TCP connection: 127.0.0.1:1137
45756 New TCP connection: 127.0.0.1:1138
45756 New TCP connection: 127.0.0.1:1139
New zoneserver: #2 127.0.0.1:1139
New zoneserver: #3 127.0.0.1:1138
New zoneserver: #4 127.0.0.1:1137
New zoneserver: #5 127.0.0.1:1136
Zoneserver SetConnectInfo: 127.0.0.1:1136: 127.0.0.1:7998
Zoneserver SetConnectInfo: 127.0.0.1:1137: 127.0.0.1:7996
Zoneserver SetConnectInfo: 127.0.0.1:1138: 127.0.0.1:7995
Zoneserver SetConnectInfo: 127.0.0.1:1139: 127.0.0.1:7999
290688 New client from ip: 127.0.0.1 port: 1142
Logged in: FirstLogin Account #2: USERNAME_HERE
Received unknown opcode: 0x02eb size:0 bytes
Name approval request for:Neriaka race:6 class:9
Character creation request from (weird code here, deleted so I could post) (127.0.0.1:1142) :
Name: Neriaka
Race: 6 Class: 9 Gender: 1 Deity: 205 Start zone: 5
STR STA AGI DEX WIS INT CHA Total
60 65 110 105 83 99 60 582
Face: 3 Eye colors: 1 1
Hairstyle: 2 Haircolor: 255
Beard: 255 Beardcolor: 16
Validating char creation info...
Found 0 errors in character creation request
[Status] Start zone query: SELECT x,y,z,zone_id,bind_id FROM start_zones WHERE player_choice=5 AND player_class=9 AND player_deity=205 AND player_race=6
[Status] Found starting location in start_zones
Current location: NeriakC -1305.00, 634.00, -80.84
Bind location: NeriakC -1305.00, 634.00, -80.84
Starting Items Query: SELECT itemid, item_charges FROM starting_items WHERE (race = 6 or race = 0) AND (class = 9 or class = 0) AND (deityid = 205 or deityid=0) AND (zoneid = 42 or zoneid = 0) AND gm <= 250 ORDER BY id Character creation successful: Neriaka
Read group ID for 'Neriaka': 0
0: 2C 35 39 39 39 2C 2E 4E - 65 72 69 61 6B 61 2C 30 | ,5999,.Neriaka,0
16: 36 37 61 37 39 64 34 00 | 67a79d4.
Attempting autobootup of NeriakC (42) for Neriaka
Zoneserver SetZone: 127.0.0.1:7998 NeriakC (42)
Enter world: Neriaka: NeriakC (42)
Broadcasting a world time update
Zoneserver SetZone: 127.0.0.1:7998 NeriakC (42)
Received unknown opcode: 0x0376 size:0 bytes
Client disconnected
Removing client from ip:127.0.0.1 port:1142
Zoneserver SetZone: 127.0.0.1:7998 tutorialb (0)
Zoneserver SetZone: 127.0.0.1:7998 tutorialb (0)
1370621 New client from ip: 127.0.0.1 port: 1145
Logged in: FirstLogin Account #2: USERNAME_HERE
Received unknown opcode: 0x02eb size:0 bytes
Read group ID for 'Neriaka': 0
0: 2C 35 39 39 39 2C 2E 4E - 65 72 69 61 6B 61 2C 30 | ,5999,.Neriaka,0
16: 36 37 61 37 39 64 34 00 | 67a79d4.
Attempting autobootup of NeriakC (42) for Neriaka
Zoneserver SetZone: 127.0.0.1:7998 NeriakC (42)
Enter world: Neriaka: NeriakC (42)
Broadcasting a world time update
Zoneserver SetZone: 127.0.0.1:7998 NeriakC (42)
Received unknown opcode: 0x02eb size:0 bytes
zoneID is NULL in Client::Clearance!!
0: 2C 35 39 39 39 2C 2E 4E - 65 72 69 61 6B 61 2C 30 | ,5999,.Neriaka,0
16: 36 37 61 37 39 64 34 00 | 67a79d4.
Enter world: Neriaka: NeriakC (42)
Zoneserver SetZone: 127.0.0.1:7998 NeriakC (42)
Received unknown opcode: 0x0376 size:0 bytes
Client disconnected
Removing client from ip:127.0.0.1 port:1145
Zoneserver SetZone: 127.0.0.1:7998 tutorialb (0)
Zoneserver SetZone: 127.0.0.1:7998 tutorialb (0)

Astartae · #4 05-26-2005, 05:41 AM

Here's my zone.exe output:

Quote:

[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 guilds
[Status] Loading factions
[Status] Loading AA effects
[Status] Loading swarm spells
[Status] Loading tributes
[Error] Error in LoadTributes level query 'SELECT id,name,descr FROM tributes':
#1146: Table 'eq2.tribute_levels' 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...
[Error] Starting command queue Mapping...
[Quest] Loading perlemb plugins.
[Quest] Loading perl commands...
[Status] Entering sleep mode
Connected to worldserver: localhost:9000
Map ./Maps/neriakc.map not found.
[Status] Weather should change in 624 seconds
Init: Loading zone lists, zone state or spawn list, player corpses, traps
, timezone data - Done. ZoneID = 42; Time Offset = 0
Successfully loaded Zone Config.
[Status] Loading Objects from DB...
[Status] Loading Ground Spawns from DB...
[Status] Loading doors for neriakc ...
[Status] Done loading doors for neriakc ...
[Status] Loading AA information...
[Status] Loading Merchant Lists...
[Status] Loading Temporary Merchant Lists...
[Status] Zone Bootup: NeriakC (42)
Received Message SyncWorldTime
Time Broadcast Packet: EQTime [02:02 am]
[Status] 528921 New client from ip:127.0.0.1 port:1143
Read group ID for 'Neriaka': 0
Client linkdead: Neriaka
Dropping client: Process=false, ip=127.0.0.1, port=1143
[Status] Zone Shutdown: neriakc (42)
Map ./Maps/neriakc.map not found.
[Status] Weather should change in 6612 seconds
Init: Loading zone lists, zone state or spawn list, player corpses, traps
, timezone data - Done. ZoneID = 42; Time Offset = 0
Successfully loaded Zone Config.
[Status] Loading Objects from DB...
[Status] Loading Ground Spawns from DB...
[Status] Loading doors for neriakc ...
[Status] Done loading doors for neriakc ...
[Status] Loading AA information...
[Status] Loading Merchant Lists...
[Status] Loading Temporary Merchant Lists...
[Status] Zone Bootup: NeriakC (42)
Received Message SyncWorldTime
Time Broadcast Packet: EQTime [07:10 am]
[Status] 1494079 New client from ip:127.0.0.1 port:1146
Read group ID for 'Neriaka': 0
Client linkdead: Neriaka
Dropping client: Process=false, ip=127.0.0.1, port=1146
[Status] Zone Shutdown: neriakc (42)

And yes I did name the char Neriaka just in cast you where confused, lol.

Belfedia · #5 05-26-2005, 10:09 AM

The texture problem isn't an eqemu's bug
I think your client program (priority) / directx or Graphic drivers are corrupt :(

Astartae · #6 05-26-2005, 02:24 PM

Ok, I had a feeling my Nvidia might need reinstalling. It's been giving me some problems. Now if I can figure out why those opcodes are crashing my game, I'll have it down.

I did get in earlier today until the game crashed again. I think the video software was to blame that time though. Thanks for your help.

kouhei · #7 05-26-2005, 03:10 PM

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

You need to source in tribute_levels.sql.
You can get that on the cvs site.

Astartae · #8 05-26-2005, 05:05 PM

oops, double posted... ignore me...

Astartae · #9 05-26-2005, 05:05 PM

I didn't know that. Thanks. I saw that file in cvs but didn't know it was important. Thanks, going to download it and source it in!

It looks like I might have gotten a virus today too so off to update my AVG and do a scan...

Hopefully I'll have a working database soon!

---

Hmmm, I'm actually not finding it. Maybe I didn't see it after all. Could it have another name? I actually can't find anything with the word "tribute" in the CVS right now. Maybe they removed it.

kouhei · #10 05-26-2005, 06:03 PM

If I remember right I had to drop that table out of the db and re load that table in.use msql front and check to see if you already have that table in.

Astartae · #11 05-26-2005, 06:21 PM

Nope, it's missing. Do you know the code I need to make my own mini sql file for it? Although another failed db has it. Maybe I can transfer it to the other one in MySQL Front. Off to try that.