Bug #131

no longer works in firefox 20

Added by wagle almost 5 years ago. Updated almost 5 years ago.

Status:New Start date:04/04/2013
Priority:High Due date:
Assignee:- % Done:


Target version:-


seems to no longer work in firefox 20. anyone know why?

(I select a tag, but don't get a list of bookmarks for that tag)


#1 Updated by wagle almost 5 years ago

Timestamp: 4/4/13 1:30:24 PM
Error: TAGSIEVE :( executeQueryStmts failed: [Exception... "Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.createStatement]" nsresult: "0x80004005 (NS_ERROR_FAILURE)" location: "JS frame :: chrome://bookmarktags/content/query.js :: executeQueryStmts :: line 383" data: no]

SQL was:
SELECT (CASE bms.title ISNULL WHEN 1 THEN moz_places.url ELSE (CASE bms.title WHEN '' THEN moz_places.url ELSE bms.title END) END) AS title, (CASE moz_places.favicon_id ISNULL WHEN 1 THEN '' ELSE (SELECT 'moz-anno:favicon:' || moz_favicons.url FROM moz_favicons WHERE moz_favicons.id = moz_places.favicon_id) END) AS favicon, moz_places.url AS url, moz_places.visit_count AS visit_count, moz_places.frecency AS frecency, bms.id AS id, bms.dateAdded AS dateAdded, bms.lastModified AS lastModified, (SELECT max(visit_date) FROM moz_historyvisits WHERE place_id = moz_places.id) AS visit_date FROM (SELECT fk AS id FROM moz_bookmarks WHERE parent IN (6068538) GROUP BY fk HAVING count(*) = 1) AS t, moz_places, moz_bookmarks AS folders, moz_bookmarks AS bms WHERE t.id = moz_places.id AND t.id = bms.fk AND bms.parent = folders.id AND folders.parent != 4 GROUP BY bms.id ORDER BY title COLLATE NOCASE ASC, title COLLATE NOCASE ASC
Source File: chrome://bookmarktags/content/util.js
Line: 437

#2 Updated by wagle almost 5 years ago

The problem is the version of sqlite3 firefox uses. The current sqlite3 (as of 2013-04-10) is broken too. I have a workaround that is a kludge, which I'm trying to make better.

#3 Updated by wagle almost 5 years ago

My current workaround is in:


Warning: I have some of my personal customizations in that branch. Also, I imagine only sorting by title is supported. If you need something specific, I can try to fix that too.

#4 Updated by wagle almost 5 years ago

Oh, the workaround is in branch "workaround".

Also available in: Atom PDF