6.2 Server errors [Archive] - EQEmulator Forums

32ones

09-17-2005, 04:01 PM

I used tallerin's guide (http://www.eqemulator.net/wiki/wikka.php?wakka=Windows6) and I got a few errors here =(

I posted it in his thread, but I think I am not allowed to so I will repost here and hopefully a mod will delete my old one.. or let it rot.

World.exe
[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.2-DR1
[Status] Loading opcodes..
[Status] EMuShareMem loaded
Opcode OP_Command is missing from ./opcodes.conf
Opcode OP_MailboxHeader is missing from ./opcodes.conf
Opcode OP_MailHeader is missing from ./opcodes.conf
Opcode OP_MailBody is missing from ./opcodes.conf
Opcode OP_NewMail is missing from ./opcodes.conf
Opcode OP_SentConfirm is missing from ./opcodes.conf
Opcode OP_RAWSessionRequest is missing from ./opcodes.conf
Opcode OP_RAWSessionResponse is missing from ./opcodes.conf
Opcode OP_RAWCombined is missing from ./opcodes.conf
Opcode OP_RAWSessionDisconnect is missing from ./opcodes.conf
Opcode OP_RAWKeepAlive is missing from ./opcodes.conf
Opcode OP_RAWSessionStatRequest is missing from ./opcodes.conf
Opcode OP_RAWSessionStatResponse is missing from ./opcodes.conf
Opcode OP_RAWPacket is missing from ./opcodes.conf
Opcode OP_RAWFragment is missing from ./opcodes.conf
Opcode OP_RAWOutOfOrderAck is missing from ./opcodes.conf
Opcode OP_RAWAck is missing from ./opcodes.conf
Opcode OP_RAWAppCombined is missing from ./opcodes.conf
Opcode OP_RAWOutOfSession is missing from ./opcodes.conf
00346640
[Status] Loading variables..
[Status] Loading zones..
[Status] Clearing groups..
[Status] Loading items..
[Status] EMuShareMem loaded
Error in GetItemsCount query 'SELECT MAX(id),count(*),sum(length(serialization)+
1) FROM items' #1054: Unknown column 'serialization' in 'field list'
Error: Database::LoadItems() (sharemem): GetItemsCount() returned -1
[Error] Error: Could not load item data. But ignoring
[Status] ./LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading guild link..
[Status] EMuShareMem loaded
[Status] Loading GuildList from database...
[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: localhost:9000
World server listening on: localhost:9000
Setting World to MiniLogin Server type
Connected to LoginServer: localhost:5999
96559 New TCP connection: 127.0.0.1:16777343
New zoneserver: #1 127.0.0.1:2829
Zoneserver SetConnectInfo: 127.0.0.1:2829: localhost:8782
96759 New TCP connection: 127.0.0.1:16777343
96759 New TCP connection: 127.0.0.1:16777343
New zoneserver: #2 127.0.0.1:2830
96799 New TCP connection: 127.0.0.1:16777343
96799 New TCP connection: 127.0.0.1:16777343
New zoneserver: #3 127.0.0.1:2833
New zoneserver: #4 127.0.0.1:2832
New zoneserver: #5 127.0.0.1:2831
Zoneserver SetConnectInfo: 127.0.0.1:2831: localhost:8780
Zoneserver SetConnectInfo: 127.0.0.1:2832: localhost:8781
Zoneserver SetConnectInfo: 127.0.0.1:2833: localhost:8783
Zoneserver SetConnectInfo: 127.0.0.1:2830: localhost:8784

I think when I put in the minilogin opcodes with the eqemu opcodes something wrong went down... About the other error.. My only guess is something is missing from my DB.

Boot5zones.exe

[Status] CURRENT_ZONE_VERSION: EQEMu 0.6.2-DR1
[Status] Loading opcodes..
[Status] Mapping Opcodes
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
Error in GetItemsCount query 'SELECT MAX(id),count(*),sum(length(serialization)+
1) FROM items' #1054: Unknown column 'serialization' in 'field list'
Error: Database::LoadItems() (sharemem): GetItemsCount() returned -1
[Error] Loading items FAILED!
Failed. But ignoring error and going on...
[Status] Loading npcs
[Status] Loading npc faction lists
[Status] EMuShareMem loaded
[Status] Loading NPC Faction Lists from database...
[Status] Loading loot tables
[Status] Loading Loot tables from database...
[Status] Loading doors
[Status] EMuShareMem loaded
[Status] Loading Doors from database...
[Status] EMuShareMem loaded
[Status] Loading guilds
[Status] Loading guild list
[Status] EMuShareMem loaded
[Status] Loading factions
[Status] Loading titles
[Status] Loading AA effects
[Status] Loading swarm spells
[Status] Loading tributes
[Error] Error in LoadTributes first query 'SELECT id,name,descr,unknown,isguild
FROM tributes': #1054: Unknown column 'isguild' in 'field list'
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] 179 commands loaded
[Status] Starting EQ Network server.
[Status] Entering sleep mode
Connected to worldserver: localhost:9000

