Filters are missing

[andy]

OK in v6.42, but filters missing in v6.50b17. The filters.db3 file is there.

I do not speak the filterjabber well at all. looked up perl grep and got something in portuguese. help?

[dexter]

Odd. You know we are up to B18 now but that shouldn't make a difference.

I made major changes to the installer for B17 but I didn't touch that part of the code. Did you install it as a clean install? An upgrade install shouldn't have touched it at all.

The default filters.db3 file delivered in the installer can be downloaded separately from http://www.newsbin.com/downloads/filters.db3 - just download it and stick it in the Newsbin Data Folder (when Newsbin is closed) and the default filters should be back in place when you restart Newsbin.

If you had some custom filters in place, make a copy of your old filters.db3 file first, maybe the database got corrupted or something.

[andy]

I did an upgrade install from v6.42 to v6.50b17 -- I must not lose my downloaded sigs file. It's an upgrade install unless I erase everything first, eh? I'll try your suggestions, but my filters.db3 file has always been there big as a bear. b17 ignored it.

[dexter]

Verify that your Newsbin Data Folder has not changed. I recall you were using some external drives from prior communications and I wonder if Newsbin is looking some place you aren't expecting. Go under Options/Setup within Newsbin and click the "Open Data Folder" and see if it's the same filters.db3 file that you were using before, or if one exists at all. The fact it's coming up blank tells me either no .db3 file was there and it created its own blank one or, your current filters.db3 file got corrupted somehow.

[andy]

all in b17 for now >>> I gave up and allowed the C:\users\andy etc data folder path, where a 40K filters.db3 file resided. I looked at it with notepad, but the squalite or whatever code eluded me. I have now downloaded the 10k filters.db3 file you suggested, restarted newsbin, and have the good old boilerplate, from whence it will be a small matter to reconfigure my few filters. Thanks for solving my problem. With an avatar like I've used ten years, I have learned to be cautious when declaring an issue, lest it be merely the typical misplaced gaze.

Geeez, I'm slipping . The new swirling, amorphous bluish-on-bluish icons are dreadful. Any way I could make a set for the visually appalled? Years ago you even encouraged such individualism, if I recall.

[dexter]

I looked at it with notepad, but the squalite or whatever code eluded me.

The installer includes sqlite3.exe which is a program that allows you to load .db3 files and manipulate them with SQL commands if you know SQL. It should be sitting in the folder where you installed Newsbin. You could try loading up your 40K filters.db3 file in sqlite3 and see if it loads, then try some basic commands to see if you can act on it. I'd try to do a vacuum command and see if that works.

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