6 hours ago, broncepulido said:

I'm not sure, do you mean from the next PE iteration it will not arbitrary changes on the scripted magazines from that point?

I did some tests last night and one thing I found was that the only time I tried to link to an existing pfdataxxx.mdb file it failed, I had to import from the commondb files.

I was able to import a known problem db and correct the magazines, export, test in GE, import and export again (to double check) and re test. All was good. I also did some new modifications of platforms and tested that their magazines were correct and that the magazine.csv files were unchanged if the magazines weren't altered and all good.

I can not think of a way of actually correcting a corrupted database other than going back to a good one and redoing the modifications. One of the problems is that the corruptions seems to have been random, so it's hard to know where to look.

Do you have a note of what changes / additions you've made? Are there many?

On 10/21/2023 at 11:35 AM, eeustice said:

I have imported several of my backup db's into the PE. I am still getting the same results as above.

I created a new scenario in the SE and a ship that shows no magazine info in the PE iand have the same results

 

I am guessing that we need TonyE to investigate what has happened.

OK, this type of corruption I think I can capture as it it caused by a magazine item having a weapon ID = 0 (thus the unknown weapon), but there are other corruptions that place a valid magazine in the wrong place so catching only this type of corruption isn't sufficient. It probably shows up in TE's LazGUI export.dll.

 

On 10/21/2023 at 10:54 AM, eeustice said:

I have seen this happen with bases in my personal db too.

There is a limit of around 13,000 magazines available in HC.

You can find the number of magazines you have looking at tPlatformMagazine.

I have attached a screen shot to help you locate the annex where the magazines are located.

I use the full version of MS Access and am not sure if it is available to a player that uses the MS Access Runtime the comes with HC.

That would be a TonyE question.

 

 

 

the MS access runtime won't let yo ulook at that much detail (Mine won't anyway), but most of it you can see in the annex_mags.csv file in commondb/res folder

11 hours ago, donaldseadog said:

Do you have a note of what changes / additions you've made? Are there many?

Yeah, almost everything!!!

But many thanks!!!

15 hours ago, TonyE said:

Correct, upon first export with the updated PE you may find the magazines assigned to a platform may be sorted differently than before but after that the ordering should be consistent and of course assigned to the correct platform in the game as in the PE.

Great, many thanks!!!

2024.001 posted, be extra cautious and careful, back up your files and tuck them away in case I accidentally introduced new issues.

6 hours ago, TonyE said:

2024.001 posted, be extra cautious and careful, back up your files and tuck them away in case I accidentally introduced new issues.

Tested, both Database remading some magazine entries and tested in some small scenarios.

Apparently everything is OK again!

Thanks E, that is a good sign!

Eric is looking at the magazines on bases, are base magazines exporting and importing correctly for the rest of you in 2024.001?  Again, any existing corruption would remain.

6 hours ago, TonyE said:

Eric is looking at the magazines on bases, are base magazines exporting and importing correctly for the rest of you in 2024.001?  Again, any existing corruption would remain.

If the order of magazines is now correct I think bases should be good also. I did check sum type tests comparing the magazine.csv file before and after a import/export/import cycle (with no edits) and it passed while before this new PE the same test would fail.

But the test doesn't pickup correct magagazines assigned to the wrong platfroms/bases.

To me the biggest problem in correcting DB is that the errors were random, so could be anywhere. I pondered using LazGUI to run thru the DB loaded into the game and look for weapons in magazines not used by mounts of that platform, but kind of hoped people with th eproblem would nut out something else