After calibre update having some issues with errors

[mted558]

I've been using calibre for awhile with no real issues but since the last 2 updates every time I try to open the program up I get an error message about corrupt files "your calibre database seems to be corrupted. Do you want calibre to try and repair it automatically? If you say No, a new empty calibre library will be created." When I say yes, it says "the database repair failed. Starting with a new empty library." Then I get error that says "Bad database location u'C:\\(the location I renamed). calibre will now quit."
If I say no, it asks me to create a new location for the files but whatever I call it I get another error that says same as above, "bad database......calibre will now quit." I've tried uninstalling and reinstalling the program, still get same errors. Not exactly sure what to do next. I used the program earlier today and it was fine.
This is the second time it's happened in the past 2 days. First it works fine, after I convert a few books,close the program then reopen it I get these errors. Anyone have any ideas???

[chaley]

Ensure you are using 0.7.40 or 0.7.38. Do *not* use 0.7.39.

If you are not using 0.7.39, then we need more information. Please start calibre in debug mode. In a command box, type
calibre-debug -g
then copy and post the information printed.

[mted558]

I'm getting an error when I type the command "calibre-debug-g is not recognized as an internal or external command,operable program or batch file" I'm using 0.7.40 but I did have the 0.7.39 and that's when this started.

[mted558]

this is what I'm getting when I try to open a database
"Traceback (most recent call last):
File "site-packages\calibre\gui2\main.py", line 195, in initialize_db_stage2
File "site-packages\calibre\library\database2.py", line 163, in __init__
File "site-packages\calibre\library\database2.py", line 207, in initialize_dynamic
File "site-packages\calibre\library\sqlite.py", line 251, in run
DatabaseException: unable to open database file
RemoteTraceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file"

[chaley]

Is calibre running in your system tray?

[Manichean]

Originally Posted by mted558

I'm getting an error when I type the command "calibre-debug-g is not recognized as an internal or external command,operable program or batch file" I'm using 0.7.40 but I did have the 0.7.39 and that's when this started.

Apart from needing to close Calibre down before starting the debug, of course, you also need to mind the spaces. You should type

calibre-debug -g

(notice the space between "debug" and "-g").

[mted558]

I've uninstalled calibre and I'm going to try to install again. Now my issue is I can't delete the calibre library. I keep getting an error message that says I "don't have permission to perform these actions". I've been trying to find out how to change the permissions but when I click allow it's still giving me the same error. I'm sure if I can possibly delete these old libraries I would be OK, I think that's where the issue is but I can't delete the folder.

[Manichean]

Your initial error might possibly be connected to the permission issues you're seeing now. Ordinarily, the Calibre library should have full access permissions for the user who initially created the library, I believe. Is that the case for you? What OS are you running?

[mted558]

I'm running Windows 7 and I'm pretty sure it's an issue with the permissions, I've tried everything to change the permissions, allow everything, etc,etc,etc, blah,blah,blah. I sure it's something fairly simple that I need to do but just can't seem to figure it out. I've gone thru all the change permission info on the windows 7 help site and it's still saying I don't have permission. I just thought if maybe someone else had the same issue they could talk me thru it.

[mted558]

By the way, this is the only folder/file I'm having a permission error that I know of so that's why at first I thought it was an issue with Calibre but now I'm wondering....

[Manichean]

I can't help you further with that issue, because I don't know Win7. However, can you tell me if the account you're currently logged in as is the same account you used to create the Calibre library in the first place?
Also, I just thought that maybe logging in as Administrator may possibly help you setting the permissions, if your account doesn't have admin privileges in the first place.

[chaley]

You might need to sign in as an admin to change the permissions. This is certain if you are not the folder's owner.

[mted558]

I am the folder's owner, I'm the administrator. I created the folder originally. If anyone else has any ideas I'd really appreciate it. Thanks to those that have tried!!

[mted558]

ok finally got the libraries deleted. So I reinstalled calibre and got the same error about the database being corrupted. I'm so confused now. I don't know what else to try.

[mted558]

did the command prompt, got a really long debug report, not sure if you want me to copy all of it, but here it is:

File "site-packages\calibre\debug.py", line 80, in reinit_db
File "site-packages\calibre\library\sqlite.py", line 251, in run
DatabaseException: unable to open database file
RemoteTraceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file

Traceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file
Traceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file
SQL line u'CREATE VIEW tag_browser_authors AS SELECT\n id,\n
name,\n (SELECT COUNT(id) FROM books_autho
rs_link WHERE author=authors.id) count,\n (SELECT AVG(ratings
.rating)\n FROM books_authors_link AS tl, books_ratings_link
AS bl, ratings\n WHERE tl.author=authors.id AND bl.book=tl.
book AND\n ratings.id = bl.rating AND ratings.rating <> 0) a
vg_rating,\n sort AS sort\n FROM authors;' fa
iled with error:
Traceback (most recent call last):
File "site-packages\calibre\debug.py", line 80, in reinit_db
File "site-packages\calibre\library\sqlite.py", line 251, in run
DatabaseException: unable to open database file
RemoteTraceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file

Traceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file
Traceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file
SQL line u'CREATE VIEW tag_browser_filtered_authors AS SELECT\n
id,\n name,\n (SELECT COUNT(books_autho
rs_link.id) FROM books_authors_link WHERE\n author=author
s.id AND books_list_filter(book)) count,\n (SELECT AVG(rating
s.rating)\n FROM books_authors_link AS tl, books_ratings_lin
k AS bl, ratings\n WHERE tl.author=authors.id AND bl.book=tl
.book AND\n ratings.id = bl.rating AND ratings.rating <> 0 A
ND\n books_list_filter(bl.book)) avg_rating,\n
sort AS sort\n FROM authors;' failed with error:
Traceback (most recent call last):
File "site-packages\calibre\debug.py", line 80, in reinit_db
File "site-packages\calibre\library\sqlite.py", line 251, in run
DatabaseException: unable to open database file
RemoteTraceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file

Traceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file
Traceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file
SQL line u'CREATE VIEW tag_browser_series AS SELECT\n id,\n
name,\n (SELECT COUNT(id) FROM books_series
_link WHERE series=series.id) count,\n (SELECT AVG(ratings.ra
ting)\n FROM books_series_link AS tl, books_ratings_link AS
bl, ratings\n WHERE tl.series=series.id AND bl.book=tl.book
AND\n ratings.id = bl.rating AND ratings.rating <> 0) avg_ra
ting,\n (title_sort(name)) AS sort\n FROM ser
ies;' failed with error:
Traceback (most recent call last):
File "site-packages\calibre\debug.py", line 80, in reinit_db
File "site-packages\calibre\library\sqlite.py", line 251, in run
DatabaseException: unable to open database file
RemoteTraceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file

Traceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file
Traceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file
SQL line u'CREATE VIEW tag_browser_filtered_series AS SELECT\n
id,\n name,\n (SELECT COUNT(books_series
_link.id) FROM books_series_link WHERE\n series=series.id
AND books_list_filter(book)) count,\n (SELECT AVG(ratings.ra
ting)\n FROM books_series_link AS tl, books_ratings_link AS
bl, ratings\n WHERE tl.series=series.id AND bl.book=tl.book
AND\n ratings.id = bl.rating AND ratings.rating <> 0 AND\n
books_list_filter(bl.book)) avg_rating,\n
(title_sort(name)) AS sort\n FROM series;' failed with error:
Traceback (most recent call last):
File "site-packages\calibre\debug.py", line 80, in reinit_db
File "site-packages\calibre\library\sqlite.py", line 251, in run
DatabaseException: unable to open database file
RemoteTraceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file

Traceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file
Traceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file
SQL line u'CREATE VIEW tag_browser_publishers AS SELECT\n id,
\n name,\n (SELECT COUNT(id) FROM books_pu
blishers_link WHERE publisher=publishers.id) count,\n (SELECT
AVG(ratings.rating)\n FROM books_publishers_link AS tl, boo
ks_ratings_link AS bl, ratings\n WHERE tl.publisher=publishe
rs.id AND bl.book=tl.book AND\n ratings.id = bl.rating AND r
atings.rating <> 0) avg_rating,\n name AS sort\n
FROM publishers;' failed with error:
Traceback (most recent call last):
File "site-packages\calibre\debug.py", line 80, in reinit_db
File "site-packages\calibre\library\sqlite.py", line 251, in run
DatabaseException: unable to open database file
RemoteTraceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file

Traceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file
Traceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file
SQL line u'CREATE VIEW tag_browser_filtered_publishers AS SELECT\n
id,\n name,\n (SELECT COUNT(books_pu
blishers_link.id) FROM books_publishers_link WHERE\n publ
isher=publishers.id AND books_list_filter(book)) count,\n (SE
LECT AVG(ratings.rating)\n FROM books_publishers_link AS tl,
books_ratings_link AS bl, ratings\n WHERE tl.publisher=publ
ishers.id AND bl.book=tl.book AND\n ratings.id = bl.rating A
ND ratings.rating <> 0 AND\n books_list_filter(bl.book)) avg
_rating,\n name AS sort\n FROM publishers;' f
ailed with error:
Traceback (most recent call last):
File "site-packages\calibre\debug.py", line 80, in reinit_db
File "site-packages\calibre\library\sqlite.py", line 251, in run
DatabaseException: unable to open database file
RemoteTraceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file

Traceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file
Traceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file
SQL line u'CREATE VIEW tag_browser_ratings AS SELECT\n id,\n
rating,\n (SELECT COUNT(id) FROM books_rat
ings_link WHERE rating=ratings.id) count,\n (SELECT AVG(ratin
gs.rating)\n FROM books_ratings_link AS tl, books_ratings_li
nk AS bl, ratings\n WHERE tl.rating=ratings.id AND bl.book=t
l.book AND\n ratings.id = bl.rating AND ratings.rating <> 0)
avg_rating,\n rating AS sort\n FROM ratings;
' failed with error:
Traceback (most recent call last):
File "site-packages\calibre\debug.py", line 80, in reinit_db
File "site-packages\calibre\library\sqlite.py", line 251, in run
DatabaseException: unable to open database file
RemoteTraceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file

Traceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file
Traceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file
SQL line u'CREATE VIEW tag_browser_filtered_ratings AS SELECT\n
id,\n rating,\n (SELECT COUNT(books_rat
ings_link.id) FROM books_ratings_link WHERE\n rating=rati
ngs.id AND books_list_filter(book)) count,\n (SELECT AVG(rati
ngs.rating)\n FROM books_ratings_link AS tl, books_ratings_l
ink AS bl, ratings\n WHERE tl.rating=ratings.id AND bl.book=
tl.book AND\n ratings.id = bl.rating AND ratings.rating <> 0
AND\n books_list_filter(bl.book)) avg_rating,\n
rating AS sort\n FROM ratings;' failed with error:
Traceback (most recent call last):
File "site-packages\calibre\debug.py", line 80, in reinit_db
File "site-packages\calibre\library\sqlite.py", line 251, in run
DatabaseException: unable to open database file
RemoteTraceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file

Traceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file
Traceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file
SQL line u'CREATE VIEW tag_browser_tags AS SELECT\n id,\n
name,\n (SELECT COUNT(id) FROM books_tags_lin
k WHERE tag=tags.id) count,\n (SELECT AVG(ratings.rating)\n
FROM books_tags_link AS tl, books_ratings_link AS bl, ratings
\n WHERE tl.tag=tags.id AND bl.book=tl.book AND\n
ratings.id = bl.rating AND ratings.rating <> 0) avg_rating,\n
name AS sort\n FROM tags;' failed with error:
Traceback (most recent call last):
File "site-packages\calibre\debug.py", line 80, in reinit_db
File "site-packages\calibre\library\sqlite.py", line 251, in run
DatabaseException: unable to open database file
RemoteTraceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file

Traceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file
Traceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file
SQL line u'CREATE VIEW tag_browser_filtered_tags AS SELECT\n
id,\n name,\n (SELECT COUNT(books_tags_lin
k.id) FROM books_tags_link WHERE\n tag=tags.id AND books_
list_filter(book)) count,\n (SELECT AVG(ratings.rating)\n
FROM books_tags_link AS tl, books_ratings_link AS bl, ratings\n
WHERE tl.tag=tags.id AND bl.book=tl.book AND\n
ratings.id = bl.rating AND ratings.rating <> 0 AND\n
books_list_filter(bl.book)) avg_rating,\n name AS sort\n
FROM tags;' failed with error:
Traceback (most recent call last):
File "site-packages\calibre\debug.py", line 80, in reinit_db
File "site-packages\calibre\library\sqlite.py", line 251, in run
DatabaseException: unable to open database file
RemoteTraceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file

Traceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file
Traceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file
SQL line u'CREATE TRIGGER books_update_trg\n AFTER UPDATE ON books\n
BEGIN\n UPDATE books SET sort=title_sort(NEW.title)\n
WHERE id=NEW.id AND OLD.title <> NEW.title;\n END
;' failed with error:
Traceback (most recent call last):
File "site-packages\calibre\debug.py", line 80, in reinit_db
File "site-packages\calibre\library\sqlite.py", line 251, in run
DatabaseException: unable to open database file
RemoteTraceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file

Traceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file
Traceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file
SQL line u'CREATE TRIGGER books_delete_trg\n AFTER DELETE ON books\n
BEGIN\n DELETE FROM books_authors_link WHERE book=OLD.
id;\n DELETE FROM books_publishers_link WHERE book=OLD.id;\n
DELETE FROM books_ratings_link WHERE book=OLD.id;\n DE
LETE FROM books_series_link WHERE book=OLD.id;\n DELETE FROM book
s_tags_link WHERE book=OLD.id;\n DELETE FROM data WHERE book=OLD.
id;\n DELETE FROM comments WHERE book=OLD.id;\n DE
LETE FROM conversion_options WHERE book=OLD.id;\n DELETE FROM boo
ks_plugin_data WHERE book=OLD.id;\n END;' failed with error:
Traceback (most recent call last):
File "site-packages\calibre\debug.py", line 80, in reinit_db
File "site-packages\calibre\library\sqlite.py", line 251, in run
DatabaseException: unable to open database file
RemoteTraceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file

SQL line 'COMMIT;' failed with error:
Traceback (most recent call last):
File "site-packages\calibre\debug.py", line 80, in reinit_db
File "site-packages\calibre\library\sqlite.py", line 251, in run
DatabaseException: cannot commit - no transaction is active
RemoteTraceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: cannot commit - no transaction is active

Traceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file
Traceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 215, in run
OperationalError: unable to open database file
Upgrading database to version 2...
Upgrading database to version 3...
Upgrading database to version 4...
Upgrading database to version 5...
Upgrading database to version 6...
Upgrading database to version 7...
Catastrophic failure initializing GUI, bailing out...
Error in sys.excepthook:

Original exception was:

C:\Users\Monica>