npc create not working...

[Bonehard]

hehe well 5 minutes before i read your answer i expanded the sourcecode to write out any error that the NPCSpawnDB function did.

so i got the error:
Field: special_abilities - doesn't have a default value.

Atm iam looking trough the svn/git sql. but cant find any that have special_abilities updates on the npc_type table.

Any hint what default value for the field?

Thanks

[Bonehard]

Ok i found a solution.
Since the column for the special_abilities is a text column(Blob field) and i got a newer mysql version the default setting don't allow me to have a default value like '' for a text column.
Since i dont want to change the options of my database settings i did a temp table copied the values(id, special_abilities) into it.
I added another field to to npc_types from type varchar(255) than i copied the values from the temp table into the npc_types table using the new column.
i droped the column special_abilities and renamed the new field added to special_abitlies.
The new field from type varchar(255) can now be default ''.

Now it works to create new npc.

Thanks for help

Edit: sorry my english is really bad. hope you guys understand most of the technical aspect i was talking about :P