|
|
 |
 |
 |
 |
|
 |
 |
|
 |
 |
|
 |
|
Archive::Windows Servers Archive area for Windows Servers's posts that were moved here after an inactivity period of 90 days. |
 |
|
 |

11-08-2003, 09:54 PM
|
Sarnak
|
|
Join Date: Mar 2003
Location: Flers (en normandie)
Posts: 56
|
|
Error: 10060
hi, I've a problem when i launch my 'Boot5zones.bat.
Code:
[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.0
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading items from database: count=0, max id=0
[Error] DBLoadItems query 'SELECT gmflag,minstatus,unknown002,unknown005,unknown
107,unknown108,id,weight,norent,nodrop,size,itemclass,idfile,lore,slots,cost,nam
e,icon,unknown105,booktype,filename,bagtype,bagslots,bagsize,bagwr,augslot1type,
augslot2type,augslot3type,augslot4type,augslot5type,unknown018,unknown019,unknow
n020,casttime2,unknown061,unknown067,unknown069,unknown070,unknown076,unknown077
,augtype,unknown097,unknown098,unknown099,astr,asta,aagi,adex,awis,aint,acha,pr,
mr,dr,fr,cr,skillmodvalue,skillmodtype,banedmgamt,banedmgbody,banedmgrace,magic,
hasteproclvl,light,delay,effecttype,range,damage,material,maxcharges,reclevel,re
cskill,charmfile,factionmod1,factionmod2,factionmod3,factionmod4,factionamt1,fac
tionamt2,factionamt3,factionamt4,reqlevel,hp,mana,ac,color,classes,races,spellid
,casttime,focusid,itemtype,accuracy,avoidance,bardtype,bardvalue,combateffects,d
eity,elemdmgamt,elemdmgtype,sellrate,shielding,spellshield,strikethrough,stunres
ist,tradeskills FROM items ORDER BY id', #1054: Unknown column 'casttime2' in 'f
ield list'
Error: EMuShareMem: DLLLoadItems: !cbDBLoadItems
[Error] Loading items FAILED!
Failed. But ignoring error and going on...
[Status] Loading npcs
[Status] Loading NPCTypes from database...
[Status] Loading npc faction lists
[Status] Loading NPC Faction Lists from database...
[Status] Loading loot tables
[Status] Loading Loot tables from database...
[Status] Loading doors
[Status] Loading Doors from database...
[Status] FileLoadSPDat() Loading spells from spells_us.txt
[Status] FileLoadSPDat() spells loaded: 4340
[Status] Loading guilds
[Status] Loading factions
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] 148 commands loaded
WorldServer connect: Connecting to the server failed: TCPConnection::Connect():
connect() failed. Error: 10060
[Error] worldserver.Connect() FAILED!
[Status] Entering sleep mode
only one zone work on five !
|
 |
|
 |

11-09-2003, 01:34 AM
|
Hill Giant
|
|
Join Date: Apr 2003
Posts: 225
|
|
DL and source the latest Dumpeditems.sql from sourceforge. looks like you might have an incorrect table...
Kgaul
|

