Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Readers > Kobo Reader

Notices

Reply
 
Thread Tools Search this Thread
Old 05-24-2013, 04:10 PM   #841
theonna
One
theonna knows how to choose the perfect melontheonna knows how to choose the perfect melontheonna knows how to choose the perfect melontheonna knows how to choose the perfect melontheonna knows how to choose the perfect melontheonna knows how to choose the perfect melontheonna knows how to choose the perfect melontheonna knows how to choose the perfect melontheonna knows how to choose the perfect melontheonna knows how to choose the perfect melontheonna knows how to choose the perfect melon
 
theonna's Avatar
 
Posts: 103
Karma: 137282
Join Date: Oct 2009
Device: Sony, Kindle,Pocketbook, Nook...
Thank you,
I used sql browser, after compacting file was 84mb, can it be put back on the reader and be useable?
theonna is offline   Reply With Quote
Old 05-24-2013, 04:51 PM   #842
93terp
Fear The Turtle!
93terp ought to be getting tired of karma fortunes by now.93terp ought to be getting tired of karma fortunes by now.93terp ought to be getting tired of karma fortunes by now.93terp ought to be getting tired of karma fortunes by now.93terp ought to be getting tired of karma fortunes by now.93terp ought to be getting tired of karma fortunes by now.93terp ought to be getting tired of karma fortunes by now.93terp ought to be getting tired of karma fortunes by now.93terp ought to be getting tired of karma fortunes by now.93terp ought to be getting tired of karma fortunes by now.93terp ought to be getting tired of karma fortunes by now.
 
93terp's Avatar
 
Posts: 475
Karma: 1007178
Join Date: Sep 2009
Location: Margaritaville
Device: Kobo Aura HD, K3
Quote:
Originally Posted by DNSB View Post
I've been using SQLite Database Browser. I've used the Windows and Linux versions but not the Mac version.

http://sqlitebrowser.sourceforge.net/

For the change davidfor suggested, go the the second tab (Browse Data) and then select Activity on the table drop down menu. Look down the Type column until you see sync, click on the true in the Activity column next to sync and set it's value to false.

I'd suggest copying the database to your computer, saving a backup copy, making the change and then copying the changed database back to your Kobo. Suspenders and belt seldom hurts.

Regards,
David
DNSB -

I've followed your instructions to a "tee", but I can't find a way to actually change the "true" value to "false". There's no mechanism I can see to affect the change to the table...

93terp is offline   Reply With Quote
 
Advertisement
Old 05-24-2013, 05:05 PM   #843
DNSB
Bibliophagist
DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.
 
DNSB's Avatar
 
Posts: 2,319
Karma: 6142827
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Aura HD, Glo, Nexus 7 HD, iPad Air
Quote:
Originally Posted by 93terp View Post
DNSB -

I've followed your instructions to a "tee", but I can't find a way to actually change the "true" value to "false". There's no mechanism I can see to affect the change to the table...

Double click on the cell containing the true value. It should pop up an window labelled "Edit Database Cell". Make the changes in there and click on "Apply Changes". Save the database and copy it back to your Kobo.

Regards,
David
Attached Thumbnails
Click image for larger version

Name:	SQLiteBrowser.jpg
Views:	116
Size:	168.2 KB
ID:	106220   Click image for larger version

Name:	Cell_editor.jpg
Views:	83
Size:	31.1 KB
ID:	106221  
DNSB is offline   Reply With Quote
Old 05-24-2013, 05:07 PM   #844
DNSB
Bibliophagist
DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.
 
DNSB's Avatar
 
Posts: 2,319
Karma: 6142827
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Aura HD, Glo, Nexus 7 HD, iPad Air
Quote:
Originally Posted by theonna View Post
Thank you,
I used sql browser, after compacting file was 84mb, can it be put back on the reader and be useable?
Yes. Just make sure you have a backup saved. While there should be no problems, the best way to make sure you don't need a backup is to have one.

Regards,
David
DNSB is offline   Reply With Quote
Old 05-24-2013, 05:07 PM   #845
jackie_w
Wizard
jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.jackie_w ought to be getting tired of karma fortunes by now.
 
Posts: 2,877
Karma: 4200035
Join Date: Sep 2009
Location: UK
Device: Sony PRS-350, PB360, Kobo Glo/AuraHD/Aura6"/AuraH2O
too late, never mind
jackie_w is offline   Reply With Quote
Old 05-24-2013, 10:00 PM   #846
TechniSol
GranPohbah-Fezzes r cool!
TechniSol ought to be getting tired of karma fortunes by now.TechniSol ought to be getting tired of karma fortunes by now.TechniSol ought to be getting tired of karma fortunes by now.TechniSol ought to be getting tired of karma fortunes by now.TechniSol ought to be getting tired of karma fortunes by now.TechniSol ought to be getting tired of karma fortunes by now.TechniSol ought to be getting tired of karma fortunes by now.TechniSol ought to be getting tired of karma fortunes by now.TechniSol ought to be getting tired of karma fortunes by now.TechniSol ought to be getting tired of karma fortunes by now.TechniSol ought to be getting tired of karma fortunes by now.
 
