I saw that before. I thought I'd fixed it... but obviously not.
I don't see how that can be possible. It can't insert an article if the msgid already exists. It's obviously a direct result of the bug above. (Or is that your point?)
What are you trying to say? What's wrong with the programming style? eh?! ;)
This is probably just a problem with the 'for loop'. It derives it's count from the last message number in the forum, the batch limit in the control panel and the last number reported by the newsserver.
This is the way I expected it to work. That doesn't seem to be the case though. I couldn't get it to return anything. It may be a newsserver issue but even CPAN makes no mention of a return value. If you can confirm it returns the msgid, let me know. it would make things a lot easier and more reliable.

By the way; I've got another version of the script ready. This one has a few efficiency changes but the big change is that it now continues to load replies in the correct order until there are no more left. This avoids having to make multiple runs when collecting history and should also prevent the stray articles that may not get loaded. Here's the zip if you want to play with it. I've got it running on my server. I'll package it up properly after I've looked at these other bugs and beta 5 comes out.

The one big problem with the script at the moment is the orphan reply checking. It does a full table scan for each newsgroup every run. That means for my 70 newsgroups I'm doing 70 full tablescans! My poor little Freedom 300 can barely keep up. As the post table fills up, it gets worse (I've got 23,000 posts at the moment). I need to find another way to do it or maybe make it an option for individual newsgroups. Although you get a few orhans in every newsgroup, it's really only a big problem with the mailing archives. Any ideas?

Hi fastforward,

Can I replace the old ./newnews.pl with this new one and if so are there any changes I need to make besides just replacing the file?

Thanks,

Michael

Does spam filter work during posting? I'm a little affraid that opening posting features could attract spammers and get my news server blacklisted?

That's the point... one of the results of this bug.
I wouldn't say there is anything wrong.... just not a style that I can follow very well (with those variable variables and such). I am not all that good at Perl.

I saw it on a page from a google search. I don't know which module it was (I've seen both News::NNTPClient and Net::NNTP which apear to have the same functions). On CPAN, neither of these modules mention anything about returning the message-id. :(

I did a lot of manual insertion to minimize how many articles were in the usenet_article table, then when I gave up for the itme being on inserting those posts, I renamed the table and created a blank one. Though that's just a temporary fix. Another idea is when not importing old archives, to limit the subjects it can match to those threads that have posts from the last 30 days in them. Maybe even make another table with just the subjects and refs of the threads from the last 30 days.

No it doesn't. I was thinking of adding it though. It's only a minor change so I'll add it in the next release with beta 5.

You should be able to do that. provided you deleted the indexes and added the extra table from the latest full release? If not then it won't work. Let me know if you need help.

Fastforward, your 2.5 vb code change instructions don't have any of these postings.php changes. Are they still needed?

No... not needed because the unique constraint has been removed from the msgid columns in the post and thread tables.

Make sure you deleted the unique indexes and re-created normal indexes on those columns.

This release is for vB 2.0 beta 5

Upgrading:

• The only vB code changes that differ to the previous version are in showthread.php. The way the Registered: and Location: bits are handled (via custom fields) make it messy to try to hide via code. If you removed the words from your templates in a previous version, you'll have to put it back again as this release doesn't attempt to hide it. If you really need them hiding, the best bet is to create a seperate style set for usenet forums. I'll look at adding options to handle it via the control panel in a later release.
• No DDL changes have been made.
• There is one DML change that deletes an unnecessary option. (The 'reply iterations' option that is now handled automatically).

This is all listed in UPGRADE.txt

INSTALL.txt details a fresh installation on a virgin vB 2.0 beta 5.

Download

All links in this thread have been updated to point to the new version. The latest version will always be in the first post of this thread.

I hope to get another release of newnews.pl out over the weekend that will add some of the outstanding features listed at the top of this thread. This should simply be a drop in replacement.

does anybody know some of the free ones?