FireFox 19.0+ Downloads Fix

From Proxmox VE
Jump to: navigation, search

The Issue

Starting from Mozilla FireFox 19.0 onwards, a new schema for the downloads.sqlite database was introduced. This has implications for any download done from the browser.

The Fix

Just delete the said download.sqlite file from your Mozilla FireFox Profile and it will be re-created on next usage. The said file in WinXP is in the foldert:

C:\Documents and Settings\WINXPUSER\Application Data\Mozilla\Firefox\Profiles\RANDOMALPHANUM.default

The schema change

CREATE TABLE moz_downloads (
id INTEGER PRIMARY KEY,
name TEXT,
source TEXT,			## <== new field
target TEXT,
tempPath TEXT,
startTime INTEGER,
endTime INTEGER,
state INTEGER,
referrer TEXT,
entityID TEXT,
currBytes INTEGER NOT NULL DEFAULT 0,
maxBytes INTEGER NOT NULL DEFAULT -1,
mimeType TEXT,
preferredApplication TEXT,
preferredAction INTEGER NOT NULL DEFAULT 0,
autoResume INTEGER NOT NULL DEFAULT 0,
guid TEXT
);


CREATE UNIQUE INDEX moz_downloads_guid_uniqueindex ON moz_downloads(guid);

References