View Single Post
  #8  
Old August 10th 18, 09:14 PM posted to alt.windows7.general,microsoft.public.windowsxp.general
Paul[_32_]
external usenet poster
 
Posts: 11,873
Default Latest Firefox ESR

JJ wrote:
On Thu, 9 Aug 2018 19:43:41 -0700, OG wrote:
Why is there no way to open the last download folder after a firefox
restart !!! ?


It's Firefox bug. But not because the "Open Containing Folder" icon doesn't
work. It's because Firefox doesn't remove that icon if the downloaded file
is no longer present in the containing folder.

https://bugzilla.mozilla.org/show_bug.cgi?id=726451

Quote:
When the target file is removed from disk, clicking on a download item does
nothing. The issue is that we can't detect whether the file is still there
on hover, for performance reasons. Thus, detect missing files on click,
and/or with an asynchronous background process when the panel opens, and
assume the file is available until otherwise detected.

For performance reason my azz. They're just lazy. The icon clearly says
"Open Containing Folder". So, it's the folder that needs to be opened. Not
the file. The presence of the file is irrelevant.

And apparently, that same icon also has problem in Linux too.

https://bugzilla.mozilla.org/show_bug.cgi?id=1467084

https://bugzilla.mozilla.org/show_bug.cgi?id=1469052

And this one is over 6 years old without being either resolved, or rejected.

https://bugzilla.mozilla.org/show_bug.cgi?id=746780


At least some of that information is kept in
one of the sqlite databases. There are multiple
databases, and an overall schema defines the
linkage between databases.

You can use sqlite3.exe to dump a database.

sqlite3.exe some.sqlite .dump some.txt

If the output contains two lines of text, you
likely need a later version.

PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE moz_places ( id INTEGER PRIMARY KEY, url LONGVARCHAR, title LONGVARCHAR ...
INSERT INTO "moz_places" VALUES(1,'https://www.mozilla.org/en-US/firefox/central/' ...
INSERT INTO "moz_places" VALUES(2,'http://www.ubuntu.com/',NULL,'moc.utnubu.www.' ...
COMMIT;

One of those text outputs, has around 91000 lines in it.

*******

This is a sample dump of "downloads.sqlite".
For the version you're running right now, you'd
repeat the exercise, and see how yours are stored.

sqlite3.exe downloads.sqlite .dump downloads.txt

INSERT INTO "moz_downloads" VALUES(139,'10-Band Graphic Equalizer.pdf',
'http://digitalcommons.calpoly.edu/cgi/viewcontent.cgi?article=1118&context=eesp',
'file:///C:/Downloads/10-Band%20Graphic%20Equalizer.pdf','',
1477204721921875,1477204725968750,1,NULL,'',
1123399,1123399,'application/pdf',
'C:\Program Files\Mozilla Firefox',0,0);

You can see the folder it was put in, is remembered.
As is the URL it was downloaded from.

It's possible Firefox has to cross-reference the "139" value with
one of the other databases, to get the URL of the web page
where the download link is contained.

Naming convention:

http://sqlite.org/2018/sqlite-tools-...86-3230100.zip
https://www.sqlite.org/2018/sqlite-t...86-3240000.zip

That's a tool so you can figure out whether
they actually do still harbor the necessary data.

Paul
Ads