The error must be your original problem. You may need to do a manual post following the instruction in the first page, ie. ssh, telnet etc. Basically your news server does not know the posting command sent by gateway script. 1) Are you allowed to post? 2) Have you changed the script, especially nntp.php?

I am going to try the SSH instruction on the front now.

1) I should be allowed to post, since some posts have gone through before through gateway.php.

2) The only modifications I made were the ones you suggested to gateway.php.

If you have the time, would you mind getting on some sort of instant messaging client?

Hmm. Both telnet and Agent tell me that I'm not allowed to post...


Very odd.

Just to clarify, did you mean a task within the Windows operating system, or within the task manager built into vB3? I took you to mean the former, and when I tried it I couldn't get it to work; just now, though, I stumbled across the latter and it appears to be doing the trick each hour.

Forget it - I signed for a free account with Teranews which is letting me post.

I find it better to use the one on teh Operating system if you can. The one in VB is based on visitors to your site. If you site has lulls in traffic your task won't be run until someone visits.

Everyone I found out how to make the posts not count towards your total board post counts.

Note: this hack is totally the work of Wayne Luke. I'm just copy/pasting

My only addition is that you have to go into your AdminCP and update post counts for the changes to take affect. Try running gateway.php as well.

Hi, could everyone who runs a board with USENET access reply as to
1. what news account you are using
2. how much it costs
3. how many GB you get/month
4. how reliaable it is

I have a few questions

1. What is your favorite news account?

2. If someone wants to run 2 different web sites using VBulleting with the USENET hack - can they use the same news feed and share the bandwidth?

3. Do most webmasters here find that the cost of the news account is worth the extra traffic, etc?

4. Can you make it so that anyone who posts to Usenet through your board has a signature in their posts that read something like

______________________________
"This was posted at www.ABC.com"

1. I was using Giganews (the link is my referral link). But for some reason, they stopped letting me post.

So I went to Teranews.com. They let me post once, and then none of them were getting through.

2. Giganews is $7.99 a month. Teranews is only a $3.95 setup fee.

3. Giganews is 2GB a month. Teranews is 50MB a day.

4. Both unreliable if you ask me, although I would think Giganews is more reliable than Teranews.

1. No favorite yet.

2. Yes.

3. Just started. Don't know yet.

4. Don't know.

I'm starting to think this is more trouble than it's worth.

Help!!!

