Page 1 of 1

Please Help

Posted: Sun Jul 31, 2011 8:20 am
by nevets
I know I must be overlooking something have you seen and resolved this? If so how?

[Status] Using database 'eq2' at 127.0.0.1
[Status] CURRENT_WORLD_VERSION:EQ2EMu 0.6.5 Developer Alpha
[Status] ./LoginServer.ini read.
[Status] Connecting to Update Server..
[Status] Connected to Update Server: updates.eq2emulator.net:9103
[Status] Checking for updates.
[Status] Server is already up-to-date.
[Status] Loading opcodes..
[Status] Loading structs..
[Status] Loading command list..
[Status] Loaded 527 entity command lists.
[Status] Loaded 3604 NPC(s).
[Status] Loaded 644 Object(s).
[Status] Loaded 153 GroundSpawn(s).
[Status] Loaded 356 Widget(s).
[Status] Loaded 581 Sign(s).
[Status] Loading ground spawn items..
[Status] Loading loot data..
[Status] Loaded 2 loot tables.
[Status] Loaded 2 loot drops.
[Status] Loaded 1673 spawn loot lists.
[Status] Loading Transporter Information..
[Status] Loaded 25 Teleporter(s)
[Status] Loaded global variables list..
[Status] Loaded visual states list..
[Status] Loading World Time..
[Status] Loading items.. (this might take a few minutes)
[Error] Error in LoadItemClasses query 'select item_id, class_id, tradeskill_cla
ss_id, level from item_classes order by item_id asc': #1146: Table 'eq2.item_cla
sses' doesn't exist
[Error] Error Loading Bag ID: 1
[Error] Error in LoadItemClasses query 'select item_id, class_id, tradeskill_cla
ss_id, level from item_classes order by item_id asc': #1146: Table 'eq2.item_cla
sses' doesn't exist
[Error] Error Loading Bag ID: 220000
[Error] Error in LoadItemClasses query 'select item_id, class_id, tradeskill_cla
ss_id, level from item_classes order by item_id asc': #1146: Table 'eq2.item_cla
sses' doesn't exist
[Error] Error Loading Bag ID: 220001
[Error] Error in LoadItemClasses query 'select item_id, class_id, tradeskill_cla
ss_id, level from item_classes order by item_id asc': #1146: Table 'eq2.item_cla
sses' doesn't exist
[Error] Error Loading Bag ID: 220002
[Error] Error in LoadItemClasses query 'select item_id, class_id, tradeskill_cla
ss_id, level from item_classes order by item_id asc': #1146: Table 'eq2.item_cla
sses' doesn't exist
[Error] Error Loading Bag ID: 220003
[Error] Error in LoadItemClasses query 'select item_id, class_id, tradeskill_cla
ss_id, level from item_classes order by item_id asc': #1146: Table 'eq2.item_cla
sses' doesn't exist
[Error] Error Loading Bag ID: 220004
[Error] Error in LoadItemClasses query 'select item_id, class_id, tradeskill_cla
ss_id, level from item_classes order by item_id asc': #1146: Table 'eq2.item_cla
sses' doesn't exist
[Error] Error Loading Bag ID: 220005
[Error] Error in LoadItemClasses query 'select item_id, class_id, tradeskill_cla
ss_id, level from item_classes order by item_id asc': #1146: Table 'eq2.item_cla
sses' doesn't exist
[Error] Error Loading Bag ID: 220006
[Error] Error in LoadItemClasses query 'select item_id, class_id, tradeskill_cla
ss_id, level from item_classes order by item_id asc': #1146: Table 'eq2.item_cla
sses' doesn't exist
[Error] Error Loading Bag ID: 220007
[Error] Error in LoadItemClasses query 'select item_id, class_id, tradeskill_cla
ss_id, level from item_classes order by item_id asc': #1146: Table 'eq2.item_cla
sses' doesn't exist
[Error] Error Loading Bag ID: 220008
[Error] Error in LoadItemClasses query 'select item_id, class_id, tradeskill_cla
ss_id, level from item_classes order by item_id asc': #1146: Table 'eq2.item_cla
sses' doesn't exist
[Error] Error Loading Bag ID: 220009
[Error] Error in LoadItemClasses query 'select item_id, class_id, tradeskill_cla
ss_id, level from item_classes order by item_id asc': #1146: Table 'eq2.item_cla
sses' doesn't exist
[Error] Error Loading Bag ID: 220010
[Error] Error in LoadItemClasses query 'select item_id, class_id, tradeskill_cla
ss_id, level from item_classes order by item_id asc': #1146: Table 'eq2.item_cla
sses' doesn't exist
[Error] Error Loading Bag ID: 220011
[Error] Error in LoadItemClasses query 'select item_id, class_id, tradeskill_cla
ss_id, level from item_classes order by item_id asc': #1146: Table 'eq2.item_cla
sses' doesn't exist
[Error] Error Loading Bag ID: 220012
[Error] Error in LoadItemClasses query 'select item_id, class_id, tradeskill_cla
ss_id, level from item_classes order by item_id asc': #1146: Table 'eq2.item_cla
sses' doesn't exist
[Error] Error Loading Bag ID: 220013
[Error] Error in LoadItemClasses query 'select item_id, class_id, tradeskill_cla
ss_id, level from item_classes order by item_id asc': #1146: Table 'eq2.item_cla
sses' doesn't exist
[Error] Error Loading Bag ID: 220014
[Error] Error in LoadItemClasses query 'select item_id, class_id, tradeskill_cla
ss_id, level from item_classes order by item_id asc': #1146: Table 'eq2.item_cla
sses' doesn't exist
[Error] Error Loading Bag ID: 220015
[Error] Error in LoadItemClasses query 'select item_id, class_id, tradeskill_cla
ss_id, level from item_classes order by item_id asc': #1146: Table 'eq2.item_cla
sses' doesn't exist
[Error] Error Loading Bag ID: 220016
[Error] Error in LoadItemClasses query 'select item_id, class_id, tradeskill_cla
ss_id, level from item_classes order by item_id asc': #1146: Table 'eq2.item_cla
sses' doesn't exist
[Error] Error Loading Bag ID: 220017
[Error] Error in LoadItemClasses query 'select item_id, class_id, tradeskill_cla
ss_id, level from item_classes order by item_id asc': #1146: Table 'eq2.item_cla
sses' doesn't exist
[Error] Error Loading Bag ID: 220018
[Error] Error in LoadItemClasses query 'select item_id, class_id, tradeskill_cla
ss_id, level from item_classes order by item_id asc': #1146: Table 'eq2.item_cla
sses' doesn't exist
[Error] Error Loading Bag ID: 220019
[Error] Error in LoadItemClasses query 'select item_id, class_id, tradeskill_cla
ss_id, level from item_classes order by item_id asc': #1146: Table 'eq2.item_cla
sses' doesn't exist

