View Single Post
Old 01-19-2018, 07:04 PM   #1862
knc1
99.44/100% On Holiday
knc1 ought to be getting tired of karma fortunes by now.knc1 ought to be getting tired of karma fortunes by now.knc1 ought to be getting tired of karma fortunes by now.knc1 ought to be getting tired of karma fortunes by now.knc1 ought to be getting tired of karma fortunes by now.knc1 ought to be getting tired of karma fortunes by now.knc1 ought to be getting tired of karma fortunes by now.knc1 ought to be getting tired of karma fortunes by now.knc1 ought to be getting tired of karma fortunes by now.knc1 ought to be getting tired of karma fortunes by now.knc1 ought to be getting tired of karma fortunes by now.
 
knc1's Avatar
 
Posts: 17,151
Karma: 18200597
Join Date: Feb 2012
Location: Central Texas
Device: No K1, PW2, KV, KOA
Quote:
Originally Posted by knc1 View Post
- - - - -
And then again...
So try following the sqlite.org directions, and:
Code:
[root@kindle local]# sqlite3 cc.db
SQLite version 3.7.14.1 2012-10-04 19:37:12
Enter ".help" for instructions
Enter SQL statements terminated with a ";"

sqlite> .dump Locale
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE Locale ( locale );
INSERT INTO "Locale" VALUES('en_US.utf8');
COMMIT;

sqlite> SELECT * FROM Locale;
en_US.utf8

sqlite> SELECT icu_load_collation('en_US.utf8', 'icu');
Error: no such function: icu_load_collation
sqlite>
????
Well, the answer to that one happens to be on the first line shown above.
SQLite version 3.7.14.1 2012-10-04 19:37:12
The ability to load a custom collation was first added to sqlite3, version 3.7.16

The current version is 3.21
My Ubuntu LTS has 3.20 installed.
So the most likely situation is the (?contractor?) person at Lab126 is doing all of s/he's work on a PC (with a current or nearly current version) and never checking their work on the Kindle.

Update:
The above was from 5.9.2 -
A similar problem exists on 5.3.7.3 (the oldest ts firmware version we support here).
I.E: The interactive sqlite3 can not delete records from cc.db for the same reason (the extension library might be able to but not the interactive).
Whoot!
A build of SQLite3 (3.21.0 the newest) that runs on our oldest, supported, touchscreen model, the KT-fw5.3.7.3:
Code:
[root@kindle local]# cat /etc/prettyversion.txt
Kindle 5.3.7.3 (~~otaVersion~~)

[root@kindle local]# LD_LIBRARY_PATH=/var/local ./sqlite3.armv7a
SQLite version 3.21.0 2017-10-24 18:55:49
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite>
The library path thingy is because the Kindles are missing a library that is required.
Which really isn't all that bad, only one additional file required to make today's sqlite3 version run on our oldest supported model/firmware combination.

Tomorrow - return to the "get rid of the KUAL booklet" script writing.

Last edited by knc1; 01-19-2018 at 07:17 PM.
knc1 is offline   Reply With Quote