ChildLoop: AsyncSQL: query failed: Data truncated for column 'setRaceFlag' at row 1

[Aurora 45]

Hey guys,

Did someone find a solution for the 'ChildLoop: AsyncSQL: query failed: Data truncated for column 'setRaceFlag' at row 1' Problem from mob_proto?

I am trying to add the mob_proto from my language(DUTCH) into my server BUT i bounced against this error .

I already try a solution of a someone on elitepvpers but it doesn't help by me

I hope someone can help out!

Thanks in advance.

- Aurora

[vodkline 0]

u must disable substitution in mysql

enter in mysql prompt with command  mysql , then write , 

SET GLOBAL sql_mode='NO_ENGINE_SUBSTITUTION';

but ,her disappears when you rebooting

[Aurora 45]

On 26-5-2016 at 3:38 PM, vodkline said:

u must disable substitution in mysql

enter in mysql prompt with command  mysql , then write , 

SET GLOBAL sql_mode='NO_ENGINE_SUBSTITUTION';

but ,her disappears when you rebooting

Yeah i know its temporary fix i want an permant fix.

So someone else got a idea?

[ds_aim 206]

45 minutes ago, Aurora said:

Yeah i know its temporary fix i want an permant fix.

So someone else got a idea?

Dude don't exist another fix.

This is a mysql option.

 

If you want a permanent fix send ticket to mysql developers and say them to add default  this sql_mode

[DangIt 1]

The issue here is that the setRaceFlag column is of type enum. By default, it's supposed to default to a blank value but the stored elements inside the enum don't match with the default value, thus the error. Simply add a blank value at the top of the enum list and the issue is solved. This is as permanent as you can go.

[iltizio 138]

On 28/5/2016 at 6:23 PM, ds_aim said:

Dude don't exist another fix.

This is a mysql option.

 

If you want a permanent fix send ticket to mysql developers and say them to add default  this sql_mode

You can set sql_mode permanent without a patch. You can set it on my.cnf file. 

On section mysqld add

sql_mode='NO_ENGINE_SUBSTITUTION'

Then on every MySQL restart this configuration are loaded