Jump to content
  • 0

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



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 :angry:.

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

  • Answers 5
  • Created
  • Last Reply

Top Posters For This Question

5 answers to this question

Recommended Posts

  • 0

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

  • 0
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


Then on every MySQL restart this configuration are loaded

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Activity

    1. 3

      Once upon a time...

    2. 1183

      [40250] Reference Serverfile + Client + Src [15 Available Languages]

    3. 3

      Once upon a time...

    4. 3

      Once upon a time...

    5. 0

      problem ability

    6. 0

      Transmutation system error "unknow command server"

    7. 39

      Official Transmutation / Change Look

  • Recently Browsing

    • No registered users viewing this page.
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.