How to remove typed-in URLs from browser history in Firefox?

As all things accessible via Firefox's default interface seemed to fail, I decided to take the "deep-dive" approach. So I installed the SQLite Manager plugin, opened the places.sqlite file from within my firefox user profile directory (Menü: Database → Connect Database), and checked the moz_places table (select it in the left pane of SQLite manager) via the search function (in the big right pane: Tab Browse and Search, there the "Search" button) for the "offending" url. The corresponding SQL-Statement (for the Execute SQL tab) would have been:

SELECT * FROM moz_places WHERE url LIKE '%readwrite.com%';

For users prefering the graphical way:

^{Screenshot of the search filter (click image to enlarge)}

As it turned out, there was exactly one hit with a full URL, which did not show up when filtering the browser history/bookmarks! So I took the freedom to delete that record, and tried my urlbar again: Yeah, looks like that solved the issue! But why so difficult, Mozilla?

EDIT: Keep in mind that "operating directly at the heart" you might "kill the cat". Be careful modifying Firefox' databases directly -- or you might end up with inconsistent bookmarks or worse! Always cross-check before deleting, for example.

When you've typed an URL into the address bar, and the autocomplete popup is visible, highlight an URL in the list and press Delete. That will stop that URL being suggested again for any query. If there are many similar URLs you want to get rid of, you might need to backspace the last character and type it again to refresh the list.

Note: This doesn't work on bookmarked URLs. Hitting Delete removes them from the list while it's open, but the bookmark will be suggested again next time you type a similar URL. If that causes you a problem: on the Options dialog, on the Privacy tab, there's an option to make it only suggest from history, not bookmarks.

There's also another kind of autocomplete, where a domain name appears inline in the address bar itself (not in the autocomplete list) as you type. It only completes the domain name, not the whole URL, so it doesn't cause the "too many completions for stackoverflow.com" problem you describe.

The suggestions come from the same list, so if you delete all the autocomplete items for a domain and you don't have any bookmarks for that domain, it won't suggest that domain inline either. This can be quite tricky to arrange, as in your example, if you type "rea" and it completes readwrite.com but the list is full of pages about "reanimation". In that case, you need to let it complete readwrite.com by pressing End (not Enter), and then backspace the last character to refresh the list. Then only the readwrite.com entries will show in the list, and you can delete them in the same way. Again, if there are lots of entries, you might need to backspace the m to refresh the list.

You can disable just the inline-autocomplete feature by going to about:config and setting browser.urlbar.autoFill to false. That setting doesn't affect the drop-down list of suggestions, only the inline suggestion.

Problem

This is a bug in Firefox, specifically bug #932036.

The answer by Dan Hulme describes how Firefox is supposed to work. Unfortunately, this does not always actually work, even when pressing End and then Backspace (no dropdown ever shows up). Even if you have no History, Bookmark, or drop-down items from that domain, the autocomplete will still suggest domains that you visited in the past.

The reason is that in some cases URLs are not removed from the places.sqlite file in your Firefox profile directory, even if you clear the complete history.

Solution

According to the bug report linked above, this means that your places.sqlite database is corrupted. The recommended approach is to delete the places.sqlite file altogether. This should prevent the bug from occurring again on your installation in the future.

1. This will cause you to lose all your browsing history, so be careful!

2. Quit Firefox

3. Then, delete (or better yet move it somewhere safe) places.sqlite. The file is usually located at ~/.mozilla/firefox/<randomnumbers>.default/places.sqlite

4. Also remove the places.sqlite-shm and places.sqlite-wal files.

Your bookmarks should still be there, but your history will be gone. The bookmarks will be restored from the latest automatic backup that Firefox made (in the bookmarkbackups folder), so very recent additions will be lost. If you are afraid of losing newly added bookmarks I suggest exporting your bookmarks beforehand.

From http://kb.mozillazine.org/Places.sqlite#Deleting:

If you suspect that the file is corrupted, deleting "places.sqlite" will delete your browsing history, and a new, empty file will be created automatically. In Firefox 3 and SeaMonkey 2.1 and above, places.sqlite will be rebuilt using the latest dated JSON file from the bookmarkbackups folder; if no JSON backup exists, bookmarks will be imported from bookmarks.html, if found.

Not recommended (see bug report)

If you want to take a risk you can also modify the places.sqlite file directly. Do note that with this approach it is likely that the bug will reoccur. That said, you can use the SQLite Manager plugin recommended by the answer by Izzy to edit the moz_places and moz_hosts table and remove the entries containing the URLs manually.

You can search for the URLs as follows (replace example.com as appropriate):

SELECT * FROM moz_places WHERE url LIKE '%example.com%';

and

SELECT * FROM moz_hosts WHERE url LIKE '%example.com%';

I know this is an old thread, but the problem has been annoying me, and the solutions mentioned either didn't work or seemed too complicated. I found that if you open your History, search for the URL you want to remove, then DELETE THE PAGE from your history, it will no longer show up when you start typing its URL. Seems simple enough for me, but it's not all that obvious. It would be nice if you could just right-click on the URL suggestions and delete them, instead of having to delete them from your browsing history.

I had the same annoyng issue, everytime I start typing ww..... then the stored web adresses appear... not serious, but very VERY annoying. I use Firefox.

I went onto the Firefox website and looked in HELP, I finally solved this.

• In the URL bar type : About:config (and promise to be carefull !)
• locate : Browser.urlbar.default.behaviour (this value is probably 0)
• double click this, so that you can modify it, and change the 0 to 33.
• close this page Your problem should be solved, it did for me.

Thank you Firefox !

I found the solution here (dangowan's answer)

I hope it works for you

ps.: sorry my poor English :(