EQEmulator Forums - Spell Group Editor Issue ?

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Development::GeorgeS's Tools (https://www.eqemulator.org/forums/forumdisplay.php?f=674)

- - Spell Group Editor Issue ? (https://www.eqemulator.org/forums/showthread.php?t=33120)

Kroe	02-28-2011 12:13 PM

Spell Group Editor Issue ?

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

02-28-2011 04:45 PM

did you also updated the DB with newest sql?

Kroe	02-28-2011 05:30 PM

The Newest Sql Installed

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

03-01-2011 11:43 AM

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

03-02-2011 11:47 PM

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

03-03-2011 12:51 AM

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

All times are GMT -4. The time now is 09:53 AM.