X
Tap here to go to the mobile version of the site.

Support Forum

Want to delete a value from places.sqlite

Posted

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
Quote

Additional System Details

Installed Plug-ins

  • Shockwave Flash 32.0 r0

Application

  • User Agent: Mozilla/5.0 (X11; Linux x86_64; rv:66.0) Gecko/20100101 Firefox/66.0

More Information

jscher2000
  • Top 10 Contributor
8568 solutions 70054 answers

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?

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?
Was this helpful to you?
Quote
cor-el
  • Top 10 Contributor
  • Moderator
17334 solutions 156716 answers

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

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
Was this helpful to you?
Quote

Question owner

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

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
Was this helpful to you?
Quote
jscher2000
  • Top 10 Contributor
8568 solutions 70054 answers

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.

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.
Was this helpful to you?
Quote

Question owner

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?

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?
Was this helpful to you?
Quote
jscher2000
  • Top 10 Contributor
8568 solutions 70054 answers

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?

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?
Was this helpful to you? 1
Quote
jscher2000
  • Top 10 Contributor
8568 solutions 70054 answers

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.

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

Was this helpful to you?
Quote

Question owner

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.

''jscher2000 [[#answer-1214901|said]]'' <blockquote> 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? </blockquote> 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

Was this helpful to you?
Quote
Ask a question

You must log in to your account to reply to posts. Please start a new question, if you do not have an account yet.