In-Development TradeDangerous: power-user trade optimizer
- Thread starter kfsone
- Start date
Yeah - I'm working on some database stuff at the moment before giving the ships section an overhaul.
Last edited:
Planetary column missing error
Hi guys,
I'm using TD and TDH and have a small problem updating my DB. I haven't played for a while (Since before the horizons update) and when I tried to update my DB in TDH I had thousands of errors for unrecognised commodities. After a quick search I found a solution to this problem by manually downloading all of the latest CSV's from maddavo's site.
However I am now getting a new error if I try to update my DB and I can't find any mention of this or a fix. (Not saying there isn't one, just that I can't find it.
)So I'm hoping someone here knows what the issue is and how to fix it.
Text dump below.
Hi guys,
I'm using TD and TDH and have a small problem updating my DB. I haven't played for a while (Since before the horizons update) and when I tried to update my DB in TDH I had thousands of errors for unrecognised commodities. After a quick search I found a solution to this problem by manually downloading all of the latest CSV's from maddavo's site.
However I am now getting a new error if I try to update my DB and I can't find any mention of this or a fix. (Not saying there isn't one, just that I can't find it.
)So I'm hoping someone here knows what the issue is and how to fix it.Text dump below.
Code:
Command line: -u "C:\trade\trade.py" import --plug=maddavo --opt=usefull,force
NOTE: Rebuilding cache file: this may take a few moments.
*** INTERNAL ERROR: table Station has no column named planetary
CSV File: C:\trade\data\Station.csv:2
SQL Query: INSERT INTO Station (system_id,name,ls_from_star,blackmarket,max_pad_size,market,shipyard,modified,outfitting,rearm,refuel,repair,planetary) VALUES((SELECT System.system_id FROM System WHERE System.name = ?),?,?,?,?,?,?,?,?,?,?,?,?)
Params: ['1 G. CAELI', 'Giacobini Base', '0', '?', 'L', '?', 'N', '2016-01-08 16:48:42', 'Y', '?', '?', '?', 'Y']
Finished updating using all available data from Maddavo.
Command line: -u "C:\trade\trade.py" import --plug=maddavo --opt=use2d,force
NOTE: Rebuilding cache file: this may take a few moments.
*** INTERNAL ERROR: table Station has no column named planetary
CSV File: C:\trade\data\Station.csv:2
SQL Query: INSERT INTO Station (system_id,name,ls_from_star,blackmarket,max_pad_size,market,shipyard,modified,outfitting,rearm,refuel,repair,planetary) VALUES((SELECT System.system_id FROM System WHERE System.name = ?),?,?,?,?,?,?,?,?,?,?,?,?)
Params: ['1 G. CAELI', 'Giacobini Base', '0', '?', 'L', '?', 'N', '2016-01-08 16:48:42', 'Y', '?', '?', '?', 'Y']
Finished updating using all available data from Maddavo.
Command line: -u "C:\trade\trade.py" import --plug=maddavo --opt=use3h,force,csvs
NOTE: Rebuilding cache file: this may take a few moments.
*** INTERNAL ERROR: table Station has no column named planetary
CSV File: C:\trade\data\Station.csv:2
SQL Query: INSERT INTO Station (system_id,name,ls_from_star,blackmarket,max_pad_size,market,shipyard,modified,outfitting,rearm,refuel,repair,planetary) VALUES((SELECT System.system_id FROM System WHERE System.name = ?),?,?,?,?,?,?,?,?,?,?,?,?)
Params: ['1 G. CAELI', 'Giacobini Base', '0', '?', 'L', '?', 'N', '2016-01-08 16:48:42', 'Y', '?', '?', '?', 'Y']
Finished updating using all available data from Maddavo.Hi guys,
I'm using TD and TDH and have a small problem updating my DB. I haven't played for a while (Since before the horizons update) and when I tried to update my DB in TDH I had thousands of errors for unrecognised commodities. After a quick search I found a solution to this problem by manually downloading all of the latest CSV's from maddavo's site.
However I am now getting a new error if I try to update my DB and I can't find any mention of this or a fix. (Not saying there isn't one, just that I can't find it.
Text dump below.
Code:Command line: -u "C:\trade\trade.py" import --plug=maddavo --opt=usefull,force NOTE: Rebuilding cache file: this may take a few moments. *** INTERNAL ERROR: table Station has no column named planetary CSV File: C:\trade\data\Station.csv:2 SQL Query: INSERT INTO Station (system_id,name,ls_from_star,blackmarket,max_pad_size,market,shipyard,modified,outfitting,rearm,refuel,repair,planetary) VALUES((SELECT System.system_id FROM System WHERE System.name = ?),?,?,?,?,?,?,?,?,?,?,?,?) Params: ['1 G. CAELI', 'Giacobini Base', '0', '?', 'L', '?', 'N', '2016-01-08 16:48:42', 'Y', '?', '?', '?', 'Y'] Finished updating using all available data from Maddavo. Command line: -u "C:\trade\trade.py" import --plug=maddavo --opt=use2d,force NOTE: Rebuilding cache file: this may take a few moments. *** INTERNAL ERROR: table Station has no column named planetary CSV File: C:\trade\data\Station.csv:2 SQL Query: INSERT INTO Station (system_id,name,ls_from_star,blackmarket,max_pad_size,market,shipyard,modified,outfitting,rearm,refuel,repair,planetary) VALUES((SELECT System.system_id FROM System WHERE System.name = ?),?,?,?,?,?,?,?,?,?,?,?,?) Params: ['1 G. CAELI', 'Giacobini Base', '0', '?', 'L', '?', 'N', '2016-01-08 16:48:42', 'Y', '?', '?', '?', 'Y'] Finished updating using all available data from Maddavo. Command line: -u "C:\trade\trade.py" import --plug=maddavo --opt=use3h,force,csvs NOTE: Rebuilding cache file: this may take a few moments. *** INTERNAL ERROR: table Station has no column named planetary CSV File: C:\trade\data\Station.csv:2 SQL Query: INSERT INTO Station (system_id,name,ls_from_star,blackmarket,max_pad_size,market,shipyard,modified,outfitting,rearm,refuel,repair,planetary) VALUES((SELECT System.system_id FROM System WHERE System.name = ?),?,?,?,?,?,?,?,?,?,?,?,?) Params: ['1 G. CAELI', 'Giacobini Base', '0', '?', 'L', '?', 'N', '2016-01-08 16:48:42', 'Y', '?', '?', '?', 'Y'] Finished updating using all available data from Maddavo.
Looks like your import command is forcing a buildcache before executing. This can be because some of the data files have changed since the last command was executed. BUT probably also your code has changed to accomodate horizons (did you update the code from the bgol bitbucket? Anyway - looks like the buildcache is failing because it is an old Station.csv file without a planetary column.
You could try doing a buildcache with the "ignore" switch on - "trade buildcache -fi". Then export the Station table - "trade export --tab station". Then try doing the import.
If the buildcache doesn't work - then try downloading the latest Station.csv manually and put it in your data folder - then do a "trade buildcache -fi"
Cheers,
Maddavo
I have manually downloaded the station.csv from your site (in fact all available files from your site have been manually downloaded and replaced in the data folder), but running your suggested command is still having the same effect.
To cover any issues with my setup I deleted both TD and TDH. Then reinstalled the kfsone version, then copied the bgol version over the top. Installed TDH. And finally manually downloaded all the files from your site.
This was all done without running TD or TDH until all files were in place.
Code:
c:\trade>"C:\trade\trade.py" buildcache -fiNOTE: Rebuilding cache file: this may take a few moments.
*** INTERNAL ERROR: table Station has no column named planetary
CSV File: C:\trade\data\Station.csv:2
SQL Query: INSERT INTO Station (system_id,name,ls_from_star,blackmarket,max_pad_size,market,shipyard,modified,outfitting,rearm,refuel,repair,planetary) VALUES((SELECT System.system_id FROM System WHERE System.name = ?),?,?,?,?,?,?,?,?,?,?,?,?)
Params: ['1 G. CAELI', 'Giacobini Base', '0', '?', 'L', '?', 'N', '2016-01-08 16:48:42', 'Y', '?', '?', '?', 'Y']Just checked the stations CSV in notepad++ and it does have a planetary column. So no idea what is going on. lol
EDIT:
I just deleted TD and installed the bgol version without installing the kfsone version first in case it was causing a conflict, but the same error still exists.
The only thing I can think of is that the bgol download doesn't include the horizons update as standard as he has it listed as a separate branch. But I have no idea if that is true or how to download a specific branch if it is.
Code:
unq:name@System.system_id,unq:name,ls_from_star,blackmarket,max_pad_size,market,shipyard,modified,outfitting,rearm,refuel,repair,planetary'unq:name@System.system_id,unq:name,ls_from_star,blackmarket,max_pad_size,market,shipyard,modified,outfitting,rearm,refuel,repair,planetary
'1 G. CAELI','Giacobini Base',0,'?','L','?','N','2016-01-08 16:48:42','Y','?','?','?','Y'
'1 G. CAELI','Kandel Arsenal',3486,'Y','L','N','N','2016-01-03 17:48:47','Y','Y','Y','Y','Y'
'1 G. CAELI','Smoot Gateway',4761,'N','L','Y','Y','2015-05-06 17:03:00','Y','Y','Y','Y','N'
'1 GEMINORUM','Collins Settlement',2598,'Y','M','Y','N','2015-10-10 16:16:04','Y','Y','Y','N','N'
'1 GEMINORUM','Zholobov Orbital',3430,'Y','M','N','N','2015-06-21 23:25:43','N','Y','Y','Y','N'EDIT:
I just deleted TD and installed the bgol version without installing the kfsone version first in case it was causing a conflict, but the same error still exists.
The only thing I can think of is that the bgol download doesn't include the horizons update as standard as he has it listed as a separate branch. But I have no idea if that is true or how to download a specific branch if it is.
Last edited:
Solaris, I've copied this extract from an earlier post
It's a "planetary" extension of TD. Stations do get a field "planetary" and you can use the switch "--no-planet" to avoid stations on planets.
You can go to the Download page on bitbucket, select "Branches" and click on the "zip" link (in the download column on the right) of the "horizon" line. This will give you the code you can place into its own subdir and use it like the original TD.
Changelog:
This should give you Bgol's Horizons version of TD where the planet stuff works.
if you've already done that, then sorry, I haven't a clue!
It's a "planetary" extension of TD. Stations do get a field "planetary" and you can use the switch "--no-planet" to avoid stations on planets.
You can go to the Download page on bitbucket, select "Branches" and click on the "zip" link (in the download column on the right) of the "horizon" line. This will give you the code you can place into its own subdir and use it like the original TD.
Changelog:
- Don't merge the prices form maddavo anymore (use --merge-import if you need it).
- New items with version 1.5/2.0 of ED
- data update from maddavo
- Added "planetary" column to station table and maddavo import.
- Added "--planetary" argument to station command.
- Added "--no-planet" switch to buy, local, nav, rares, run and sell command.
- Added "Plt: X" output.
- Update EDAPI plugin to version 3.6.0
This should give you Bgol's Horizons version of TD where the planet stuff works.
if you've already done that, then sorry, I haven't a clue!
That fixed the issue. Thanks a lot.
Not in Trade Dangerous no. TD is Allegiance agnostic. You can use something like EDDB.IO for that.
Hi CMDR, with the last Version of TD from "bgol" (16-01-2016) I have a problem. I get the known ERROR/Warning:
WARNING: import.prices:45529 ERROR Unrecognized item name: "BUILDING FABRICATORS"
WARNING: import.prices:45531 ERROR Unrecognized item name: "GEOLOGICAL EQUIPMENT"
WARNING: import.prices:45535 ERROR Unrecognized item name: "SKIMMER COMPONENTS"
WARNING: import.prices:45536 ERROR Unrecognized item name: "THERMAL COOLING UNITS" ...
but yesterday with the version before I had no problems with the update. What's wrong ?
Sorry for my english, and thanx for your help.
Greetings from nepomuk
WARNING: import.prices:45529 ERROR Unrecognized item name: "BUILDING FABRICATORS"
WARNING: import.prices:45531 ERROR Unrecognized item name: "GEOLOGICAL EQUIPMENT"
WARNING: import.prices:45535 ERROR Unrecognized item name: "SKIMMER COMPONENTS"
WARNING: import.prices:45536 ERROR Unrecognized item name: "THERMAL COOLING UNITS" ...
but yesterday with the version before I had no problems with the update. What's wrong ?
Sorry for my english, and thanx for your help.
Greetings from nepomuk
Try downloading the latest items.csv from Maddavo, otherwise you could probably edit them in yourself.
http://www.davek.com.au/td/Item.csv
Thank you for your answer, but that is not the problem. I used the last Item.csv (19. Jan. 2016) from Maddavo (www.davek.com).
Hi @nepomuk,
Building Fabricators, Geological Equipment, Skimmer Components and Thermal Cooling Units are all items that are in the latest Item.csv at the link @Tromador gave (http://www.davek.com.au/td/Item.csv). Please check that those items are in your Item.csv in your data directory. If they are not in there, then you may have got a cached version of the file - try to download it again. If the items are in the Item.csv, then try doing a buildcache using the command: trade buildcache -fi
Cheers,
Maddavo
