Spell Group Editor Issue ?

[Kroe]

My Spell List Editor inside Georges Tools Npc Editor, the one for making spell groups for Npc's Keeps giving me a error.

Run-time error ' -2147467259(80004005)' :
[MySQL][ODBC 3.51 Driver][mysqld-5.0.82-community-nt] Column count doesn't match value count at row 1.

We just updated to the newest source and op-codes any ideas what may have happened here?

[ChaosSlayerZ]

did you also updated the DB with newest sql?

[Kroe]

I have this topic in Geotools as well and found that a new column was added resist_adjust. Now i have the newest GeoTools installed but i still get the error.. Any fix that can be done otherwise?

[GeorgeS]

Thanks for letting me know. Since I don't update as often, I miss these bugs.
I'll look into this and post a fix.

GeorgeS

[GeorgeS]

I'm running db ver 1751 and I looked for any updated sql and found this

ALTER TABLE `npc_spells_entries` ADD `resist_adjust` INT NULL AFTER `priority`;

I'll add this to the program

Thanks
GeorgeS

[GeorgeS]

Ok, spent a while fixing this. The hard part was the use of "Null" that someone decided to use in the newest schema. This is a bonehead idea as it's very hard to code for NULL field defaults. I prefer the use of '0'

Anyway, latest version should be live in a few minutes

NPC and Loot Editor

08.25.04 - Making compatible with database rev 1834


GeorgeS