Error: malformed database schema (books_insert_trg)

cbatalla · 05-07-2010, 01:58 AM

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.

kovidgoyal · 05-07-2010, 10:19 AM

what version did you update from?

cbatalla · 05-08-2010, 07:32 AM

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.

kovidgoyal · 05-08-2010, 08:41 AM

Strange, can you mail your database to me (the file metadata.db) to kovid at kovidgoyal. net

cbatalla · 05-08-2010, 01:02 PM

Of course! I have already sent it to you. Thanks a lot for your help.

05-07-2010, 01:58 AM	#1
cbatalla 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-08-2010, 07:32 AM	#3
cbatalla 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, 01:02 PM	#5
cbatalla 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.

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

05-07-2010, 10:19 AM	#2
kovidgoyal creator of calibre Posts: 45,345 Karma: 27182818 Join Date: Oct 2006 Location: Mumbai, India Device: Various	what version did you update from?

05-08-2010, 08:41 AM	#4
kovidgoyal creator of calibre Posts: 45,345 Karma: 27182818 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

Advert

Advert