Malformed DownloadMarker.db3 file

This is the place to help test and discuss Version 6 Beta releases.

Malformed DownloadMarker.db3 file

Postby KingFish » Tue Oct 17, 2017 10:48 am

My installation of Newsbin Pro is of Newbin Pro Version 6.80B9 Build 4978, running under Windows 10 Pro 64-bit Individual Preview Build 17017.

Running the sqlite3 command, ' sqlite3 DownloadMarker.db3 "VACUUM;" from a command prompt has disclosed that file in my installation as being malformed.

What would be the effect of deleting that file?

Are there any other files which also need to be deleted due to the deletion of the DownloadMarker.db3 file?

Thank you.
MS Windows 10 Pro 64-Bit - ASUS P8Z77-V LE; Intel i7-3770K 3.5 GHz; 16.0GB DDR3; 512MB EVGA GeForce GTX 760; SAMSUNG 850 500GB SATA III SSD; 2 X HGST 3TB 7200RPM 6.0Gb/s SATA III.
User avatar
KingFish
Seasoned User
Seasoned User
 
Posts: 372
Joined: Mon Aug 13, 2001 5:17 pm

Registered Newsbin User since: 05/17/03

Re: Malformed DownloadMarker.db3 file

Postby Quade » Tue Oct 17, 2017 11:05 am

Make sure you're using the latest sqlite3.exe before you delete it.

http://www.sqlite.org/download.html

That's the file that tags downloads as "Downloaded" or not. If you delete it, you'll loose that status. It will build up again as the file grows.
User avatar
Quade
Eternal n00b
Eternal n00b
 
Posts: 42525
Joined: Sat May 19, 2001 12:41 am
Location: Virginia, US

Registered Newsbin User since: 10/24/97

Re: Malformed DownloadMarker.db3 file

Postby KingFish » Tue Oct 17, 2017 11:38 am

Quade wrote:Make sure you're using the latest sqlite3.exe before you delete it.

http://www.sqlite.org/download.html

That's the file that tags downloads as "Downloaded" or not. If you delete it, you'll loose that status. It will build up again as the file grows.


Thank you.

Can I replace the malformed file with a backup copy, which isn't malformed, from a few days ago that was created with the same version of Newsbin Pro?
MS Windows 10 Pro 64-Bit - ASUS P8Z77-V LE; Intel i7-3770K 3.5 GHz; 16.0GB DDR3; 512MB EVGA GeForce GTX 760; SAMSUNG 850 500GB SATA III SSD; 2 X HGST 3TB 7200RPM 6.0Gb/s SATA III.
User avatar
KingFish
Seasoned User
Seasoned User
 
Posts: 372
Joined: Mon Aug 13, 2001 5:17 pm

Registered Newsbin User since: 05/17/03

Re: Malformed DownloadMarker.db3 file

Postby Quade » Tue Oct 17, 2017 11:42 am

Sure.

The big question is how the file got damaged in the first place. The Db's are very robust.
User avatar
Quade
Eternal n00b
Eternal n00b
 
Posts: 42525
Joined: Sat May 19, 2001 12:41 am
Location: Virginia, US

Registered Newsbin User since: 10/24/97

Re: Malformed DownloadMarker.db3 file

Postby KingFish » Tue Oct 17, 2017 12:24 pm

Quade wrote:Sure.

The big question is how the file got damaged in the first place. The Db's are very robust.


I've been working for several days trying to find the answer to that question. :x :? :cry: :evil:
MS Windows 10 Pro 64-Bit - ASUS P8Z77-V LE; Intel i7-3770K 3.5 GHz; 16.0GB DDR3; 512MB EVGA GeForce GTX 760; SAMSUNG 850 500GB SATA III SSD; 2 X HGST 3TB 7200RPM 6.0Gb/s SATA III.
User avatar
KingFish
Seasoned User
Seasoned User
 
Posts: 372
Joined: Mon Aug 13, 2001 5:17 pm

Registered Newsbin User since: 05/17/03

Re: Malformed DownloadMarker.db3 file

Postby Quade » Tue Oct 17, 2017 1:52 pm

I've been working for several days trying to find the answer to that question. :x :? :cry: :evil:


If you have any security software other than the MS stuff that's built in, I'd probably start there.
User avatar
Quade
Eternal n00b
Eternal n00b
 
Posts: 42525
Joined: Sat May 19, 2001 12:41 am
Location: Virginia, US

Registered Newsbin User since: 10/24/97


Return to Newsbin Version 6 Beta Support

Who is online

Users browsing this forum: Bing [Bot], Google [Bot] and 3 guests