I am receiving this error:

Database error in vBulletin 3.5.4:

Invalid SQL:
UPDATE nntp_settings
SET value = WHERE varname = 'last_postid';

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 'WHERE varname = 'last_postid'' at line 2
Error Number : 1064
Date : Saturday, April 8th 2006 @ 10:18:32 PM
Script : http://.../forums/gateway.php
Referrer :
IP Address : ...
Username : ...
Classname : vB_Database

This is great, It does exactly what it says on the tin.

Thanks for this it really is awesome...

Wish it did for me Phill2003

Still getting the 441 posting failed errors as above. So near and yet so far.

Does anyone have any ideas where I can start to look for this?

Could it be a server issue? I run the site on a dedicated server so have no issues tweaking settings if required.

Are there any NTTP options I need enabled within Apache to enable me to post back?

Thanks anyone for any advice :)

Claire

Are you sure the news server your using allows posting quite a lot of the free ones dont, I used a premium service for mine and it worked straight away?

Hey phill2003, thanks for the response :)

Yeh I'm using a premium service too (giganews) and if you look at the error message I'm getting:

Can we post? server responded: 340 send article
Posting Message 'Re: Andrea update' from Claire. Result: 441 posting failed

The newserver is confirming we can post but when the post is being seent, its at this point that it fails. :(

Mine was working fine updating messages for days now and it was almost caught up to current in the two groups I have added and then it seems to have just stopped. I use giganews and it was up to about 79K post in just one of the groups when it has just stopped. Still about 6 more months worth of post to catch all the way up too.. :(.. When I run the task from the scheduler it says:

UseNet Update

Done

but the post counts are not climbing. I checked giganews and I have not used but a 1/4 of my monthly quota so thats not it. Any thoughts on what I can do to find out what is happening?

Any ideas?

dwbro1, try manually increasing the Last Message count by by 1 or two.

Ie, if your current message count is 754545 change it to 754546 and run gateway.php again.

See if this works :)

Claire

Yeah I did and nada. I finally just jumped from 7-22-05 to the first msg on 1-1-06 and started again and it worked. Just lost 4 to 5 months worth but thats ok.

Fair enough..glad you got it working dwbro1, minus a few thousand posts anyway ;)

Quick question if anyone has any ideas.

Many of the posts I'm pulling for one of my sites from a particular usenet newsgroup includes posts from what I guess can only be described as a competitor, made to the usenet group via a similar (if not the same) hack.

Thats not the problem, what is the problem is every post from said site has a nice big footer including the text:

"This post was made at http://www......XXXXX - Click here for the best information about" etc etc.....

I don't add anything similar to my footers and although I don't mind general links in any posts I 'grab'; I don't want to be actively driving potential new members to this other site.

I know this can be done with mailing lists but is their a way to strip out certain footers for usenet syncs?

I thought that I might have been able to use the turn signature off for guests option but as these footers form part of the main text thats not really an option.

I have also tried the censorship option , however you don't appear to be able to censor full phrases, just individual words which is of no help to me.

I'm still pretty new to VB so I may be missing something. Any ideas / help is really appreciated.

Cheers all

Claire :)