This site will have limited functionality while we undergo maintenance to improve your experience. If an article doesn't solve your issue and you want to ask a question, we have our support community waiting to help you at @FirefoxSupport on Twitter and/r/firefox on Reddit.

Avatar for Username

Search Support

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More

Hierdie gesprek is in die argief. Vra asseblief 'n nuwe vraag as jy hulp nodig het.

FF 49.0.1 messes up something with SQLite code

  • 2 antwoorde
  • 2 hierdie probleem
  • 2 views
  • Laaste antwoord deur sludge7051-x

sludge7051-x
sludge7051-x
more options

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?

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?

Gekose oplossing

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

Lees dié antwoord in konteks 👍 0

All Replies (2)

sludge7051-x
sludge7051-x Vraag-eienaar
more options

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]

sludge7051-x
sludge7051-x Vraag-eienaar
more options

Gekose oplossing

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