Jump to content
RealModScene
Sign in to follow this  
sxg75

FSD3 game icons duplication with 2 usb hhd

Recommended Posts

Yesterday I connected an another external hdd to my xbox360 rgh.

FSD3.483 started after the reboot and it show all the previously existing game icons duplicated.

 

After the disconnection of the 2nd usb and reboot, the problem doesn't exist.

 

So, it's tasting like a typical sql error, which can be easily solved with a "distinct" prefix in the sql query.

 

 

Share this post


Link to post
Share on other sites

Did you remove the first USB HDD before you scanned? You should scan with both HDDs connected. I also name my game directory's different. Delete your DB and try this way.

Usb0/games

Usb1/games2

Share this post


Link to post
Share on other sites

So, it is no need to check scanpaths nor rescan, because

1. stage:

- imagine FSD3 runs

- only the 1st hdd runs

- icons are not duplicated

2. stage:

- swithc the 2nd hdd on 

- and wow the icons duplicated

 

So if's NOT a scanpaths or db error - because in the 1st stage the icons are NOT duplicated at all.

 

I try to check the inner select's of the fsd3's default.xex.

I think this is the problematic query:

 

SELECT ContentItemId, ContentItemScanPathId, ContentItemFileType, ContentItemContentType, ContentItemTab, ContentItemPath, ContentItemDirectory, ContentItemFileName, ContentItemTitleId, ContentItemMediaId, ContentItemDiscNum, ContentItemDiscsInSet, ContentItemName, ContentItemDescription, ContentItemDeveloper, ContentItemPublisher, ContentItemGenre, ContentItemRating, ContentItemRaters, ContentItemReleaseDate, RecentlyPlayedTitleDateTime, RecentlyPlayedTitleOrder, UserRatingRating, FavoriteId, ScanPathDeviceId, ContentItemHash ContentItemKinectFlag FROM ContentItems, ScanPaths, MountedDevicesLEFT OUTER JOIN RecentlyPlayedTitles ON ContentItemId = RecentlyPlayedTitleContentId AND RecentlyPlayedTitleGamerProfile = ?LEFT OUTER JOIN UserRatings ON ContentItemId = UserRatingContentId AND UserRatingGamerProfile = ?LEFT OUTER JOIN Favorites ON ContentItemId = FavoriteContentId AND FavoriteGamerProfile = ?WHERE ContentItemScanPathId = ScanPathId AND ContentItemId = ?

because the MountedDevices table.

 

I looked at my content.db and I saw, that the two USB devices (USB0 and USB1) have SAME MountedDeviceDeviceID's.

I'm pretty sure, that his caused the bug.

 

There could be two different way of solution:

1st way: need a tool to make all MountedDeviceDeviceID to be unique (I hope, that there is no formatting needed)

2nd way: a DISTINCT prefix after the SELECT keyword.

 

sxg

Share this post


Link to post
Share on other sites

Any response ?

As I know, there are lot of queries and updates in FSD3.

So the real solution should be the #1 - need a tool to change the MountedDeviceID's to be unique.

Anyway, what are these ID-s and it is possible to change them without sideeffects ?

Share this post


Link to post
Share on other sites

Thank you very much !

Are there any developing or testing thing I can help the developing process ?Please le me know !

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...