Welcome to the Invelos forums. Please read the forum rules before posting.

Read access to our public forums is open to everyone. To post messages, a free registration is required.

If you have an Invelos account, sign in to post.

    Invelos Forums->DVD Profiler: Desktop Technical Support Page: 1  Previous   Next
Major Database Error that Refuses to Repair
Author Message
DVD Profiler Unlimited RegistrantMrVideo
Unix works!
Registered: July 22, 2007
Posts: 348
Posted:
PM this userDirect link to this postReply with quote
The system crashed shortly after I added a bunch of entries.

The database ended up with three entries that have a title, but it refused to bring up info for that release, instead it showed info for whatever title I looked at last.  If I tried to delete the screwed up entry, it removed the entry it was displaying.

I had to re-enter the incorrectly deleted title.

So, I tried re-entering the data for the three bad entries and ended up with each title having two entries, each one displaying the title's info.  All six entries have separate collection numbers.  DVDP did not think the entries existed, so I was able to do the re-entry, even though the title for each of them is still in the list, with a collection number.

When I try and delete one of the duplicate entries. the remaining entry will no longer display data.

Repairing will not remove the duplicate titles.

How the hell does one get rid of an entry that does not display correctly?

Before anyone suggests restoring to a previously saved database, forget it.  You are welcome to come to my house and re-enter the 27 titles that I've added since that save (all done in a single update).
Mr Video Productions
If it isn't Unix, it isn't an OS :-)
DVD Profiler Unlimited RegistrantStar ContributorLewis_Prothero
Strength Through Unity
Registered: May 19, 2007
Reputation: Superior Rating
Germany Posts: 6,730
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
The solution is easier:

If you know which the titles are that are corrupted simply perform a partial backup that excludes the culprits.
Afterwards restore this partial backup (best into a new database).
It all seems so stupid, it makes me want to give up!
But why should I give up, when it all seems so stupid?


Registrant since 05/22/2003
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,456
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
Or, just do a partial backup of the 27 good titles you entered and then restore them into the good backed up database.

BTW were you offering to have a DVDP house party? 
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
 Last edited: by mediadogg
DVD Profiler Unlimited RegistrantMrVideo
Unix works!
Registered: July 22, 2007
Posts: 348
Posted:
PM this userDirect link to this postReply with quote
Quoting mediadogg:
Quote:
Or, just do a partial backup of the 27 good titles you entered and then restore them into the good backed up database.


Too late, already did it the other way.  Was finishing up the work before positing.

Quote:
BTW were you offering to have a DVDP house party? 


Not exactly.  Just to the person that was willing to spend money to come here and re-enter the 27 new entries.

Not necessary anymore. 
Mr Video Productions
If it isn't Unix, it isn't an OS :-)
DVD Profiler Unlimited RegistrantMrVideo
Unix works!
Registered: July 22, 2007
Posts: 348
Posted:
PM this userDirect link to this postReply with quote
Quoting Lewis_Prothero:
Quote:
If you know which the titles are that are corrupted simply perform a partial backup that excludes the culprits.


Thanks.  After digging around to find a way to flag all of the entries, I did a backup and then a restore.

Though I did have to quit an restart DVDP before the restore would work.  A restore after the backup failed with an error.
Mr Video Productions
If it isn't Unix, it isn't an OS :-)
    Invelos Forums->DVD Profiler: Desktop Technical Support Page: 1  Previous   Next