There are a couple of things to check first (I'm sure you have, but just to be sure...) as these are insensitive to any tolerance.

Double check that this bit has been entered in the right place in gateway.php.

Lastly, check that the new Varname you entered in the controlpanel is called exactly "emailfooter" (without quotes).

Try to keep what you put between the {} as short as possible, but enough that it won't occur naturally in a normal message. What is the phrase you are trying to match? Are there any unusual characters that may cause the script to hiccup?

thanks kevin,
I did a clean install and everything is working as it should.

However the "preview" hack doesn't work. It's not fetching $postid.
Taken from partial error report
It would be great to have an option to modify past posts that have "unwanted footers".

Hey, no one has responded to a post I created a few days ago ... in regards to $subject. It needs to be wrapped in htmlspecialchars() - - some titles may have html in it.

thanks again

I figured out why giganews suspended my posting privileges.

Someone sent in a complaint about one of the posts that one my users made.

:(

that's why it would be good to have an option to disable upload (to newsgroup/mlist) of postings made within the forum

?5 says it does :nervous:

well ... it doesn't work for me. :ermm:

I'll look again ... it was working before.

I have just installed this mod and I am having trouble getting it to run.

First i tried NNTP and that failed.

So then i tried to collect from a pop3 mail account and I got this error when running gateway.php for the first time.

I am sure I did not make an error as the installation is pretty straight forward.

If ran from scheduled task manager in vb3

Otherwise the forums work OK

Any help apprciated.

Sorry, it was my own fault, email works now.

But I have another few questions on some things I would like to do.

The mail list that i am backing up requires registration to post and the backup i will make on the forum should be read only. i don't want to spam the list with test messages to try this one out so i thought i would ask.

If I simply change the forum permissions to prevent usergroups from being able to post/reply for that forum, should that be sufficient to stop forum users from using the email gateway to post messages to the mail list server?

Also when messages are delivered they sometimes are prefixed "RE:...." or "FW:...." Can these characters be stripped?
If I could strip things like FW: and RE: I could forward old messages to test threading etc (which does not seem to work).
Each post has a fixed name enclosed with suqare brackets always, like [listname]

Any help appreciated

Yes, that will work.

Use KevinM's hack to thread properly and that will get rid of the "RE's".


You can get rid of those by using the Replacement Variable Manager. Go to your Admin CP, select Styles and Templates, then Replacement Variable Manager. For the style you want this to apply to, select add new replacement variable, then enter the text you want removed (eg, [yourlistname]), and leave the replacement blank. That will do the trick. Note, the text isn't actually stripped, it's just hidden from view.

What is the point of having newsgroups in the forums, then? Just another content source?

Cheers Dave

I applied Kevins mod, but it seems erratic. As the mail list is not public and the posts spread reasonably evenly across the day I do not think its a server issue.

Screenshot is below.

A couple of posts were threaded correctly, then some were not, then another 2, then some were not.

Perhaps related to time received? I think the threaded mod should filter by subject no problem regardless of when it is received, if i read the functions correct, or is the filtering done after messsages are batch downloaded or per message. The mail server from which it collects the messages is the same as the site is hosted on, so no delays there.

you can see from the list that one subject was threaded OK (after Kevins mod) then another, but the posts after that were not, even although subject lines were identical.

Any ideas?

That's what my posts looked like before I applied Kevin's hack. Double check your gateway.php file and make sure you followed the directions exactly. Also, run gateway.php manually, copy and paste what the screen log shows, and post it here.

Some of the information in mlist is very valuable; however, if you or a member does something wrong you can be removed/banned. I would like the option to prevent posting to mlist for this very reason. A forum member will always be able to post to the forum - it just won't be sent to the public mlist.

ARCHIVE - for information only; some of the content found in newsgroup/mlist can answer posted questions on forum (similar threads)

If you still can't get it working, post the 10 lines from gateway.php just before this mini-hack and I'll have a look.

From your screenshot, that is exactly the problem that this mini-hack fixes. It picks these up by their subject title and threads correctly where the reference in the email header is missing.

Like BustaCap say, check the installation in gateway.php, and if you still have problems post the output here.

I got it working ... thank you. :up:

Kevin,
I never get this error when I call the file directly. However, I do occasionally get this error when Schedule Task runs the file.
[sql]Invalid SQL: INSERT INTO post
(postid, threadid, title, username, userid, dateline,
pagetext, allowsmilie, showsignature, ipaddress,

iconid, visible, isusenetpost, msgid, ref, parentid)
VALUES (NULL, ,
'',
'', 0,
'',
'', 1, 0,
'', 0, 1, 1,
'',
'',
+ 0)
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 '
'',
'', 0,
'',
'', 1, 0,
'', 0, 1, 1[/sql]
(I direct this to you (kevin) because it only happens when I use your mini hack.)

Kevin

Today it was working and I have not changed the gateway.php file.

Output from running from inside AdminCP

I set this up as a scheduled task in the AdminCP to run every 15 minutes but it seems to have no effect, I have to push it manually to run. If I tried to run it directly from the browser I got an error that it was already running so I have set the check in AdminCP to 1 now.

However it seems the ones before failed to match (title '2004 simulator ops') see attachment

It looks to be working correctly. The thread that you mention looks like a duplicate post (it has no "Re: " in the title), so the correct action is to start a new thread.

It will only search for a match by subject title under the following circumstances:

1. There are no references in the header that match an exisiting thread

AND

2. There is at least one "Re: " in the subject title, which gives an indication that there should be a parent thread for this post.

The output from gateway.php which you have shown also indicates that it is working correctly.

It's hard to tell from the sql query what is causing it to fail. If it ever happens when you are running gateway manually, make a copy & post the output which was running at the time.

Are you running the 'threading by subject' hack? There was an error in my first release which caused the $parentid not to generate, which would produce a error like the one you have. It was corrected with this version shortly afterwards:https://vborg.vbsupport.ru/showpost....&postcount=181

Kevin

Could it be that some users have just removed the subject prefix (or their mail clients have not added one?) . I have not used any other mail clients except Eudora or Outlook and these both addd it.

So in order for the threading function to be initiated it checks the first chars of the subject feild for matches on 'RE' ? Then parses an subject index for a match?

Guess its not case sensitive?

BTW, thanks for this really cool mod :)

The primary method of matching threads is by a reference number which is inthe headers of newsgroup posts and emails. This was written by Lierduh and is highly effective. All newsgroups thread pretty much perfectly just by this method.

Some mail groups (my personal experience is with Yahoo groups) do not reliably put the reference number in the header of the email, therefore I wrote a secondary check (case insensitive!) which checks again before starting a new thread. The "Re: " can appear anywhere in the subject title.

If you really, really have problems, you can find in the script where it searches for "Re: " and change it to "", and it will search every post that comes through for a subject match. This WILL slow things down, and will also match a thread from (say) 3 years ago if it has the same title. This is completely untested (and not recommended) as the basic threading will pick up most of them.

Lierduh cooked the Sunday roast, I just made some gravy :cheeky:

Thanks Kevin

I undestand a little better now, so ill dig deeper.

the source of the list is a private server using Lyris, its not yahoo or anything like that.

I might try using"" as this list server only has 50 or so posts a day so is never busy enough to slow the server down.

Also if using "" it should only d/l message that are in the pop3 box so it might not cause a flood.

The roast and the gravy make a fine combo mate, sweet :)

