Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre

Notices

Reply
 
Thread Tools Search this Thread
Old 05-07-2010, 01:58 AM   #1
cbatalla
Junior Member
cbatalla began at the beginning.
 
Posts: 3
Karma: 10
Join Date: May 2010
Device: Cybook 3Gen
Unhappy 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.
cbatalla is offline   Reply With Quote
Old 05-07-2010, 10:19 AM   #2
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 26,117
Karma: 5101571
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
what version did you update from?
kovidgoyal is offline   Reply With Quote
 
Enthusiast
Old 05-08-2010, 07:32 AM   #3
cbatalla
Junior Member
cbatalla began at the beginning.
 
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.
cbatalla is offline   Reply With Quote
Old 05-08-2010, 08:41 AM   #4
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 26,117
Karma: 5101571
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
kovidgoyal is offline   Reply With Quote
Old 05-08-2010, 01:02 PM   #5
cbatalla
Junior Member
cbatalla began at the beginning.
 
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.
cbatalla is offline   Reply With Quote
Reply

Tags
error message, malformed database

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

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


All times are GMT -4. The time now is 11:52 AM.


MobileRead.com is a privately owned, operated and funded community.