EQEmulator Forums - so very frustrated!

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Archive::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=617)

- - so very frustrated! (https://www.eqemulator.org/forums/showthread.php?t=12987)

so very frustrated!

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.

Code:

[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

Re: so very frustrated!

Quote:

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

Quote:

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

Code:

CREATE DATABASE &lt;DBName>;

USE &lt;DBName>;

again before you try and source the correct DB....

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.

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.

No, you do

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

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

Code:

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

Code:

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

Code:

[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

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

Quote:

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

**jumps up and down**

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