Oh nuts

Just seen the glitch again

This time i ran the script directly

But this was a reply to an earlier one and has Re in it

Header from first messsage/thread

Header from reply messsage

Is this because the Message ID is different? Or is the filter being confused between ID's in the reply and only seeing the first one (different) and not the second one (match)

John

When I run gateway.php, I get the message:

Gateway version 2.1.0 1 group(s) gatewayed.
Could not connect to NNTP-serverNot connectedNot connected

What's the problem?

I am trying to do this for the newsgroup rec.sport.golf

you are not allowed to access newsgroup via script or you have settings wrong (username/password if required).

I remommend you do a test first.
Use-------
- msnews.microsoft.com as SERVER
- microsoft.public.security as NEWSGROUP

NOTE: add 58700 as LAST MESSAGE or check the XREF # in header of last message found in usergroup.

I tried that microsoft newsgroup and i got the same message. should i try to reinstall?

I still get the message.
And ... yes, I am using the code posted on that POST.

Would you care to see the file?
I've made some "visual/html" modifcations to the file ... however, everything is clearly marked where the changes have been made (your mini-hacks , etc,)

yes, start from scratch ... make sure you read the instructions carefully

Anyone else using email delivery method and found problems with the script crashing?

I have been sending most things I could think of at the script and it has crashed twice, big time.

The first time was when a message was forwarded to the lists, the forward contained multiple forwarded messages and no subject. In this case the first message was part entered into the database (with no subject filled in) but nothing on the rest.

The second time was when a message was sent to the lists with no subject, perhaps it was still recovering from the first crash.

I might go back and try the nntp feed instead of email.

:ermm: My forums stopped grabbing new Usenet messages on 6/21. I'm trying to finger out exactly where the log jam has occured. My cron job is still going off like clockwork.

This is the entire content of my cron results minus the header garbage.


Any ideas as to what is happening? It looks like it only hits one group... then stops. ? :ermm: