Yes that was the error, a double field. I thought about that but couldnt find it. Thanks!

I run each 10 minutes. It takes a few seconds to run each time. If you were using the old script and run every 5 minutes. Then if the script is called before the first one is finished. You can push the server over the edge! The new script prevents this. The new script is less system intensive.

Depending on how many messages stored on the server, the first time the script runs, it can take a long time to import all the messages. You should be able to set the last message number to a high one. That way you ignore all the older messages, only import the new ones. To find out the current message number, open the news post using a normal browser, look for Xref in the headers.

Xref: freenews.iinet.net.au aus.tv.pay:132041

The 132041 is the message number.

Check your current message setting in the nntp_groups table against what is on the server, and set the lastmsg for that group to the latest message number. Run the script manually, keep an eye on the server load. If you have shell access, type "top" should show. After you are sure that your script is not a resource hog, email the support nicely and explain to them you have fixed the problem.:)

(The next version will be even less server intensive.)

Still in the dark.:)

I searched my forum's home page for the word "theme", not there. I then searched for "post", nothing is associated with a number.

Greetings,

Can anyone confirm whether the test newsgroup list described above (here is still running? The original parameters were these:

newsgroup= webdiscuss.test
server= free.teranews.com

I have the c-imap library installed and my web services provider opened TCP port 119, but I get a notepad window popping up which says

1 group(s) gatewayed.
Logging in to free.teranews.com, group webdiscuss.test

and that's it - nothing gets imported into my designated empty forum. It seems a little further along than before they opened the port, when it used to say
"1 group(s) gatewayed.
Could not connect to NNTP-serverLogging
NotConnected Not Connected."

So, further along, but no joy!

Regards,

Matt

EDIT: To try uploading I put a test message in the forum and got this result in a popup

Posting Message from Username: 501 Unknown command: From: Username <Username.1666kd@timelimit.yourserver.com>
Posting Message from Username: 501 Unknown command: Newsgroups: webdiscuss.test

memobug, maybe you can try using the nntp.php that's on page 24 of this thread? It'll do extended logging and maybe we can figure out what's what.

No, it does not work.

[root@hd root]# telnet webdiscuss.com 119
Trying 66.51.100.134...
telnet: connect to address 66.51.100.134: Connection refused
telnet: Unable to connect to remote host: Connection refused

I get the following error when I try and run the gateway.php. Please keep in mind I am a ASP guru and PHP is all new to me... I have run this mod with VB 2 in the past with no issues.

Warning: implode(): Bad arguments. in /home/hsphere/local/home/changed/changed/forum/gateway.php on line 83

Database error in vBulletin 3.0.1:

Invalid SQL: UPDATE post AS post, thread AS thread SET isusenetpost = 1 WHERE
post.threadid = thread.threadid AND
isusenetpost = 0 AND
thread.forumid NOT IN ()
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 4

mysql error number: 1064

Thank you for your time.

Mark

Thanks allan for the suggestion and lierduh for the test. I really appreciate the help. It took me nearly a month of haggling to get that port opened!

I installed the debug version of nntp that allan suggests and got this
So I guess this is consistent with what lierduh reports in his trial. Is there another mail server to try before I subscribe to a news service or do my results suggest I am getting far enough along for a reasonable chance of success?

Any recommendation on which news service I should go with when I subscribe? I'm looking to bring in rec.arts.bonsai , which is a text-based service. My three main requirements are cheap, cheap and you-guessed-it.

The email mod built into gateway - for posting - seemed to be generating errors on my server, so I commented it out as recommended in another post here.

Regards,

Matt

Mark, it will be easier since you are a programmer. :) The error is in

"thread.forumid NOT IN ()"
where it should be "thread.forumid NOT IN (100,101,102,103)

The numbers are the forum IDs.

The following code is used to retrieve the forum ID for those usenet forums

Looks like the above query did not return anything.

Is there any of the nntp_groups has "enabled" set to 1 instead of 0?

>themes

Boy ME and my english :D sorry. I mean THREADS... I have the "total new threads since last visit" and "total new postings since last visit" link in the forum. Excluded the NG Forums, that works fine, they dont show up if one searches for new postings, but the NG posts still COUNT. So, i.e. no "real" new posts in the forum, but 3 new in the NG forum = "3 new postins since last visit". I just wanna make a "Totalposts" = xxx - NGposts = realposts.