Error adding local account for LS login...
 

Hello all,
I have just got together a public server i was working on when i went to try and log in for the first time and got Error adding local account for LS login... for 2 different accounts. If someone could point me in the right direction to get this fixed that would be great.

Here is my World.exe

[Debug] [WORLD__CLIENT] New connection from 127.0.0.1:4812
[Debug] [NET__IDENT_TRACE] 127.0.0.1:4812: First opcode 0x4dd0 did not match exp
ected 0x2792
[Debug] [NET__IDENT_TRACE] 127.0.0.1:4812: Tried patch 6.2_world, and it did not
match.
[Debug] [NET__IDENT_TRACE] 127.0.0.1:4812: First opcode 0x4dd0 did not match exp
ected 0x2ec9
[Debug] [NET__IDENT_TRACE] 127.0.0.1:4812: Tried patch 6.2_zone, and it did not
match.
[Debug] [NET__IDENT_TRACE] 127.0.0.1:4812: First opcode matched 0x4dd0 and lengt
h matched 464
[Debug] [NET__IDENTIFY] Identified stream 127.0.0.1:4812 with signature Titanium
_world
[Debug] [WORLD__CLIENT] Checking inbound connection 127.0.0.1 against BannedIPs
table
[Debug] [WORLD__CLIENT] Connection 127.0.0.1 PASSED banned IPs check. Processin
g connection.
Account Attempting to be created:permaxx 0
Error in CreateAccount query 'INSERT INTO account SET name='permaxx', status=0,
lsaccount_id=94791, time_creation=UNIX_TIMESTAMP();' #1054: Unknown column 'time
_creation' in 'field list'
[Debug] [WORLD__CLIENTLIST_ERR] Error adding local account for LS login: 'permax
x', duplicate name?
[Debug] [WORLD__CLIENT_ERR] NOCLE: Bad/Expired session key '94791'
[Debug] [WORLD__CLIENT] New connection from 127.0.0.1:4817
[Debug] [NET__IDENT_TRACE] 127.0.0.1:4817: First opcode 0x4dd0 did not match exp
ected 0x2792
[Debug] [NET__IDENT_TRACE] 127.0.0.1:4817: Tried patch 6.2_world, and it did not
match.
[Debug] [NET__IDENT_TRACE] 127.0.0.1:4817: First opcode 0x4dd0 did not match exp
ected 0x2ec9
[Debug] [NET__IDENT_TRACE] 127.0.0.1:4817: Tried patch 6.2_zone, and it did not
match.
[Debug] [NET__IDENT_TRACE] 127.0.0.1:4817: First opcode matched 0x4dd0 and lengt
h matched 464
[Debug] [NET__IDENTIFY] Identified stream 127.0.0.1:4817 with signature Titanium
_world
[Debug] [WORLD__CLIENT] Checking inbound connection 127.0.0.1 against BannedIPs
table
[Debug] [WORLD__CLIENT] Connection 127.0.0.1 PASSED banned IPs check. Processin
g connection.
Account Attempting to be created:equinox 0
Error in CreateAccount query 'INSERT INTO account SET name='equinox', status=0,
lsaccount_id=94792, time_creation=UNIX_TIMESTAMP();' #1054: Unknown column 'time
_creation' in 'field list'
[Debug] [WORLD__CLIENTLIST_ERR] Error adding local account for LS login: 'equino
x', duplicate name?
[Debug] [WORLD__CLIENT_ERR] NOCLE: Bad/Expired session key '94792'


thx you

You need to source in this SQL to your database to add the missing column:

thx you very much!!!!!!!!! worked like a charm

i have the same error but not sure I'm source in the sql you posted correctly cause i get and failed error when doing so.
if i leave source off the front I get

Don't use source and you are using the wrong ` marks. Copy and paste his block directly.

yeah I just got it working! now the fun part... :)