PDA

View Full Version : Getting error Received unknown opcode: 0x0376 size:0 bytes


ANUBUSEE
10-23-2004, 09:42 AM
i get this error everytime a person tryes connecting to my server and a zone.exe dissapeares i dont know whats wrong now this is one that im stumped on i checked everything in my files to the letter and found no problems here is the world .exe txt and btw i am running 5 zones after the first 5 went away i reclicked my boot5zones.bat to get 5 more.


[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.0-DR1
[Status] Loading variables..
[Status] Loading zones..
[Status] Clearing groups..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=45402, max id=69882
[Error] DBLoadItems query 'SELECT charges,unknown002,unknown003,merchantprice,un
known005,unknown006,unknown007,SpellCharges,itemcl ass,name,lore,idfile,id,weight
,norent,nodrop,attuneable,size,slots,cost,icon,unk nown018,unknown019,unknown020,
tradeskills,cr,dr,pr,mr,fr,astr,asta,aagi,adex,ach a,aint,awis,hp,mana,ac,deity,s
killmodvalue,skillmodtype,banedmgrace,banedmgamt,b anedmgbody,magic,casttime2,has
teproclvl,reqlevel,bardtype,bardvalue,light,delay, reclevel,recskill,elemdmgtype,
elemdmgamt,effecttype,range,damage,color,classes,r aces,unknown061,spellid,maxcha
rges,itemtype,material,sellrate,unknown067,casttim e,unknown069,proc_rate_mod,foc
usid,combateffects,shielding,stunresist,strikethro ugh,combatskill,combatskilldmg
,spellshield,avoidance,accuracy,unknown081,faction mod1,factionmod2,factionmod3,f
actionmod4,factionamt1,factionamt2,factionamt3,fac tionamt4,charmfile,augtype,aug
slot1type,augslot2type,augslot3type,augslot4type,a ugslot5type,ldonpointtheme,ldo
npointcost,ldonsold,bagtype,bagslots,bagsize,bagwr ,unknown105,booktype,filename,
banedmgamt2,augmentrestriction,loreflag,pendinglor eflag,artifactflag,summonedfla
g,tribute,gmflag,endur,dotshielding,attackbonus,hp regen,manaregen,hastepercent,d
amageshield,minstatus FROM items ORDER BY id', #1054: Unknown column 'SpellCharg
es' in 'field list'
[Error] If you got an error related to the 'SpellCharges' field, run the followi
ng SQL Query: ALTER TABLE `items` CHANGE `unknown008` `SpellCharges` INT(11)
FAULT "0" NOT NULL;
Error: EMuShareMem: DLLLoadItems: !cbDBLoadItems
[Error] Error: Could not load item data. But ignoring
[Status] ./LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading ./addon.ini..
[Status] Loading EQ time of day..
[Error] Could not load EQTime file ./eqtime.cfg
[Error] Unable to load ./eqtime.cfg
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Warning: You need to get laid...
TCP listening on: 65.96.247.148:9000
World server listening on: 65.96.247.148:9000
Connected to LoginServer: newlogin1.eqemulator.net:5994
330375 New TCP connection: 192.168.1.101:3122
330375 New TCP connection: 192.168.1.101:3123
330375 New TCP connection: 192.168.1.101:3124
330375 New TCP connection: 192.168.1.101:3125
330375 New TCP connection: 192.168.1.101:3126
New zoneserver: #1 192.168.1.101:3126
New zoneserver: #2 192.168.1.101:3125
New zoneserver: #3 192.168.1.101:3124
New zoneserver: #4 192.168.1.101:3123
New zoneserver: #5 192.168.1.101:3122
Zoneserver SetConnectInfo: 192.168.1.101:3122: 65.96.247.148:7999
Zoneserver SetConnectInfo: 192.168.1.101:3123: 65.96.247.148:7997
Zoneserver SetConnectInfo: 192.168.1.101:3124: 65.96.247.148:7996
Zoneserver SetConnectInfo: 192.168.1.101:3125: 65.96.247.148:7998
Zoneserver SetConnectInfo: 192.168.1.101:3126: 65.96.247.148:7995
572156 New client from ip: 65.30.130.136 port: 33787
Logged in: FirstLogin LS#61063: Capedmoose
Logged in: FirstLogin LS#61063: Capedmoose
Logged in: FirstLogin LS#61063: Capedmoose
Logged in: FirstLogin LS#61063: Capedmoose
603750 New client from ip: 24.176.90.88 port: 1207
Account Attempting to be created:Nitesmoke5 0
Logged in: FirstLogin LS#62901: Nitesmoke5
Logged in: FirstLogin LS#62901: Nitesmoke5
Received unknown opcode: 0x02eb size:0 bytes
Name approval request for:Storm race:11 class:6
Character creation request from Nitesmoke5 LS#62901 (24.176.90.88:1207) :
Name: Storm
Race: 11 Class: 6 Gender: 0 Deity: 207 Start zone: 3
STR STA AGI DEX WIS INT CHA Total
70 90 95 90 115 67 50 577
Face: 1 Eye colors: 0 0
Hairstyle: 0 Haircolor: 0
Beard: 0 Beardcolor: 0
Validating char creation info...
Found 0 errors in character creation request
Found 'startzone' variable setting: poknowledge
Current location: poknowledge 0.00, 0.00, 0.00
Bind location: poknowledge 0.00, 0.00, 0.00
Starting Items Query: SELECT itemid, item_charges FROM starting_items WHERE (rac
e = 11 or race = 0) AND (class = 6 or class = 0) AND (deityid = 207 or deityid=0
) AND (zoneid = 202 or zoneid = 0) AND gm <= 0 ORDER BY id
Character creation successful: Storm
Read group ID for 'Storm': 0
0: 2C 30 2C 2E 53 74 6F 72 - 6D 2C 30 36 37 61 37 39 | ,0,.Storm,067a79
16: 64 34 00 | d4.
Attempting autobootup of poknowledge (202) for Storm
Zoneserver SetZone: 65.96.247.148:7999 poknowledge (202)
Enter world: Storm: poknowledge (202)
Broadcasting a world time update
192.168.1.101:3122: TCPConnection::RecvData(): Error: 10054
Removing zoneserver from ip:0.0.0.0 port:0 (65.96.247.148:7999)
Received unknown opcode: 0x02eb size:0 bytes
Received unknown opcode: 0x02eb size:0 bytes
0: 2C 30 2C 2E 53 74 6F 72 - 6D 2C 30 36 37 61 37 39 | ,0,.Storm,067a79
16: 64 34 00 | d4.
Attempting autobootup of poknowledge (202) for Storm
Read group ID for 'Daven': 0
0: 2C 30 2C 2E 44 61 76 65 - 6E 2C 30 36 37 61 37 39 | ,0,.Daven,067a79
16: 64 34 00 | d4.
Attempting autobootup of nexus (152) for Daven
Zoneserver SetZone: 65.96.247.148:7997 poknowledge (202)
Enter world: Storm: poknowledge (202)
Zoneserver SetZone: 65.96.247.148:7997 poknowledge (202)
192.168.1.101:3123: TCPConnection::RecvData(): Error: 10054
Removing zoneserver from ip:0.0.0.0 port:0 (65.96.247.148:7997)
Received unknown opcode: 0x0376 size:0 bytes
Zoneserver SetZone: 65.96.247.148:7996 nexus (152)
Enter world: Daven: nexus (152)
Zoneserver SetZone: 65.96.247.148:7996 nexus (152)
192.168.1.101:3124: TCPConnection::RecvData(): Error: 10054
Removing zoneserver from ip:0.0.0.0 port:0 (65.96.247.148:7996)
Received unknown opcode: 0x0376 size:0 bytes
Client disconnected
Removing client from ip:24.176.90.88 port:1207
Client disconnected
Removing client from ip:65.30.130.136 port:33787
966266 New client from ip: 24.176.90.88 port: 1218
Logged in: FirstLogin LS#62901: Nitesmoke5
Received unknown opcode: 0x02eb size:0 bytes
1080516 New client from ip: 24.21.162.142 port: 19256
Logged in: FirstLogin LS#62800: chrisroake
Read group ID for 'Storm': 0
0: 2C 30 2C 2E 53 74 6F 72 - 6D 2C 30 36 37 61 37 39 | ,0,.Storm,067a79
16: 64 34 00 | d4.
Attempting autobootup of poknowledge (202) for Storm
Zoneserver SetZone: 65.96.247.148:7998 poknowledge (202)
Enter world: Storm: poknowledge (202)
Zoneserver SetZone: 65.96.247.148:7998 poknowledge (202)
Received unknown opcode: 0x0376 size:0 bytes
192.168.1.101:3125: TCPConnection::RecvData(): Error: 10054
Removing zoneserver from ip:0.0.0.0 port:0 (65.96.247.148:7998)
Client disconnected
Removing client from ip:24.176.90.88 port:1218
Received unknown opcode: 0x02eb size:0 bytes
Name approval request for:Mario race:10 class:10
Character creation request from chrisroake LS#62800 (24.21.162.142:19256) :
Name: Mario
Race: 10 Class: 10 Gender: 0 Deity: 211 Start zone: 7
STR STA AGI DEX WIS INT CHA Total
130 132 70 70 102 60 42 606
Face: 7 Eye colors: 3 3
Hairstyle: 255 Haircolor: 255
Beard: 255 Beardcolor: 255
Validating char creation info...
Found 0 errors in character creation request
Found 'startzone' variable setting: poknowledge
Current location: poknowledge 0.00, 0.00, 0.00
Bind location: poknowledge 0.00, 0.00, 0.00
Starting Items Query: SELECT itemid, item_charges FROM starting_items WHERE (rac
e = 10 or race = 0) AND (class = 10 or class = 0) AND (deityid = 211 or deityid=
0) AND (zoneid = 202 or zoneid = 0) AND gm <= 0 ORDER BY id
Character creation successful: Mario
Read group ID for 'Mario': 0
0: 2C 30 2C 2E 4D 61 72 69 - 6F 2C 30 36 37 61 37 39 | ,0,.Mario,067a79
16: 64 34 00 | d4.
Attempting autobootup of poknowledge (202) for Mario
Zoneserver SetZone: 65.96.247.148:7995 poknowledge (202)
Enter world: Mario: poknowledge (202)
Zoneserver SetZone: 65.96.247.148:7995 poknowledge (202)
192.168.1.101:3126: TCPConnection::RecvData(): Error: 10054
Removing zoneserver from ip:0.0.0.0 port:0 (65.96.247.148:7995)
Client disconnected
Removing client from ip:24.21.162.142 port:19256
1461906 New TCP connection: 192.168.1.101:3247
New zoneserver: #6 192.168.1.101:3247
Zoneserver SetConnectInfo: 192.168.1.101:3247: 65.96.247.148:7999
1462531 New TCP connection: 192.168.1.101:3249
New zoneserver: #7 192.168.1.101:3249
1462563 New TCP connection: 192.168.1.101:3250
1462563 New TCP connection: 192.168.1.101:3251
1462563 New TCP connection: 192.168.1.101:3252
New zoneserver: #8 192.168.1.101:3252
New zoneserver: #9 192.168.1.101:3251
New zoneserver: #10 192.168.1.101:3250
Zoneserver SetConnectInfo: 192.168.1.101:3249: 65.96.247.148:7997
Zoneserver SetConnectInfo: 192.168.1.101:3250: 65.96.247.148:7998
Zoneserver SetConnectInfo: 192.168.1.101:3251: 65.96.247.148:7995
Zoneserver SetConnectInfo: 192.168.1.101:3252: 65.96.247.148:7996
2952031 New client from ip: 65.30.130.136 port: 34079
Logged in: FirstLogin LS#61063: Capedmoose
Received unknown opcode: 0x02eb size:0 bytes
Delete character: Daven
DeleteCharacter: successfully deleted 'Daven' (id 2)
Name approval request for:Daven race:4 class:4
Character creation request from Capedmoose LS#61063 (65.30.130.136:34079) :
Name: Daven
Race: 4 Class: 4 Gender: 0 Deity: 215 Start zone: 9
STR STA AGI DEX WIS INT CHA Total
70 95 105 80 85 75 75 585
Face: 7 Eye colors: 6 6
Hairstyle: 1 Haircolor: 255
Beard: 255 Beardcolor: 18
Validating char creation info...
Found 0 errors in character creation request
Found 'startzone' variable setting: poknowledge
Current location: poknowledge 0.00, 0.00, 0.00
Bind location: poknowledge 0.00, 0.00, 0.00
Starting Items Query: SELECT itemid, item_charges FROM starting_items WHERE (rac
e = 4 or race = 0) AND (class = 4 or class = 0) AND (deityid = 215 or deityid=0)
AND (zoneid = 202 or zoneid = 0) AND gm <= 0 ORDER BY id
Character creation successful: Daven
Read group ID for 'Daven': 0
0: 2C 30 2C 2E 44 61 76 65 - 6E 2C 30 36 37 61 37 39 | ,0,.Daven,067a79
16: 64 34 00 | d4.
Attempting autobootup of poknowledge (202) for Daven
Zoneserver SetZone: 65.96.247.148:7998 poknowledge (202)
Enter world: Daven: poknowledge (202)
Zoneserver SetZone: 65.96.247.148:7998 poknowledge (202)
192.168.1.101:3250: TCPConnection::RecvData(): Error: 10054
Removing zoneserver from ip:0.0.0.0 port:0 (xx.xx.xx.xxx:7998)
Client disconnected
Removing client from ip:xx.xx.xx.xxx port:34079
3786531 New client from ip: xx.xx.xx.xxx port: 1085
Account Attempting to be created:l33tpwnr 0
Logged in: FirstLogin LS#56243: l33tpwnr
Received unknown opcode: 0x02eb size:0 bytes
Name approval request for:Everquest race:4 class:6
Character creation request from l33tpwnr LS#56243 (4.15.186.247:1085) :
Name: Everquest
Race: 4 Class: 6 Gender: 0 Deity: 215 Start zone: 9
STR STA AGI DEX WIS INT CHA Total
65 80 95 80 115 75 75 585
Face: 6 Eye colors: 8 8
Hairstyle: 0 Haircolor: 255
Beard: 255 Beardcolor: 3
Validating char creation info...
Found 0 errors in character creation request
Found 'startzone' variable setting: poknowledge
Current location: poknowledge 0.00, 0.00, 0.00
Bind location: poknowledge 0.00, 0.00, 0.00
Starting Items Query: SELECT itemid, item_charges FROM starting_items WHERE (rac
e = 4 or race = 0) AND (class = 6 or class = 0) AND (deityid = 215 or deityid=0)
AND (zoneid = 202 or zoneid = 0) AND gm <= 0 ORDER BY id
Character creation successful: Everquest
Read group ID for 'Everquest': 0
0: 2C 30 2C 2E 45 76 65 72 - 71 75 65 73 74 2C 30 36 | ,0,.Everquest,06
16: 37 61 37 39 64 34 00 | 7a79d4.
Attempting autobootup of poknowledge (202) for Everquest
Zoneserver SetZone: 65.96.247.148:7995 poknowledge (202)
Enter world: Everquest: poknowledge (202)
Zoneserver SetZone: xx.xx.xx.xx:7995 poknowledge (202)
192.168.1.101:3251: TCPConnection::RecvData(): Error: 10054
Removing zoneserver from ip:0.0.0.0 port:0 (65.96.247.148:7995)
Client disconnected
Removing client from ip xx.xx.xx.xxx port:1085
4452594 New client from ip: xx.xx.xx.xxx port: 3195
Account Attempting to be created:Kosumi 0
Logged in: FirstLogin LS#8011: Kosumi
Received unknown opcode: 0x02eb size:0 bytes
Name approval request for:Ledias race:5 class:14
Character creation request from Kosumi LS#8011 (172.170.221.66:3195) :
Name: Ledias
Race: 5 Class: 14 Gender: 1 Deity: 215 Start zone: 10
STR STA AGI DEX WIS INT CHA Total
55 65 85 70 95 119 103 592
Face: 0 Eye colors: 0 0
Hairstyle: 0 Haircolor: 0
Beard: 0 Beardcolor: 0
Validating char creation info...
Found 0 errors in character creation request
Found 'startzone' variable setting: poknowledge
Current location: poknowledge 0.00, 0.00, 0.00
Bind location: poknowledge 0.00, 0.00, 0.00
Starting Items Query: SELECT itemid, item_charges FROM starting_items WHERE (rac
e = 5 or race = 0) AND (class = 14 or class = 0) AND (deityid = 215 or deityid=0
) AND (zoneid = 202 or zoneid = 0) AND gm <= 0 ORDER BY id
Character creation successful: Ledias
Read group ID for 'Ledias': 0
0: 2C 30 2C 2E 4C 65 64 69 - 61 73 2C 30 36 37 61 37 | ,0,.Ledias,067a7
16: 39 64 34 00 | 9d4.
Attempting autobootup of poknowledge (202) for Ledias
Zoneserver SetZone: xx.xx.xx.xxx:7996 poknowledge (202)
Enter world: Ledias: poknowledge (202)
Zoneserver SetZone: xx.xx.xx.xxx:7996 poknowledge (202)
192.168.1.101:3252: TCPConnection::RecvData(): Error: 10054
Removing zoneserver from ip:0.0.0.0 port:0 (65.96.247.148:7996)
Received unknown opcode: 0x0376 size:0 bytes
Client disconnected
Removing client from ip:xxx.xx.xx.xx port:3195



is it the spell error causeing it to get rid of the zone's.exe?
i dont think that is the problem but if it is i need to find out how to fix it lol

Cans
10-23-2004, 09:47 AM
You PMed me before, but now I know why.

You are using the wrong IP address in the wrong space in your boot5zones.bat file.

Go to www.whatismyip.com, look at the big number, and write it down. Let's say you go there and the number is 68.67.66.65 .. Your boot5zones should look like this:

REM: ****Read this first!!!****

REM: This file requires your real IP in the place of "YourIP" when you are connecting
REM: To the EQEmu Loginserver.

REM: When you are using minilogin, Replace all IP Addresses to say 127.0.0.1

REM: If you still get errors try using 127.0.0.1 instead of localhost
REM:--------------Start-----------------------
@echo off

if NOT exist spells_us.txt goto NOSPELL

start zone . 68.67.66.65 7995 127.0.0.1
start zone . 68.67.66.65 7996 127.0.0.1
start zone . 68.67.66.65 7997 127.0.0.1
start zone . 68.67.66.65 7998 127.0.0.1
start zone . 68.67.66.65 7999 127.0.0.1
start zone . 68.67.66.65 8000 127.0.0.1
exit
cls

:NOSPELL
echo You did not copy the spells_en.txt from your everquest directory to this one. Please do so or zones will crash on startup.
PAUSE

REM:---------------END------------------------

You can exchange 127.0.0.1 with localhost, and also be sure to replace 68.67.66.65 with the IP address on whatismyip.com.

Also, be sure to forward the ports of 7995 - 8000 (more if you want more zones) so the people can connect.

This should fix the problem.

Cans
10-23-2004, 09:49 AM
Also, to fix that big items error thing run this in a MySQL query:

ALTER TABLE `items` CHANGE `unknown008` `SpellCharges` INT(11) DEFAULT "0" NOT NULL;

That will remove the error.

ANUBUSEE
10-23-2004, 09:58 AM
what is the exact code to get to where you type that to fix that error is it mysql~root eq?

Cans
10-23-2004, 10:07 AM
Get to your mysql directory in a command prompt.

I type in

mysql -u root mysql

Then,

grant all privileges on *.* to username@localhost idenitified by 'password' with grant option;

Replace username and password with your user/pass for MySQL.

From there, type in "use <database>;"

Replace <database> with the name of your database.

Then type in the query posted above. I use an older version of MySQL and am not sure if the 'mysql -u root mysql' will work anymore. If not, browse around for how you would do it.

ANUBUSEE
10-23-2004, 10:07 AM
n/m i got that error fixed lets see if the zone.exe error is fixed knowing the help you provided me before it will be fixed =P ty