Ce site disposera de fonctionnalités limitées pendant que nous effectuons des opérations de maintenance en vue de vous proposer un meilleur service. Si un article ne règle pas votre problème et que vous souhaitez poser une question, notre communauté d’assistance est prête à vous répondre via @FirefoxSupport sur Twitter, et /r/firefox sur Reddit.

Avatar for Username

Rechercher dans l’assistance

Évitez les escroqueries à l’assistance. Nous ne vous demanderons jamais d’appeler ou d’envoyer un SMS à un numéro de téléphone ou de partager des informations personnelles. Veuillez signaler toute activité suspecte en utilisant l’option « Signaler un abus ».

En savoir plus

Ce sujet de discussion a été archivé. Veuillez poser une nouvelle question si vous avez besoin d’aide.

FF 49.0.1 messes up something with SQLite code

  • 2 réponses
  • 2 ont ce problème
  • 2 vues
  • Dernière réponse par 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?

Solution choisie

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

Lire cette réponse dans son contexte 👍 0

Toutes les réponses (2)

sludge7051-x
sludge7051-x Auteur de la question
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 Auteur de la question
more options

Solution choisie

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