Pesquisar no site de suporte

Evite golpes de suporte. Nunca pedimos que você ligue ou envie uma mensagem de texto para um número de telefone, ou compartilhe informações pessoais. Denuncie atividades suspeitas usando a opção “Denunciar abuso”.

Saiba mais

Esta discussão foi arquivada. Faça uma nova pergunta se precisa de ajuda.

FF 49.0.1 messes up something with SQLite code

  • 2 respostas
  • 2 têm este problema
  • 2 visualizações
  • Última resposta de 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?

Solução escolhida

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

Ler esta resposta 👍 0

Todas as respostas (2)

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]

more options

Solução escolhida

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