PDA

View Full Version : eqitems editor error


mastajon
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
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
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
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
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
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
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
08-27-2010, 04:43 PM
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
08-27-2010, 07:21 PM
Using this SQL will clear those issues up:


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
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
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
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