can't open calibre in window - after update to 0.4.84

[asfaltboy]

I can't open calibre (windows) after installing latest version (0.4.84)..

no errors appear, but it seems to happen right after choosing a library folder, the interface appears for a second and directly dissapears..

maybe i'm not doing it right, which folder should I chose for my library?

p.s: tried searching for "library1.db", "calibre.ini" and "calibre2.ini" and they don't exist on my hard drive... also i don't have a "VirtualStore\Program Files\calibre" dir in my users folder (i'm using vista obviously).

paul

[tonyofla]

same thing happens to me.

[kovidgoyal]

Post the output from running the following command in a terminal

calibre-debug -c "from calibre.gui2.main import main; main()"

[tonyofla]

Upgrading database to version 2...
Traceback (most recent call last):
File "debug.py", line 66, in <module>
File "debug.py", line 55, in main
File "<string>", line 1, in <module>
File "C:\Program Files\calibre\library.zip\calibre\gui2\main.py", line 1387, i
n main
File "C:\Program Files\calibre\library.zip\calibre\gui2\main.py", line 220, in
__init__
File "calibre\library\database2.pyo", line 386, in __init__
File "calibre\library\database2.pyo", line 412, in upgrade_version_1
sqlite3.OperationalError: no such index: series_idx

[kovidgoyal]

When you first ran calibre, did it transfer all your books to the new library? Or did it never run at all?

[tonyofla]

it never ran at all.

[kovidgoyal]

Delete the metadata.db file and also the file global.py in the calibre directory (do a search for it). Then re-run calibre (0.4.85)

[tonyofla]

thanks, I'll try that tomorrow.

[asfaltboy]

Originally Posted by kovidgoyal

Delete the metadata.db file and also the file global.py in the calibre directory (do a search for it). Then re-run calibre (0.4.85)

Couldn't find neither of these files in all my hard-drive... not in calibre folder too..

[kovidgoyal]

Originally Posted by asfaltboy

Couldn't find neither of these files in all my hard-drive... not in calibre folder too..

You probably have a different problem. Post the output from the calibre debug command i posted before.

[tonyofla]

I couldn’t find the files to be deleted either, after several searches . So I deleted the programme and did a fresh install. Again, it wouldn’t start. Then, I disabled my anti virus (Kaspersky) and installed again. And it’s working! So, I’m guessing that Kaspersky was blocking something during the install? Great upgrade by the way, addition of Irish Times in news feeds a nice plus! (should add that it installed and worked without any problem on my macbook) So Vista+Kaspersky seems to be a problem, at least for me.

[kovidgoyal]

Hmm interesting. I think I should add that tip to the FAQ.

[asfaltboy]

following the above, i disabled my av (trend micro internet security pro) and installed calibre, now it seems to load at last ! thanks guys, great piece of software!

[machalla]

Hi,

I'm having a similar problem with Version: 0.4.89 on windows xp (sp3). I have tried disabling realtime protection in avast but that made no difference. The gui never shows, the application just asks about a location for the library every time its run.

Looks like some issue with the sqllite db but I don't know enough about the program to debug this issue properly.

Thanks for any help you can offer.

-----

Debug Info is :

C:\Program Files\calibre>calibre-debug -c "from calibre.gui2.main import main; m
ain()"
Upgrading database from version: 1
Traceback (most recent call last):
File "debug.py", line 66, in <module>
File "debug.py", line 55, in main
File "<string>", line 1, in <module>
File "C:\Program Files\calibre\library.zip\calibre\gui2\main.py", line 1252, i
n main
File "C:\Program Files\calibre\library.zip\calibre\gui2\main.py", line 76, in
__init__
File "C:\Program Files\calibre\library.zip\calibre\gui2\main.py", line 1170, i
n read_settings
File "C:\Program Files\calibre\library.zip\calibre\gui2\main.py", line 1166, i
n initialize_database
File "calibre\library\database.pyo", line 801, in __init__
File "calibre\library\database.pyo", line 615, in upgrade_version1
sqlite3.OperationalError: duplicate column name: author_sort

[kovidgoyal]

delete the file library1.db and the file metadata.db