[Jibbatwinkers]

Ive run into a problem with the NPC/Loot Editor but I think it as to do with MySQL more than anything.

All of the other tools run great, the NPC/Loot Editor will launch fine, I can search through zones and even click and edit NPCs but if I click any NPC with a loot table ID it gives me this message:

Run-time error '-2147467259 (80004005)':

Data provider or other service returned an E_FAIL status.

The problem started yesterday after I updated to 1129 and put in these two queries:

CREATE TABLE `blocked_spells` (
  `id` int(11) NOT NULL auto_increment,
  `spellid` mediumint(8) unsigned NOT NULL default '0',
  `type` tinyint(4) NOT NULL default '0',
  `zoneid` int(4) NOT NULL default '0',
  `x` float NOT NULL default '0',
  `y` float NOT NULL default '0',
  `z` float NOT NULL default '0',
  `x_diff` float NOT NULL default '0',
  `y_diff` float NOT NULL default '0',
  `z_diff` float NOT NULL default '0',
  `message` varchar(255) NOT NULL default 'You cannot cast that spell here',
  `description` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
)

Required SQL (Your groups will break completely without this):
CREATE TABLE `group_id` (
  `groupid` int(4) NOT NULL,
  `charid` int(4) NOT NULL,
  `name` varchar(64) NOT NULL,
  PRIMARY KEY (`groupid`, `charid`)
)

I removed the two tables and still have the same error. I googled the error and found some references to bad date fields but as far as I know dates are not stored in anything related to NPCs. I repaired my entire database and I also updated ODBC drivers.

Thanks for all your help, hopefully I provided enough information to get the editor up and running for me again. I'll keep looking for an answer and post if I find anything.