05-07-2010, 01:58 AM | #1 |
Junior Member
Posts: 3
Karma: 10
Join Date: May 2010
Device: Cybook 3Gen
|
Error: malformed database schema (books_insert_trg)
Yesterday I updated to version 0.6.51 without problems. However, today when I enter Calibre I receive the error "Bad database location" with the following details:
Traceback (most recent call last): File "site-packages\calibre\gui2\ui.py", line 517, in __init__ File "site-packages\calibre\library\database2.py", line 126, in __init__ File "site-packages\calibre\library\database2.py", line 129, in initialize_dynamic File "site-packages\calibre\library\custom_columns.py", line 34, in __init__ File "site-packages\calibre\library\sqlite.py", line 163, in run DatabaseException: malformed database schema (books_insert_trg) - trigger books_insert_trg already exists RemoteTraceback (most recent call last): File "site-packages\calibre\library\sqlite.py", line 127, in run File "site-packages\calibre\library\sqlite.py", line 76, in get DatabaseError: malformed database schema (books_insert_trg) - trigger books_insert_trg already exists I can point to an empty database I have on another directory, but if I go to preferences and re-select my old database the program says: ERROR: Invalid database: <p>An invalid library already exists at f:\calibrelib, delete it before trying to move the existing library.<br>Error: malformed database schema (books_insert_trg) - trigger books_insert_trg already exists RemoteTraceback (most recent call last): File "site-packages\calibre\library\sqlite.py", line 127, in run File "site-packages\calibre\library\sqlite.py", line 76, in get DatabaseError: malformed database schema (books_insert_trg) - trigger books_insert_trg already exists Traceback (most recent call last): File "site-packages\calibre\gui2\wizard\__init__.py", line 486, in move_library File "site-packages\calibre\library\database2.py", line 126, in __init__ File "site-packages\calibre\library\database2.py", line 129, in initialize_dynamic File "site-packages\calibre\library\custom_columns.py", line 34, in __init__ File "site-packages\calibre\library\sqlite.py", line 163, in run DatabaseException: malformed database schema (books_insert_trg) - trigger books_insert_trg already exists RemoteTraceback (most recent call last): File "site-packages\calibre\library\sqlite.py", line 127, in run File "site-packages\calibre\library\sqlite.py", line 76, in get DatabaseError: malformed database schema (books_insert_trg) - trigger books_insert_trg already exists As the database is not loaded, I cannot check its consistency from proferences. Is there anything (from command line, for example) that I can do to try to fix my database. There are more than 5.000 books inside! Thanks a lot. |
05-07-2010, 10:19 AM | #2 |
creator of calibre
Posts: 44,380
Karma: 23766374
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
|
what version did you update from?
|
Advert | |
|
05-08-2010, 07:32 AM | #3 |
Junior Member
Posts: 3
Karma: 10
Join Date: May 2010
Device: Cybook 3Gen
|
Previous version
I was upgrading from 0.6.48 but I DID work with the new version without problems for a day. The next time I opened calibre is when I received the error.
|
05-08-2010, 08:41 AM | #4 |
creator of calibre
Posts: 44,380
Karma: 23766374
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
|
Strange, can you mail your database to me (the file metadata.db) to kovid at kovidgoyal. net
|
05-08-2010, 01:02 PM | #5 |
Junior Member
Posts: 3
Karma: 10
Join Date: May 2010
Device: Cybook 3Gen
|
Database sent
Of course! I have already sent it to you. Thanks a lot for your help.
|
Advert | |
|
Tags |
error message, malformed database |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
"Database Disk Image is malformed" when connecting to Calibre after adding new books | djorkboy | Kobo Reader | 13 | 10-07-2010 08:47 PM |
"Database Disk Image is malformed" when connecting to Calibre after adding new books | djorkboy | Calibre | 1 | 10-06-2010 08:59 PM |
DatabaseError: malformed database schema (author_insert_trg) - no such table: authors | peterdeegan | Calibre | 3 | 07-03-2010 12:44 AM |
database disk image is malformed | sirbruce | Calibre | 12 | 06-26-2009 09:06 PM |
DatabaseError: database disk image is malformed | moggie | Calibre | 2 | 12-13-2008 08:56 AM |