EVE Search - Retribution 1.0 SDE Issues

Check My IP Information

All Channels

EVE Technology Lab

Retribution 1.0 SDE Issues

» Click here to find additional results for this topic using Google

Monitor this thread via RSS [?]

Pages: [1] 2 3 :: one page

Author	Thread Statistics \| Show CCP posts - 16 post(s)
Desmont McCallock 223	Posted - 2012.12.05 19:33:00 - [1] - Quote Please post here any issues found with Retribution 1.0 Static Data Export.
ItsmeHcK1 Burning Napalm Northern Coalition. 35	Posted - 2012.12.05 19:40:00 - [2] - Quote 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.
Desmont McCallock 223	Posted - 2012.12.05 19:41:00 - [3] - Quote 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 but that id number is nowhere to be found in the table. I'll will update the post with any new founding.
Vessper Indicium Technologies 17	Posted - 2012.12.05 20:15:00 - [4] - Quote 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 The Praxis Initiative Gentlemen's Agreement 3	Posted - 2012.12.05 21:51:00 - [5] - Quote 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. Lead Developer for EveHQ: http://www.evehq.net
Desmont McCallock 223	Posted - 2012.12.05 21:53:00 - [6] - Quote Lets face it. This SDE is a bust.
Louis Vitton Jita Trade and Industry 20	Posted - 2012.12.06 05:25:00 - [7] - Quote I am hanging out for them to re-release it with fixes

CCP Prism X C C P C C P Alliance 1005	Posted - 2012.12.06 08:50:00 - [8] - Quote 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. @CCP_PrismX EVE Database Developer and Expert Ranter Member of Team Pony Express


CCP Prism X C C P C C P Alliance 1006	Posted - 2012.12.06 11:23:00 - [9] - Quote 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_PrismX EVE Database Developer and Expert Ranter Member of Team Pony Express

Muscaat EVE Markets 12	Posted - 2012.12.06 12:09:00 - [10] - Quote 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 1006	Posted - 2012.12.06 12:34:00 - [11] - Quote 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_PrismX EVE Database Developer and Expert Ranter Member of Team Pony Express

Zifrian Licentia Ex Vereor Intrepid Crossing 439	Posted - 2012.12.06 15:02:00 - [12] - Quote 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! - Get EVE Isk per Hour!
Quantix BlackStar The Praxis Initiative Gentlemen's Agreement 3	Posted - 2012.12.06 17:47:00 - [13] - Quote 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. Lead Developer for EveHQ: http://www.evehq.net
Louis Vitton Jita Trade and Industry 20	Posted - 2012.12.07 04:52:00 - [14] - Quote 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. Cheers for this mate.
Artem Valiant NecroRise Squadron 17	Posted - 2012.12.07 06:58:00 - [15] - Quote 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 1010	Posted - 2012.12.07 08:28:00 - [16] - Quote 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_PrismX EVE Database Developer and Expert Ranter Member of Team Pony Express

Desmont McCallock 227	Posted - 2012.12.07 08:30:00 - [17] - Quote 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 1011	Posted - 2012.12.07 11:13:00 - [18] - Quote New SDE, probably with new bugs in it! @CCP_PrismX EVE Database Developer and Expert Ranter Member of Team Pony Express

Lluerssen Finaka Industrial Group Ouroboros Group 5	Posted - 2012.12.07 11:50:00 - [19] - Quote New invTypes: 16593 Old invTypes: 20186 is this ok? Sister of EvE: http://eve.bubonicpestilence.ru/ Loot History Analyzer:-áhttp://eve.bubonicpestilence.ru/loot_history/

CCP Prism X C C P C C P Alliance 1011	Posted - 2012.12.07 11:57:00 - [20] - Quote 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_PrismX EVE Database Developer and Expert Ranter Member of Team Pony Express


