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.
 

Retribution 1.0 SDE Issues (CCPPrismX twitt version)

First post
Author
Previous Topic Next Topic
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#61 - 2012-12-18 18:04:58 UTC
dgmEffects and dgmTypeEffects appear to be truncated from what they had on the first export for retribution.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Desmont McCallock
#62 - 2012-12-18 20:28:33 UTC  |  Edited by: Desmont McCallock
Supplemental to Steve's post.
dgmEffects -> Inferno SDE: 2934 lines, Retribution SDE: 101 lines
dgmTypeEffects -> Inferno SDE: 34184 lines, Retribution SDE: 7332 lines

Edit: This issue doesn't affect us much in EVEMon data files generation, as we use the dgmTypeEffects table only to determine the slot usage, I can say that a new EVEMon version with updated data files is on its way.
Quantix BlackStar
Blackstar Solutions Inc.
#63 - 2012-12-18 23:06:05 UTC
Desmont McCallock wrote:
Supplemental to Steve's post.
dgmEffects -> Inferno SDE: 2934 lines, Retribution SDE: 101 lines
dgmTypeEffects -> Inferno SDE: 34184 lines, Retribution SDE: 7332 lines

Edit: This issue doesn't affect us much in EVEMon data files generation, as we use the dgmTypeEffects table only to determine the slot usage, I can say that a new EVEMon version with updated data files is on its way.


EveHQ uses these tables in its Item Browser and Fitting modules. In my ad-hoc testing that I've been doing with fits today, I have not run into a noticeable issue, but it would be nice to have some explanations of the removals if only for clarification.

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
Cielle Tische
Who Armed the Carebears
#64 - 2012-12-18 23:24:31 UTC
EVEIDB uses these tables for item display.

Tables used in Inferno:
[AGT]
agtagents
agtagenttypes
agtresearchagents
[CHR]
chrancestries
chrattributes
chrbloodlines
chrfactions
chrraces
[CRP]
crpactivities
crpnpccorporationdivisions
crpnpccorporationresearchfields
crpnpccorporations
crpnpccorporationtrades
crpnpcdivisions
[CRT]
crtcategories
crtcertificates
crtclasses
crtrecommendations
crtrelationships
[DMG]
dgmattributecategories
dgmattributetypes
dgmeffects
dgmtypeattributes
dgmtypeeffects
[INV]
invblueprinttypes
invcategories
invcontrabandtypes
invcontroltowerresourcepurposes
invcontroltowerresources
invflags
invgroups
invitems
invmarketgroups
invmetagroups
invmetatypes
invnames
invpositions
invtypematerials
invtypereactions
invtypes
invuniquenames
[MAP]
mapcelestialstatistics
mapconstellationjumps
mapconstellations
mapdenormalize
mapjumps
maplandmarks
maplocationscenes
maplocationwormholeclasses
mapregionjumps
mapregions
mapsolarsystemjumps
mapsolarsystems
mapuniverse
[PLN]
planetinteraction
planetschematics
planetschematicspinmap
planetschematicstypemap
[RAM]
ramactivities
ramassemblylines
ramassemblylinestations
ramassemblylinetypedetailpercategory
ramassemblylinetypedetailpergroup
ramassemblylinetypes
raminstallationtypecontents
ramtyperequirements
[OTHER]
eveunits
eveicons


Those are the SDE tables we use to generate pages. Also, we use MySQL, instead of MSSQL, and we avoid YAML like it's cursed with instant death. Guess I get to figure out how to convert the YAML Icon tables into MySQL from here on out instead of them just being left where they were >.>

Developer of www.eveidb.com - Relational EVE database! [Still under construction]
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#65 - 2012-12-18 23:30:40 UTC
Cielle Tische wrote:
EVEIDB uses these tables for item display.

