Important Notice: We're experiencing email notification issues. If you've posted a question in the community forums recently, please check your profile manually for responses while we're working to fix this.

Avatar for Username

Cerca nel supporto

Attenzione alle mail truffa. Mozilla non chiederà mai di chiamare o mandare messaggi a un numero di telefono o di inviare dati personali. Segnalare qualsiasi attività sospetta utilizzando l'opzione “Segnala abuso”.

Ulteriori informazioni

Questa discussione è archiviata. Inserire una nuova richiesta se occorre aiuto.

FF 49.0.1 messes up something with SQLite code

  • 2 risposte
  • 2 hanno questo problema
  • 2 visualizzazioni
  • Ultima risposta di 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?

Soluzione scelta

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

Leggere questa risposta nel contesto 👍 0

Tutte le risposte (2)

sludge7051-x
sludge7051-x Utente che ha posto la domanda
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 Utente che ha posto la domanda
more options

Soluzione scelta

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