Abandoned [RELEASE] Trade Computer Extension

Status
Thread Closed: Not open for further replies.

Bragolatch

Bragolatch
Error 3021

Adding an Unregistered station, I filled all the info and clicked save,
It turned into wait, but after a few minutes it was still there.
I tried HIDE

and got:

3021.jpg
1004.jpg


These came back twice and then the STATION panel closed with TCE still running.

When I Opened the DATABASE/STATION again the station seemed to have been saved properly !

I clicked a box and saved it again to make sure and everything worked ok !!!
 

Bragolatch

Bragolatch
Distance said:
I'm getting errors and crashes now. I decided to fly back to Imperial space and when I jumped to a system I hadn't explored the runtime error popped up.

I've docked at a station on my way and it crashed and keeps on crashing with : runtime error 9 subscript out of range.

It looks like it's stuck crashed on system Alrai sector OC-V A2-2 as I can't open it up any more.

This is the line highlighted in the debugger (in des_systems ? not an excel user) :

If (Ar_Type(Ar_DBRegStations(Worksheets("Systems").Cells(1 + a, 14).Value, 10), 3) = "L" And Worksheets("Data").Cells(111, 2).Value = True) Or (Ar_Type(Ar_DBRegStations(Worksheets("Systems").Cells(1 + a, 14).Value, 10), 3) = "M" And Worksheets("Data").Cells(110, 2).Value = True = True) Or (Ar_Type(Ar_DBRegStations(Worksheets("Systems").Cells(1 + a, 14).Value, 10), 3) = "S" And Worksheets("Data").Cells(109, 2).Value = True) Then
Click to expand...


After getting the errors 3021 and 1004 TCE kept running.
Later I shut it down.
When I tried to start again I also receiving error 9 and can't seem to get rid of it.
I've looked in TCE.MDB the only thing weird I found was 80 blank entries (lines)
at the top of the StationPrices table.

Blank.jpg
Removing those did not solve the problem.

But manually adding the missing 80 commodities entry at the end of the table,
with all 0 and with the new station ID fixed the problem !

Removing the new station would have been faster and probably would have worked too,
But i've not tested it yet.
Tried it, not a good Idea !!! it actually makes things worst with all kinds of error popping up !!!

It is a bit confusing to me that the Station's ID from the Stations tab is listed under System in the StationPrices tab

Having tried the ablove, the station was removed for the unregistered station.
So I tried adding it as a new station and got the exact same error
(creation of 80 blank entry at the top of Station Price but no new entry corresponding with the station ID)


Sub Create_Matrix()


Dim a As Integer, b As Integer, c As Integer, i As Integer, j As Integer, X As Integer

