[Yeormom]

Originally Posted by cavedude

I had the same problem, try:

update spells_new set teleport_zone='' where teleport_zone is null;
update spells_new set you_cast ='' where you_cast is null;
update spells_new set other_casts ='' where other_casts is null;
update spells_new set cast_on_you ='' where cast_on_you is null;
update spells_new set cast_on_other ='' where cast_on_other is null;
update spells_new set spell_fades ='' where spell_fades is null;

I ran into this same issue. What is interesting about it crashing in zone/net.cpp when trying to strcpy a null result row is if you change the select statement from order by ascending to descending, it works just fine. This little quark has me scratching my head. :(

Performing a sanity check before copying a null in works just fine but I'm more curious as to what caused this change to appear mroe than anything. Also wish I had not seen the "select *" statement used to populate spells...