Deleting custom columns without opening Calibre

[Tanjamuse]

Every time I try to click on "show details" Cailbre disappear and crashes ...

[Tanjamuse]

I managed to press Copy to clipboard:

calibre, version 2.7.0
ERROR: Unhandled exception: <b>MemoryError</b>:

calibre 2.7 isfrozen: True is64bit: False
Windows-7-6.1.7601-SP1 Windows ('32bit', 'WindowsPE')
32bit process running on 64bit windows
('Windows', '7', '6.1.7601')
Python 2.7.8
Windows: ('7', '6.1.7601', 'SP1', 'Multiprocessor Free')
Successfully initialized third party plugins: Modify ePub && Wiki Reader && Manage Series && Reading List && Find Duplicates && User Category && Read MP3 AudioBook metadata && Generate Cover && Count Pages && EpubMerge && FanFictionDownLoader
Traceback (most recent call last):
File "site-packages\calibre\gui2\actions\choose_library.py", line 567, in qs_requested
File "site-packages\calibre\gui2\actions\choose_library.py", line 547, in switch_requested
File "site-packages\calibre\gui2\ui.py", line 668, in library_moved
File "site-packages\calibre\gui2\tag_browser\view.py", line 181, in set_database
File "site-packages\calibre\gui2\tag_browser\model.py", line 285, in set_database
File "site-packages\calibre\gui2\tag_browser\model.py", line 308, in _run_rebuild
File "site-packages\calibre\gui2\tag_browser\model.py", line 313, in _rebuild_node_tree
File "site-packages\calibre\gui2\tag_browser\model.py", line 871, in _get_category_nodes
File "site-packages\calibre\db\legacy.py", line 776, in <lambda>
File "site-packages\calibre\db\cache.py", line 948, in get_categories
File "site-packages\calibre\db\categories.py", line 152, in get_categories
File "site-packages\calibre\db\fields.py", line 311, in get_composite_categories
MemoryError

[chaley]

I changed your library so that the #virtual_libraries column contains only the word "foo". I then backed up to calibre V2.7 and opened your library. It opened in 62 seconds and I had no trouble looking at book details for a number of books.

The changed metadata.db is here. Note that it is a modification of the one you posted. If you have changed your library after you put that link in dropbox then those changes won't be there. Be sure to make a backup of your metadata.db.

I also note that you are using 32-bit calibre on 64-bit windows. I am using 64-bit calibre. You might want to try using 64-bit calibre, as it can use more memory than the 32-bit version.

[Tanjamuse]

Where is the 64-bit calibre?

When I download the one on the website it's always 32-bit.

[eschwartz]

Originally Posted by Tanjamuse

Where is the 64-bit calibre?

When I download the one on the website it's always 32-bit.

There are two download options (actually 5 ) -- "Windows" and "Windows 64bit".

[chaley]

Originally Posted by Tanjamuse

Where is the 64-bit calibre?

When I download the one on the website it's always 32-bit.

It is the one marked as Windows 64bit.

[Tanjamuse]

It never occured to me to scroll further down

I have now downloaded the 64-bit Calibre ... Can I run that one and keep all the settings I already have?

[PeterT]

Originally Posted by Tanjamuse

It never occured to me to scroll further down

I have now downloaded the 64-bit Calibre ... Can I run that one and keep all the settings I already have?

Yes... you can move transparently between the two; but only run one at a time.