My Collections gone in Kobo Aura H2O with new database

hoyz · 12-26-2019, 06:47 AM

Due to a "CorruptError: database disk image is malformed" I had my Kobo Aura H2O build a new KoboReader.sqlite. Unfortunately now the "My Collections", created via Genre Column in Calibre is empty. Any ideas what to do? Can I copy parts of the old database to the new one to fix it?

JSWolf · 12-26-2019, 06:56 AM

Quote:

Originally Posted by hoyz

Due to a "CorruptError: database disk image is malformed" I had my Kobo Aura H2O build a new KoboReader.sqlite. Unfortunately now the "My Collections", created via Genre Column in Calibre is empty. Any ideas what to do? Can I copy parts of the old database to the new one to fix it?

If you have a backup of the database, you can copy the backup over the current database. But you then have to put all your eBook back on. Any eBooks in the database no on the device will be deleted from the device when you eject.

jackie_w · 12-26-2019, 07:10 AM

@hoyz,

Before you do any database or book restoring, have you tried just connecting the Kobo to calibre, letting calibre do its stuff then safely disconnecting?

It's calibre that does all the Collection stuff. If you have a new Kobo database you need to give calibre a chance to repopulate the database with Collections and Series info.

hoyz · 12-26-2019, 07:10 AM

Sorry, I don't get that. What do you mean by copy the backup over the current database? If I replace the new database with the new one then I'll have the error again, right? I have kept all books on the device. Do I have to remove them all and put them back on the device?

JSWolf · 12-26-2019, 07:38 AM

If you use the Kobo Utilities plugin, you can have the database backed up every time you connect to your Calibre library. That you'll have a fairly recent backup. Also, if you create a custom yes/No column, you can use the Reading List plugin to keep track of what eBooks you have on your Kobo.

hoyz · 12-26-2019, 07:50 AM

Quote:

Originally Posted by jackie_w

@hoyz,

Before you do any database or book restoring, have you tried just connecting the Kobo to calibre, letting calibre do its stuff then safely disconnecting

I tried this before, but it didn't create the the collections.

hoyz · 12-26-2019, 07:52 AM

Quote:

Originally Posted by JSWolf

If you use the Kobo Utilities plugin, you can have the database backed up every time you connect to your Calibre library. That you'll have a fairly recent backup. Also, if you create a custom yes/No column, you can use the Reading List plugin to keep track of what eBooks you have on your Kobo.

I have a backup of the database right before I created the new one. And I simply have all the epubs and none of the other formats organized in Calibre on my Kobo, so that's not a problem to know which books are on there.

davidfor · 12-26-2019, 09:36 PM

Quote:

Originally Posted by hoyz

I have a backup of the database right before I created the new one. And I simply have all the epubs and none of the other formats organized in Calibre on my Kobo, so that's not a problem to know which books are on there.

When you connect the device, calibre should update the collections on the device. To do that, it requires the options to be set in the driver, and the metadata management option on the "Sending books to devices" page of the preferences to the set to the automatic option. The latter being wrong is a common reason for the collection management not to happen. You should check the configuration. There have been resetting of configurations with calibre updates. It shouldn't happen, but, it seems to. And, one it does happen, it is to late to work out why.

Another reason is changing between the KoboTouch and KoboTouchExtended drivers. While the options are the same, they are not shared. You need to configure them separately. And if you change between the drivers, you need to manually copy the options if you want them to be the same (though that is a good idea for my Kobo Utilities plugin).

The other thing is that the collection management is only done for books on the device that calibre has matched to books in the current library. The collection management will only be done if there book in the library has a green tick against it indicating it is on the device.

hoyz · 12-27-2019, 06:41 AM

Thank you very much for your help. I tried everything but unfortunately it didn't work. A full reset was the only solution.

12-26-2019, 06:47 AM	#1
hoyz Member Posts: 11 Karma: 10 Join Date: Dec 2019 Device: Kobo Aura H2O	My Collections gone in Kobo Aura H2O with new database Due to a "CorruptError: database disk image is malformed" I had my Kobo Aura H2O build a new KoboReader.sqlite. Unfortunately now the "My Collections", created via Genre Column in Calibre is empty. Any ideas what to do? Can I copy parts of the old database to the new one to fix it?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Tolino Android for Kobo Aura/Aura 2/Aura H2O	honeywhite	Kobo Developer's Corner	1	10-30-2018 04:11 PM
Kobo Aura H2O 2nd Edition vs old Kobo Aura H2O screen dimentions.	iXPert12	Kobo Reader	1	09-18-2017 09:35 AM
Kobo aura h2o display on aura hd?	gezzer	Kobo Developer's Corner	3	02-22-2017 10:32 AM
My Collections on Aura H2O from Calibre	dentateck	Kobo Reader	4	09-10-2015 08:12 AM
Replacing Nook Simple Touch: Onyx T68 vs Kobo Aura vs Kobo Aura H2O	iNovelReader	Which one should I buy?	0	10-28-2014 01:40 AM

12-26-2019, 07:10 AM	#3
jackie_w Grand Sorcerer Posts: 6,251 Karma: 16539642 Join Date: Sep 2009 Location: UK Device: ClaraHD, Forma, Libra2, Clara2E, LibraCol, PBTouchHD3	@hoyz, Before you do any database or book restoring, have you tried just connecting the Kobo to calibre, letting calibre do its stuff then safely disconnecting? It's calibre that does all the Collection stuff. If you have a new Kobo database you need to give calibre a chance to repopulate the database with Collections and Series info.

12-26-2019, 07:38 AM	#5
JSWolf Resident Curmudgeon Posts: 79,758 Karma: 145864619 Join Date: Nov 2006 Location: Roslindale, Massachusetts Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3	If you use the Kobo Utilities plugin, you can have the database backed up every time you connect to your Calibre library. That you'll have a fairly recent backup. Also, if you create a custom yes/No column, you can use the Reading List plugin to keep track of what eBooks you have on your Kobo.

12-27-2019, 06:41 AM	#9
hoyz Member Posts: 11 Karma: 10 Join Date: Dec 2019 Device: Kobo Aura H2O	Thank you very much for your help. I tried everything but unfortunately it didn't work. A full reset was the only solution.

Advert

Advert