Lluerssen Finaka Industrial Group Ouroboros Group 5	Posted - 2012.12.07 11:59:00 - [21] - Quote http://cl.ly/1308150r0p1E Removed invTypes, omg -.- > SELECT count(*) FROM `invTypes` WHERE typeName LIKE '%blueprint%'; 3053 vs 112 Sister of EvE: http://eve.bubonicpestilence.ru/ Loot History Analyzer:-áhttp://eve.bubonicpestilence.ru/loot_history/

CCP Prism X C C P C C P Alliance 1011	Posted - 2012.12.07 12:01:00 - [22] - Quote Yeah I accidentally put an inner join on the description, change log clearly states that was a mistake. Gimmie a few moments. @CCP_PrismX EVE Database Developer and Expert Ranter Member of Team Pony Express

Vessper Indicium Technologies 18	Posted - 2012.12.07 12:07:00 - [23] - Quote mapSolarSystems has no rows in the new SDE?

CCP Prism X C C P C C P Alliance 1011	Posted - 2012.12.07 12:10:00 - [24] - Quote Vessper wrote: mapSolarSystems has no rows in the new SDE? Dunno about the broken one I generated but the one I'm uploading now seems cool: SELECT COUNT() FROM mapSolarSystems 7929 (1 row(s) affected) @CCP_PrismX* EVE Database Developer and Expert Ranter Member of Team Pony Express

Vessper Indicium Technologies 18	Posted - 2012.12.07 12:12:00 - [25] - Quote Yes, it was the one released an hour or so ago.

CCP Prism X C C P C C P Alliance 1011	Posted - 2012.12.07 12:19:00 - [26] - Quote Yeah that makes sense. The sun types do not have a description authored. Therefore they did not get dumped into the types table, and thus all solar systems were removed as they have a sunTypeID authored and all sun types were deleted. However: New fixedfixed version uploaded to same addy and CDN cache purged. That's attempt two, I'm aiming for "Third time's the charm!" though! @CCP_PrismX EVE Database Developer and Expert Ranter Member of Team Pony Express

Vessper Indicium Technologies 18	Posted - 2012.12.07 12:51:00 - [27] - Quote The eveUnits table is missing unitIDs 103, 122 and 129, and 122 is used by many of the attributes (103 and 129 appear unused). The only thing I can see that these have in common is that the unit display name is null (or was at least in the Inferno SDE). It's easy to add that one line in manually but just thought I'd raise the issue anyway.
Vessper Indicium Technologies 18	Posted - 2012.12.07 13:19:00 - [28] - Quote The dgmAttributeTypes table is missing attributes for the low, mid, hi and rig slots of a ship (IDs 12,13,14,1137) and the dgmTypeAttributes table is missing all entries containing these IDs. Not sure if it's related to the above bearing in mind unitID 122 is "Fitting Slots".

CCP Prism X C C P C C P Alliance 1012	Posted - 2012.12.07 13:21:00 - [29] - Quote Probably is. And this is why we should be releasing the SDE before deploying the expansion. I'm going to wait for some more issues to crop up before generating another one. @CCP_PrismX EVE Database Developer and Expert Ranter Member of Team Pony Express

Sidrat Flush Low Sec Pharmacies 21	Posted - 2012.12.07 13:23:00 - [30] - Quote When the tables are converted to yaml will errors be easier or harder to spot? I am not my skill points but http://eveboard.com/pilot/Sidrat_Flush



Pages: [1] 2 3 :: one page
First page \| Previous page \| Next page \| Last page

COPYRIGHT NOTICE
EVE Online, the EVE logo, EVE and all associated logos and designs are the intellectual property of CCP hf. All artwork, screenshots, characters, vehicles, storylines, world facts or other recognizable features of the intellectual property relating to these trademarks are likewise the intellectual property of CCP hf. EVE Online and the EVE logo are the registered trademarks of CCP hf. All rights are reserved worldwide. All other trademarks are the property of their respective owners. CCP hf. has granted permission to EVE-Search.com to use EVE Online and all associated logos and designs for promotional and information purposes on its website but does not endorse, and is not in any way affiliated with, EVE-Search.com. CCP is in no way responsible for the content on or functioning of this website, nor can it be liable for any damage arising from the use of this website.