World Server and Locked Server

[dil]

World Server Run trying to Flag Account Otherwise it Runs Fine
Using database 'eq' at localhost
DB Query Error
Error #1146: Table 'eq.variables' doesn't exist
Error in GetVariable query 'SELECT value FROM variables WHERE varname like 'disa
blecommandline'' #1146: Table 'eq.variables' doesn't exist
Account being GM Flagged:ramaddil, Level: 200
database.SetGMFlag failed.

C:\eqemu>

this is what i see when i try to flag my account and when i try to log in to my server its locked all the time.

And Booting Zones looks like this

Using database 'eq' at localhost
Loading items & NPCs...DB Query Error
Error #1146: Table 'eq.npc_types' doesn't exist
Error in LoadNPCTypes query 'SELECT MAX(id) FROM npc_types' #1146: Table 'eq.npc
_types' doesn't exist
DB Query Error
Error #1146: Table 'eq.variables' doesn't exist
done.
Spells loaded from 'spdat.eff'.
Loading guild ranks...done.
Loading faction data...DB Query Error
Error #1146: Table 'eq.variables' doesn't exist
done.
WorldServer connect: Connecting to the server failed. Error: 10061
InitWorldServer failed
Entering sleep mode


<-- spent a few days on it still stumpted did everything it said in read me

[Trumpcard]

One of 2 things...

Either you didnt load the database (source db.sql)

or you created a different database name than eq.

[dil]

I Created the Database as Eq and i sourced db.sql to it

[devn00b]

Dump your old database and start over

in mysql do it like this (if you did it any other way this could be the problem)

mysql> use eq
will say database changed
mysql> source db.sql

will run through it all yada yada...

then try and log on

after you log on (and an account is created in the Database)

then jump out and try to flag the accout

sounds to me like an error when you setup the db...

[dil]

How do you create account in data base ?

[meliudaj]

If you have gone threw the proccess of getting an account on the eqfrags login server here

Then once you connect to your server from the list of servers that pop up after you sign in. Your user name is added Dinamicaly to your data base.

THEN you can use the c:/eqemu/world flag "username" 200 to give you Server Op rights on your server.

[dil]

I have a Account I can log on i am Trying to Create my own server When i type it it gives me the message Seen onmy first post trying to flag my account the account is active. But my Server Says its Locked

[meliudaj]

Post your db.ini, login.ini.

[dil]

[LoginServer]
loginserver=eqlogin.eqemu.net
worldname=Ramaddil
locked=false
account=
password=
worldaddress=68.11.186.59
loginport=5999

[Database]
host=localhost
user=******
password=*****
database=eq

[meliudaj]

Hmm One suggestion even though it shouldn't matter

change Localhost in your db.in to 127.0.0.1

If/when that doesn't work do this:

EDIT


mysql.exe
drop database eq;
create database eq;
Re copy db.sql to the c:\mysql\bin directory
use eq
source db.sql
exit

c:\eqemu\world.exe (hope for no errors)
If none
c:\eqemu\boot5zone.bat (or the 5zone.9x depending on OS)

If still no errors, THEN try and log in with your
c:\everquest\eqgame.exe patchme
And see if your server "Ramaddil" is there

This should look like a repeat of what you have done... but humor me.

[meliudaj]

One more question... How did you create the database eq?

and did you create Eq, EQ, eQ, eq?

Not 100% sure if the databse name is case sensitive. But to be safe make it ALL lowercase.