If Matrix_ready = False Then
Worksheets("DB_Goods").Activate
ActiveWorkbook.Worksheets("DB_Goods").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("DB_Goods").Sort.SortFields.Add Key:=Range( _
"A2:A1001"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
xlSortNormal
With ActiveWorkbook.Worksheets("DB_Goods").Sort
.SetRange Range("A1:D1001")
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
ArGoods = Worksheets("DB_Goods").Range("A2:D" & AzGoods + 1)
ArData_Goods = Worksheets("Prices").Range("A2:C" & AzGoods + 1)
ArData_Stations = Worksheets("DB_Stations").Range("A2:Q" & AzRegStations + 1)
ReDim ArData_Buy(1 To AzGoods + 2, 1 To AzRegStations + 2)
ReDim ArData_Sell(1 To AzGoods + 2, 1 To AzRegStations + 2)
ReDim ArData_Stock(1 To AzGoods + 2, 1 To AzRegStations + 2)
'Fill arrays vorbereiten
ArData_Buy(1, 1) = "Station_ID"
ArData_Buy(2, 1) = "Star_ID"
For b = 3 To AzGoods + 2
ArData_Buy(b, 1) = ArData_Goods(b - 2, 1)
ArData_Buy(b, 2) = ArData_Goods(b - 2, 2)
DoEvents
Next b
For c = 3 To AzRegStations + 2
ArData_Buy(1, c) = ArData_Stations(c - 2, 1)
ArData_Buy(2, c) = ArData_Stations(c - 2, 17)
DoEvents
Next c
ArData_Sell = ArData_Buy
ArData_Stock = ArData_Buy
For a = 1 To AzRegStations
DoEvents
For b = 1 To AzGoods
ArData_Buy(b + 2, a + 2) = Ar_DBPrices((a - 1) * AzGoods + b, 4)
ArData_Sell(b + 2, a + 2) = Ar_DBPrices((a - 1) * AzGoods + b, 5)
ArData_Stock(b + 2, a + 2) = Ar_DBPrices((a - 1) * AzGoods + b, 6)
DoEvents
Next b
Next a
Worksheets("DB_Goods").Activate
ActiveWorkbook.Worksheets("DB_Goods").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("DB_Goods").Sort.SortFields.Add Key:=Range( _
"B2:B1001"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
xlSortNormal
With ActiveWorkbook.Worksheets("DB_Goods").Sort
.SetRange Range("A1:D1001")
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
Panel_DB_Commodity.ComboBox1.RowSource = "DB_Goods!A2:D" & AzGoods + 1
Matrix_ready = True
End If

End Sub



Distance said:
Also, when it was working every time the star system summery pops up it flashes a white screen which is also immersion breaking.
Click to expand...

I also get this white square, should have reported it
but forgot because I started leaving the STAR SYSTEM SUMMARY up on my second screen,
I did not see the white square since.

This means that I do get the white square once on first popup thought.
It would be nice to have a button to open this panel manually too.
 
Last edited:

dreamer1986

D
After updating to 1.37, the program refuses to work anymore. It gives me runtime error 9, Subscript out of Range. I even tried to revert to the beta, but it doesn't work anymore :( .

After some testing, reverting to the backup from yesterday fixed it.

Edit: Actually, it immediately breaks again after I use it. And I lost all data from yesterday :(
 
Last edited:

Bragolatch

Bragolatch
dreamer1986 said:
After updating to 1.37, the program refuses to work anymore. It gives me runtime error 9, Subscript out of Range. I even tried to revert to the beta, but it doesn't work anymore :( .

After some testing, reverting to the backup from yesterday fixed it.
Click to expand...


As far as I've seen, as soon as you try to add an new or an unregistered station, it will happen again.

Let us know if that is the case or not please.

- - - - - Additional Content Posted / Auto Merge - - - - -

On a completely different subject :

Economy.jpg
As you can see in the pic above, the station is described on the top, under it's name, as :

Industrial and Extraction economy

but then under TRADE DATA

it says :

EXTRACTION
INDUSTRIAL



So does the hole discussion on primary and secondary economy becomes irrelevant ???
 
Last edited:

Bragolatch

Bragolatch
dreamer1986 said:
Yes, it did happen again :( . And it seems I lost all the data I put yesterday anyway :( . All that time wasted :(
Click to expand...

Not totally wasted, It's all invested in the great cause of making the best ED Trading tool ever !

Just keep your backup, I'm sure Eventure will have this fixed in a jiffy !
 

dreamer1986

D
Bragolatch said:
Not totally wasted, It's all invested in the great cause of making the best ED Trading tool ever !

Just keep your backup, I'm sure Eventure will have this fixed in a jiffy !
Click to expand...

Yea, its a great tool. I've used it so little, but I already feel I can't play without it. I'm so sorry I updated it to the new version...
 

BennyBoyW

BennyBoyW
Yeah - looks like yesterday's data is gone for me too - using 1.37B4.
I got the issue with saving Painite commodity prices first and now no data for stations I know I scanned.
However, I did take a backup before I started :)
So I will now do some bounty hunting till it's fixed.

- - - - - Additional Content Posted / Auto Merge - - - - -

dreamer1986 said:
Yes, it did happen again :( . And it seems I lost all the data I put yesterday anyway :( . All that time wasted :(
Click to expand...

Time playing Elite D is never ever wasted :)
 

Bragolatch

Bragolatch
dreamer1986 said:
But this wasn't "playing". It was traveling to stations to save trade info in the now bugged TCE.
Click to expand...

You can revert back to V1.37 beta 4 !

of course any new info you've entered after you've updated will probably not be there.
But anything you added before should !

Always Make a backup of any files you are planning to modify or replace before hand !

You need the TCE.xls from the V1.37 beta 4 package.
and a backup that was made before you updated.


Replace the TCE.xlsm in your install folder with the one from the beta 4 package.

Replace the Languages.mdb in your TCE\DB folder with the one from your backup.

delete the line :

Show_Summary=True

From your TCE.ini


Start the game, cross your fingers and start TCE :)
 
Last edited:

bAdbUd

bAdbUd
Bragolatch said:
As far as I've seen, as soon as you try to add an new or an unregistered station, it will happen again.

Let us know if that is the case or not please.

- - - - - Additional Content Posted / Auto Merge - - - - -

On a completely different subject :

View attachment 21133
As you can see in the pic above, the station is described on the top, under it's name, as :

Industrial and Extraction economy

but then under TRADE DATA

it says :

EXTRACTION
INDUSTRIAL



So does the hole discussion on primary and secondary economy becomes irrelevant ???
Click to expand...

I've raised these inconsistencies as a bug it's also different in the commodities screen.
 

eventure

eventure
Update (V1.37a) released:
- Fixes enpty entries into Prices table
- Bugfix whitebox from Star System panel
- Bugfix in Station Database panel

Note: To all, who had this issue. Please use your latest backup to import it into a new database. Extract it into a neutral folder. Install the Full-Version V1.37 and update to 1.37a. Start TCE and open the Options panel. Click on import Database and select your backup. Activate "Create new Database" and select all stations from your backup, you want to import (you can try to use your faulty database, but dont import the last station, you added when getting the error). After finish importing restart TCE.

Distance said:
I'm getting errors and crashes now. I decided to fly back to Imperial space and when I jumped to a system I hadn't explored the runtime error popped up.

I've docked at a station on my way and it crashed and keeps on crashing with : runtime error 9 subscript out of range.

It looks like it's stuck crashed on system Alrai sector OC-V A2-2 as I can't open it up any more.

This is the line highlighted in the debugger (in des_systems ? not an excel user) :

If (Ar_Type(Ar_DBRegStations(Worksheets("Systems").Cells(1 + a, 14).Value, 10), 3) = "L" And Worksheets("Data").Cells(111, 2).Value = True) Or (Ar_Type(Ar_DBRegStations(Worksheets("Systems").Cells(1 + a, 14).Value, 10), 3) = "M" And Worksheets("Data").Cells(110, 2).Value = True = True) Or (Ar_Type(Ar_DBRegStations(Worksheets("Systems").Cells(1 + a, 14).Value, 10), 3) = "S" And Worksheets("Data").Cells(109, 2).Value = True) Then

Also, when it was working every time the star system summery pops up it flashes a white screen which is also immersion breaking.
Click to expand...

This error depends on your entered trade stations. If you are using an old database, i suppose you entered an additional stationtype yourself. I am right? I suggest you import your old database into a new one (see above).
 
Last edited:

punkerich

punkerich
Eventure said:
Update (V1.37a) released:
- Fixes enpty entries into Prices table
- Bugfix whitebox from Star System panel
- Bugfix in Station Database panel

Note: To all, who had this issue. Please use your latest backup to import it into a new database. Extract it into a neutral folder. Install the Full-Version V1.37 and update to 1.37a. Start TCE and open the Options panel. Click on import Database and select your backup. Activate "Create new Database" and select all stations from your backup, you want to import (you can try to use your faulty database, but dont import the last station, you added when getting the error). After finish importing restart TCE.



This error depends on your entered trade stations. If you are using an old database, i suppose you entered an additional stationtype yourself. I am right? I suggest you import your old database into a new one (see above).
Click to expand...

i always get this, tested with main and 2-station-db:
View attachment 21198
 

dreamer1986

D
Eventure said:
Update (V1.37a) released:
- Fixes enpty entries into Prices table
- Bugfix whitebox from Star System panel
- Bugfix in Station Database panel

Note: To all, who had this issue. Please use your latest backup to import it into a new database. Extract it into a neutral folder. Install the Full-Version V1.37 and update to 1.37a. Start TCE and open the Options panel. Click on import Database and select your backup. Activate "Create new Database" and select all stations from your backup, you want to import (you can try to use your faulty database, but dont import the last station, you added when getting the error). After finish importing restart TCE.
Click to expand...

I tried to do what you said, when I import the database it shows the stations, but when I try to add them it says I have to add panaite first to the old database, and so it fails to load...
 
Last edited:

BennyBoyW

BennyBoyW
I am having major problems. I have just been to station X and scanned all the prices. I then go to station Y and even though Station Y is named in the logbook and the current position, Station X is the one listed in the commodities screen.
I'm worried that this will start to trash my data.
Also, when I tried to import my old database, the import would not work so I am having to use a copy of my old one.
 

hawkenfox

hawkenfox
Does frontier allow this at all? This seems to change the game alot.

I will not use this tool for the respect of the original design of the game

by frontier.
 
Last edited:
Status
Thread Closed: Not open for further replies.
Back
Top Bottom