unix_timestamp 1146

[ufos]

[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.2
[Status] Loading variables..
Error in LoadVariables query 'SELECT varname, value, unix_timestamp() FROM varia
bles where unix_timestamp(ts) >= 0' #1146: Table 'eq.variables' doesn't exist
[Status] Loading zones..
Error in LoadZoneNames query 'SELECT MAX(zoneidnumber) FROM zone' #1146: Table '
eq.zone' doesn't exist
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=26618, max id=68199
[LoginServer] block not found in 'LoginServer.ini'.
[Status] Loading guild ranks..
Error in LoadGuilds query 'SELECT id, eqid, name, leader, minstatus, rank0title,
rank1, rank1title, rank2, rank2title, rank3, rank3title, rank4, rank4title, ran
k5, rank5title from guilds' #1146: Table 'eq.guilds' doesn't exist
[Status] Loading addon.ini..
[Status] Loading EQ time of day..
[Error] Could not load EQTime file ./eqtime.cfg
[Error] Unable to load ./eqtime.cfg
[Status] Deleted -1 stale player corpses from database
[Status] Deleted -1 stale player backups from database
Please don't make me a levelme server. :(
TCP listening on: port 9000
World server listening on: port 9000
Error: DBAsyncCB_LoadVariables failed: !GetAnswer: '#1146: Table 'eq.variables'
doesn't exist'
Error: DBAsyncCB_LoadVariables failed: !GetAnswer: '#1146: Table 'eq.variables'
doesn't exist'
Error: DBAsyncCB_LoadVariables failed: !GetAnswer: '#1146: Table 'eq.variables'
doesn't exist'
Error: DBAsyncCB_LoadVariables failed: !GetAnswer: '#1146: Table 'eq.variables'
doesn't exist'

how fix??

[Monrezz]

Have you got your db.ini configured correctly? Looks like it can't find the database/tables.

Have you sourced in a database...need more information...

[ufos]

Boot5zones.bat
start zone . 127.0.0.1 7995 127.0.0.1
start zone . 127.0.0.1 7996 127.0.0.1
start zone . 127.0.0.1 7997 127.0.0.1
start zone . 127.0.0.1 7998 127.0.0.1
start zone . 127.0.0.1 7999 127.0.0.1

db.ini
[Database]
host=localhost
user=eq
password=eq
database=eq

eq acaunt have root priv

LoginServer.ini
[LoginServer]
loginserver=localhost
loginport=5999
worldname=UFOS
worldaddress=127.0.0.1
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

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

[Monrezz]

Make sure you have mysql-nt.exe and winmysqladmin.exe running. Try changing 127.0.0.1 to localhost. make sure you've granted the privileges to the account. Make sure you've searched the forums for the error.

What database did you source in? If you open FQAdmin or MysqlFront can you see any entries?

[ufos]

If I replace ligin:eq pass:eq on login:root that at me already such theme jumps out here


Got signal 0
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.2
[Status] Loading variables..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in LoadVariables query 'SELECT varname, value, unix_timestamp() FROM varia
bles where unix_timestamp(ts) >= 0' #2006: MySQL server has gone away
[Status] Loading zones..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in LoadZoneNames query 'SELECT MAX(zoneidnumber) FROM zone' #2006: MySQL s
erver has gone away
[Status] Loading items..
[Status] EMuShareMem loaded
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in GetItemsCount query 'SELECT MAX(id),count(*) FROM items' #2006: MySQL s
erver has gone away
Error: Database::LoadItems() (sharemem): GetItemsCount() returned -1
[Error] Error: Could not load item data. But ignoring
[LoginServer] block not found in 'LoginServer.ini'.
[Status] Loading guild ranks..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in LoadGuilds query 'SELECT id, eqid, name, leader, minstatus, rank0title,
rank1, rank1title, rank2, rank2title, rank3, rank3title, rank4, rank4title, ran
k5, rank5title from guilds' #2006: MySQL server has gone away
[Status] Loading addon.ini..
[Status] Loading EQ time of day..
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
[Status] Deleted -1 stale player corpses from database
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
[Status] Deleted -1 stale player backups from database
Please don't make me a levelme server. :(
TCP listening on: port 9000
World server listening on: port 9000
===============================
Runtime errors:

MySQL Error #1405 or #2001 means your mysql server rejected the username and pas
sword you presented it.
For more information on this error, visit http://www.eqemu.net/eqemuerror.php?id
=1

Hit any key to exit

I have replaced all 127.0.0.1 on localhost and have not helped

[ufos]

SO ANY HELP ME ????

[Monrezz]

No need for caps.

Delete my.ini found in C:\Windows.

Then run mysqladmin.exe and enter a username/password. Then run command prompt and point it into your mysql\bin directory. The type in:

mysql -u root eq
GRANT ALL OPTIONS ON *.eq TO <username in db.ini>@localhost IDENTIFIED BY '<password in db.ini>' WITH GRANT OPTION;

Replace with the username and password found in your db.ini.