These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
123Next pageLast page
 

Retribution 1.0 SDE Issues (CCPPrismX twitt version)

First post
Author
Previous Topic Next Topic
Desmont McCallock
#1 - 2012-12-05 19:33:58 UTC  |  Edited by: CCP Prism X
Please post here any issues found with Retribution 1.0 Static Data Export.

CCP Prism X Ninja Edits
Known Issues:

  • Missing names in invTypes (Fix: Dont ship broken types with SDE)
  • Spelling errors in invMarketGroups (Fix: Have content fix spelling errors before regenerating SDE)
  • Broken relationships in invMarketGroups (Fix: Dont ship broken types with SDE)


Non-Issues:

  • iconIDs in invTypes are wrong (They are no longer included in that table. I will remove it to avoid the confusion but there should be new YAML files there with the typeID, iconID relationships. If they're not I´ll have to fix that as well.. I dont have access to the local SDE drive at the moment so I don't know Ugh)


New SDE, probably with new bugs in it!Cool
ItsmeHcK1
Immortalis Inc.
Shadow Cartel
#2 - 2012-12-05 19:40:44 UTC
Some types in the invTypes table have NULL as a name. I don't recall this being the case in Inferno.
Either way, broke my data exporter for a while until I figured it out. Sad
Desmont McCallock
#3 - 2012-12-05 19:41:02 UTC  |  Edited by: Desmont McCallock
So I found some time today to fetch the SDE from CCP's PrismX twitt. And I tried to create EVEMon's data files. Little did I know that my attempt would end up in disaster.

So here's what I have found so far.

- Spelling errors in invMarketGroups for ids: 1688, 1689, 1691 "Aplifiers" instead of "Amplifiers".
- In same table ids: 1688,1689,1690,1691 have as parentGroupID id:550 "Shield Resistance Amplifiers" but that entry is nowhere to be found in the table.
- In same table id:779 "Fleet Assistance Modules" is missing, required for ids: 1638,1639,1640,1641,1642 as ParentGroupID.

I'll will update the post with any new findings.
Vessper
Dark Mason Society
#4 - 2012-12-05 20:15:20 UTC  |  Edited by: Vessper
The invMarketGroups table also has parentGroupID entries for 1610, 1625, 1626, 1627 and 1633, all of which don't exist as marketGroupIDs. The first four of those are racial subsystems and the last is for ganglinks.

In addition, item types which have new icons ingame don't have the correct iconID in the invTypes table - they still point to the old icons. This is mainly for shield/armor hardeners/resist amps, the Large Micro Jump Drive and the orbital bombardment ammo.
Quantix BlackStar
Blackstar Solutions Inc.
#5 - 2012-12-05 21:51:30 UTC
The 'Fleet Assistance Modules' market group (listed as groupId 799 in the SDE), has no sub groups so ganglinks, portal generators, etc are in groups that do not exist currently.

EveHQ is a multi-faceted character application for EVE Online. Includes pilot monitoring, skill queue planning, ship fitting, industry and more. Get the latest version at http://evehq.net
Desmont McCallock
#6 - 2012-12-05 21:53:53 UTC
Lets face it. This SDE is a bust.
Louis Vitton
Viziam
Amarr Empire
#7 - 2012-12-06 05:25:30 UTC
I am hanging out for them to re-release it with fixes
CCP Prism X
C C P
C C P Alliance
#8 - 2012-12-06 08:50:49 UTC
Sorry for that guys.
In my defense I no longer maintain the SDE code nor have anything to do with its generation. I just knew people would want to get their hands on it ASAP so I Tweeted it.

But I think the new SDE guy might be busy with post expansion fallout. I'll poke at him and if he is I'll just get stuff sorted myself. Blink

CCP Prism X

Programmer on Team Gridlock & Expert Ranter
CCP Prism X
C C P
C C P Alliance
#9 - 2012-12-06 11:23:27 UTC
Quantix BlackStar wrote:
The 'Fleet Assistance Modules' market group (listed as groupId 799 in the SDE), has no sub groups so ganglinks, portal generators, etc are in groups that do not exist currently.


Not sure what you mean. Group 799 is a hasTypes=1 group so subgroups are not to be expected. Instead there are types in invTypes that have a marketGroupID of 799. Am I misunderstanding something?

CCP Prism X

Programmer on Team Gridlock & Expert Ranter
Muscaat
EVE Markets
#10 - 2012-12-06 12:09:00 UTC
CCP Prism X wrote:
Quantix BlackStar wrote:
The 'Fleet Assistance Modules' market group (listed as groupId 799 in the SDE), has no sub groups so ganglinks, portal generators, etc are in groups that do not exist currently.


Not sure what you mean. Group 799 is a hasTypes=1 group so subgroups are not to be expected. Instead there are types in invTypes that have a marketGroupID of 799. Am I misunderstanding something?


799 is present and correct AFAICT; it's the group for blueprints of items that live in subgroups of the missing 779.
CCP Prism X
C C P
C C P Alliance
#11 - 2012-12-06 12:34:05 UTC
Muscaat wrote:
CCP Prism X wrote:
Quantix BlackStar wrote:
The 'Fleet Assistance Modules' market group (listed as groupId 799 in the SDE), has no sub groups so ganglinks, portal generators, etc are in groups that do not exist currently.


Not sure what you mean. Group 799 is a hasTypes=1 group so subgroups are not to be expected. Instead there are types in invTypes that have a marketGroupID of 799. Am I misunderstanding something?


799 is present and correct AFAICT; it's the group for blueprints of items that live in subgroups of the missing 779.


Ah! Now we're talking!

CCP Prism X

Programmer on Team Gridlock & Expert Ranter
Zifrian
The Frog Pond
Ribbit.
#12 - 2012-12-06 15:02:43 UTC
All I've found so far is these two typeId's in the invTypes table that don't have typeNames or any other data - 32894,351611. First one seems to be some sort of celestial (from the icon), not sure on the other.

Maximze your Industry Potential! - Download EVE Isk per Hour!

Import CCP's SDE - EVE SDE Database Builder
Quantix BlackStar
Blackstar Solutions Inc.
#13 - 2012-12-06 17:47:41 UTC
CCP Prism X wrote:
Quantix BlackStar wrote:
The 'Fleet Assistance Modules' market group (listed as groupId 799 in the SDE), has no sub groups so ganglinks, portal generators, etc are in groups that do not exist currently.


Not sure what you mean. Group 799 is a hasTypes=1 group so subgroups are not to be expected. Instead there are types in invTypes that have a marketGroupID of 799. Am I misunderstanding something?


whoops...my mistake on that. I was trying to find where the ganglink items group information was in the group tree (and where the break was), and got that crossed with the blueprint group.

EveHQ is a multi-faceted character application for EVE Online. Includes pilot monitoring, skill queue planning, ship fitting, industry and more. Get the latest version at http://evehq.net
Louis Vitton
Viziam
Amarr Empire
#14 - 2012-12-07 04:52:41 UTC
CCP Prism X wrote:

But I think the new SDE guy might be busy with post expansion fallout. I'll poke at him and if he is I'll just get stuff sorted myself. Blink


Cheers for this mate.
Artem Valiant
NecroRise Squadron
Galaxy Spiritus
#15 - 2012-12-07 06:58:53 UTC  |  Edited by: Artem Valiant
I exported invMarketGroups table from the game client. It contains the missing market groups.
http://dl.eve-files.com/media/1212/invMarketGroups.sql.zip
Strangely, it also contains a spelling error.
CCP Prism X
C C P
C C P Alliance
#16 - 2012-12-07 08:28:26 UTC
Just checking in so nobody thinks I forgot about you.

Yesterday was quite intensive on meetings with regards to going over the deployment, the development cycle leading up to it and starting to line up our ducks for the next cycle. In between those I was looking at the SDE (and other things) and I'm pretty confident I'll be done with it by noon GMT.

I'll try and shanghai some people into releasing it ASAP and post the new link here as well as twitter.

CCP Prism X

Programmer on Team Gridlock & Expert Ranter
Desmont McCallock
#17 - 2012-12-07 08:30:57 UTC
CCP Prism X wrote:
Just checking in so nobody thinks I forgot about you.

Yesterday was quite intensive on meetings with regards to going over the deployment, the development cycle leading up to it and starting to line up our ducks for the next cycle. In between those I was looking at the SDE (and other things) and I'm pretty confident I'll be done with it by noon GMT.

I'll try and shanghai some people into releasing it ASAP and post the new link here as well as twitter.

Any news is good news.
CCP Prism X
C C P
C C P Alliance
#18 - 2012-12-07 11:13:58 UTC
Lluerssen
PHUB Corporation
#19 - 2012-12-07 11:50:54 UTC
New invTypes: 16593
Old invTypes: 20186

is this ok?

Sister of EvE: http://SisterOfEvE.ru/ Loot History Analyzer: http://SisterOfEvE.ru/loot_history/
CCP Prism X
C C P
C C P Alliance
#20 - 2012-12-07 11:57:39 UTC
Hmm, not 100% sure atm but it sure does look like something got sanitized out of the types that shouldn't have. I'll beat at it with a stick for a while and see what happens.

CCP Prism X

Programmer on Team Gridlock & Expert Ranter
123Next pageLast page