View Single Post
  #5  
Old 06-13-2014, 05:09 PM
Bonehard
Fire Beetle
 
Join Date: Feb 2011
Posts: 16
Default

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
Reply With Quote