Calibre Not Seeing Kobo Aura H20 Edition 2 Contents

mjt57 · 01-03-2018, 07:41 PM

A friend has a Kobo Aura H2O Edition 2. He cannot get Calibre to detect its contents. So, we connected it to my laptop. Same thing. The device is seen as a removable device under Windows 10 and Calibre sees it as being connected. But when we go to "Device" nothing is displayed.

Then we got an error. Below is the data that was copied to the Clipboard.

calibre, version 3.14.0
ERROR: Error: Error communicating with device

CantOpenError: unable to open database file

Traceback (most recent call last):
File "site-packages\calibre\gui2\device.py", line 87, in run
File "site-packages\calibre\gui2\device.py", line 510, in _books
File "site-packages\calibre\devices\kobo\driver.py", line 1764, in books
File "site-packages\calibre\devices\kobo\driver.py", line 167, in get_database_version
File "c:\t\t\apsw-j6gj96\apsw-3.13.0-r1\src\cursor.c", line 1019, in APSWCursor_execute.sqlite3_prepare
File "c:\t\t\apsw-j6gj96\apsw-3.13.0-r1\src\statementcache.c", line 386, in sqlite3_prepare
CantOpenError: CantOpenError: unable to open database file

I checked all of the Kobo plugins. All are installed and are up-to-date. Even searched for new ones that may be specific to this model Kobo.

Is there anything else that we can do to get Kobo to talk to Calibre?

Thanks
Martin

davidfor · 01-03-2018, 09:14 PM

That error means the database on the device is corrupted. It means that the driver cannot open the database properly to read it. Until this is fixed, calibre will not be able to do anything with the device. And, it will also mean problems when using the device. These problems will usually be losing the reading status of books, or books disappearing and being reimported each time the device is disconnected from the PC as it cannot update the database. These problems are most noticeable after restarting the device as it as any information it can read from the database will be from before when the corruption happened.

The solution is to sign out of the Kobo account on the device. This will rebuild the database from scratch and reimport the books from the device. Unfortunately, you will lose the reading status of any sideloaded books.

mjt57 · 01-04-2018, 06:41 PM

Thanks David. I'll pass this onto my friend for him to try.

As far as books go on the device, he has purchased one book, no "side loaded" books. It's a new device. Just wondering, if it's new how can it become corrupted like this?

davidfor · 01-05-2018, 06:35 PM

The database corruption can be caused by a few things. One is not ejecting it from the PC properly. Others are a crash on the device or something that prevented the database from being written properly. It could be a faulty device, and if it keeps happening without any other obvious cause, then that's what I'd be looking at. But, it isn't my first thought.

01-03-2018, 07:41 PM	#1
mjt57 Connoisseur Posts: 76 Karma: 478544 Join Date: Jan 2011 Location: Victoria, Australia Device: Kindle Oasis, Kindle app on iPad and iPhone	Calibre Not Seeing Kobo Aura H20 Edition 2 Contents A friend has a Kobo Aura H2O Edition 2. He cannot get Calibre to detect its contents. So, we connected it to my laptop. Same thing. The device is seen as a removable device under Windows 10 and Calibre sees it as being connected. But when we go to "Device" nothing is displayed. Then we got an error. Below is the data that was copied to the Clipboard. calibre, version 3.14.0 ERROR: Error: Error communicating with device CantOpenError: unable to open database file Traceback (most recent call last): File "site-packages\calibre\gui2\device.py", line 87, in run File "site-packages\calibre\gui2\device.py", line 510, in _books File "site-packages\calibre\devices\kobo\driver.py", line 1764, in books File "site-packages\calibre\devices\kobo\driver.py", line 167, in get_database_version File "c:\t\t\apsw-j6gj96\apsw-3.13.0-r1\src\cursor.c", line 1019, in APSWCursor_execute.sqlite3_prepare File "c:\t\t\apsw-j6gj96\apsw-3.13.0-r1\src\statementcache.c", line 386, in sqlite3_prepare CantOpenError: CantOpenError: unable to open database file I checked all of the Kobo plugins. All are installed and are up-to-date. Even searched for new ones that may be specific to this model Kobo. Is there anything else that we can do to get Kobo to talk to Calibre? Thanks Martin

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help with Tags/Collections Calibre/Aura H20 (First Edition)	djcnyc	Kobo Reader	4	09-13-2017 09:46 AM
Kobo Aura H20 2nd edition or Tolino Vision 4 HD for library books?	Albert LeRoi	Which one should I buy?	14	07-17-2017 09:03 PM
Calibre sideload - Kobo Aura H20 Ed 2	Avanindra500	Devices	8	07-05-2017 04:46 AM
[Kobo Aura H20] Calibre seems to corrupts the database each time	myki	Devices	15	04-03-2015 02:08 AM
Calibre doesn't detect my Kobo Aura H20	glin	Devices	6	02-11-2015 12:08 PM

01-03-2018, 09:14 PM	#2
davidfor Grand Sorcerer Posts: 24,907 Karma: 47303748 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos	That error means the database on the device is corrupted. It means that the driver cannot open the database properly to read it. Until this is fixed, calibre will not be able to do anything with the device. And, it will also mean problems when using the device. These problems will usually be losing the reading status of books, or books disappearing and being reimported each time the device is disconnected from the PC as it cannot update the database. These problems are most noticeable after restarting the device as it as any information it can read from the database will be from before when the corruption happened. The solution is to sign out of the Kobo account on the device. This will rebuild the database from scratch and reimport the books from the device. Unfortunately, you will lose the reading status of any sideloaded books.

01-04-2018, 06:41 PM	#3
mjt57 Connoisseur Posts: 76 Karma: 478544 Join Date: Jan 2011 Location: Victoria, Australia Device: Kindle Oasis, Kindle app on iPad and iPhone	Thanks David. I'll pass this onto my friend for him to try. As far as books go on the device, he has purchased one book, no "side loaded" books. It's a new device. Just wondering, if it's new how can it become corrupted like this?

01-05-2018, 06:35 PM	#4
davidfor Grand Sorcerer Posts: 24,907 Karma: 47303748 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos	The database corruption can be caused by a few things. One is not ejecting it from the PC properly. Others are a crash on the device or something that prevented the database from being written properly. It could be a faulty device, and if it keeps happening without any other obvious cause, then that's what I'd be looking at. But, it isn't my first thought.

Advert