eqitems editor error

mastajon · #1 01-04-2010, 05:35 PM

when i try to look up certain items i get the following error and eq items crashes

run-time error '-214767259 (80004005)';
data provider or other service returned an E_FAIL status.

any idea what this means?

**trevius** · #2 01-04-2010, 06:47 PM

I don't know for sure, but normally crashes in the editors like that mean that your table layout doesn't match what the tool thinks it should be. That either means that your DB has updates to it that the tool doesn't have yet, or that the tool is newer than the version of DB you are running.

**GeorgeS** · #3 01-04-2010, 10:12 PM

I need more details - what item and exactly what were you trying to do?

What database ver?

note, these are .net/vb MS error codes and mean nothing unless I get details
GeorgeS

mastajon · #4 01-05-2010, 07:46 PM

I am using database rev 1052, i will post my item schema and the item im trying to look up that is causing the crash.

**Schema***

CREATE TABLE IF NOT EXISTS `items` (
`id` int(11) NOT NULL default '0',
`minstatus` smallint(5) NOT NULL default '0',
`Name` varchar(64) NOT NULL default '',
`aagi` int(11) NOT NULL default '0',
`ac` int(11) NOT NULL default '0',
`accuracy` int(11) NOT NULL default '0',
`acha` int(11) NOT NULL default '0',
`adex` int(11) NOT NULL default '0',
`aint` int(11) NOT NULL default '0',
`artifactflag` tinyint(3) unsigned NOT NULL default '0',
`asta` int(11) NOT NULL default '0',
`astr` int(11) NOT NULL default '0',
`attack` int(11) NOT NULL default '0',
`augrestrict` int(11) NOT NULL default '0',
`augslot1type` tinyint(3) NOT NULL default '0',
`augslot1visible` tinyint(3) default NULL,
`augslot2type` tinyint(3) NOT NULL default '0',
`augslot2visible` tinyint(3) default NULL,
`augslot3type` tinyint(3) NOT NULL default '0',
`augslot3visible` tinyint(3) default NULL,
`augslot4type` tinyint(3) NOT NULL default '0',
`augslot4visible` tinyint(3) default NULL,
`augslot5type` tinyint(3) NOT NULL default '0',
`augslot5visible` tinyint(3) default NULL,
`augtype` int(11) NOT NULL default '0',
`avoidance` int(11) NOT NULL default '0',
`awis` int(11) NOT NULL default '0',
`bagsize` int(11) NOT NULL default '0',
`bagslots` int(11) NOT NULL default '0',
`bagtype` int(11) NOT NULL default '0',
`bagwr` int(11) NOT NULL default '0',
`banedmgamt` int(11) NOT NULL default '0',
`banedmgraceamt` int(11) NOT NULL default '0',
`banedmgbody` int(11) NOT NULL default '0',
`banedmgrace` int(11) NOT NULL default '0',
`bardtype` int(11) NOT NULL default '0',
`bardvalue` int(11) NOT NULL default '0',
`book` int(11) NOT NULL default '0',
`casttime` int(11) NOT NULL default '0',
`casttime_` int(11) NOT NULL default '0',
`charmfile` varchar(32) NOT NULL default '',
`charmfileid` varchar(32) NOT NULL default '',
`classes` int(11) NOT NULL default '0',
`color` int(10) unsigned NOT NULL default '0',
`combateffects` varchar(10) NOT NULL default '',
`extradmgskill` int(11) NOT NULL default '0',
`extradmgamt` int(11) NOT NULL default '0',
`price` int(11) NOT NULL default '0',
`cr` int(11) NOT NULL default '0',
`damage` int(11) NOT NULL default '0',
`damageshield` int(11) NOT NULL default '0',
`deity` int(11) NOT NULL default '0',
`delay` int(11) NOT NULL default '0',
`augdistiller` int(11) NOT NULL default '0',
`dotshielding` int(11) NOT NULL default '0',
`dr` int(11) NOT NULL default '0',
`clicktype` int(11) NOT NULL default '0',
`clicklevel2` int(11) NOT NULL default '0',
`elemdmgtype` int(11) NOT NULL default '0',
`elemdmgamt` int(11) NOT NULL default '0',
`endur` int(11) NOT NULL default '0',
`factionamt1` int(11) NOT NULL default '0',
`factionamt2` int(11) NOT NULL default '0',
`factionamt3` int(11) NOT NULL default '0',
`factionamt4` int(11) NOT NULL default '0',
`factionmod1` int(11) NOT NULL default '0',
`factionmod2` int(11) NOT NULL default '0',
`factionmod3` int(11) NOT NULL default '0',
`factionmod4` int(11) NOT NULL default '0',
`filename` varchar(32) NOT NULL default '',
`focuseffect` int(11) NOT NULL default '0',
`fr` int(11) NOT NULL default '0',
`fvnodrop` int(11) NOT NULL default '0',
`haste` int(11) NOT NULL default '0',
`clicklevel` int(11) NOT NULL default '0',
`hp` int(11) NOT NULL default '0',
`regen` int(11) NOT NULL default '0',
`icon` int(11) NOT NULL default '0',
`idfile` varchar(30) NOT NULL default '',
`itemclass` int(11) NOT NULL default '0',
`itemtype` int(11) NOT NULL default '0',
`ldonprice` int(11) NOT NULL default '0',
`ldontheme` int(11) NOT NULL default '0',
`ldonsold` int(11) NOT NULL default '0',
`light` int(11) NOT NULL default '0',
`lore` varchar(80) NOT NULL default '',
`loregroup` int(11) NOT NULL default '0',
`magic` int(11) NOT NULL default '0',
`mana` int(11) NOT NULL default '0',
`manaregen` int(11) NOT NULL default '0',
`enduranceregen` int(11) NOT NULL default '0',
`material` int(11) NOT NULL default '0',
`maxcharges` int(11) NOT NULL default '0',
`mr` int(11) NOT NULL default '0',
`nodrop` int(11) NOT NULL default '0',
`norent` int(11) NOT NULL default '0',
`pendingloreflag` tinyint(3) unsigned NOT NULL default '0',
`pr` int(11) NOT NULL default '0',
`procrate` int(11) NOT NULL default '0',
`races` int(11) NOT NULL default '0',
`range` int(11) NOT NULL default '0',
`reclevel` int(11) NOT NULL default '0',
`recskill` int(11) NOT NULL default '0',
`reqlevel` int(11) NOT NULL default '0',
`sellrate` float NOT NULL default '0',
`shielding` int(11) NOT NULL default '0',
`size` int(11) NOT NULL default '0',
`skillmodtype` int(11) NOT NULL default '0',
`skillmodvalue` int(11) NOT NULL default '0',
`slots` int(11) NOT NULL default '0',
`clickeffect` int(11) NOT NULL default '0',
`spellshield` int(11) NOT NULL default '0',
`strikethrough` int(11) NOT NULL default '0',
`stunresist` int(11) NOT NULL default '0',
`summonedflag` tinyint(3) unsigned NOT NULL default '0',
`tradeskills` int(11) NOT NULL default '0',
`favor` int(11) NOT NULL default '0',
`weight` int(11) NOT NULL default '0',
`unknown002` int(11) NOT NULL default '0',
`unknown003` int(11) NOT NULL default '0',
`unknown005` int(11) NOT NULL default '0',
`unknown007` int(11) NOT NULL default '0',
`unknown018` int(11) NOT NULL default '0',
`unknown019` int(11) NOT NULL default '0',
`unknown020` int(11) NOT NULL default '0',
`UNK012` int(11) NOT NULL default '0',
`UNK013` int(11) NOT NULL default '0',
`benefitflag` int(11) NOT NULL default '0',
`unknown061` int(11) NOT NULL default '0',
`UNK054` int(11) NOT NULL default '0',
`unknown067` int(11) NOT NULL default '0',
`unknown069` int(11) NOT NULL default '0',
`UNK059` int(11) NOT NULL default '0',
`UNK061` int(11) NOT NULL default '0',
`unknown081` int(11) NOT NULL default '0',
`unknown105` int(11) NOT NULL default '0',
`booktype` int(11) NOT NULL default '0',
`unknown122` int(11) NOT NULL default '0',
`unknown123` varchar(11) NOT NULL default '0',
`unknown124` varchar(11) NOT NULL default '0',
`recastdelay` int(11) NOT NULL default '0',
`recasttype` int(11) NOT NULL default '0',
`guildfavor` int(11) NOT NULL default '0',
`unknown128` varchar(11) NOT NULL default '0',
`UNK123` int(11) NOT NULL default '0',
`UNK124` int(11) NOT NULL default '0',
`attuneable` int(11) NOT NULL default '0',
`nopet` int(11) NOT NULL default '0',
`unknown133` varchar(11) NOT NULL default '0',
`updated` datetime NOT NULL default '0000-00-00 00:00:00',
`comment` varchar(255) NOT NULL default '',
`UNK127` int(11) NOT NULL default '0',
`pointtype` int(11) NOT NULL default '0',
`potionbelt` int(11) NOT NULL default '0',
`potionbeltslots` int(11) NOT NULL default '0',
`stacksize` int(11) NOT NULL default '0',
`notransfer` int(11) NOT NULL default '0',
`stackable` int(11) NOT NULL default '0',
`UNK134` varchar(255) NOT NULL default '',
`UNK137` int(11) NOT NULL default '0',
`proceffect` int(11) NOT NULL default '0',
`proctype` int(11) NOT NULL default '0',
`proclevel2` int(11) NOT NULL default '0',
`proclevel` int(11) NOT NULL default '0',
`UNK142` int(11) NOT NULL default '0',
`worneffect` int(11) NOT NULL default '0',
`worntype` int(11) NOT NULL default '0',
`wornlevel2` int(11) NOT NULL default '0',
`wornlevel` int(11) NOT NULL default '0',
`UNK147` int(11) NOT NULL default '0',
`focustype` int(11) NOT NULL default '0',
`focuslevel2` int(11) NOT NULL default '0',
`focuslevel` int(11) NOT NULL default '0',
`UNK152` int(11) NOT NULL default '0',
`scrolleffect` int(11) NOT NULL default '0',
`scrolltype` int(11) NOT NULL default '0',
`scrolllevel2` int(11) NOT NULL default '0',
`scrolllevel` int(11) NOT NULL default '0',
`UNK157` int(11) NOT NULL default '0',
`serialized` datetime default NULL,
`verified` datetime default NULL,
`serialization` text,
`source` varchar(20) NOT NULL default '',
`UNK033` int(11) NOT NULL default '0',
`lorefile` varchar(32) NOT NULL default '',
`UNK014` int(11) NOT NULL default '0',
`svcorruption` int(11) NOT NULL default '0',
`UNK038` int(11) NOT NULL default '0',
`UNK060` int(11) NOT NULL default '0',
`augslot1unk2` int(11) NOT NULL default '0',
`augslot2unk2` int(11) NOT NULL default '0',
`augslot3unk2` int(11) NOT NULL default '0',
`augslot4unk2` int(11) NOT NULL default '0',
`augslot5unk2` int(11) NOT NULL default '0',
`UNK098` int(11) NOT NULL default '0',
`UNK109` int(11) NOT NULL default '0',
`UNK120` int(11) NOT NULL default '0',
`UNK121` int(11) NOT NULL default '0',
`questitemflag` int(11) NOT NULL default '0',
`UNK131` int(11) NOT NULL default '0',
`UNK132` text NOT NULL,
`clickunk5` int(11) NOT NULL default '0',
`clickunk6` varchar(32) NOT NULL default '',
`clickunk7` int(11) NOT NULL default '0',
`procunk1` int(11) NOT NULL default '0',
`procunk2` int(11) NOT NULL default '0',
`procunk3` int(11) NOT NULL default '0',
`procunk4` int(11) NOT NULL default '0',
`procunk6` varchar(32) NOT NULL default '',
`procunk7` int(11) NOT NULL default '0',
`wornunk1` int(11) NOT NULL default '0',
`wornunk2` int(11) NOT NULL default '0',
`wornunk3` int(11) NOT NULL default '0',
`wornunk4` int(11) NOT NULL default '0',
`wornunk5` int(11) NOT NULL default '0',
`wornunk6` varchar(32) NOT NULL default '',
`wornunk7` int(11) NOT NULL default '0',
`focusunk1` int(11) NOT NULL default '0',
`focusunk2` int(11) NOT NULL default '0',
`focusunk3` int(11) NOT NULL default '0',
`focusunk4` int(11) NOT NULL default '0',
`focusunk5` int(11) NOT NULL default '0',
`focusunk6` varchar(32) NOT NULL default '',
`focusunk7` int(11) NOT NULL default '0',
`scrollunk1` int(11) NOT NULL default '0',
`scrollunk2` int(11) NOT NULL default '0',
`scrollunk3` int(11) NOT NULL default '0',
`scrollunk4` int(11) NOT NULL default '0',
`scrollunk5` int(11) NOT NULL default '0',
`scrollunk6` varchar(32) NOT NULL default '',
`scrollunk7` int(11) NOT NULL default '0',
`UNK193` int(11) NOT NULL default '0',
`purity` int(11) NOT NULL default '0',
`evolvinglevel` int(11) NOT NULL default '0',
`UNK129` int(11) NOT NULL default '0',
`clickname` varchar(64) NOT NULL default '',
`procname` varchar(64) NOT NULL default '',
`wornname` varchar(64) NOT NULL default '',
`focusname` varchar(64) NOT NULL default '',
`scrollname` varchar(64) NOT NULL default '',
`dsmitigation` smallint(6) NOT NULL default '0',
`heroic_str` smallint(6) NOT NULL default '0',
`heroic_int` smallint(6) NOT NULL default '0',
`heroic_wis` smallint(6) NOT NULL default '0',
`heroic_agi` smallint(6) NOT NULL default '0',
`heroic_dex` smallint(6) NOT NULL default '0',
`heroic_sta` smallint(6) NOT NULL default '0',
`heroic_cha` smallint(6) NOT NULL default '0',
`heroic_pr` smallint(6) NOT NULL default '0',
`heroic_dr` smallint(6) NOT NULL default '0',
`heroic_fr` smallint(6) NOT NULL default '0',
`heroic_cr` smallint(6) NOT NULL default '0',
`heroic_mr` smallint(6) NOT NULL default '0',
`heroic_svcorrup` smallint(6) NOT NULL default '0',
`healamt` smallint(6) NOT NULL default '0',
`spelldmg` smallint(6) NOT NULL default '0',
`clairvoyance` smallint(6) NOT NULL default '0',
`backstabdmg` smallint(6) NOT NULL default '0',
`created` varchar(64) NOT NULL default '',
`elitematerial` smallint(6) NOT NULL default '0',
`ldonsellbackrate` smallint(6) NOT NULL default '0',
`scriptfileid` smallint(6) NOT NULL default '0',
`expendablearrow` smallint(6) NOT NULL default '0',
`powersourcecapacity` smallint(6) NOT NULL default '0',
`bardeffect` smallint(6) NOT NULL default '0',
`bardeffecttype` smallint(6) NOT NULL default '0',
`bardlevel2` smallint(6) NOT NULL default '0',
`bardlevel` smallint(6) NOT NULL default '0',
`bardunk1` smallint(6) NOT NULL default '0',
`bardunk2` smallint(6) NOT NULL default '0',
`bardunk3` smallint(6) NOT NULL default '0',
`bardunk4` smallint(6) NOT NULL default '0',
`bardunk5` smallint(6) NOT NULL default '0',
`bardname` varchar(64) NOT NULL default '',
`bardunk7` smallint(6) NOT NULL default '0',
`UNK214` smallint(6) NOT NULL default '0',
UNIQUE KEY `ID` (`id`),
KEY `name_idx` (`Name`),
KEY `lore_idx` (`lore`),
KEY `minstatus` (`minstatus`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

***Item im sourcing in**

INSERT INTO `items` (`id`, `minstatus`, `Name`, `aagi`, `ac`, `accuracy`, `acha`, `adex`, `aint`, `artifactflag`, `asta`, `astr`, `attack`, `augrestrict`, `augslot1type`, `augslot1visible`, `augslot2type`, `augslot2visible`, `augslot3type`, `augslot3visible`, `augslot4type`, `augslot4visible`, `augslot5type`, `augslot5visible`, `augtype`, `avoidance`, `awis`, `bagsize`, `bagslots`, `bagtype`, `bagwr`, `banedmgamt`, `banedmgraceamt`, `banedmgbody`, `banedmgrace`, `bardtype`, `bardvalue`, `book`, `casttime`, `casttime_`, `charmfile`, `charmfileid`, `classes`, `color`, `combateffects`, `extradmgskill`, `extradmgamt`, `price`, `cr`, `damage`, `damageshield`, `deity`, `delay`, `augdistiller`, `dotshielding`, `dr`, `clicktype`, `clicklevel2`, `elemdmgtype`, `elemdmgamt`, `endur`, `factionamt1`, `factionamt2`, `factionamt3`, `factionamt4`, `factionmod1`, `factionmod2`, `factionmod3`, `factionmod4`, `filename`, `focuseffect`, `fr`, `fvnodrop`, `haste`, `clicklevel`, `hp`, `regen`, `icon`, `idfile`, `itemclass`, `itemtype`, `ldonprice`, `ldontheme`, `ldonsold`, `light`, `lore`, `loregroup`, `magic`, `mana`, `manaregen`, `enduranceregen`, `material`, `maxcharges`, `mr`, `nodrop`, `norent`, `pendingloreflag`, `pr`, `procrate`, `races`, `range`, `reclevel`, `recskill`, `reqlevel`, `sellrate`, `shielding`, `size`, `skillmodtype`, `skillmodvalue`, `slots`, `clickeffect`, `spellshield`, `strikethrough`, `stunresist`, `summonedflag`, `tradeskills`, `favor`, `weight`, `unknown002`, `unknown003`, `unknown005`, `unknown007`, `unknown018`, `unknown019`, `unknown020`, `UNK012`, `UNK013`, `benefitflag`, `unknown061`, `UNK054`, `unknown067`, `unknown069`, `UNK059`, `UNK061`, `unknown081`, `unknown105`, `booktype`, `unknown122`, `unknown123`, `unknown124`, `recastdelay`, `recasttype`, `guildfavor`, `unknown128`, `UNK123`, `UNK124`, `attuneable`, `nopet`, `unknown133`, `updated`, `comment`, `UNK127`, `pointtype`, `potionbelt`, `potionbeltslots`, `stacksize`, `notransfer`, `stackable`, `UNK134`, `UNK137`, `proceffect`, `proctype`, `proclevel2`, `proclevel`, `UNK142`, `worneffect`, `worntype`, `wornlevel2`, `wornlevel`, `UNK147`, `focustype`, `focuslevel2`, `focuslevel`, `UNK152`, `scrolleffect`, `scrolltype`, `scrolllevel2`, `scrolllevel`, `UNK157`, `serialized`, `verified`, `serialization`, `source`, `UNK033`) VALUES
(556, 0, 'Antheks Stone of Godly Sight', 15, 34, 3, 25, 16, 25, 0, 15, 15, 35, 0, 0, 1, 0, 1, 0, 1, 0, 1, 0, 1, 128, 0, 25, 0, 0, 0, 0, 0, 0, 0, 0, 51, 32, 0, -1, -1, '', '', 65535, 0, '0', 0, 0, 0, 0, 0, 0, 0, 0, 186, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 1450, 0, 948, 'IT63', 0, 54, 0, 0, 0, 0, 'Augment of Ring Events', 0, 1, 0, 0, 0, 0, -1, 0, 0, 255, 0, 0, 0, 32767, 0, 0, 0, 65, 0, 0, 0, 0, 0, 2097150, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', '0', 0, 0, 0, '0', 0, 0, 0, 0, '0', '0000-00-00 00:00:00', '', 0, 0, 0, 0, 20, 0, 0, '00000000000000000000000000000000000000', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'KingMort', 0);

Burningsoul · #5 03-14-2010, 06:04 AM

I'm also getting this error while attempting to load raid bots in the Item Editor using AX_Classic's repack. Both are updated to the newest versions. It works perfectly using the PEQ database, I'm just unsure of what to look for in the tables.. anyone willing to share some insight?

**GeorgeS** · #6 03-14-2010, 11:22 AM

Not sure about AX database, but I am thinking about a check compatibility button - that checks what I expect in the table vs. what your table has.

Might make troubleshooting easier.

GeorgeS

**GeorgeS** · #7 03-14-2010, 12:32 PM

Regarding the above, the error for the "Antheks Stone of Godly Sight" that mastajon posted is due to the 'updated' and other date fields with
'0000-00-00 00:00:00' where you should use a date like '2009-08-25 14:30:06' instead. This will prevent these errors in the future

GeorgeS

**bad_captain** · #8 08-27-2010, 04:43 PM

Quote:

Originally Posted by Burningsoul

I'm also getting this error while attempting to load raid bots in the Item Editor using AX_Classic's repack. Both are updated to the newest versions. It works perfectly using the PEQ database, I'm just unsure of what to look for in the tables.. anyone willing to share some insight?

I am also getting this error while trying to load raid bots, but I am using peq. I have double checked my bot tables vs. what is in the newest peq db revision, and haven't found anything different. One thing I can say is that the bots were imported from another database on my PC (moved to separate a server), and this is when the problem came up. I noticed that the bot creation date was listed as '0000-00-00 00:00:00' , so I changed them to a valid date, but I am still getting these errors. I downloaded your source files, but am unable to upgrade to VB .NET 2003 or 2008, as it says there are files missing, etc. I was hoping to do some debugging on my own.

When eqitems loads, I can edit my character's inventory, but when I click on the Load Raid Bots button, I receive the above mentioned error:
run-time error '-214767259 (80004005)';
data provider or other service returned an E_FAIL status.

This occurs when it is just trying to load the list of bots to edit the inventory for. I looked through the code, and it didn't seem like too much was happening before the bots list form comes up, just loading the races, classes, etc, then loading the bots names and such. Not sure where the problem would be.

**Akkadius** · #9 08-27-2010, 07:21 PM

Using this SQL will clear those issues up:

Code:

UPDATE items set UNK132 = '0000000000000000000';
UPDATE items SET verified = '2010-06-01 16:08:42';
UPDATE items SET updated = '2010-06-01 16:08:42';
UPDATE items SET serialized = '2010-06-01 16:08:42';

**GeorgeS** · #10 08-28-2010, 03:22 PM

That's the correct fix.

Sometimes blank 000's in the date fields causes data corruption in VB, and it just about impossible to fix in code. You just have to update the database as mentioned.

GeorgeS

**bad_captain** · #11 08-28-2010, 03:31 PM

I ran those updates, as well as one to fix my Bot Created Date problem, but was still giving the error.

I'll check to see if any other tables might be having the same problem, but since I am able to edit my gear, but not my bots, I'm assuming it has to do with one of those tables. I can't even get to try to edit any bot's gear, as I can't load the form to select my bot. I'm sure there's something on my end I'm just missing, but I sure wish I could outfit my bots without having to actually start up my server and log in.. lol

**GeorgeS** · #12 08-28-2010, 06:22 PM

I would re-do the bot tables. Drop all and rdo
Here are the tables:
I have to say the r1589 database was used in my latest testing, and it all works great. If your'e still having issues then let me know -

source c:/mysql/bin/r1589/player_tables/botguildmembers.sql;
source c:/mysql/bin/r1589/player_tables/bots.sql;
source c:/mysql/bin/r1589/player_tables/botpetstatepersists.sql;
source c:/mysql/bin/r1589/player_tables/botinventory.sql;
source c:/mysql/bin/r1589/player_tables/botbuffs.sql;
source c:/mysql/bin/r1589/player_tables/botadventuring.sql;
source c:/mysql/bin/r1589/player_tables/botgroups.sql;

GeorgeS