jetbalsa / pos-tracker-eve

Automatically exported from code.google.com/p/pos-tracker-eve
0 stars 0 forks source link

Unknown Regions/Constellations Confusing #32

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. install multiple unknown regions
2. add new pos
3. be confused as to which region to select

What is the expected output? What do you see instead?
Some identifiable text such as dotlan's region/constellation identification:
Unknown R##
Unknown C###

reference: http://evemaps.dotlan.net/system/J100237

What version of the product are you using? On what operating system?
5.1.4

Please provide any additional information below.
I made some sql to temporarily fix the issue for my own installation: 

update `pos3_moonsinstalled` set `regionName`=concat(regionName ,' R' , 
right(`regionID`,2)) WHERE `regionName` = 'Unknown'

update `pos3_mapregions` set `regionName`=concat(regionName ,' R' , 
right(`regionID`,2)) WHERE `regionName` = 'Unknown'

update `pos3_mapconstellations` set `contellationName`=concat(contellationName 
,' C' , right(`contellationID`,3)) WHERE `contellationName` = 'Unknown'

Original issue reported on code.google.com by scott.mu...@gmail.com on 25 Aug 2011 at 4:38

GoogleCodeExporter commented 9 years ago
Accepted into future fixes however your SQL is wrong. contellation is not a 
word.
-FG

Original comment by frozenic...@gmail.com on 9 Sep 2011 at 5:32

GoogleCodeExporter commented 9 years ago
Completed. In 5.1.7

Original comment by frozenic...@gmail.com on 7 Nov 2011 at 10:46