EQEmulator Forums - 0.5.2 database.CreateCharacter failed

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Archive::Linux Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=618)

- - 0.5.2 database.CreateCharacter failed (https://www.eqemulator.org/forums/showthread.php?t=11167)

0.5.2 database.CreateCharacter failed

Whenever i try to create a character on my server (0.5.2 on Linux) i get this in the logfile:

Code:

Name approval request for:Maleko race:1 class:14

Choice:4

[Error] Database: could not find start_zones entry in database. Using Defaults..

[Error] CreateCharacter query 'UPDATE character_ SET timelaston=0,guild=0, zonename='freportw', x=0.000000, y=0.000000, z=0.000000, profile=



(insert lots of 0's \'s and other such characters here)



WHERE account_id=2 AND name='Maleko'' #1054: Unknown column 'timelaston' in 'field list'

database.CreateCharacter failed

Got a bogus character (Maleko), deleting it.

PP length =0

and it rejects my character name.
I saw another thread about this, and it said that something wasnt supported by 0.5.2 that caused it, but there must be a way to fix it as i can see 0.5.2 servers up and running. Any suggestions?

Thanks.

I have the same time question with eqemu for win32
Emu5.3Dr2
Database
mw_052_053_alpha2.zip
mw_052_053_alpha2_upgrade.zip
dumpeditems.sql.gz

But some char can be logon in, like agnostic...

Code:

WHERE account_id=2 AND name='Maleko'' #1054: Unknown column 'timelaston' in 'field list'

well, the code tries to write datas to a table field that doesn't exists (timelaston), which causes the query to fail.
You could prolly fix that urself searching for that field into the sqle files you sourced. If you do this, you'll see where it is added or removed and will understand how to fix it :wink:

I thought that was the key, but to be honest i know nothing about SQL. I may just re-build the database... i'm still new to SQL, so i may have done something wrong.

Thanks.