Right after I upgraded to the new 3.6 version, I ran the profile update.  As I was going through the list to tell it what to add and what to change, it took off on its own somehow, and rebuilt four years worth of numbering.  Now I have 200+ more titles in the total than I had before. 

I just discovered that it appears my online database is still showing things as they were before things blew up.  I have three or four local backups on my PC since then.  It looks as if I may have all the relevant data between the two. 

How do get back to my original numbering setup, and how do I then add the titles I've entered since then back in keeping the numbering in the proper format?  I really don't fancy having to renumber over 1400 titles.

Quoting Silence_of_Lambs:

Quote:
What exactly did change?
The number shown in the "owned" tab, or really the collection numbering?

Both actually.  I don't number individual discs unless they actually are a stand alone title.  A TV box set, for example, would only have one numbered title, even if it had 10 discs in the set.  A box set with a collection of titles, such as a John Wayne collection of six different movies, I would number each movie (individual title) but not the box set itself.  Child profiles also don't get numbered unless they are individual titles. 

I had about 1300 titles based on the above format before the upgrade to 3.6.1.  Right after the update finished, it wanted to refresh and update profiles.  I had things locked down (or so I thought) and expected to be able to go through the list and specify what I did/did not want, but it just took off and processed over 700 updates.  When it finished, my total now reads 1500+, and some of the titles are out of sequence.  It obviously added numbers (and God knows what else) to a lot of the discs that I had previously designated NOT to be numbered.

Problem here is I don't give a rat's butt how many discs I have.  I'm only interested in individual UPC'd titles.  It took a hell of a lot of work to set it up four years ago, and I only had 1/4 of the titles I have now.  Not looking forward to redoing it manually.

How many titles did you add before you realized this problem?  and you said you do have current backups before the renumbering happened ,, but you added a lot more titles..
Could you flag the title(s) you added since , and then print those off in text only .., Then backup your current library UNDER a different name., Then go back to the saved good backup, restore your library as it was .,  and then go back to the saved 'bad backup'  just individually select these flagged titles only to restore .,  I believe the numbering of the restored titles will be the old numbers and the flagged restored titles would be the incorrect numbers then you just renumber the second backup flagged numbers.. then after after all is well, structure your library ( count as library)  so it won't happen again. Then recheck, ,then do a master backup once more ....

Quoting Rifter:

Quote:
UPDATE:  Well, I loaded the Database Query plug-in after running the database repair utility.  The repair found some corrupted profiles/indexes and fixed those, and the plug-in tells me I have gaps in the numbering that total 141 slots.  I also used it to find those box sets with numbered child profiles that should NOT have had numbers.  That accounted for another 40 odd discs.

I tried to do a partial renumber to eliminate gaps in the sequence, but it doesn't seem to want to change anything.  Anybody have any ideas how to make it eliminate those gaps?

The only thing I would suggest John would be to a) make sure any titles you don't want numbered tick the box not to number, then b) do a COMPLETE renumber based on the sort feature you require. In my case mine are numbered by Purchase Date. Other than that, your only option, since Partial Re-Numbering is not working is to do it manually (long winded I know) to get your desired result.

Have you tried a DB Repair in-case there is a hiccup in your local somewhere?