tallerin

09-17-2005, 07:44 PM

from looking at the error's i would have to guess that your not useing Velious Release Candidate 1 from PEQ. your item error can be fixed by following what is posted here http://www.eqemulator.net/forums/showthread.php?t=18990 #4 is what you would need to. not needed to be done using RC1.

so you will need to install perl to do either of option A. or B.

for the missing opcodes can find fix here not really needed but if you don't want to see them as missing in world you can do this http://www.eqemulator.net/forums/showthread.php?t=19336 Read post #7

also not to sound rude http://www.eqemulator.net/forums/search.php? can be your friend.

32ones

09-17-2005, 09:35 PM

Thanks! I did find the opcodes fix using search but I couldnt find anything about the other error. Just one question... How do I Re-serialize something? lol I got the serialize_items.pl file from thre CVS, but what do I do with it?

**EDIT**

N/M I just found
* It has been reported that serialize_items.pl doesn't work right, I'll be looking at it tonight to see why. So, either take option b or sit tight. on the same thread so it looks like I am taking option B

How would I go aboutReload them from the latest itemdb ??

tallerin

09-18-2005, 03:24 AM

either option require you to install perl and other components.
can go here http://www.eqemulator.net/forums/showthread.php?t=18707 and follow steps 18-23 allso all the links needed for perl and others are there to.

edit also if you get errors when trying to load the itemdb in through perl you will have to change the tables in your db

32ones

09-18-2005, 04:28 PM

32ones

09-18-2005, 09:35 PM

I went ahead and screwed with it.

alter table items change merchantprice price;
(Changed the colum merchantprice to price)

now I get this error for a couple minutes.

DBD::mysql::db do failed: Unknown column 'UNK012' in 'field list' at load_13thfl
oor_items.pl line 37, <STDIN> line 49019.

any ideas? Lol.

Dr Zauis

09-18-2005, 10:07 PM

Great! You are awesome! I hope it works.

**edit**
I know this sounds really stupid, but I did get errors and what tables do I have to edit?

**edit again**
is it bad if I drop the database from your tutorial and use the one from http://www.eqemulator.net/forums/showthread.php?t=18707? I will back up my current one and try it.

You cant use that DataBase..What I would do is scrap what you are doing and DL the RC 1 Candidate..Get to your DOS box. And source from there.
You will have a 6.2 compatible database.

32ones

09-19-2005, 03:15 AM

Alright, I will do that. Source RC (I know what that means now) 1 and report back... I got about 40 minutes before I gotta go to school.

I will
source load_system.sql; source load_empty_users.sql;
then
INSERT INTO variables VALUES ('ZSPassword', '12345', 'Zone Server Password', '2005-06-02 21:32:56');
then
perl load_13thfloor_items.pl -d eq -u [user] -p [password] <items.txt

wish me luck and thanks for all the help!

