Calibre: Can't Delete Books?

elliebeans · 02-16-2021, 04:00 PM

Hi hi!

New here so I really hope I'm posting in the right place.

I have a really old iPad Mini, the first generation if I'm not mistaken and I use a PC. So when iBooks was taken away from iTunes, I had to resort to using old versions of Calibre and iTunes to upload books on my iPad...

That being said, the current version of Calibre that I use is Version 3.0

So yeah, superrrr old.

Today I was adding new books to my iPad, as one does, and whilst trying to delete some books that I realise were doubles, it gave me some sort of "no module fts5 error"

Needless to say, after countless of googling it tells me that I have to download the newer version. Is there any alternative to this though? Because a few new versions higher and the iTunes connection is going to disappear. Ugh. I need a new iPad.

If anyone could help, that would be amazing! Thank you! x

ownedbycats · 02-16-2021, 04:06 PM

That happens when you have a library that's been opened in 5.xx and then you open it in an older version. The database isn't quite compatible.

The only way to fix the error is to use Library > Switch/create library to make an empty library (use "copy structure from existing library") and then use "copy to library" to move them over. Then make sure not to open it in a newer version again.

JSWolf · 02-16-2021, 05:47 PM

Quote:

Originally Posted by ownedbycats

That happens when you have a library that's been opened in 4.23/5.xx and then you open it in an older version. The database isn't quite compatible.

The only way to fix the error is to use Library > Switch/create library to make an empty library (use "copy structure from existing library") and then use "copy to library" to move them over. Then make sure not to open it in a newer version again.

Sorry, but that's incorrect. The database only gets changed when using Calibre 5.x. Calibre 4.23 is compatible with the Calibre 5 database but does not change the database if it's not the new version.

The solution (IMHO) is to use cloud storage such as Dropbox and the associated app. Load some ePub and use the cloud app to copy to iBooks.

ownedbycats · 02-16-2021, 05:50 PM

I'll correct my post.

JSWolf · 02-16-2021, 06:50 PM

Calibre 4.23 is the oldest version that's compatible with the Calibre 5 database.

elliebeans · 02-16-2021, 07:40 PM

Quote:

Originally Posted by ownedbycats

That happens when you have a library that's been opened in 5.xx and then you open it in an older version. The database isn't quite compatible.

The only way to fix the error is to use Library > Switch/create library to make an empty library (use "copy structure from existing library") and then use "copy to library" to move them over. Then make sure not to open it in a newer version again.

Hmm, I'm a little confused.

I mean thank you to you both for your help but can we repeat it one more time but much simpler?

JSWolf · 02-16-2021, 08:18 PM

Calibre 5 has changed the database format that Calibre uses. After running Calibre 5 and loading your library, the database format is changed. The only pre-version 5 that can read/write to the new database format is Calibre 4.23. Any older version will not work. So forget using any version of Calibre earlier then 4.23.

elliebeans · 02-19-2021, 10:59 AM

Quote:

Originally Posted by JSWolf

Calibre 5 has changed the database format that Calibre uses. After running Calibre 5 and loading your library, the database format is changed. The only pre-version 5 that can read/write to the new database format is Calibre 4.23. Any older version will not work. So forget using any version of Calibre earlier then 4.23.

Oh... well damn. Because if I am not mistake any version higher than what I have right now... doesn't have the iTunes connection any more. Oh boy.

What do I do now? Get a new iPad clearly. Hahahaha.

Thank you for your help though! So basically to delete again, I have to download any version of Calibre higher than 4.23?

JSWolf · 02-19-2021, 11:07 AM

Quote:

Originally Posted by elliebeans

Oh... well damn. Because if I am not mistake any version higher than what I have right now... doesn't have the iTunes connection any more. Oh boy.

What do I do now? Get a new iPad clearly. Hahahaha.

Thank you for your help though! So basically to delete again, I have to download any version of Calibre higher than 4.23?

You could use Calibre 4.23 as it's compatible with the Calibre 5 database format. But if you can run the current Calibre 5, I suggest doing that.

I also suggest forgetting the old version of Calibre 3 and iTunes as that's all a bit meh! Load your eBooks on a cloud server such as Dropbox or Onedrive and using the cloud storage app, you can download to iBooks/Books (depending on which iPad OS). It also means you can keep the software on your computer up-to-date.

elliebeans · 02-20-2021, 02:30 PM

Quote:

Originally Posted by JSWolf

You could use Calibre 4.23 as it's compatible with the Calibre 5 database format. But if you can run the current Calibre 5, I suggest doing that.

I also suggest forgetting the old version of Calibre 3 and iTunes as that's all a bit meh! Load your eBooks on a cloud server such as Dropbox or Onedrive and using the cloud storage app, you can download to iBooks/Books (depending on which iPad OS). It also means you can keep the software on your computer up-to-date.

Keeping the software on my computer sounds like an absolute dream and I would 100% like to go in that direction if it's possible. This back and forth between old versions is just a headache.

My iPad is really old. I'm not even sure what OS version it is but think of literally the first gen iPad Mini and feel it's age.

So basically any app does not work on it. Netflix, Disney+, the whole she-bang. I'm surprised Spotify and Amazon Prime is still working. Hahahaha.

I did find an app called Calibro which you can apparently synv with Dropbox to use? The only issue is my Dropbox doesn't have a lot of space.

Would you know of anything (like even any cloud server) that could work well with my ancient iPad?

JSWolf · 02-20-2021, 02:37 PM

