Can't Connect To Server

[Xenerox]

Everytime i attempt to connect to my server this is the message the logs show

[Debug] [WORLD__CLIENT] New connection from 68.62.43.74:63182
[Debug] [NET__IDENT_TRACE] 68.62.43.74:63182: First opcode 0x13da did not match
expected 0x2792
[Debug] [NET__IDENT_TRACE] 68.62.43.74:63182: Tried patch 6.2_world, and it did
not match.
[Debug] [NET__IDENT_TRACE] 68.62.43.74:63182: First opcode 0x13da did not match
expected 0x2ec9
[Debug] [NET__IDENT_TRACE] 68.62.43.74:63182: Tried patch 6.2_zone, and it did n
ot match.
[Debug] [NET__IDENT_TRACE] 68.62.43.74:63182: First opcode 0x13da did not match
expected 0x4dd0
[Debug] [NET__IDENT_TRACE] 68.62.43.74:63182: Tried patch Titanium_world, and it
 did not match.
[Debug] [NET__IDENT_TRACE] 68.62.43.74:63182: First opcode 0x13da did not match
expected 0x7213
[Debug] [NET__IDENT_TRACE] 68.62.43.74:63182: Tried patch Titanium_zone, and it
did not match.
[Debug] [NET__IDENT_TRACE] 68.62.43.74:63182: First opcode 0x13da did not match
expected 0x6c3c
[Debug] [NET__IDENT_TRACE] 68.62.43.74:63182: Tried patch SoF_world, and it did
not match.
[Debug] [NET__IDENT_TRACE] 68.62.43.74:63182: First opcode 0x13da did not match
expected 0x737e
[Debug] [NET__IDENT_TRACE] 68.62.43.74:63182: Tried patch SoF_zone, and it did n
ot match.
[Debug] [NET__IDENT_TRACE] 68.62.43.74:63182: First opcode 0x13da did not match
expected 0xff4
[Debug] [NET__IDENT_TRACE] 68.62.43.74:63182: Tried patch SoD_world, and it did
not match.
[Debug] [NET__IDENT_TRACE] 68.62.43.74:63182: First opcode 0x13da did not match
expected 0x5a6b
[Debug] [NET__IDENT_TRACE] 68.62.43.74:63182: Tried patch SoD_zone, and it did n
ot match.
[Debug] [NET__IDENT_TRACE] 68.62.43.74:63182: First opcode matched 0x13da and le
ngth matched 464
[Debug] [NET__IDENTIFY] Identified stream 68.62.43.74:63182 with signature Under
foot_world
[Debug] [WORLD__CLIENT] Checking inbound connection 68.62.43.74 against BannedIP
s table
[Debug] [WORLD__CLIENT] Connection 68.62.43.74 PASSED banned IPs check.  Process
ing connection.
Account Attempting to be created:Xenerox 0
Error in CreateAccount query 'INSERT INTO account SET name='Xenerox', status=0,
lsaccount_id=139227, time_creation=UNIX_TIMESTAMP();' #1054: Unknown column 'tim
e_creation' in 'field list'
[Debug] [WORLD__CLIENTLIST_ERR] Error adding local account for LS login: 'Xenero
x', duplicate name?
[Debug] [WORLD__CLIENT_ERR] NOCLE: Bad/Expired session key '139227'

im not understanding why its doing it bcz my account isnt already in db
any help would be appreciated please

[Derision]

You need to source in this SQL:

ALTER TABLE `account` ADD `time_creation` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `suspendeduntil`;
UPDATE `account` SET `time_creation` = UNIX_TIMESTAMP() WHERE `time_creation` = 0;

The problem is that PEQ updated the 'system' tables in the database to something like Rev1753 in their latest DB release, but not the 'player' tables such as account, character_ etc.

There may be other SQL changes required, but try that and see how much further you can get.

[Xenerox]

thank you Derision that helped me get past 1 issue but nows theres another i can make a character and get to char select as soon as i hit enterworld i get kicked back to login screen no matter what zone my characters in