wow, that dosent look good (world.exe errors
World .exe seems to finish loading but it looks like this when it does:
Using database 'eq' at localhost
[Status] CURRENT_WORLD_VERSION:EQEMu 0.4.4
[Error] CURRENT_WORLD_VERSION:EQEMu 0.4.4
Loading Variables, zone names & items...
Error in LoadVariables query 'SELECT varname, value, unix_timestamp() FROM varia
bles where unix_timestamp(ts) >= 0' #1142: select command denied to user: 'Patri
ck@127.0.0.1' for table 'variables'
Error in LoadZoneNames query 'SELECT MAX(zoneidnumber) FROM zone' #1142: select
command denied to user: 'Patrick@127.0.0.1' for table 'zone'
EMuShareMem.dll loaded.
Error in GetItemsCount query 'SELECT MAX(id), count(*) FROM items' #1142: select
command denied to user: 'Patrick@127.0.0.1' for table 'items'
Error: Database::LoadItems() (sharemem): GetItemsCount() returned -1
Error: Could not load item data. But ignoring
...done.
LoginServer.ini read.
Loading guild ranks...Error in LoadGuilds query 'SELECT id, eqid, name, leader,
minstatus, rank0title, rank1, rank1title, rank2, rank2title, rank3, rank3title,
rank4, rank4title, rank5, rank5title from guilds' #1142: select command denied t
o user: 'Patrick@127.0.0.1' for table 'guilds'
done.
Loading EQ time of day...done.
Deleted -1 stale player corpses from database.
Deleted -1 stale player backups from database.
Please don't make me a levelme server. :(
TCP listening on: 24.88.201.106:9000
World server listening on: 24.88.201.106:9000
Error: DBAsyncCB_LoadVariables failed: !GetAnswer: '#1142: select command denied
to user: 'Patrick@127.0.0.1' for table 'variables''
Connected to LoginServer: eqlogin2.eqemu.net:5999
Error: DBAsyncCB_LoadVariables failed: !GetAnswer: '#1142: select command denied
to user: 'Patrick@127.0.0.1' for table 'variables''
Error: DBAsyncCB_LoadVariables failed: !GetAnswer: '#1142: select command denied
to user: 'Patrick@127.0.0.1' for table 'variables''
Error: DBAsyncCB_LoadVariables failed: !GetAnswer: '#1142: select command denied
to user: 'Patrick@127.0.0.1' for table 'variables''
Error: DBAsyncCB_LoadVariables failed: !GetAnswer: '#1142: select command denied
to user: 'Patrick@127.0.0.1' for table 'variables''
Error: DBAsyncCB_LoadVariables failed: !GetAnswer: '#1142: select command denied
to user: 'Patrick@127.0.0.1' for table 'variables''
tell me if you guys have any suggestions for all of these errors, im pretty new to SQL so i probably screwed something up, my server appears on the list though, i just figure all of these things kinda mean something is wrong
edit: im guessing the access denied for select command is part of it, i searched for this and i found info just about granting priveleges just to get world.exe to finish loading, i still get the select command error even after i do the GRANT ALL PRIVELEGES and it says it works, very strange
|