It seems your iPad Mini is too old to work with the apps you'll need. Dropbox and Onedrive require newer then iOS 9. I'll say it, you may want to consider a newer iPad.

elliebeans · 02-23-2021, 06:44 PM

Ah yes, it seems that that time is upon me and my iPad is slowly but surely saying, "you need a new one". Hahaha. I'm saving up. For a Kindle at least. That'll make my life easier.

Which software does one actually use to add books into one's Kindle anyway? Can I use Calibre and "upload" stuff like I'm currently doing with iTunes?

Sirtel · 02-23-2021, 07:09 PM

Quote:

Originally Posted by elliebeans

Ah yes, it seems that that time is upon me and my iPad is slowly but surely saying, "you need a new one". Hahaha. I'm saving up. For a Kindle at least. That'll make my life easier.

Which software does one actually use to add books into one's Kindle anyway? Can I use Calibre and "upload" stuff like I'm currently doing with iTunes?

You can use Calibre to copy your books to your Kindle, but you can also simply drag and drop them to the Documents folder on your Kindle, no program needed at all.

theducks · 02-23-2021, 07:38 PM

Quote:

Originally Posted by elliebeans

Ah yes, it seems that that time is upon me and my iPad is slowly but surely saying, "you need a new one". Hahaha. I'm saving up. For a Kindle at least. That'll make my life easier.

Which software does one actually use to add books into one's Kindle anyway? Can I use Calibre and "upload" stuff like I'm currently doing with iTunes?

Look at Kobo also. Not as locked down as Amazon is doing. Side loads beautifully and supports 'Series'

elliebeans · 02-26-2021, 04:36 AM

Quote:

Originally Posted by theducks

Look at Kobo also. Not as locked down as Amazon is doing. Side loads beautifully and supports 'Series'

Ooh yeah, I've heard of it before! Thanks for the advice!

02-16-2021, 04:00 PM	#1
elliebeans Member Posts: 19 Karma: 10 Join Date: Jan 2019 Device: iPad Mini, 1st Gen	Calibre: Can't Delete Books? Hi hi! New here so I really hope I'm posting in the right place. I have a really old iPad Mini, the first generation if I'm not mistaken and I use a PC. So when iBooks was taken away from iTunes, I had to resort to using old versions of Calibre and iTunes to upload books on my iPad... That being said, the current version of Calibre that I use is Version 3.0 So yeah, superrrr old. Today I was adding new books to my iPad, as one does, and whilst trying to delete some books that I realise were doubles, it gave me some sort of "no module fts5 error" Needless to say, after countless of googling it tells me that I have to download the newer version. Is there any alternative to this though? Because a few new versions higher and the iTunes connection is going to disappear. Ugh. I need a new iPad. If anyone could help, that would be amazing! Thank you! x

02-16-2021, 04:06 PM	#2
ownedbycats Custom User Title Posts: 8,644 Karma: 61234567 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	That happens when you have a library that's been opened in 5.xx and then you open it in an older version. The database isn't quite compatible. The only way to fix the error is to use Library > Switch/create library to make an empty library (use "copy structure from existing library") and then use "copy to library" to move them over. Then make sure not to open it in a newer version again. Last edited by ownedbycats; 02-16-2021 at 05:50 PM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calibre 3.26.1 X64 unable to delete books	Tijntje	Calibre	10	07-02-2018 08:38 AM
Cannot Delete books while connected to Calibre	Doart	Calibre Companion	2	12-22-2014 07:57 AM
How to delete books versions in Calibre?	ALaguna	Library Management	2	07-28-2012 07:02 AM
How to delete library books from CN using Calibre	BAD18	Devices	2	09-26-2011 03:01 AM
Delete Books from Calibre on OS X?	feralicious	Library Management	3	06-19-2011 06:02 PM

02-16-2021, 05:50 PM	#4
ownedbycats Custom User Title Posts: 8,644 Karma: 61234567 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	I'll correct my post.

02-16-2021, 06:50 PM	#5
JSWolf Resident Curmudgeon Posts: 74,033 Karma: 129333114 Join Date: Nov 2006 Location: Roslindale, Massachusetts Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3	Calibre 4.23 is the oldest version that's compatible with the Calibre 5 database.

02-16-2021, 08:18 PM	#7
JSWolf Resident Curmudgeon Posts: 74,033 Karma: 129333114 Join Date: Nov 2006 Location: Roslindale, Massachusetts Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3	Calibre 5 has changed the database format that Calibre uses. After running Calibre 5 and loading your library, the database format is changed. The only pre-version 5 that can read/write to the new database format is Calibre 4.23. Any older version will not work. So forget using any version of Calibre earlier then 4.23.

02-20-2021, 02:37 PM	#11
JSWolf Resident Curmudgeon Posts: 74,033 Karma: 129333114 Join Date: Nov 2006 Location: Roslindale, Massachusetts Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3	It seems your iPad Mini is too old to work with the apps you'll need. Dropbox and Onedrive require newer then iOS 9. I'll say it, you may want to consider a newer iPad.

02-23-2021, 06:44 PM	#12
elliebeans Member Posts: 19 Karma: 10 Join Date: Jan 2019 Device: iPad Mini, 1st Gen	Ah yes, it seems that that time is upon me and my iPad is slowly but surely saying, "you need a new one". Hahaha. I'm saving up. For a Kindle at least. That'll make my life easier. Which software does one actually use to add books into one's Kindle anyway? Can I use Calibre and "upload" stuff like I'm currently doing with iTunes?

Advert

Advert