I think you are not using the "a" version I uploaded not long after the first upload. I posted a message about this.

I did some quick test with vB adminCP schedule tasks, it worked for me. What is the exact problem and what have you need to do to fix?

Okay, that's a relief, so I can update the table, and reset them all to an empty value without fear of messing it up entirely.

I'm still plugging away at a few of the other oddities. I think some of them may also be since I switched the news server I was using on a few of the groups.

well, let us know when it's all ready to go. i just got the green light from my host to try the script again. :D

Looks like some version of MySQL might not support this SQL statement. I will come up with another one to get around.

Could you do a test on your server. Just run this SQL manually:
=======================================
UPDATE post, thread SET post.isusenetpost = 1 WHERE
post.threadid = thread.threadid AND
post.isusenetpost = 0 AND
thread.forumid NOT IN (25,27,29,34)
=======================================

>update the table, and reset them all to an empty

How? Alter table thread set.... ???

UPDATE thread SET msgid = '';

Thx!

New version release:

**Build X-No-Archive header honouring system
**Improved speed
**Bug fixes
**Verbose output when run manually. Easier to find problem when interating with NNTP server.

change the honor_no-archive record from 0 to 1 to stop importing messages with X-No-Archive header, just as Google Group does.

Download it from:

https://vborg.vbsupport.ru/showpost....&postcount=658

Output from the manual query -

==========

Error

SQL-query :

UPDATE post,
thread SETpost.isusenetpost = 1 WHERE post.threadid = thread.threadid AND post.isusenetpost = 0 AND thread.forumid NOT IN ( 25, 27, 29, 34 )

MySQL said:

You have an error in your SQL syntax near ' thread SET post.isusenetpost = 1 WHERE post.threadid = thread.threadid AND post' at line 1

==========

MySQL version is 3.23

installed registry patch from M$, ran setlastmsg.php and got...

for me it works just fine... just a question for the crontab: Has to be a Carriage Return at the ent of the line in the crontab.txt?

Edit: Ist has :rolleyes:

Thanks. Looks like that SQL only works with MySQL 4.

Please download the new version. I have got rid of this section of code altogether.

Use this modified one. Delete this file after installation!

thank you sir! that new file did the trick.

I have a new error now. lol :)


I'm getting this once per hour as my crontab runs.

hmmm... :ermm:

That worked. Everything's going swimmingly now, lierduh - thanks :)

lierduh, there's a typo in your SQL query for the upgrade from May 12 script - the two-line query at the bottom of the post -

"hohor_no-archive" should read "honor_no-archive"

I fixed my database but others might not have seen it.

cheers -

allan

I think we should start another thread... lol

Any thoughts on this new error?

PHP version 4.3.3

Running latest files posted.

Change line 353 in gateway.php

from

SET attach=attache + 1 WHERE postid=$postid");

to

SET attach=attach + 1 WHERE postid=$postid");

Thanks Allan.

I will upload the file with the typos corrected shortly.

I have received permission from Gilby allowing me to release this hack under the vB3 section of the forums. So I will create a thread there in the next one or two days. That should make the support easier.

No - thank you, lierduh - you've really gone above and beyond.

cheers -

allan

Also thx from me, you make a very good job.

Thanks to both lierduh and allan grossman... I should have fingered out that error.

thanks

New release and new thread. I have released the gateway to the vB3 section of the forums. Thank you very much Gilby for allowing me to do so. Please post to the new thread for support and questions.

https://vborg.vbsupport.ru/showthread.php?t=65152

If you feel I have been in a little hurry, that is because I have more time on the weekend to do something.:)

Thanks, downloaded and installed

I also used Newsranger for the past 4 months. Recently I learned that the Newsranger.com is going to close at the end of this month, so I need to change services. Is there anything out there that is comparable? That is known to work with this hack? Newsranger was around $5 a month for a minimal account, which met my needs Newsranger used recurring paypal billing.

I really need read & write access to only one newsgroup - rec.arts.bonsai, and no binaries required.

Thanks for your suggestions!

Matt

Regards,

Matt

Yep I recently had to switch from Newsranger because they just cut me off suddenly, going out of business.

NewsGuy looked ok for me. No paypal recurring though.

Thank you for the quick response. :)

I tried your example server (microsoft that you gave as an example). With that one it works.

However, I am trying to get this one to work but with no luck. It seems that my settings are correct though. It is a google one:

Newsgroup name: alt.music.pearl-jam
Server name: groups.google.com

That doesn't work though.

Is there something I did wrong? I know that these are stupid questions but I think I have done everything correct as the example server you mentioned in your readme file worked perfectly.

Thanks

What SQL modifications does the NNTP hack do ?
I got the following error:
I have a field postid but I don't have a field msgid.