6.2 Server errors
 

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

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.

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
on the same thread so it looks like I am taking option B

How would I go about ??

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

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.

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.

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.

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!

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.

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.

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.

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?

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 ?