Bad/Expired session Key

[bodi]

I just set up my server. It is temporarily called "The Matrix" and shows up when I try to log in. However, when I login (from the same computer that is hosting the server) the client (HoT) locks up. In my world.exe window, I get

Error in CreateAccount queery 'INSERT INTO account SET name='bodi satva', status=0, lsaccount_id=166846, time_creation=UNIX_TIMESTAMP();#1054:unknown column 'time_creation' in 'field list'
Debug [WORLD__CLIENTLIST__ERR] Error adding local account for LS login: 'bodi satva' duplicate name?
[Debug] [WORLD__CLIENT_ERR] NOCLE: Bad/Expired session key '166846'

2 Things:
Can you not login to your own server from the same computer or network? If not, what do you do to test?
I have a router Belkin FD64230-4 V3 and there is no option for port forwarding in the stupid router info. Maybe that is the problem?

Any help is appreciated, thanks!

[blackdragonsdg]

You are missing an update. Source in 1711_account_restricted_aa.sql which can be found here http://projecteqemu.googlecode.com/svn/trunk/EQEmuServer/utils/sql/svn/

[bodi]

Thanks! Now I can login to my server, but i'm just regular, how would I grant myself GM powers lol

[xinu]

Now it's been a long time since i set up my last server up but go into SQL -> account table -> status and set that to 250.

[eviakhan]

You are missing an update. Source in 1711_account_restricted_aa.sql which can be found here http://projecteqemu.googlecode.com/svn/trunk/EQEmuServer/utils/sql/svn/

I had the exact same error as the OP. The most recent guides I have found on this site did not mention these sql update. Do I need to execute ALL of the SQL scripts in that folder? Thanks.

[eviakhan]

found the answer in this thread, no need reply:

http://www.eqemulator.org/forums/showthread.php?t=34189