PDA

View Full Version : Connection Problem Or DB


Panolyen
11-08-2003, 03:42 PM
I dunno what exactly is wrong this time but i got everything here and i will paste it.
(WHen WORLD.EXE is run)

[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.0
[Status] Loading variables..
[Status] Loading zones..
[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] 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..
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Warning: Pants may change during online play.
:9000istening on: localhost
:9000 server listening on: localhost
Error: LoginServer::Connect: Resolving IP address: 'Unable to get the host name.
Error: 11001'

DB.INI Looks like this:
# READ README.TXT!


[Database]
host=localhost
user=test
password=test
database=eq
compression=off





### --- This file tells world.exe what computer mySQL is on. Host should
### --- be left "localhost" unless mysql is on a differant computer than world.exe.

Loginserver.INI is as follows:
### --- This file tells world.exe what loginserver to connect to.

### --- Leave the account and password field BLANK.



### --- Public Login is un-supported as is LAN playing. We reccomend using the EQEmu.net Loginserver ALWAYS.



### --- NOTE: Starting 6-1-2002, you can no longer use the word "Server" in worldname.

### --- NOTE2: the word "Server" is added to each server automaticly.



# READ README.TXT



[LoginServer]

loginserver=localhost

loginport=5997

worldname=PanolyensStuff

worldaddress=localhost

locked=false

account=

password=



[WorldServer]

Defaultstatus=o

Unavailzone=



[LoginConfig]

ServerMode=Standalone

ServerPort=5999

UplinkAddress=

UplinkPort=

UplinkAccount=

UplinkPassword=

And heres Boot5Zones.Bat:
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 localhost instead of 127.0.0.1



REM:--------------Start-----------------------

@echo off



if NOT exist spells_en.txt goto NOSPELL



start zone . localhost 7995 localhost

start zone . localhost 7996 localhost

start zone . localhost 7997 localhost

start zone . localhost 7998 localhost

start zone . localhost 7999 localhost

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



Sorry for another post, i just figured this one would be more detailed and i could find out exactly what i did wrong.
Thanks Guys

mangoo
11-08-2003, 04:21 PM
Download the current Items DB from SourceForge, link to its is on main EQEmu website.

mByte
11-10-2003, 12:36 PM
Here is the Current 0.5.0 items table


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

Magick
11-15-2003, 08:39 PM
A lil late for help but I'm restless and can't sleep.

As noted above, you need to repair your database, it's a mess and not current :)

Second, try switching from "localhost" to 127.0.0.1 and see if that helps you connect.

Thirdly, since you're doing a LAN Server, try changing your LoginServer.ini to:

[LoginServer]
loginserver=127.0.0.1
loginport=5999
worldname=Your Server Here
worldaddress=127.0.0.1
locked=false

** Notice the port change number **

I hope that helps. Good luck!

gthang187
04-28-2004, 01:24 PM
ok the best way to find out what ip to use is well from what i just did nothing i have tryed worked untill i got a well brainstorm. i guess is what i haveta call it :) anyways what i decided to do was ask mysql what ip it use's the way you do this is :) c:\mysql\bin run file winmysqladmin.exe and then click environment

I know i dont spell well so sew me LOL ok anyways once you do this you will see the ip that mysql use's there local ip addy also make sure you have ODBC installed becuase i also installed that just before i figured it out but i suggest useing the same ip mysql use's well there you go guys hope i helped out :)