TechniSol's Avatar
 
Posts: 1,008
Karma: 3088870
Join Date: Jul 2010
Device: Nook STRs, Kobo Touch, Kobo Glo
Excuse me, but what in the holy heck are they using 40,000+ characters or bytes for per book in the database? Does no one else find this questionable? I'm basing this on the figures I've seen in this thread like an 80MB database for 1,800 books... No wonder it takes forever to process a few thousand books!
TechniSol is offline   Reply With Quote
Old 05-24-2013, 11:57 PM   #847
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 5,891
Karma: 5704423
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo Touch, Kobo Glo
Quote:
Originally Posted by Jaden View Post
What sqlite manager/editor can I use to do that?
The other David pointed to SQLite Database Browser, but I have been using a Firefox plugin. It is SQLite Manager. The main reason I started using it for the Kobo database was because I had it installed. But, it works very well, and I usually have Firefox opened, so there is little overhead.

Something the SQLite Database Browser is missing from its menus are database checking functions. If you get an error from calibre about the database, or changes on the device don't seem to save, then open the database and run:

Code:
PRAGMA integrity_check
That will report any problems. Or it will report "Ok" if there are no problems.
davidfor is online now   Reply With Quote
Old 05-25-2013, 12:05 AM   #848
spikexp
Connoisseur
spikexp has a spectacular aura aboutspikexp has a spectacular aura aboutspikexp has a spectacular aura aboutspikexp has a spectacular aura aboutspikexp has a spectacular aura aboutspikexp has a spectacular aura aboutspikexp has a spectacular aura aboutspikexp has a spectacular aura aboutspikexp has a spectacular aura aboutspikexp has a spectacular aura aboutspikexp has a spectacular aura about
 
spikexp's Avatar
 