32ones

09-19-2005, 03:35 AM

Dr Zauis

09-19-2005, 04:43 AM

unfortunately another error.. =(

DBD::mysql::db do failed: Unknown column 'augslot1unk' in 'field list' at load_1
3thfloor_items.pl line 37, <STDIN> line 9103.

Although I think I know whats wrong...

You dont need the items..Just source the 2 things in the DL. You are doing too much then. Like overwriting the items with the 13th floor stuff.

tallerin

09-19-2005, 05:19 AM

if you follow the tut i put up you would not have an issue. I didn't include the adding the 13th floor items in my tut cause it does not need to be done to get a working server. if this is your first time setting up a server get a working server first. then if you want to add the 13th floor items you can add them later.

32ones

09-19-2005, 11:13 AM

When I follow your tut exactly I get that error

Error in GetItemsCount query 'SELECT MAX(id),count(*),sum(length(serialization)+
1) FROM items' #1054: Unknown column 'serialization' in 'field list'
Error: Database::LoadItems() (sharemem): GetItemsCount() returned -1
[Error] Error: Could not load item data. But ignoring

which is why I am trying to get the 13thfloor items in.

**edit**
alright, I am redoing the RC 1 database and I will try again... I think I screwed up here the first time. One the one hand I hope I did so it works, but on the other I hope it did'nt so i dont look like an idiot... If I dont already =(

***EDIT***
I got some bad news... Turns out I was sourcing the wrong DB. I am an idiot =(. I apologize for wasting your time. =(

On a ligher note. HUZZUH!! it works.. Now to boot up EQ.

32ones

09-19-2005, 11:47 AM

Boo another error..

Minilogin.exe
Unknown packet: .4233692 [92.153.64.0:15->0.0.0.0:0]
[OpCode 0x0003 (OP_Unknown) Size=11]
00000: 00 06 00 00 00 00 00 00 - 00 00 00 | ...........
Fixed thanks to search =)
http://eqemulator.net/forums/showthread.php?t=19342&highlight=Unknown+packet%3A+.4233692

World.exe
103619 New client from ip: 127.0.0.1 port: 1764
ERROR! ID is 0!!!
Is this server connected to minilogin?
If so you forget the minilogin variable...
Removing client from ip:127.0.0.1 port:1764

Any ideas?

32ones

09-19-2005, 04:55 PM

Yea, so when I boot up EQ, I type in my username and PW, log in to server select, connect to the server and it goes black. It then boots me to the login screen after a few seconds (it doesnt say anything) and when I exit EQ it displays thoses errors even after I fixed opcodes...

sdabbs65

09-20-2005, 07:26 AM

sdabbs65

09-20-2005, 07:28 AM

Error in GetItemsCount query 'SELECT MAX(id),count(*),sum(length(serialization)+
1) FROM items' #1054: Unknown column 'serialization' in 'field list'
Error: Database::LoadItems() (sharemem): GetItemsCount() returned -1

Download the PEQ database it will fix your items issue.

32ones

09-20-2005, 11:56 AM

I am using the the PEQ database....

http://www.projecteq.net/getfiles.php

the second from the top, Velious Release Candidate 1.

tallerin

09-20-2005, 12:22 PM

World.exe
103619 New client from ip: 127.0.0.1 port: 1764
ERROR! ID is 0!!!
Is this server connected to minilogin?
If so you forget the minilogin variable...
Removing client from ip:127.0.0.1 port:1764

make sure you sourced in and altered the tables needed to make your server work with minilogin.

32ones

09-20-2005, 02:38 PM

Ill go back and redo the altering =D

**edit**

I think I see a DB editing part I missed.. Lol

I still get the same error.. I think... Would being behind a router be the problem?

WOOT!!! I had to insert another account and it worked!!! Huzzuh!! Thanks for your help! Lol. If I have 2 computers on a network, both with EQ can I play on the same server with minilogin, or will I need to use the eqemu login server?