Aurora 46 Posted May 25, 2016 Share Posted May 25, 2016 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 Link to comment Share on other sites More sharing options...
vodkline 0 Posted May 26, 2016 Share Posted May 26, 2016 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 Link to comment Share on other sites More sharing options...
Aurora 46 Posted May 28, 2016 Author Share Posted May 28, 2016 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? Link to comment Share on other sites More sharing options...
ds_aim 241 Posted May 28, 2016 Share Posted May 28, 2016 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 Link to comment Share on other sites More sharing options...
DangIt 1 Posted June 1, 2016 Share Posted June 1, 2016 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. Link to comment Share on other sites More sharing options...
iltizio 217 Posted June 2, 2016 Share Posted June 2, 2016 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now