| Author |
Message |
| Registered: July 1, 2007 | | Posts: 10 |
| | Posted: | | | | I had a catastrophic hard drive failure recently and lost all my data. Fortunately I have an automatic backup process running, so I had a backup of my DVDProfiler database.
I'm now trying to restore it to my main hard drive, and I'm running into problems; I'd appreciate some assistance.
When I try to Open a Database, I browse to the backup file, and select the COLLECTION.DAT file. I get an error message:
"Unable to load the selected database. The following error occurred while attempting to open the database: DBISAM Engine Error # 10022 Invalid secondary index name 'ByName' specified for the table 'Users'"
I am offered the option to Repair the database with the Database Repair Utility. When I try that option, and select the "Full Repair" version, it appears to finish the repair process successfully. When DVDProfiler is re-launched, I get a new error message:
"Unable to load the selected database. The following error occurred while attempting to open the database: tblUsers: No index for fields 'ID'"
Any suggestions? (I'm using version 3.5.1, build 1252)
Thanks,
Nick |
|
| Registered: March 13, 2007 | Reputation:  |  Posts: 1,774 |
| | Posted: | | | | A backup (made by the internal DVD Profiler backup function) has the ending .dpb
Youll need to import that one. "Collection.dat" is something different, it doesn't contain things like headshots, cover scans etc.
If you don't made a proper backup, you could try to import the movie data from your online-list:
In DVD Profiler select "Online" --> "DVD Profiler Online" --> sign in and "next" --> select "Download" | | | | Last edited: by SpaceFreakMicha |
|
| Registered: May 19, 2007 | Reputation:  |  Posts: 5,917 |
| | Posted: | | | | If your "My Documents" directory was being backed up, you can simply open up the database by File > Open Database and then browse to it's location if not in the "Default" directory. |
|
| Registered: July 1, 2007 | | Posts: 10 |
| | Posted: | | | | Sorry for the delay in getting back to this topic... unfortunately, I do not have an official DVD Profiler backup file ( .dpb) Nor do I have an Onlne backup. Instead, I only have a duplicate copy of the Collection.xxx set of files, and that is what is generating the errors in the original post when I try to open it. When I navigate to the file, it shows clearly (in the dialog box) that my 1,117 titles are still in there -- but it generates those errors. Any other ideas or suggestions?
Thanks,
Nick |
|
| Registered: March 13, 2007 | | Reputation: |  Posts: 1,946 |
| | Posted: | | | | You could try running the "database repair utility". You can launch it without starting DVD Profiler. Go to the "All Programs" in your start menu, it's located under "DVD Profiler". | | | View my collection at http://www.chriskepolis.be/home/dvd.htm
Chris |
|
| Registered: July 1, 2007 | | Posts: 10 |
| | Posted: | | | | Chris,
Thanks for the suggestion. However, even though the repair seems to finish correctly, the database will not open, and I get the same error as before:
"Unable to load the selected database. The following error occurred while attempting to open the database: tblUsers: No index for fields 'ID'"
Still looking for suggestions.
Thanks.
Nick |
|
| Registered: March 14, 2007 | | Posts: 1,777 |
| | Posted: | | | | Well, this is going to sound silly, but do you even have a users.dat and a users.idx with your collections files? I'm looking at my default database folder and it contains a mountain of tables with indexes, as well as an images and pending subfolder. Pending is empty but images contains all the cover art. Unfortunately, our wiki page on data recovery doesn't seem to cover your particular problem. link |
|
| Registered: March 14, 2007 | | Reputation: | | Posts: 6,741 |
| | Posted: | | | | Quoting npudar: Quote:
Sorry for the delay in getting back to this topic... unfortunately, I do not have an official DVD Profiler backup file ( .dpb) Nor do I have an Onlne backup. Instead, I only have a duplicate copy of the Collection.xxx set of files, and that is what is generating the errors in the original post when I try to open it. When I navigate to the file, it shows clearly (in the dialog box) that my 1,117 titles are still in there -- but it generates those errors. Any other ideas or suggestions?
Thanks,
Nick Do you have only the collection.xxx files or others as well? A full database directory looks like this: Quote:
ACTORASSGN.DAT
ACTORASSGN.IDX
ACTORS.BLB
ACTORS.DAT
ACTORS.IDX
ALIASES.DAT
ALIASES.IDX
BoxSets.DAT
BoxSets.IDX
CastCrewCache.dod
COLLECTION.BLB
COLLECTION.DAT
COLLECTION.IDX
CreditsAssign.DAT
CreditsAssign.IDX
CustomGenres.dat
DIRECTPRODUCE.BLB
DIRECTPRODUCE.DAT
DIRECTPRODUCE.IDX
DISCS.DAT
DISCS.IDX
Events.DAT
Events.IDX
Images
Pending
RETAILERS.DAT
RETAILERS.IDX
STUDIOS.DAT
STUDIOS.IDX
TagAssign.DAT
TagAssign.IDX
Tags.DAT
Tags.IDX
Thumbnails.BLB
Thumbnails.DAT
Thumbnails.IDX
TimeStamps.DAT
TimeStamps.IDX
USERS.DAT
USERS.IDX If you only have the collection.xxx, you could try to create a new, empty DB (it will create all the above files) and then copy your collection.xxx files to it. Maybe it will work. | | | Karsten
DVD Collectors Online
 | | | | Last edited: by DJ Doena |
|
| Registered: July 1, 2007 | | Posts: 10 |
| | Posted: | | | | Back in town to address this issue...
These are the files I have in my database folder:
ACTORASSGN.DAT
ACTORASSGN.IDX
ACTORS.DAT
ACTORS.BLB
ACTORS.IDX
ALIASES.DAT
ALIASES.IDX
BoxSets.DAT
BoxSets.IDX
COLLECTION.DAT
COLLECTION.BBK
COLLECTION.BLB
COLLECTION.DBK
COLLECTION.IBK
COLLECTION.IDX
CreditsAssign.DAT
CreditsAssign.DBK
CreditsAssign.IBK
CreditsAssign.IDX
DIRECTPRODUCE.DAT
DIRECTPRODUCE.BLB
DIRECTPRODUCE.IDX
DISCS.DAT
DISCS.IDX
Events.DAT
Events.IDX
RETAILERS.DAT
RETAILERS.IDX
STUDIOS.DAT
STUDIOS.IDX
TagAssign.DAT
TagAssign.IDX
Tags.DAT
Tags.IDX
Thumbnails.DAT
Thumbnails.BLB
Thumbnails.IDX
TimeStamps.DAT
TimeStamps.IDX
Users.DAT
USERS.DBK
USERS.IBK
Users.IDX
I seem to have some extra files than in the preceding post list of files. I have copied all of the filenames with the actual case-sensitive text. Do I have some unnecessary files? Hopefully this is a clue for soemfolk. I appreciate all your sleuthing.
Nick |
|
| Registered: July 1, 2007 | | Posts: 10 |
| | Posted: | | | | SOLVED!!!
Thanks to mdnitoil and DJ Doena, I found a solution that worked. Here is what I did:
I created an empty, new database. Using the list of files that DJ Doena provided, I copied all of them, except for the Users.DAT and Users.IDX, to the new database folder. (I also copied all of the images and thumbnails.) When I opened the database, it worked!
Thanks to all for your ideas and recommendations.
Nick |
|
| Registered: March 14, 2007 | | Reputation: | | Posts: 6,741 |
| | Posted: | | | | Grats.  And now do a proper backup via File->Backup Database.  | | | Karsten
DVD Collectors Online
| | | | Last edited: by DJ Doena |
|
| Registered: July 1, 2007 | | Posts: 10 |
| | Posted: | | | | DJ Doena, The very first thing I did was to do a real backup! Thanks again. Now I have some DVDs to enter. Nick |
|
| Registered: March 13, 2007 | | Reputation: |  Posts: 5,491 |
| | Posted: | | | | Quoting npudar: Quote:
DJ Doena,
The very first thing I did was to do a real backup! Thanks again. Now I have some DVDs to enter.
Nick and if you have a partitioned HD do the backup on another medium.. Memory stick would be the best .. | | | In the 60's, People took Acid to make the world Weird. Now the World is weird and People take Prozac to make it Normal.
Terry |
|
| Registered: March 14, 2007 | | Reputation: |  Posts: 820 |
| | Posted: | | | | Quoting npudar: Quote:
DJ Doena,
The very first thing I did was to do a real backup! Thanks again. Now I have some DVDs to enter.
Nick Upload your collection regularly as well. It will allow you to vote on contributions relating to your titles and give you another recovery option for your data. |
|