DB update z2489_mangos_creature_template.sql Column 'AIName' cannot be null

[rage_311]

# mysql -uroot mangos < z2489_mangos_creature_template.sql
ERROR 1048 (23000) at line 79: Column 'AIName' cannot be null

I removed the "NOT NULL" from the AIName definition in CREATE TABLE (and ScriptName) in the .sql script. The creature_template_old obviously had some NULL values in the AIName and ScriptName columns.

[antz]

I corrected that update last night to resolve the issue, thank for reporting it though.

Please make sure your creature table is ok though. On my system the failure caused my creature table to be incomplete.

[rage_311]

I corrected that update last night to resolve the issue, thank for reporting it though.

Please make sure your creature table is ok though. On my system the failure caused my creature table to be incomplete.

Yes, it royally screwed mine up as well. I'll try the new update.