Welcome, Guest
Try to get help from other ComicRack users

TOPIC: Unable to open database

Unable to open database 3 months 1 week ago #49374

  • werdegast
  • werdegast's Avatar
  • Offline
  • Fresh Boarder
  • Posts: 7
  • Karma: 0
I opened ComicRack this morning and received the notice "unable to open database new database created" or something similar to that.

Anyway my database is corrupt now apparently. I have this file "Corrupt Database Backup [04_02_18 10_00_51 AM].xml"

Any ideas?

----
Dang could a moderator please move this to the help section :(
Last Edit: 3 months 1 week ago by werdegast. Reason: I am a dork and posted in the wrong forum.
The administrator has disabled public write access.

Unable to open database 3 months 1 week ago #49375

  • Stonepaw
  • Stonepaw's Avatar
  • Offline
  • Moderator
  • Posts: 926
  • Thank you received: 273
  • Karma: 173
Is there a backup database you can restore?
The administrator has disabled public write access.
The following user(s) said Thank You: werdegast

Unable to open database 3 months 1 week ago #49376

  • werdegast
  • werdegast's Avatar
  • Offline
  • Fresh Boarder
  • Posts: 7
  • Karma: 0
The only backup was pretty old. I scanned the comic folders and most of the comics have the meta data stored in the cbz file.

Some time ago I converted most of my comics to cbz so that helped. I'm not sure what all of them do not contain metadata but oh well.
The administrator has disabled public write access.

Unable to open database 3 months 1 week ago #49381

  • boshuda
  • boshuda's Avatar
  • Offline
  • Platinum Boarder
  • Posts: 334
  • Thank you received: 86
  • Karma: 10
I've never had a corrupt DB, but if you drop it here (zip it up), I'll take a look. I'm pretty sure CR creates a backup for itself, also. That might not be corrupt.

There's a backup manager plugin that will create backups for you regularly. That way, ideally, you can just go back to the last good database should it happen again. I'm not sure where it's located nowadays, but I think it's in the thread Stonepaw links to in his signature.

Edit: Found it, it's in that thread from Stonepaw
Author: docdoom
Current version: 1.0
Last Updated: Apr 5, 2013
Forum Topic | Direct Download

This little plugin automates the process of saving the ComicRack library file. See the manual at google code for further information.
Last Edit: 3 months 1 week ago by boshuda.
The administrator has disabled public write access.
The following user(s) said Thank You: werdegast

Unable to open database 3 months 1 week ago #49383

  • werdegast
  • werdegast's Avatar
  • Offline
  • Fresh Boarder
  • Posts: 7
  • Karma: 0
Thanks for the help and the link to the backup manager plugin.
Attachments:
The administrator has disabled public write access.

Unable to open database 3 months 1 week ago #49385

  • boshuda
  • boshuda's Avatar
  • Offline
  • Platinum Boarder
  • Posts: 334
  • Thank you received: 86
  • Karma: 10
Sorry -- there's not much that can be done. It looks like a known issue with programs like CR where the program is interrupted while writing the XML and the whole file is overwritten with 'null' values instead of the real values. The consensus is the file can't be recovered and it needs to be generated again from scratch. I was hoping it was just truncated or something, and could be manually edited to close some XML tags and get you back on your feet.

If you're on Windows 10 you might have Windows File History turned on -- but it's off by default. With something like that you could get a previous version, but that's beyond the scope of ComicRack.

Are you sure there isn't a valid ComicDb.xml.bak file in the same location you got that one from...? It might be overwritten by now, but it's worth a minute to take a look.
The administrator has disabled public write access.
The following user(s) said Thank You: werdegast

Unable to open database 3 months 1 week ago #49388

  • werdegast
  • werdegast's Avatar
  • Offline
  • Fresh Boarder
  • Posts: 7
  • Karma: 0
The ComicDb.xml.bak was overwritten by the new blank file.

When I scanned my comics folder most of the meta data was imported from the cbz files. It says 316 files to update. Not too bad out of almost 29000 files :)
The administrator has disabled public write access.

Unable to open database 3 months 1 week ago #49393

  • rmagere
  • rmagere's Avatar
  • Offline
  • Gold Boarder
  • Posts: 253
  • Thank you received: 27
  • Karma: 7
You might want to look into the Backup Plugin (comicrack.cyolito.com/forum/13-scripts/3...omicrack-version-1-0) which creates an automatic backup everytime you open Comicrack - also consider whether a move to SQL could be worthwhile.

I know it's not much help now but for the future :)
Last Edit: 3 months 1 week ago by rmagere.
The administrator has disabled public write access.
The following user(s) said Thank You: werdegast

Unable to open database 3 months 1 week ago #49395

  • werdegast
  • werdegast's Avatar
  • Offline
  • Fresh Boarder
  • Posts: 7
  • Karma: 0
Automatic backup would be great. I did not know that Comicrack could support SQL. Although I can't say that I have ever really looked :)

I just realized the backup plugin was the same one boshuda linked to earlier! Thanks to both of you again for the pointer.
Last Edit: 3 months 1 week ago by werdegast.
The administrator has disabled public write access.
Time to create page: 0.191 seconds

Who's Online

We have 152 guests and one member online