X
Tap here to go to the mobile version of the site.
An updated version of Firefox is available to address the issues with Add-ons disabled or fail to install on Firefox. You can download the update for your OS here: https://www.mozilla.org/firefox/new/ For Known Issues and Workarounds, please check out the update at https://support.mozilla.org/kb/add-ons-disabled-or-fail-to-install-firefox

Support Forum

SQL command insert / delete bookmark

Posted

Hi, what SQL command is executed when a bookmark ist dragged from the adress bar to the bookmark menue? what SQL command is executed when a bookmark ist deleted from the bookmark menue? For example what do I have to enter in SQLite manger?

Hi, what SQL command is executed when a bookmark ist dragged from the adress bar to the bookmark menue? what SQL command is executed when a bookmark ist deleted from the bookmark menue? For example what do I have to enter in SQLite manger?
Quote

Additional System Details

Installed Plug-ins

  • PDF-XChange Viewer Netscape Gecko Plugin

Application

  • User Agent: Mozilla/5.0 (Windows NT 5.1; rv:52.0) Gecko/20100101 Firefox/52.0

More Information

cor-el
  • Top 10 Contributor
  • Moderator
17088 solutions 154334 answers

You would have to change the folder ID if you want to move a bookmark. To remove a bookmark there are two main tables moz_bookmarks and moz_places and possible links to moz_keywords and tables that deal with annotations (moz_annos, moz_anno_attributes) and moz_favicons. You can see that this can require a lot of work if you want to do this properly.

Some files that have SQL statements that deal with bookmarks. https://dxr.mozilla.org/mozilla-release/source/toolkit/components/places/Bookmarks.jsm https://dxr.mozilla.org/mozilla-release/source/toolkit/components/places/Database.cpp https://dxr.mozilla.org/mozilla-release/source/toolkit/components/places/PlacesDBUtils.jsm https://dxr.mozilla.org/mozilla-release/source/toolkit/components/places/nsNavBookmarks.cpp

Maybe try to ask at the Reddit forum.

You would have to change the folder ID if you want to move a bookmark. To remove a bookmark there are two main tables moz_bookmarks and moz_places and possible links to moz_keywords and tables that deal with annotations (moz_annos, moz_anno_attributes) and moz_favicons. You can see that this can require a lot of work if you want to do this properly. Some files that have SQL statements that deal with bookmarks. https://dxr.mozilla.org/mozilla-release/source/toolkit/components/places/Bookmarks.jsm https://dxr.mozilla.org/mozilla-release/source/toolkit/components/places/Database.cpp https://dxr.mozilla.org/mozilla-release/source/toolkit/components/places/PlacesDBUtils.jsm https://dxr.mozilla.org/mozilla-release/source/toolkit/components/places/nsNavBookmarks.cpp Maybe try to ask at the Reddit forum. *https://www.reddit.com/r/firefox/
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.