Windows 10 will reach EOS (end of support) on October 14, 2025. For more information, see this article.

Search Support

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More

Want to delete a value from places.sqlite

more options

Whenever I use Firefox a sleeping HDD is activated. Found that the mountpoint /home-HDD is stored in places.sqlite Want to delete this value while keeping all of other data stored in places.sqlite

Whenever I use Firefox a sleeping HDD is activated. Found that the mountpoint /home-HDD is stored in places.sqlite Want to delete this value while keeping all of other data stored in places.sqlite

Chosen solution

I don't know how the indexes work. These are the two key tables:

  • moz_places => look in the URL column
  • moz_origins => look in the host column

Possibly if you delete something from a table there is a command to update the indexes after that?

Read this answer in context 👍 1

All Replies (8)

more options

Do you have a bookmark or history item on that disk? You can use the Library window to search for and delete it. If that doesn't surface it, hmm, how did you discover it and does that tool provide insight into what table it's in?

more options

Other possible causes could be downloaded files that you saved to this location.

You could possibly use a SQLite browsing utility to check the moz_places table and possibly other tables like moz_bookmarks

more options

I found the string "/home-HDD" in history and deleted all occurances. Then I did the same with bookmarks. This would not remove "/home-HDD" from places.sqlite either as shown by running:

LANG=POSIX grep -r /home-HDD .mozilla/firefox/

Binary file .mozilla/firefox/fpefgz51.default-1555692947173/sessionstore-backups/recovery.baklz4 matches Binary file .mozilla/firefox/fpefgz51.default-1555692947173/sessionstore-backups/recovery.jsonlz4 matches Binary file .mozilla/firefox/fpefgz51.default-1555692947173/places.sqlite matches

more options

I think you are going to need a local SQLite program to ferret it out and remove it if Firefox doesn't finish cleaning up references after those history and bookmark deletions.

more options

I ran "zypper install sqlitebrowser" and was overwhelmed by the number of tables, indices and columns . :-) Any idea where to search first for stale information?

more options

Chosen Solution

I don't know how the indexes work. These are the two key tables:

  • moz_places => look in the URL column
  • moz_origins => look in the host column

Possibly if you delete something from a table there is a command to update the indexes after that?

more options

This is a web app I use for looking in SQLite databases. As far as I know, it cannot update the table on disk, but you can use it for querying the tables if you know some SQL:

(A) Open https://inloop.github.io/sqlite-viewer/

(B) Click in the center to launch a file browser to open a backup copy of places.sqlite

(C) Replace the listed SELECT query with one of these, change mozilla to your string of interest, then click Execute to list the results (and repeat with the second one):

  • SELECT * FROM 'moz_places' WHERE url like '%mozilla%'
  • SELECT * FROM 'moz_origins' WHERE host like '%mozilla%'

The query will return rows with their id numbers, which might be useful as a cross-reference to your tool.

Modified by jscher2000 - Support Volunteer

more options

jscher2000 said

I don't know how the indexes work. These are the two key tables:
  • moz_places => look in the URL column
  • moz_origins => look in the host column
Possibly if you delete something from a table there is a command to update the indexes after that?

sqlitebrowser indeed allows to delete data and write back to places.sqlite. But found nothing related to /home-HDD.

What really puzzles me:

- Don't need to invoke Firefox for waking up the sleeping HDD.

- Invoking sqlitebrowser and opening its file dialog also starts the disk. Seems to be a KDE desktop configuration problem.

Sorry for being too fast.

Modified by karlmistelberger