MobileRead Forums
Register Guidelines E-Books Today's Posts Search

Go Back   MobileRead Forums > E-Book Software > Calibre > Devices
Reload this Page What does this [Kobo] database error mean?

Notices

Reply
Page 1 of 2 1 2
 
Thread Tools Search this Thread
Old 01-03-2024, 05:05 AM   #1
Uncle Robin
Diligent dilettante
Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.
 
Uncle Robin's Avatar
 
Posts: 3,649
Karma: 52424118
Join Date: Sep 2019
Location: in my mind
Device: Kobo Sage; Kobo Libra Colour
What does this [Kobo] database error mean?
I just connected my Sage and got "error connecting with device" again. When I ran Kobo Utilities database check, I got this:

Quote:
Result of running 'PRAGMA integrity_check' on database on the Kobo device:


*** in database main ***
Tree 3 page 12769 cell 0: 2nd reference to page 15967
Tree 3 page 14832 cell 97: Rowid 9809 out of order
Tree 3 page 16424 cell 3: Rowid 9813 out of order
Tree 20 page 20 cell 16: 2nd reference to page 16295
Page 9874: never used
Page 16323: never used
non-unique entry in index sqlite_autoindex_content_1
non-unique entry in index sqlite_autoindex_content_1
non-unique entry in index sqlite_autoindex_content_1
non-unique entry in index sqlite_autoindex_content_1
non-unique entry in index sqlite_autoindex_content_1
non-unique entry in index sqlite_autoindex_content_1
NULL value in Achievement.ImageId
NULL value in Achievement.Name
row 25 missing from index sqlite_autoindex_Achievement_1
NULL value in Achievement.ImageId
NULL value in Achievement.Name
row 26 missing from index sqlite_autoindex_Achievement_1
What does this mean and how do I fix it?
Uncle Robin is offline   Reply With Quote
Old 01-03-2024, 07:11 AM   #2
chaley
Grand Sorcerer
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 12,346
Karma: 8012652
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
Moderator Notice
Moved to the devices forum because this is a Kobo question.
chaley is offline   Reply With Quote
Advert
Old 01-03-2024, 07:14 AM   #3
Uncle Robin
Diligent dilettante
Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.
 
Uncle Robin's Avatar
 
Posts: 3,649
Karma: 52424118
Join Date: Sep 2019
Location: in my mind
Device: Kobo Sage; Kobo Libra Colour
Sorry for putting it in the wrong forum. I managed to get back up and running by logging out of my Kobo account and logging back in, but I have another, related question:

Since my first run-in with "malformed database" last weekend, I've been using Kobo Utilities to create a backup every day. How do I restore from that backup if needed?
Uncle Robin is offline   Reply With Quote
Old 01-03-2024, 07:51 AM   #4
Terisa de morgan
Grand Sorcerer
Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.
 
Terisa de morgan's Avatar
 
Posts: 6,597
Karma: 12595249
Join Date: Jun 2009
Location: Madrid, Spain
Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2
Quote:
Originally Posted by Uncle Robin View Post
Sorry for putting it in the wrong forum. I managed to get back up and running by logging out of my Kobo account and logging back in, but I have another, related question:

Since my first run-in with "malformed database" last weekend, I've been using Kobo Utilities to create a backup every day. How do I restore from that backup if needed?
You only need to copy the database file "KoboReader.sqlite" in the .kobo directory and eject the ereader. What you did with the loghout and login is, basically, wipe clean the database.
Terisa de morgan is offline   Reply With Quote
Old 01-03-2024, 07:57 AM   #5
Uncle Robin
Diligent dilettante
Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.
 
Uncle Robin's Avatar
 
Posts: 3,649
Karma: 52424118
Join Date: Sep 2019
Location: in my mind
Device: Kobo Sage; Kobo Libra Colour
Quote:
Originally Posted by Terisa de morgan View Post
You only need to copy the database file "KoboReader.sqlite" in the .kobo directory and eject the ereader.

Thank you, that's what I thought most likely, but wanted to be absolutely sure.
Uncle Robin is offline   Reply With Quote
Advert
Old 01-03-2024, 10:46 AM   #6
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 30,916
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Quote:
Originally Posted by Uncle Robin View Post
Sorry for putting it in the wrong forum. I managed to get back up and running by logging out of my Kobo account and logging back in, but I have another, related question:

Since my first run-in with "malformed database" last weekend, I've been using Kobo Utilities to create a backup every day. How do I restore from that backup if needed?
Utilities backup of the DB Creates a date encoded Zip file (has serial#, then.date-time code
eg ... 29011-20240101-172231.zip
That ZIP is where you find the file @terisa mentions
theducks is offline   Reply With Quote
Old 01-03-2024, 10:54 AM   #7
Uncle Robin
Diligent dilettante
Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.
 
Uncle Robin's Avatar
 
Posts: 3,649
Karma: 52424118
Join Date: Sep 2019
Location: in my mind
Device: Kobo Sage; Kobo Libra Colour
Quote:
Originally Posted by theducks View Post
Utilities backup of the DB Creates a date encoded Zip file (has serial#, then.date-time code
eg ... 29011-20240101-172231.zip

Where do I find these ZIPs? When I click on Kobo Utilities>Database>Backup Device Database it opens the standard file save dialog, asking me for both a filename and a destination directory. I've been giving them dates as names - 2023-12-31.sqlite, etc.
Uncle Robin is offline   Reply With Quote
Old 01-03-2024, 11:10 AM   #8
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 30,916
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Where you put them


BTW no need to put a date, that happens automatically.
I have 2 folders configured, 1 for each device
I chose to put each of those in a Kobo folder in Documents ( made folders for Aura and Libra there)
Attached Thumbnails
Click image for larger version Name: KoboUtilsBackup.JPG Views: 131 Size: 129.0 KB ID: 205553  
theducks is offline   Reply With Quote
Old 01-03-2024, 11:27 AM   #9
Uncle Robin
Diligent dilettante
Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.
 
Uncle Robin's Avatar
 
Posts: 3,649
Karma: 52424118
Join Date: Sep 2019
Location: in my mind
Device: Kobo Sage; Kobo Libra Colour
Quote:
Originally Posted by theducks View Post
Where you put them


BTW no need to put a date, that happens automatically.
I have 2 folders configured, 1 for each device
I chose to put each of those in a Kobo folder in Documents ( made folders for Aura and Libra there)
Sorry, I should haven clearer. I meant where are the ZIP files you mentioned stored? The screenshot shows what I mentioned above. Running the Utilities Database option generates an sqlite file, not a ZIP, and does not automatically name it, it prompts me for a name, without which it will not save. I have no ZIP files anywhere of the type you describe.
Attached Thumbnails
Click image for larger version Name: backup.jpg Views: 121 Size: 50.0 KB ID: 205554  
Uncle Robin is offline   Reply With Quote
Old 01-03-2024, 11:39 AM   #10
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 30,916
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
I assumed you used the utilities to backup. That is what zipped the devices .kobo folder. <you might need to tell Windows to show hidden files/folders. >
If you had not configured the PI on the screen shown, It should ask (as it seems it did)
theducks is offline   Reply With Quote
Old 01-03-2024, 11:46 AM   #11
Uncle Robin
Diligent dilettante
Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.
 
Uncle Robin's Avatar
 
Posts: 3,649
Karma: 52424118
Join Date: Sep 2019
Location: in my mind
Device: Kobo Sage; Kobo Libra Colour
Quote:
Originally Posted by theducks View Post
I assumed you used the utilities to backup. That is what zipped the devices .kobo folder. <you might need to tell Windows to show hidden files/folders. >
If you had not configured the PI on the screen shown, It should ask (as it seems it did)
Sorry, I'm clearly making some fundamental error of comprehension here. You say "I Assumed you use the utilities to backup". I am using the Kobo Utilities plugin in Calibre - is that not the "utilities" you mean? My Windows is set to show hidden files and folders (and extensions), and has been since XP
Uncle Robin is offline   Reply With Quote
Old 01-03-2024, 11:58 AM   #12
rantanplan
Weirdo
rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.
 
Posts: 825
Karma: 11003000
Join Date: Nov 2019
Location: Wuppertal, Germany
Device: Kobo Sage, Kobo Libra 2, Boox Note Air 2+
You have to actively set up the database backup and tell the plugin where to store the backup. If you didn't do that, you have no backup.
rantanplan is offline   Reply With Quote
Old 01-03-2024, 12:00 PM   #13
Uncle Robin
Diligent dilettante
Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.Uncle Robin ought to be getting tired of karma fortunes by now.
 
Uncle Robin's Avatar
 
Posts: 3,649
Karma: 52424118
Join Date: Sep 2019
Location: in my mind
Device: Kobo Sage; Kobo Libra Colour
Quote:
Originally Posted by rantanplan View Post
You have to actively set up the database backup and tell the plugin where to store the backup. If you didn't do that, you have no backup.
So the sqlite files I've been saving are not usable, even if I rename them to KoboReader.sqlite ?
Uncle Robin is offline   Reply With Quote
Old 01-03-2024, 01:25 PM   #14
rantanplan
Weirdo
rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.
 
Posts: 825
Karma: 11003000
Join Date: Nov 2019
Location: Wuppertal, Germany
Device: Kobo Sage, Kobo Libra 2, Boox Note Air 2+
Now I'm confused. If you have the files, you can just copy them on your Kobo as "theducks" suggested.
rantanplan is offline   Reply With Quote
Old 01-03-2024, 01:32 PM   #15
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 30,916
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Quote:
Originally Posted by Uncle Robin View Post
So the sqlite files I've been saving are not usable, even if I rename them to KoboReader.sqlite ?
The file name you put back must be the same as what was THERE. (in the .kobo folder)
The backup name is for you to know what the file belonged to
theducks is offline   Reply With Quote
Reply
Page 1 of 2 1 2

« Previous Thread | Next Thread »

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[KOBO] Error communicating with device, CantOpenError: unable to open database file LSH Devices 4 06-09-2020 01:33 AM
Kobo Forma Database Error csdaley Devices 17 05-14-2019 10:36 AM
Error in Kobo Glo: database disk image is malformed Carpidor Devices 2 08-07-2015 07:17 AM
kobo database version unsupported error on MAC 10.6.8 cloudyweather Devices 1 09-14-2014 10:14 AM
Kobo error: database disk image is malformed RSaunders Devices 7 07-28-2011 09:52 PM


All times are GMT -4. The time now is 12:41 PM.

Contact Us - FAQ - Guidelines - Privacy - Top

MobileRead.com is a privately owned, operated and funded community.