Dead link checker.

Win7 SP1

I have Firefox and I need a program to find and
delete dead Internet links. I have tried
AM-DeadLink
http://aignes.com/deadlink.htm
but while this finds the dead links it will not
delete them because of the Firefox Bookmark
system. Is there some way to get around this or
is there a suitable one. There are hundreds of
dead links; far too many to delete manually.
Peter

On Thu, 25 Apr 2013 09:51:19 +1000, Peter Jason wrote in message
:

Win7 SP1

I have Firefox and I need a program to find and
delete dead Internet links. I have tried
AM-DeadLink
http://aignes.com/deadlink.htm
but while this finds the dead links it will not
delete them because of the Firefox Bookmark
system. Is there some way to get around this or
is there a suitable one. There are hundreds of
dead links; far too many to delete manually.
Peter

You could try:

AM-DeadLink
http://www.snapfiles.com/get/amdeadlink.html

But here's what David McRitchie, a leading Firefox guru, has to say:

"Keep in mind that even a dead link (or dead bookmark) can provide
information to find a current version in Google, or an archived
version in Google cache, archive.org, and the archived version
might give you sufficient information to locate a more current file or
something better. So you might want to use such utilities and/or
extensions more for identification purposes than outright deletions.

You might see if that utility provides a right click (context menu item)
to check for cached or archived material, since it does allow you to
view files from same list you would delete from."

On Thu, 25 Apr 2013 01:05:30 +0000, Iceman wrote in message
:

You could try:

AM-DeadLink
http://www.snapfiles.com/get/amdeadlink.html

Sorry. I didn't read your post carefully enough. AM-DeadLink seems to be
the number one extension for such a task, and it claims it can remove dead
links. You, OTOH, say it doesn't.

But here's a Google sweep of FF Bookmarks editors. You can try some of
them:

http://firefox1.software.informer.co...ove-dead-link/

Shorter link: http://tinyurl.com/cagtxft

And there's also the quotation I added.

Good luck,
Iceman

On Thu, 25 Apr 2013 02:14:04 +0000, Iceman
wrote:

On Thu, 25 Apr 2013 01:05:30 +0000, Iceman wrote in message
:

You could try:

AM-DeadLink
http://www.snapfiles.com/get/amdeadlink.html

Sorry. I didn't read your post carefully enough. AM-DeadLink seems to be
the number one extension for such a task, and it claims it can remove dead
links. You, OTOH, say it doesn't.

But here's a Google sweep of FF Bookmarks editors. You can try some of
them:

http://firefox1.software.informer.co...ove-dead-link/

Shorter link: http://tinyurl.com/cagtxft

And there's also the quotation I added.

Good luck,
Iceman

Thanks, I have read some fine print way down on a
relevant page which suggests that all the Firefox
bookmarks should be imported into IE9 and then
processed with the AM-Deadlink. The remainder
can then be imported back into Firefox.

Still, I'll check out your links first.
Peter

Peter Jason wrote:
On Thu, 25 Apr 2013 02:14:04 +0000, Iceman
wrote:

On Thu, 25 Apr 2013 01:05:30 +0000, Iceman wrote in message
:

You could try:

AM-DeadLink
http://www.snapfiles.com/get/amdeadlink.html
Sorry. I didn't read your post carefully enough. AM-DeadLink seems to be
the number one extension for such a task, and it claims it can remove dead
links. You, OTOH, say it doesn't.

But here's a Google sweep of FF Bookmarks editors. You can try some of
them:

http://firefox1.software.informer.co...ove-dead-link/

Shorter link: http://tinyurl.com/cagtxft

And there's also the quotation I added.

Good luck,
Iceman

Thanks, I have read some fine print way down on a
relevant page which suggests that all the Firefox
bookmarks should be imported into IE9 and then
processed with the AM-Deadlink. The remainder
can then be imported back into Firefox.

Still, I'll check out your links first.
Peter

Firefox uses multiple SQLite databases. With the right database
tool, you can issue commands to modify the database. So I would
say it should be possible to do, from a technical viewpoint.
You would want Firefox shut down, while making changes to the
file with some other tool.

You can "dump" an sqlite database, which converts an SQLite
file, into a text file full of commands. On my machine, this
file is a 16MB text file. In theory, reading this file back
into SQLite, recreates the SQLite file. As long as you
carefully edit such a file, it should work.

sqlite3.exe places.sqlite .dump sometextfile.txt

This is a few lines of stuff, snipped from the file.

PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE moz_bookmarks (id INTEGER PRIMARY KEY,type INTEGER,
fk INTEGER DEFAULT NULL, parent INTEGER, position INTEGER,
title LONGVARCHAR, keyword_id INTEGER, folder_type TEXT,
dateAdded INTEGER, lastModified INTEGER);
INSERT INTO "moz_bookmarks" VALUES(103,1,138,2,28,
'PC ATI Radeon 9800 Pro conversion to Mac',
NULL,NULL,1221301522000000,1220759377000000);
CREATE TRIGGER moz_historyvisits_afterinsert_v1_trigger AFTER INSERT
ON moz_historyvisits FOR EACH ROW WHEN NEW.visit_type
NOT IN (0,4,7) BEGIN UPDATE moz_places
SET visit_count = visit_count + 1
WHERE moz_places.id = NEW.place_id; END;
CREATE TRIGGER moz_historyvisits_afterdelete_v1_trigger
AFTER DELETE ON moz_historyvisits FOR EACH ROW WHEN
OLD.visit_type NOT IN (0,4,7) BEGIN UPDATE moz_places
SET visit_count = visit_count - 1 WHERE
moz_places.id = OLD.place_id AND visit_count 0; END;
CREATE TRIGGER moz_bookmarks_beforedelete_v1_trigger
BEFORE DELETE ON moz_bookmarks FOR EACH ROW WHEN OLD.keyword_id
NOT NULL BEGIN DELETE FROM moz_keywords
WHERE id = OLD.keyword_id AND NOT EXISTS
(SELECT id FROM moz_bookmarks WHERE
keyword_id = OLD.keyword_id AND id OLD.id LIMIT 1); END;
COMMIT;

I'm not suggesting you actually edit it, because
editing the thing consistently is hard. But it does show
that a tool exists for manipulating the file.
I keep a copy of SQLite3 here, for playing with
the SQLite files. I originally got this, so I
could experiment with the vacuum command.

http://sqlite.org/sqlite.html

I would guess, it would be relatively easy, to remove just the bookmark,
leaving dead annotations and a reference to the URL, behind in the
database. It would cosmetically look like you cleaned it up, while
leaving a mess behind for another day.

This is an example of the schema. You can see a table
call moz_bookmarks exists here, just like the .dump
above said it would. This diagram shows the relationship
of the tables to one another.

http://people.mozilla.org/~dietrich/places-erd.png

*******

Or, you could use the add-on suggested here :-)
I would back up the profile, before letting something
like this run.

http://helpdeskgeek.com/how-to/remov...-from-firefox/

I don't really see the point in doing this, because
you can always go to www.archive.org, and feed the
bookmark into there, and find an archived copy of
the "dead" link. Links aren't always totally dead,
and if you need the content again, you can find it
later.

Paul

On 24 Apr 2013, Peter Jason wrote in
alt.windows7.general:

Win7 SP1

I have Firefox and I need a program to find and
delete dead Internet links. I have tried
AM-DeadLink
http://aignes.com/deadlink.htm
but while this finds the dead links it will not
delete them because of the Firefox Bookmark
system. Is there some way to get around this or
is there a suitable one. There are hundreds of
dead links; far too many to delete manually.

I have and use a Firefox add-on called "CheckPlaces 2.6.2".
Unfortunately, the author had ceased development due to his
disagreement with Mozilla's policies (http://www.andyhalford.com/).
You might still be able to find it around the net somewhere.

Peter Jason wrote:
Win7 SP1

I have Firefox and I need a program to find and
delete dead Internet links. I have tried
AM-DeadLink
http://aignes.com/deadlink.htm
but while this finds the dead links it will not
delete them because of the Firefox Bookmark
system. Is there some way to get around this or
is there a suitable one. There are hundreds of
dead links; far too many to delete manually.
Peter

Peter, I use SeaMonkey Suite, which is the continuation of Mozilla
Suite, which spawned Firefox and Thunderbird.

I have noted, as you have, that AM-Deadlink cannot clean out the (in my
case) dead SeaMonkey Bookmark links because it is now tied up in the
places.sqlite data base.

What I have thought about (but not tried, yet) is to export the
bookmarks from places.sqlite, probably via Tools-Export in the
SeaMonkey Bookmark Manager, then point AM-Deadlink at this created file
so it cleans out any deadlinks in that file and then import this cleaned
up file back into SeaMonkey (in my case) or FF for you.

Haven't tried it, and am not sure if importing back into SM/FF will
*replace* the contents or *add to* the contents (i.e. doubling up) in
places.sqlite.

Will get around to checking one day!!

Daniel

On Thu, 25 Apr 2013 09:51:19 +1000, Peter Jason wrote:

I have Firefox and I need a program to find and
delete dead Internet links. I have tried
AM-DeadLink
http://aignes.com/deadlink.htm
but while this finds the dead links it will not
delete them because of the Firefox Bookmark
system. Is there some way to get around this

That's weird since their website claims:

| AM-DeadLink can check the following resources:
|
| Firefox bookmarks
....
| HTML files

If it doesn't work then you could export your Fx bookmarks to a
HTML-file, let it be scanned and corrected by AM-Deadlink and then
import it to Fx again.

--
s|b