FF 49.0.1 messes up something with SQLite code
In this post, I learned how to export my Bookmarks using SQLite:
Bookmarks - Convert from places.sqlite to .xlsx (Excel) - How? . . . https://support.mozilla.org/en-US/questions/996638
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
With the new FF update to 49.0.1, I now get this error message when I run the query:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
SQLiteManager: insert into __sm_ext_mgmt(type, value) select 'QueryHistory', 'SELECT a.id AS ID, a.title AS Title, b.url AS URL, datetime(a.dateAdded/1000000,unixepoch','localtime') AS Date FROM moz_bookmarks AS a JOIN moz_places AS b ON a.fk = b.id' where not exists ( select value from (select tb1.value as value from __sm_ext_mgmt tb1 inner join __sm_ext_mgmt tb2 ON tb1.id=tb2.id where tb1.type='QueryHistory' order by tb1.id desc limit 1) SUB where value='SELECT a.id AS ID, a.title AS Title, b.url AS URL, datetime(a.dateAdded/1000000,unixepoch','localtime') AS Date FROM moz_bookmarks AS a JOIN moz_places AS b ON a.fk = b.id') [ near ")": syntax error ] Exception Name: NS_ERROR_FAILURE Exception Message: Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.createStatement]
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Any idea how to fix?
Chosen solution
I figured it out from this page - use double quotes:
"Change the single quotes on the VALUES section to double quotes" . . . http://stackoverflow.com/questions/27025578/ns-error-failure-in-sqlite-insert
I changed it from this:
SELECT a.id AS ID, a.title AS Title, b.url AS URL, datetime(a.dateAdded/1000000,'unixepoch','localtime') AS Date FROM moz_bookmarks AS a JOIN moz_places AS b ON a.fk = b.id
To this:
SELECT a.id AS ID, a.title AS Title, b.url AS URL, datetime(a.dateAdded/1000000,"unixepoch","localtime") AS Date FROM moz_bookmarks AS a JOIN moz_places AS b ON a.fk = b.id
Read this answer in context 👍 0All Replies (2)
It runs the five lines together. Here they are separate:
SQLiteManager: insert into __sm_ext_mgmt(type, value) select 'QueryHistory', 'SELECT a.id AS ID, a.title AS Title, b.url AS URL, datetime(a.dateAdded/1000000,unixepoch','localtime') AS Date
FROM moz_bookmarks AS a JOIN moz_places AS b ON a.fk = b.id' where not exists ( select value from (select tb1.value as value from __sm_ext_mgmt tb1 inner join __sm_ext_mgmt tb2 ON tb1.id=tb2.id where tb1.type='QueryHistory' order by tb1.id desc limit 1) SUB where value='SELECT a.id AS ID, a.title AS Title, b.url AS URL, datetime(a.dateAdded/1000000,unixepoch','localtime') AS Date
FROM moz_bookmarks AS a JOIN moz_places AS b ON a.fk = b.id') [ near ")": syntax error ]
Exception Name: NS_ERROR_FAILURE
Exception Message: Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.createStatement]
Chosen Solution
I figured it out from this page - use double quotes:
"Change the single quotes on the VALUES section to double quotes" . . . http://stackoverflow.com/questions/27025578/ns-error-failure-in-sqlite-insert
I changed it from this:
SELECT a.id AS ID, a.title AS Title, b.url AS URL, datetime(a.dateAdded/1000000,'unixepoch','localtime') AS Date FROM moz_bookmarks AS a JOIN moz_places AS b ON a.fk = b.id
To this:
SELECT a.id AS ID, a.title AS Title, b.url AS URL, datetime(a.dateAdded/1000000,"unixepoch","localtime") AS Date FROM moz_bookmarks AS a JOIN moz_places AS b ON a.fk = b.id