so very frustrated!

[Gonkers]

Okay, I Sourced db.sql (I suppose it was old one I have no clue)... okay so i move on and source the alpha's....Then go to source alpha_02.. Beep beep beep beep is all I hear from my comp, get mad so I exit out. doorsupdate did fine, then realise i sourced wrong DB, oh np, new db will overwrite...Nope..beep beep beep..exct is all I hear from my computer speaker...I drive myself insane so I exit out of that, go to start up server and get this mess from world.exe.. Please please please help me..hate being frustrated.

[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.5
[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,ldonpointtheme,ldonpointcost,unknown099,a str,asta,aagi,adex,awis,aint,a
cha,pr,mr,dr,fr,cr,skillmodvalue,skillmodtype,bane dmgamt,banedmgbody,banedmgrace
,magic,hasteproclvl,light,delay,effecttype,range,d amage,material,maxcharges,recl
evel,recskill,charmfile,factionmod1,factionmod2,fa ctionmod3,factionmod4,factiona
mt1,factionamt2,factionamt3,factionamt4,reqlevel,h p,mana,ac,color,classes,races,
spellid,casttime,focusid,itemtype,accuracy,avoidan ce,bardtype,bardvalue,combatef
fects,deity,elemdmgamt,elemdmgtype,sellrate,shield ing,spellshield,strikethrough,
stunresist,tradeskills FROM items ORDER BY id', #1054: Unknown column 'casttime2
' in 'field 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: You need to get laid...
TCP listening on: my ip:9000
World server listening on: my ip:9000
Connected to LoginServer: eqlogin3.eqemulator.net:5997

[Derision]

then realise i sourced wrong DB,

go into mysql, then type

drop database <your eq db> ;

and then source the correct database (see Jezzebell's guide).

[samandhi]

and then source the correct database (see Jezzebell's guide). By typing drop database you are deleting the DB. You will need to do the CREATE DATABASE <DBName>;
USE <DBName>;
again before you try and source the correct DB....

[Gonkers]

That was the last thing I wanted to do, LOL, looks like i'm screwed... Oh well, i'll go slowly and see if i still get problem.

[Gonkers]

Confiming that it Still says that on world.exe even after I dropped it (even twice) and went in and

create database eq

source db.sql


Is there some sql file I should be sourcing before it?...

I dont know why this keeps doing this to me /cry lol.

[NarutoLegacy]

No, you do

create database eq;
use eq;
source db.sql;

[Gonkers]

i'll go one by one to show ya it doesnt work :p.


C:\Documents and Settings\myname\Desktop>cd\mysql\bin

C:\mysql\bin>mysql -u root mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 68 to server version: 4.0.18-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> drop database eq;
Query OK, 0 rows affected (0.05 sec)

mysql> create database eq;
Query OK, 1 row affected (0.00 sec)

mysql> use eq;
Database changed
mysql> source db.sql

**all rows were okay, so i typed exit**

### --- 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 recommend using the eqemulator.net Loginserver ALWAYS.

### --- NOTE: You can NOT use the word "Server" in worldname.
### --- NOTE2: the word "Server" is added to each server automatically.

# READ README.TXT
[LoginServer]
loginserver=eqlogin1.eqemulator.net
loginserver2=eqlogin2.eqemulator.net
loginserver3=eqlogin3.eqemulator.net
loginport=5997
loginport2=5997
loginport3=5997
worldname=my server name
worldaddress=my ip
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

[LoginConfig]
ServerMode=Standalone
ServerPort=5999
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=

Boot5zones is correct also.


db.ini correct


Double clicked on world.exe and get


[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.5
[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,ldonpointtheme,ldonpointcost,unknown099,a str,asta,aagi,adex,awis,aint,a
cha,pr,mr,dr,fr,cr,skillmodvalue,skillmodtype,bane dmgamt,banedmgbody,banedmgrace
,magic,hasteproclvl,light,delay,effecttype,range,d amage,material,maxcharges,recl
evel,recskill,charmfile,factionmod1,factionmod2,fa ctionmod3,factionmod4,factiona
mt1,factionamt2,factionamt3,factionamt4,reqlevel,h p,mana,ac,color,classes,races,
spellid,casttime,focusid,itemtype,accuracy,avoidan ce,bardtype,bardvalue,combatef
fects,deity,elemdmgamt,elemdmgtype,sellrate,shield ing,spellshield,strikethrough,
stunresist,tradeskills FROM items ORDER BY id', #1054: Unknown column 'casttime2
' in 'field 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
Breaking linux compiles....
TCP listening on: my ip:9000
World server listening on: my ip:9000
Connected to LoginServer: eqlogin1.eqemulator.net:5997

[Gonkers]

Hmmm... Now since i look over it, lemme grab the Items.sql source........

[Derision]

Hmmm... Now since i look over it, lemme grab the Items.sql source........

Yes, that is your problem, or source the MW databases, see

http://www.eqemulator.net/forums/viewtopic.php?t=13403

[Gonkers]

**jumps up and down**

i was correct :).. Thank you for your help also :). Will source that other db tonight :p.