Tables used in Inferno:
[AGT]
agtagents
agtagenttypes
agtresearchagents
[CHR]
chrancestries
chrattributes
chrbloodlines
chrfactions
chrraces
[CRP]
crpactivities
crpnpccorporationdivisions
crpnpccorporationresearchfields
crpnpccorporations
crpnpccorporationtrades
crpnpcdivisions
[CRT]
crtcategories
crtcertificates
crtclasses
crtrecommendations
crtrelationships
[DMG]
dgmattributecategories
dgmattributetypes
dgmeffects
dgmtypeattributes
dgmtypeeffects
[INV]
invblueprinttypes
invcategories
invcontrabandtypes
invcontroltowerresourcepurposes
invcontroltowerresources
invflags
invgroups
invitems
invmarketgroups
invmetagroups
invmetatypes
invnames
invpositions
invtypematerials
invtypereactions
invtypes
invuniquenames
[MAP]
mapcelestialstatistics
mapconstellationjumps
mapconstellations
mapdenormalize
mapjumps
maplandmarks
maplocationscenes
maplocationwormholeclasses
mapregionjumps
mapregions
mapsolarsystemjumps
mapsolarsystems
mapuniverse
[PLN]
planetinteraction
planetschematics
planetschematicspinmap
planetschematicstypemap
[RAM]
ramactivities
ramassemblylines
ramassemblylinestations
ramassemblylinetypedetailpercategory
ramassemblylinetypedetailpergroup
ramassemblylinetypes
raminstallationtypecontents
ramtyperequirements
[OTHER]
eveunits
eveicons


Those are the SDE tables we use to generate pages. Also, we use MySQL, instead of MSSQL, and we avoid YAML like it's cursed with instant death. Guess I get to figure out how to convert the YAML Icon tables into MySQL from here on out instead of them just being left where they were >.>


http://sumanrs.wordpress.com/2012/02/23/yaml-to-mysql-yaml2sql-script-in-php/ may be of interest to you.

(mysql version available from another post of mine)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Dei
Cosmic Core Industries
#66 - 2012-12-18 23:54:55 UTC
It's not too bad that it's in YAML. It is strange that the official way of converting the MSSQL backup is to do one table per expansion...

There are a crap load of YAML to XXX converters available on their main website, so it shouldn't be too hard to integrate it into your program/app. I do wish CCP would either convert the entire lot to YAML or continue with a DB backup until it's all done though.
CCP Prism X
C C P
C C P Alliance
#67 - 2012-12-19 09:40:01 UTC
Fixing stools!

I'm going on vacation after tomorrow, Thursday the 20th of December. That means if there are more issues after tomorrow they will not get fixed until 2013. I'm going carefully over all the joins I added to ensure that no further data is lost from the first update to remove the nameless records. Hopefully there will be no further issues with that specific change.

But if there's anything other broken, the window to report it is getting slimmer by the minute. Blink

CCP Prism X

Programmer on Team Gridlock & Expert Ranter
CCP Prism X
C C P
C C P Alliance
#68 - 2012-12-19 11:26:53 UTC
Dei
Cosmic Core Industries
#69 - 2012-12-19 11:35:25 UTC
Did anyone tell you how awesome you are?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#70 - 2012-12-19 13:46:21 UTC
https://forums.eveonline.com/default.aspx?g=posts&t=184575

In case anyone wants converted versions

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Desmont McCallock
#71 - 2012-12-19 14:34:36 UTC
SDE looks OK now. Concurring, CCP Prism X all time favorite CCP.

@CCP PrismX
Still your #2 fan. (For those who don't know, Karbowiak is #1).
Lors Dornick
Kallisti Industries
#72 - 2012-12-19 15:59:48 UTC
Dei wrote:
Did anyone tell you how awesome you are?

Shush, don't tell him!

Keep it a secret and hope that he'll work even harder ;)