Posts: 88
Karma: 4132
Join Date: Oct 2011
Device: Kobo Vox
New week, new battery test.
From 100% Monday to 0% now, with a total of 15 seconds of use (just to see the battery life, don't have time to read, these day).
spikexp is offline   Reply With Quote
Old 05-25-2013, 01:37 AM   #849
DNSB
Bibliophagist
DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.
 
DNSB's Avatar
 
Posts: 2,319
Karma: 6142827
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Aura HD, Glo, Nexus 7 HD, iPad Air
Quote:
Originally Posted by davidfor View Post
Something the SQLite Database Browser is missing from its menus are database checking functions. If you get an error from calibre about the database, or changes on the device don't seem to save, then open the database and run:

Code:
PRAGMA integrity_check
That will report any problems. Or it will report "Ok" if there are no problems.
I've just got a bunch of queries I use saved in a text file and copy/paste to execute them. Being able to save queries would be handier.
DNSB is offline   Reply With Quote
Old 05-25-2013, 05:17 AM   #850
samhy
Wizard
samhy ought to be getting tired of karma fortunes by now.samhy ought to be getting tired of karma fortunes by now.samhy ought to be getting tired of karma fortunes by now.samhy ought to be getting tired of karma fortunes by now.samhy ought to be getting tired of karma fortunes by now.samhy ought to be getting tired of karma fortunes by now.samhy ought to be getting tired of karma fortunes by now.samhy ought to be getting tired of karma fortunes by now.samhy ought to be getting tired of karma fortunes by now.samhy ought to be getting tired of karma fortunes by now.samhy ought to be getting tired of karma fortunes by now.
 
samhy's Avatar
 
Posts: 1,719
Karma: 5660023
Join Date: Dec 2012
Location: France
Device: Sony (J) PRS 650, Kobo Mini and Aura HD
Quote:
Originally Posted by spikexp View Post
New week, new battery test.
From 100% Monday to 0% now, with a total of 15 seconds of use (just to see the battery life, don't have time to read, these day).
And nothing touches the screen before it enters completely the sleep mode? That was a reason for huge battery drains on other Kobo devices.
samhy is offline   Reply With Quote
Old 05-25-2013, 10:16 AM   #851
Jaden
Evangelist
Jaden ought to be getting tired of karma fortunes by now.Jaden ought to be getting tired of karma fortunes by now.Jaden ought to be getting tired of karma fortunes by now.Jaden ought to be getting tired of karma fortunes by now.Jaden ought to be getting tired of karma fortunes by now.Jaden ought to be getting tired of karma fortunes by now.Jaden ought to be getting tired of karma fortunes by now.Jaden ought to be getting tired of karma fortunes by now.Jaden ought to be getting tired of karma fortunes by now.Jaden ought to be getting tired of karma fortunes by now.Jaden ought to be getting tired of karma fortunes by now.
 
Posts: 405
Karma: 1115004
Join Date: Jan 2012
Device: Kobo Touch
Quote:
Originally Posted by davidfor View Post
The other David pointed to SQLite Database Browser, but I have been using a Firefox plugin. It is SQLite Manager.
Jaden is offline   Reply With Quote
Old 05-25-2013, 03:14 PM   #852
spikexp
Connoisseur
spikexp has a spectacular aura aboutspikexp has a spectacular aura aboutspikexp has a spectacular aura aboutspikexp has a spectacular aura aboutspikexp has a spectacular aura aboutspikexp has a spectacular aura aboutspikexp has a spectacular aura aboutspikexp has a spectacular aura aboutspikexp has a spectacular aura aboutspikexp has a spectacular aura aboutspikexp has a spectacular aura about
 
spikexp's Avatar
 
Posts: 88
Karma: 4132
Join Date: Oct 2011
Device: Kobo Vox
Quote:
Originally Posted by samhy View Post
And nothing touches the screen before it enters completely the sleep mode? That was a reason for huge battery drains on other Kobo devices.
I open it, check the battery, and put it back to sleep.
It was on my shelf all week.
spikexp is offline   Reply With Quote
Old 05-25-2013, 04:03 PM   #853
samhy
Wizard
samhy ought to be getting tired of karma fortunes by now.samhy ought to be getting tired of karma fortunes by now.samhy ought to be getting tired of karma fortunes by now.samhy ought to be getting tired of karma fortunes by now.samhy ought to be getting tired of karma fortunes by now.samhy ought to be getting tired of karma fortunes by now.samhy ought to be getting tired of karma fortunes by now.samhy ought to be getting tired of karma fortunes by now.samhy ought to be getting tired of karma fortunes by now.samhy ought to be getting tired of karma fortunes by now.samhy ought to be getting tired of karma fortunes by now.
 
samhy's Avatar
 
Posts: 1,719
Karma: 5660023
Join Date: Dec 2012
Location: France
Device: Sony (J) PRS 650, Kobo Mini and Aura HD
Quote:
Originally Posted by spikexp View Post
I open it, check the battery, and put it back to sleep.
It was on my shelf all week.
So if you don't have a cover, that can't be the issue that happened with the Glo. Such a drain would be a good reason to contact CS and have a new unit.
samhy is offline   Reply With Quote
Old 05-30-2013, 02:25 AM   #854
FJames
Addict
FJames ought to be getting tired of karma fortunes by now.FJames ought to be getting tired of karma fortunes by now.FJames ought to be getting tired of karma fortunes by now.FJames ought to be getting tired of karma fortunes by now.FJames ought to be getting tired of karma fortunes by now.FJames ought to be getting tired of karma fortunes by now.FJames ought to be getting tired of karma fortunes by now.FJames ought to be getting tired of karma fortunes by now.FJames ought to be getting tired of karma fortunes by now.FJames ought to be getting tired of karma fortunes by now.FJames ought to be getting tired of karma fortunes by now.
 
Posts: 319
Karma: 320941
Join Date: Jun 2011
Location: Canada
Device: Kobo Touch & Aura
My Aura finally shut down due to low battery, and I had to give it a full charge for the first time since I got it. It did last a long time on the initial charge, even accounting for the many times that I plugged it into the computer. On the other hand, it takes twice as long as the Touch to charge the battery, around 4 hours. I'm guessing that it still limits the charging current to 500ma max. I also notice that unlike the Touch it doesn't display the charge status on the screen when it's sleeping.
FJames is offline   Reply With Quote
Old 05-30-2013, 03:03 AM   #855
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 5,891
Karma: 5704423
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo Touch, Kobo Glo
So, how long did that take and how many hours of reading? The latter should be on the Reading Stats page of Reading life.
davidfor is online now   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Glo How to import reading Life Statistics from Kobo Touch to Kobo Glo? the_m Kobo Reader 5 12-13-2012 04:40 PM
$25 gift card w. purchase of Kobo Touch or Kobo Vox at Frys sufue Deals, Freebies, and Resources (No Self-Promotion) 0 07-15-2012 11:39 AM
Touch Kobo Touch defective after 3 months and Kobo Customer Support useless shaf Kobo Reader 5 12-04-2011 06:10 PM
Touch Kobo Touch not ejecting cleanly with Calibre OR Kobo Desktop - Windows 7 JBlyth Kobo Reader 11 08-03-2011 06:38 PM
Kobo Touch not disconnecting properly from Calibre OR Kobo Desktop - Windows 7 JBlyth Devices 1 08-03-2011 07:50 AM


All times are GMT -4. The time now is 09:21 AM.


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