HELP! Please Please Please! (Calibre Database Crash)

[Abisha]

Okay, here's the deal. I'm using Calibre 0.5.14 on M$FT Windows, and in every instance that I try to add a new book to my database, the library crashes and Calibre gives me the following error message:



I have tried cleaning out my appdata directory, performing a clean install, additionally I've tried creating a library from scratch with zero books. Once this error occurs It's like I'm forever being locked out and can't add any more books to my database. Any help would be greatly appreciated.

-Abi

 C:\Program Files\calibre>calibre-debug.exe -g
link  hasn't been detected!
link  hasn't been detected!
Traceback (most recent call last):
  File "calibre\gui2\add.pyo", line 212, in run
  File "calibre\library\database2.pyo", line 1248, in import_book
  File "calibre\library\sqlite.pyo", line 146, in run
DatabaseException: table books has no column named uri
        RemoteTraceback (most recent call last):
          File "calibre\library\sqlite.pyo", line 119, in run
        OperationalError: table books has no column named uri

QObject::setParent: Cannot set parent, new parent is in a different thread
QPixmap: It is not safe to use pixmaps outside the GUI thread
QPixmap: It is not safe to use pixmaps outside the GUI thread
QPixmap: It is not safe to use pixmaps outside the GUI thread
QPixmap: It is not safe to use pixmaps outside the GUI thread
QPixmap: It is not safe to use pixmaps outside the GUI thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QObject::startTimer: timers cannot be started from another thread
QApplication: Object event filter cannot be in a different thread.
QObject::startTimer: timers cannot be started from another thread
QApplication: Object event filter cannot be in a different thread.
QObject::startTimer: timers cannot be started from another thread
QApplication: Object event filter cannot be in a different thread.
QObject::startTimer: timers cannot be started from another thread
QApplication: Object event filter cannot be in a different thread.
QObject::startTimer: timers cannot be started from another thread
QApplication: Object event filter cannot be in a different thread.
QObject::startTimer: timers cannot be started from another thread
QApplication: Object event filter cannot be in a different thread.
QObject::startTimer: timers cannot be started from another thread
QApplication: Object event filter cannot be in a different thread.
QObject::startTimer: timers cannot be started from another thread
QApplication: Object event filter cannot be in a different thread.
QObject::startTimer: timers cannot be started from another thread
QApplication: Object event filter cannot be in a different thread.
QObject::startTimer: timers cannot be started from another thread
QApplication: Object event filter cannot be in a different thread.
QObject::startTimer: timers cannot be started from another thread
QApplication: Object event filter cannot be in a different thread.
QObject::startTimer: timers cannot be started from another thread
QApplication: Object event filter cannot be in a different thread.
QPixmap: It is not safe to use pixmaps outside the GUI thread
QObject::startTimer: timers cannot be started from another thread
QApplication: Object event filter cannot be in a different thread.
QObject::startTimer: timers cannot be started from another thread
QApplication: Object event filter cannot be in a different thread.
QObject::startTimer: timers cannot be started from another thread
QApplication: Object event filter cannot be in a different thread.
QObject::startTimer: timers cannot be started from another thread
QApplication: Object event filter cannot be in a different thread.
QObject::startTimer: timers cannot be started from another thread
QApplication: Object event filter cannot be in a different thread.
QObject::startTimer: timers cannot be started from another thread
QApplication: Object event filter cannot be in a different thread.
QObject::startTimer: timers cannot be started from another thread
QApplication: Object event filter cannot be in a different thread.
QObject::startTimer: timers cannot be started from another thread
QApplication: Object event filter cannot be in a different thread.
QObject::startTimer: timers cannot be started from another thread
QApplication: Object event filter cannot be in a different thread.
QObject::startTimer: timers cannot be started from another thread
QApplication: Object event filter cannot be in a different thread.
QObject::startTimer: timers cannot be started from another thread
QApplication: Object event filter cannot be in a different thread.
QObject::startTimer: timers cannot be started from another thread
QApplication: Object event filter cannot be in a different thread.
QObject::startTimer: timers cannot be started from another thread
QApplication: Object event filter cannot be in a different thread.
QObject::startTimer: timers cannot be started from another thread
QApplication: Object event filter cannot be in a different thread.
QObject::startTimer: timers cannot be started from another thread
QApplication: Object event filter cannot be in a different thread.
QObject::startTimer: timers cannot be started from another thread
QApplication: Object event filter cannot be in a different thread.
QObject::startTimer: timers cannot be started from another thread
QApplication: Object event filter cannot be in a different thread.
QObject::startTimer: timers cannot be started from another thread
QApplication: Object event filter cannot be in a different thread.
QObject::startTimer: timers cannot be started from another thread
QApplication: Object event filter cannot be in a different thread.
QObject::startTimer: timers cannot be started from another thread
QApplication: Object event filter cannot be in a different thread.
QObject::startTimer: timers cannot be started from another thread
QApplication: Object event filter cannot be in a different thread.
QPixmap: It is not safe to use pixmaps outside the GUI thread
QPixmap: It is not safe to use pixmaps outside the GUI thread
QPixmap: It is not safe to use pixmaps outside the GUI thread

C:\Program Files\calibre>

[itimpi]

I got that after I had tried running 0.6 beta 1 and then reverting to 0.5.14. I had assumed that 0.6 removed that column as it was no longer needed, but I could be wrong.

I had a very recent backup of the metadata.db file, so I got around it by simply restoring that file.

I would have thought it should be possible to add that column manually to the database as an alternative using a tool like SqliteMan.

[kovidgoyal]

That error is caused by running 0.6 and then reverting to 0.5. You have to restore the backup of your library first.

[sirbruce]

Originally Posted by kovidgoyal

That error is caused by running 0.6 and then reverting to 0.5. You have to restore the backup of your library first.

You mean I can't downcovert to 0.5 after my earlier attempt to install 0.6 to use another library failed? Great. Just great. You know that's specifically why I tried to install it elsewhere to avoid this issue.

[kovidgoyal]

Originally Posted by sirbruce

You mean I can't downcovert to 0.5 after my earlier attempt to install 0.6 to use another library failed? Great. Just great. You know that's specifically why I tried to install it elsewhere to avoid this issue.

It is stated in the beta annoucement that you can't use the same library with 0.5 and 0.6

It is also stated quite clearly that you should backup your library before trying the betas.

That said, if your attempt to install 0.6 failed, your original library should remain unmolested, depending on what stage the process failed at.

[sirbruce]

I agree, but specifically starting 0.6 with a different library would seem to avoid the need to backup the previous library. However, as you know from a previous thread, 0.6 failed to function properly in that case the first time it is run. So it's a bit annoying.

[Abisha]

Admittedly I did use a .6* beta build. I do want to be clear though about the steps I took when I reverted to build 0.5.14. When I reinstalled 0.5.14 I took the following steps:

1. Uninstalled 0.6* via "Programs and Features > Uninstall"
2. Manual deletion of "C:\Users\********\AppData\Roaming\calibre"
3. Manual deletion of "metadata.db" (Yes, I completely scratched my entire ".db" and started over from the ground up. I wanted to take the opportunity while I have some free time during my summer break to 'clean up' my library, properly tag, etc..)

Point being, this error is occurring after a clean install, with a virgin database. I hope this makes the circumstances a little clearer. Thanks everyone for taking a look at my situation. I hope someone can spot an error in my installation or offer some suggestion.

Thank you. -Abi

[kovidgoyal]

That error definitely indicates the use of a metadata.db that has been altered by an 0.6 version of calibre. Try running a search on your computer for all metadata.db files and delete them all to make sure you're starting with a clean slate