11-09-2003, 05:18 AM
|
Sarnak
|
|
Join Date: Mar 2003
Location: Flers (en normandie)
Posts: 56
|
|
when I have put the new db i had a new error :
[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.0
[Status] Loading Variables
Error in LoadVariables query 'SELECT varname, value, unix_timestamp() FROM varia
bles where unix_timestamp(ts) >= 0' #1146: Table 'eq.variables' doesn't exist
[Status] Loading zone names
Error in LoadZoneNames query 'SELECT MAX(zoneidnumber) FROM zone' #1146: Table '
eq.zone' doesn't exist
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading items from database: count=25742, max id=68034
 :  :
|
 |
|
 |

11-10-2003, 12:33 PM
|
Hill Giant
|
|
Join Date: Feb 2002
Posts: 206
|
|
this should clear up the issue from the Items table as i got the same error upgrading today.
make a txt file or sql file and put this in it, then run it.
Code:
--
-- v.0.5.0
--
--
-- Table structure for table 'items'
--
CREATE TABLE items (
id int(11) NOT NULL default '0',
minstatus smallint(5) NOT NULL default '0',
name varchar(64) default NULL,
aagi int(11) default NULL,
ac int(11) default NULL,
accuracy int(11) default NULL,
acha int(11) default NULL,
adex int(11) default NULL,
aint int(11) default NULL,
asta int(11) default NULL,
astr int(11) default NULL,
augtype tinyint(3) default NULL,
augslot1type tinyint(3) default NULL,
augslot2type tinyint(3) default NULL,
augslot3type tinyint(3) default NULL,
augslot4type tinyint(3) default NULL,
augslot5type tinyint(3) default NULL,
avoidance int(11) default NULL,
awis int(11) default NULL,
bagsize int(11) default NULL,
bagslots int(11) default NULL,
bagtype int(11) default NULL,
bagwr int(11) default NULL,
banedmgamt int(11) default NULL,
banedmgbody int(11) default NULL,
banedmgrace int(11) default NULL,
bardtype int(11) default NULL,
bardvalue int(11) default NULL,
booktype int(11) default NULL,
casttime int(11) default NULL,
casttime2 int(11) default NULL,
charmfile varchar(32) default NULL,
classes int(11) default NULL,
color int(11) default NULL,
combateffects varchar(10) default NULL,
cost int(11) default NULL,
cr int(11) default NULL,
damage int(11) default NULL,
deity int(11) default NULL,
delay int(11) default NULL,
dr int(11) default NULL,
effecttype int(11) default NULL,
elemdmgamt int(11) default NULL,
elemdmgtype int(11) default NULL,
factionamt1 int(11) default NULL,
factionamt2 int(11) default NULL,
factionamt3 int(11) default NULL,
factionamt4 int(11) default NULL,
factionmod1 int(11) default NULL,
factionmod2 int(11) default NULL,
factionmod3 int(11) default NULL,
factionmod4 int(11) default NULL,
filename varchar(15) default NULL,
focusid int(11) default NULL,
fr int(11) default NULL,
gmflag int(11) NOT NULL,
hp int(11) default NULL,
icon int(11) default NULL,
idfile varchar(30) default NULL,
itemclass int(11) NOT NULL,
itemtype int(11) default NULL,
hasteproclvl int(11) default NULL,
light int(11) default NULL,
lore varchar(80) default NULL,
magic int(11) default NULL,
mana int(11) default NULL,
material int(11) default NULL,
maxcharges int(11) default NULL,
mr int(11) default NULL,
nodrop int(11) NOT NULL,
norent int(11) NOT NULL,
pr int(11) default NULL,
races int(11) default NULL,
range int(11) default NULL,
reclevel int(11) default NULL,
recskill int(11) default NULL,
reqlevel int(11) default NULL,
sellrate float default NULL,
shielding int(11) default NULL,
size int(11) NOT NULL,
skillmodtype int(11) default NULL,
skillmodvalue int(11) default NULL,
slots int(11) NOT NULL,
spellid int(11) default NULL,
spellshield int(11) default NULL,
strikethrough int(11) default NULL,
stunresist int(11) default NULL,
tradeskills int(11) default NULL,
unknown002 int(11) default NULL,
unknown004 int(11) default NULL,
unknown005 int(11) default NULL,
unknown018 int(11) default NULL,
unknown019 int(11) default NULL,
unknown020 int(11) default NULL,
unknown044 int(11) default NULL,
unknown061 int(11) default NULL,
unknown067 int(11) default NULL,
unknown069 int(11) default NULL,
unknown070 int(11) default NULL,
unknown076 int(11) default NULL,
unknown077 int(11) default NULL,
unknown089 int(11) default NULL,
unknown091 int(11) default NULL,
unknown097 int(11) default NULL,
unknown098 int(11) default NULL,
unknown099 int(11) default NULL,
unknown105 int(11) default NULL,
unknown107 int(11) default NULL,
unknown108 int(11) default NULL,
updated datetime default NULL,
md5sum tinyblob NULL,
weight int(11) NULL,
comment varchar(255) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;
--
-- Dumping data for table 'items'
--
__________________
 mByte
|
 |
|
 |
 |
|
 |

11-11-2003, 05:15 AM
|
Sarnak
|
|
Join Date: Mar 2003
Location: Flers (en normandie)
Posts: 56
|
|
I have recreate my Database with the last "Dumpeditems.sql"
And i have always the error when I launch my "Boot5zones.bat" The #10061, how can i fix it ???
-------------------------------------------------------------------
[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.0
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading items from database: count=25315, max id=67382
[Status] Loading npcs
[Status] Loading NPCTypes from database...
[Status] Loading npc faction lists
[Status] Loading NPC Faction Lists from database...
[Status] Loading loot tables
[Status] Loading Loot tables from database...
[Status] Loading doors
[Status] Loading Doors from database...
[Status] FileLoadSPDat() Loading spells from spells_us.txt
[Status] FileLoadSPDat() spells loaded: 4352
[Status] Loading guilds
[Status] Loading factions
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] 148 commands loaded
WorldServer connect: Connecting to the server failed: TCPConnection::Connect():
connect() failed. Error: 10061
[Error] worldserver.Connect() FAILED!
[Status] Entering sleep mode
-------------------------------------------------------------------
|
 |
|
 |

11-11-2003, 05:40 AM
|
Demi-God
|
|
Join Date: Jan 2002
Location: Charlotte, NC
Posts: 2,614
|
|
Whats your ini file look like, and have you started a world server at all ?
__________________
Quitters never win, and winners never quit, but those who never win and never quit are idiots.
|

11-11-2003, 05:50 AM
|
Sarnak
|
|
Join Date: Mar 2003
Location: Flers (en normandie)
Posts: 56
|
|
All work. i started the world after boot5zone. tks you all and Trumpcard
|

11-15-2003, 08:22 PM
|
Sarnak
|
|
Join Date: Feb 2003
Posts: 73
|
|
Are you using Minilogin?
If so, double check your port settings on your LoginServer.ini.
I think the "Release" version has it set to port 5997. MiniLogin is watching Port 5999.
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 11:04 AM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |