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,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,ldonpointtheme,ldonpointcost,unknown099,astr,asta,aagi,adex,awis,aint,a
cha,pr,mr,dr,fr,cr,skillmodvalue,skillmodtype,banedmgamt,banedmgbody,banedmgrace
,magic,hasteproclvl,light,delay,effecttype,range,damage,material,maxcharges,recl
evel,recskill,charmfile,factionmod1,factionmod2,factionmod3,factionmod4,factiona
mt1,factionamt2,factionamt3,factionamt4,reqlevel,hp,mana,ac,color,classes,races,
spellid,casttime,focusid,itemtype,accuracy,avoidance,bardtype,bardvalue,combatef
fects,deity,elemdmgamt,elemdmgtype,sellrate,shielding,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]

Originally Posted by Gonkers

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,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,ldonpointtheme,ldonpointcost,unknown099,astr,asta,aagi,adex,awis,aint,a
cha,pr,mr,dr,fr,cr,skillmodvalue,skillmodtype,banedmgamt,banedmgbody,banedmgrace
,magic,hasteproclvl,light,delay,effecttype,range,damage,material,maxcharges,recl
evel,recskill,charmfile,factionmod1,factionmod2,factionmod3,factionmod4,factiona
mt1,factionamt2,factionamt3,factionamt4,reqlevel,hp,mana,ac,color,classes,races,
spellid,casttime,focusid,itemtype,accuracy,avoidance,bardtype,bardvalue,combatef
fects,deity,elemdmgamt,elemdmgtype,sellrate,shielding,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]

Originally Posted by Gonkers

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.