Aura HD Kobo Aura HD - Page 57

theonna · 05-24-2013, 03:10 PM

Thank you,
I used sql browser, after compacting file was 84mb, can it be put back on the reader and be useable?

93terp · 05-24-2013, 03:51 PM

Quote:

Originally Posted by DNSB

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...

DNSB · 05-24-2013, 04:05 PM

Quote:

Originally Posted by 93terp

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

DNSB · 05-24-2013, 04:07 PM

Quote:

Originally Posted by theonna

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

jackie_w · 05-24-2013, 04:07 PM

too late, never mind

TechniSol · 05-24-2013, 09:00 PM

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!

davidfor · 05-24-2013, 10:57 PM

Quote:

Originally Posted by Jaden

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.

spikexp · 05-24-2013, 11:05 PM

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).

DNSB · 05-25-2013, 12:37 AM

Quote:

Originally Posted by davidfor

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.

samhy · 05-25-2013, 04:17 AM

Quote:

Originally Posted by spikexp

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.

Jaden · 05-25-2013, 09:16 AM

Quote:

Originally Posted by davidfor

The other David pointed to SQLite Database Browser, but I have been using a Firefox plugin. It is SQLite Manager.

spikexp · 05-25-2013, 02:14 PM

Quote:

Originally Posted by samhy

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.

samhy · 05-25-2013, 03:03 PM

Quote:

Originally Posted by spikexp

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.

FJames · 05-30-2013, 01:25 AM

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.

davidfor · 05-30-2013, 02:03 AM

So, how long did that take and how many hours of reading? The latter should be on the Reading Stats page of Reading life.

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 03:40 PM
$25 gift card w. purchase of Kobo Touch or Kobo Vox at Frys	sufue	Deals and Resources (No Self-Promotion or Affiliate Links)	0	07-15-2012 10:39 AM
Touch Kobo Touch defective after 3 months and Kobo Customer Support useless	shaf	Kobo Reader	5	12-04-2011 05:10 PM
Touch Kobo Touch not ejecting cleanly with Calibre OR Kobo Desktop - Windows 7	JBlyth	Kobo Reader	11	08-03-2011 05:38 PM
Kobo Touch not disconnecting properly from Calibre OR Kobo Desktop - Windows 7	JBlyth	Devices	1	08-03-2011 06:50 AM

05-24-2013, 03:10 PM	#841
theonna One Posts: 107 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?

05-24-2013, 04:07 PM	#845
jackie_w Grand Sorcerer Posts: 6,212 Karma: 16534894 Join Date: Sep 2009 Location: UK Device: Kobo: KA1, ClaraHD, Forma, Libra2, Clara2E. PocketBook: TouchHD3	too late, never mind

05-24-2013, 09:00 PM	#846
TechniSol GranPohbah-Fezzes r cool! Posts: 1,056 Karma: 3151024 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!

05-24-2013, 11:05 PM	#848
spikexp Connoisseur 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).

05-30-2013, 01:25 AM	#854
FJames Addict Posts: 320 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.

05-30-2013, 02:03 AM	#855
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	So, how long did that take and how many hours of reading? The latter should be on the Reading Stats page of Reading life.

Advert

Advert