Thanks

Re: Please Help

Posted: Sun Jul 31, 2011 8:40 am
by Sylva1n
seems like your database is missing a table

Re: Please Help

Posted: Sun Jul 31, 2011 9:09 am
by nevets
umm I downloaded and imported using HeidiSQL - eq2db.sql

Re: Please Help

Posted: Sun Jul 31, 2011 9:54 am
by John Adams
What version of the emulator are you running? Certainly not the most current release (in the last 2 years) because items_classes has been gone for over 2 years. ServerPack 1.2 would not be looking for this table. Nor would the binaries from current public SVNs.

Re: Please Help

Posted: Sun Jul 31, 2011 10:29 am
by nevets
Thanks, I must have downloaded older stuff. I found serverpack 1.2 and it worked like a dream :D

Re: Please Help

Posted: Thu Aug 04, 2011 6:10 pm
by nevets
I have the server side running using 1.2
I have the ROK box set cant seem to get it connected to my server locally or any server on eq2emulator.
it there a tutorial for connecting ROK?

Re: Please Help

Posted: Thu Aug 04, 2011 7:24 pm
by Trahelion

Re: Please Help

Posted: Thu Aug 04, 2011 7:41 pm
by nevets
yes, I installed ROK patched using emupatcher changed the eq2defualt.ini to ls eq2emulator.net ran the everquest2 the program starts to load then crashes after i type in the user and account. I repeated the process for called ROK box version and repeated the process for 6118L.

I do have Vista if that makes any different but i did not see any threads saying that would be a problem.

Re: Please Help

Posted: Thu Aug 04, 2011 8:28 pm
by Trahelion
Did you try patching to
Client : 5122

Re: Please Help

Posted: Thu Aug 04, 2011 9:29 pm
by Sylva1n
nevets wrote:yes, I installed ROK patched using emupatcher changed the eq2defualt.ini to ls eq2emulator.net ran the everquest2 the program starts to load then crashes after i type in the user and account. I repeated the process for called ROK box version and repeated the process for 6118L.

I do have Vista if that makes any different but i did not see any threads saying that would be a problem.

I would assume that you cannot patch ROK to 6118L, 6118L is a Sentinel's Fate client.

The thing is, you need to patch to the closest version. Your everquest2 dir contains all the files from the ROK xpack. The .exe needs to be compatible with both your folder content AND your server.

hope I'm making sence here.

good luck