6.2 Server errors

32ones · #1 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

PHP Code:


			
[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

PHP Code:


			
[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 · #2 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 · #3 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

Quote:

* 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 about

Quote:

Reload them from the latest itemdb

??

tallerin · #4 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 · #5 09-18-2005, 04:28 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/sho...d.php?t=18707? I will back up my current one and try it.

32ones · #6 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 · #7 09-18-2005, 10:07 PM

Quote:

Originally Posted by 32ones

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/sho...d.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 · #8 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 · #9 09-19-2005, 03:35 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...

Dr Zauis · #10 09-19-2005, 04:43 AM

Quote:

Originally Posted by 32ones

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 · #11 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 · #12 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 · #13 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/showthr...et%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 · #14 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 · #15 09-20-2005, 07:26 AM

Quote:

Originally Posted by 32ones

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

do you ever get to the zone ?
is it just your server doing that can you connect to others ?