Clear *.npr Files from Database

Post Reply
Guest

Clear *.npr Files from Database

Post by Guest »

I've got a bunch of 'npr' files sitting in my DataBase\DB directory. Now, I thought that these were the remnants of 'failed' downloads, which left a bunch of 'partial' messages.

So, to clear them, instead of going through each group looking for them, I used Partial -> Delete bodies of partials with missing parts in all groups.

Except it didn't get rid of them all. I've still got a bunch of them. So, what are they and how do I get rid of them.
alex
Posts: 4549
Joined: Thu Feb 27, 2003 5:57 pm

Post by alex »

try to invoke edit menu->global message filter, messages are with bodies and press extract and close.

if you don't see articles with bodies invoke edit menu->show deleted headers.

if you see them among deleted - check in properties->general, 'saving attachments', maybe you have 'delete headers' checked and 'delete bodies' unchecked, also maybe 'delete bodies when deleting headers' option in properties general is unchecked, or the options where unchecked in the past.

to see all 'raw' bodies you may disable autopartial support and threads (partials and threads menus), then you'll see everything, but as to partials with missing parts they are handled with the option you mentioned (it is invoked automatically by default), but if a message has all parts (with or without bodies) the option won't remove such bodies since the message in
question is complete.

in short normally all is handled automatically and when you delete headers or save with deleting headers - bodies are deleted too and the rest (partials with missing parts when they are not complete) is handled automatically by default.
Guest

Post by Guest »

try to invoke edit menu->global message filter, messages are with bodies and press extract and close.
Nope. Nothing shown that would create an npr file.
if you don't see articles with bodies invoke edit menu->show deleted headers.
Again, nope. In fact this didn't show anything that wasn't displayed before.
to see all 'raw' bodies you may disable autopartial support and threads (partials and threads menus)
Bingo. It was the 'autopartial' that made them show up. There's a message with 28 of 42. Another with 33 of 34. And then 28 of 29. That explains the 89 npr files that I can see.

So, the 64K question is now: Why didn't the 'Delete bodies of partials ...' remove them. :oops:

BTW. I haven't manually deleted them yet, so if you need me to look further, I can.
alex
Posts: 4549
Joined: Thu Feb 27, 2003 5:57 pm

Post by alex »

It doesn't delete bodies of complete partials, e.g. you have a partial with bodies of parts 28 of 42 and the rest - without bodies but all parts present (with or without bodies) - it won't delete them.

Open the newsgroup that contains them, you should see the complete partial message (square light-green box), just such a global filter (messages are with bodies) doesn't show them since it doesn't include parts without bodies.

When some parts will be gone from the header list so it will be truly incomplete it will be deleted with the function since currently you can still download it (unless it is some problem with the server) and already downloaded parts won't be downloaded again.

If you reset database so there will be no headers without bodies then naturally all such partials would be deleted with the option, since then they would become truly incomplete.

So by 'complete' here is understood - all parts (with or without bodies) are present, otherwise it is a partial with missing parts, if you downloaded only some parts but have the rest in the header list the partial message is still considered complete.
Guest

Post by Guest »

I 'think' I understand what you're saying now. :?

The determination of a 'partial' applies to the availability of all the Headers which make up multi-part message, not that there are Headers without a body.

However, the ONLY way I can see them is to disable autosupport for partials, and then each part shows up with a light blue icon. They never show up with the green icon. So I'm not sure what you're saying here.

And yes, these messages were left like this because of a download/decode problem.

So, is there any way to delete these bodies without manually finding them and deleteing them or waiting for the Headers to roll off the Server.
Guest

Post by Guest »

Forget my comment about the green icon. I now see what you're saying.
alex
Posts: 4549
Joined: Thu Feb 27, 2003 5:57 pm

Post by alex »

you can select partial messages in question and invoke 'delete bodies' (you started to download something, then you don't what that any more, in addition to cancelling downloads you need to remove already downloaded bodies, otherwise they will be automatically removed only when messages will become incomplete).

maybe another state would be desirable, the bottom part half body icon and the upper part half green square, for now it is not straightforward to add it but in the future it might be there.
Post Reply