Life is Feudal Official Forum

[Seraf]

Hi all,

I have just try to set up an private server of LiF but when i create the character i found this error, Character process error (Code = 1024)


And this is what the console show.

Code: Select all

ERRR 2015-03-06 16:34:54.034 {00} <NOSCOPE> DB error #1253: COLLATION 'utf8_unicode_ci' is not valid for CHARACTER SET 'latin1'. Query: INSERT INTO `character`(AccountID, Name, LastName, GeoID, RaceID, Alignment, Strength, Agility,  Constitution, Willpower, Intellect, Luck, HungerRate, RootContainerID,     EquipmentContainerID, AlchemyHash, VisibilityHash, appearance)VALUES(1, 'AAAA', 'AAAA',     116798768,    1,      0,         12000000,       12000000,       12000000,           12000000,        12000000,        0,    10000,         f_createInventory(), f_createEquipment(),  0x0C27162D123D3A1D1F2B330A142305243B02103C1A37360108302818222126111C040919073E2C31060F40172F150D3400383F2520411B2A2E353203130B1E39290E0709020B06010A05000804030704010506080B030A020900,          0x000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000,             0102);


WARN 2015-03-06 16:34:54.034 {00} <NOSCOPE> DB::noRS(3 ms) INSERT INTO `character`(AccountID, Name, LastName, GeoID, RaceID, Alignment, Strength, Agility,  Constitution, Willpower, Intellect, Luck, HungerRate, RootContainerID,     EquipmentContainerID, AlchemyHash, VisibilityHash, appearance)VALUES(1, 'AAAA', 'AAAA',     116798768,    1,      0,         12000000,       12000000,       12000000,           12000000,        12000000,        0,    10000,         f_createInventory(), f_createEquipment(),  0x0C27162D123D3A1D1F2B330A142305243B02103C1A37360108302818222126111C040919073E2C31060F40172F150D3400383F2520411B2A2E353203130B1E39290E0709020B06010A05000804030704010506080B030A020900,          0x000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000,             0102);
ECHO 2015-03-06 16:34:54.034 {00} <NOSCOPE>

NetInterface::sendCreateCharacterAns 4


Someone can help me?

[Seraf]

After trying to add an player manually from sql i have this error report:

SQL Error (1253): COLLATION 'utf8_unicode_ci' is not valid for CHARACTER SET 'latin1'.

Maybe the solution is change this parameter but i don't know how

any help?

[Alakar]

After trying to add an player manually from sql i have this error report:

SQL Error (1253): COLLATION 'utf8_unicode_ci' is not valid for CHARACTER SET 'latin1'.

Maybe the solution is change this parameter but i don't know how

any help?

You didn't create your database in the right character set, it looks like yours is set to latin1 from that error when the game uses the other one.

[Seraf]

So if i re-create the database in the correct character set this problem can be fixed?

[Grimmblut]

You are supposed to create your DB with an UTF8 collation, utf8_general_ci preferably. Using another collation than UTF8 may cause unpredictable behaviour and is thus strongly discouraged. The problem with changing the collation of an existing DB are the foreign keys, which prevent you to do so in a batch operation. If we're not talking about a DB with lots of user data, I suggest a wipe and a reinstall of the DB with utf8_general_ci collation.