05-07-2010, 02: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, 11:19 AM
|
#2 |
|
creator of calibre
 
Posts: 45,609
Karma: 28549044
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
|
what version did you update from?
|
|
|
|
| Advert | |
|
|
|
05-08-2010, 08: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, 09:41 AM
|
#4 |
|
creator of calibre
Posts: 45,609
Karma: 28549044
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, 02: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 |
«
Previous Thread
|
Next Thread
»
| Thread Tools | Search this Thread |
|
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 09:47 PM |
| "Database Disk Image is malformed" when connecting to Calibre after adding new books | djorkboy | Calibre | 1 | 10-06-2010 09:59 PM |
| DatabaseError: malformed database schema (author_insert_trg) - no such table: authors | peterdeegan | Calibre | 3 | 07-03-2010 01:44 AM |
| database disk image is malformed | sirbruce | Calibre | 12 | 06-26-2009 10:06 PM |
| DatabaseError: database disk image is malformed | moggie | Calibre | 2 | 12-13-2008 09:56 AM |
All times are GMT -4. The time now is 04:05 PM.