CCP Greyscale: As to starbases, we agree it's pretty terrible, but we don't want to delay the entire release just for this one factor.
Jercy Fravowitz
School of Applied Knowledge
Caldari State
#73 - 2012-12-19 17:34:39 UTC
Desmont McCallock wrote:
SDE looks OK now. Concurring, CCP Prism X all time favorite CCP.

  1. you call that OK? pah. it is totally missing the entry for 500021 in chrFactions. dont you people have real databases with proper FKs?!

  2. i kinda agree. he is definetly among the top 5 devs. though he was cuter when he was even younger.

  3. time to hide somewhere.

  4. oh, yeah.

  5. my favorite part of this thread is the part with the feedback about the lack of evemon updates, and the suggested workaround/fix. that would sure work. *chuckles*
Desmont McCallock
#74 - 2012-12-19 18:35:08 UTC
Jercy Fravowitz wrote:
Desmont McCallock wrote:
SDE looks OK now. Concurring, CCP Prism X all time favorite CCP.

  1. you call that OK? pah. it is totally missing the entry for 500021 in chrFactions. dont you people have real databases with proper FKs?!

  2. i kinda agree. he is definetly among the top 5 devs. though he was cuter when he was even younger.

  3. time to hide somewhere.

  4. oh, yeah.

  5. my favorite part of this thread is the part with the feedback about the lack of evemon updates, and the suggested workaround/fix. that would sure work. *chuckles*

If only I didn't knew your sense of humor.... Pirate
Snus Mumriken
Deep Core Mining Inc.
Caldari State
#75 - 2012-12-19 23:19:13 UTC
CCP Prism X wrote:
Yet another SDE Deployment: http://content.eveonline.com/data/Retribution_1.0.7_463858_db.zip


PrismX, can you please keep the old naming scheme with the tranquility branch change ID instead of this other number? (463858, the build number or something, don't know exactly.)

Thanks!

I'm on Twitter.
Cielle Tische
Who Armed the Carebears
#76 - 2012-12-20 05:17:37 UTC
Thank god for all the fixes. However, either it didn't import correctly in my DB or something, but the new ships (velator, corax, etc) don't have blueprint information. Everything else seems to be working.

Developer of www.eveidb.com - Relational EVE database! [Still under construction]
Desmont McCallock
#77 - 2012-12-20 05:55:59 UTC
Cielle Tische wrote:
Thank god for all the fixes. However, either it didn't import correctly in my DB or something, but the new ships (velator, corax, etc) don't have blueprint information. Everything else seems to be working.

I can see those blueprints in SDE.
Cielle Tische
Who Armed the Carebears
#78 - 2012-12-20 07:04:38 UTC
Desmont McCallock wrote:
Cielle Tische wrote:
Thank god for all the fixes. However, either it didn't import correctly in my DB or something, but the new ships (velator, corax, etc) don't have blueprint information. Everything else seems to be working.

I can see those blueprints in SDE.

I'll try reimporting then. And I meant the Venture, not Velator.... My friend just started playing and he was in a velator. Must have been looking at his ship when I typed that xD


This is my example: http://www.eveidb.com/item?i=32881 (Venture) It finds the blueprint, but the material data is missing.

Developer of www.eveidb.com - Relational EVE database! [Still under construction]
Desmont McCallock
#79 - 2012-12-20 07:55:12 UTC
According to EVEMon everything is there. Scan the forum on how to get the materials for a BP as it involves more than one table.
Cielle Tische
Who Armed the Carebears
#80 - 2012-12-20 08:29:52 UTC  |  Edited by: Cielle Tische
Desmont McCallock wrote:
According to EVEMon everything is there. Scan the forum on how to get the materials for a BP as it involves more than one table.


It's just the new ones. All the others work perfectly, for example: http://www.eveidb.com/item?i=24691 (Hyperion)

I reimported the data and still nothing. Also imported into a blank database to see if it was being tainted by old data, and still nada.

---Ahhhahaha. Got it. Forgot to convert the table into the saferead tab. /derp Should be able to fix this fairly quickly.

Developer of www.eveidb.com - Relational EVE database! [Still under construction]