Where are the icons next to a site's name in History stored?
In History, to the left of a site's name, is an icon or blank space. I visited TinEye, an image searching website, and the image I was searching (which was at an address I can no longer access), is shown in this space. If I right-clicked on the image, nothing appeared in the menu which said I could do anything with the image. I'd like to find where this image is stored, so that I can search the web for it again. Is it in my Firefox profile? I've tried opening the places.sqlite file, but as it is an SQLITE file, it said Windows can't open it.
Chosen solution
You can't view the favicons via the SQLite Manager extension. You can only locate the entry in the moz_favicons table in places.sqlite and double-click the entry to open its properties and click the Save (disk icon) button next to BLOB data to save the icon to the hard drive (desktop) You can also copy its URL to the clipboard from the URL field (click the arrow right button to expand the field and see the full URL).
Read this answer in context 👍 0All Replies (6)
Favicons are stored as BLOB (binary large object) data in the moz_places and moz_favicons tables in the places.sqlite file.
You can use the SQLite Manager extension in Firefox to inspect SQLite database files.
Hi, thanks for your help. I've installed SQLite Manager, but when I try to open the places file, it asks me what I want to open it with, so I select Firefox. Then it opens a new tab, but then repeats itself and opens a new tab and asks me what I want to open it with! Could someone provide simple instructions as to what I should do? I have no skills with this kind of thing!
You need to open the places.sqlite file in the SQLite Manager extension and not in a Firefox tab.
The SQM extension has a dedicated toolbar button in the Customize palette ("3-bar" Firefox menu button) that you can drag on a toolbar or access the SQM extension via the Tools menu (Alt+T).
- Tap the Alt key or press F10 to show the Menu Bar
Thanks for your help again. I've now managed to start SQLite Manager, but I can't work out what to do next. I've opened places.sqlite, selected a URL from under the Browse & Search tab, then I've gone to the Execute SQL tab and pasted the URL under where it says "Enter SQL". Then I've clicked on "Run SQL" and a message pops up saying "SQLiteManager: Likely SQL syntax error: INSERT INTO "someTable" VALUES ("2417","http://tineye.com/query/6a2f5b8dca09d8c187288bccf5f845d10cea1f5f","BLOB (Size: 986)","image/png","1386821626201000","tyC9DBNN5HC1"); [ no such table: someTable ] Exception Name: NS_ERROR_FAILURE Exception Message: Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.createStatement]". Am I doing the right thing to enable me to view the favicons?
Chosen Solution
You can't view the favicons via the SQLite Manager extension. You can only locate the entry in the moz_favicons table in places.sqlite and double-click the entry to open its properties and click the Save (disk icon) button next to BLOB data to save the icon to the hard drive (desktop) You can also copy its URL to the clipboard from the URL field (click the arrow right button to expand the field and see the full URL).
It worked. Thanks for all your help! :)