Error: 10060

[Kran]

hi, I've a problem when i launch my 'Boot5zones.bat.
[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,itemcl ass,idfile,lore,slots,cost,nam
e,icon,unknown105,booktype,filename,bagtype,bagslo ts,bagsize,bagwr,augslot1type,
augslot2type,augslot3type,augslot4type,augslot5typ e,unknown018,unknown019,unknow
n020,casttime2,unknown061,unknown067,unknown069,un known070,unknown076,unknown077
,augtype,unknown097,unknown098,unknown099,astr,ast a,aagi,adex,awis,aint,acha,pr,
mr,dr,fr,cr,skillmodvalue,skillmodtype,banedmgamt, banedmgbody,banedmgrace,magic,
hasteproclvl,light,delay,effecttype,range,damage,m aterial,maxcharges,reclevel,re
cskill,charmfile,factionmod1,factionmod2,factionmo d3,factionmod4,factionamt1,fac
tionamt2,factionamt3,factionamt4,reqlevel,hp,mana, ac,color,classes,races,spellid
,casttime,focusid,itemtype,accuracy,avoidance,bard type,bardvalue,combateffects,d
eity,elemdmgamt,elemdmgtype,sellrate,shielding,spe llshield,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 !

[Kgaul]

DL and source the latest Dumpeditems.sql from sourceforge. looks like you might have an incorrect table...


Kgaul

[Kran]

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


:?: :?:

[mByte]

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.

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

[Kran]

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

[Trumpcard]

Whats your ini file look like, and have you started a world server at all ?

[Kran]

All work. i started the world after boot5zone. tks you all and Trumpcard

[Magick]

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.