vb.org Archive - NNTP Gateway for Usenet ( Newsgroups ), Mailing Lists

Page 8 of 19

« First

Last »

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - NNTP Gateway for Usenet ( Newsgroups ), Mailing Lists (https://vborg.vbsupport.ru/showthread.php?t=92588)

poliveira

04-09-2006 02:24 AM

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

phill2003

04-09-2006 03:14 PM

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

Thanks for this it really is awesome...

newmomsforum

04-11-2006 06:30 PM

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

phill2003

04-12-2006 04:21 AM

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?

newmomsforum

04-12-2006 05:13 AM

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. :(

dwbro1

04-16-2006 01:31 AM

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?

dwbro1

04-17-2006 10:53 PM

Any ideas?

newmomsforum

04-18-2006 04:30 PM

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

dwbro1

04-18-2006 04:52 PM

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.

newmomsforum

04-18-2006 08:25 PM

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 :)

trackpads

04-22-2006 10:52 PM

How do you truncate the usernames? They are warping my threadview ugh :)

I posted the question here as well with a screenshot. It is some of the NNTP usernames that are doing it.

https://vborg.vbsupport.ru/showthrea...447#post957447

Thanks again,

-Jason

trackpads

04-24-2006 09:46 PM

Bump please!!

Thanks again!

-Jason

trackpads

04-24-2006 11:15 PM

Some ideas for improvements or the next version:

1. Ability to have a seperate Killfile for some newsgroups. A good example is this scenario. I have Bush, Kerry both in my killfile. I know that in any computer or sports groups these are definately spam. However in the politics groups they are ok.

2. Ability to truncate ultra long usernames from imported posts. I have a few doozies that are stretching my last post columns. Here is an example:

Quote:

=?Windows-1252?Q?Rob_Giordano_\=28Crash_Gordon=AE\

3. Make the script smart so that if the load goes up to a max amount (10 for example) that it will cancel operation until the next cron. This would help when in some cases it is working on some new groups and the forums are allready busy with members.

4. Make a default news server with username and password defined. This is instead of posting them each and every time you add a new group. I just added 90 groups and that was a lot of copying and pasting!!

Thanks to lierduh for creating this and thanks again to dkendall for the awesome edits!!

Thanks,

-Jason

TMM-TT

04-25-2006 09:53 AM

I'm not sure if this has been discussed yet (I have 20 pages to look through), so I'm going to take the risk and ask anyway -

Is it possible, in any way, to handle cancel-posts so posts are deleted when they are canceled, or when you as a user delete your own posts, send a cancel to the group?

rmd708

04-28-2006 10:44 AM

Truncating user names needs to be done in the thread list file of vbuletin. I did it, but it was a while ago so I forgot what I did. It involved copying the vb code used to truncate subject lines to X characters, and rewriting it to do the same for user names. If it is really needed I can look it up.

rmd708

04-28-2006 10:47 AM

One problem I'm having is some messages (MANY) are being completely striped of the body. It says email footer match found, and then deletes the entire message body. When I check the original message and then my strip footer list, there is nothing at all that matches. So I have no idea why these messages are being erased like that.

dwbro1

04-28-2006 03:11 PM

Quote:

Originally Posted by rmd708

Oh yea this would really be nice. I get some of the kooks out there that put entire sentences for their name then by tables are about 50/50

rmd708

04-29-2006 05:14 AM

In functions_forumdisplay.php I have added

Code:

$thread['trimnamezz'] = fetch_trimmed_title($thread['lastposter'], 15);

just above this:

Code:

        $thread['lastpostdate'] = vbdate($vbulletin->options['dateformat'], $thread['lastpost'], true);

        $thread['lastposttime'] = vbdate($vbulletin->options['timeformat'], $thread['lastpost']);

Then in the threadbit template, I use this:

Code:

<phrase 1="member.php?find=lastposter&amp;t=$thread[threadid]" 2="$thread[trimnamezz]">$vbphrase[by_x]</phrase>  <a href="showthread.php?$session[sessionurl]goto=lastpost&amp;t=$thread[threadid]"><img class="inlineimg" src="$stylevar[imgdir_button]/lastpost.gif" alt="$vbphrase[go_to_last_post]" border="0" /></a>

I forget what the original had, but your default one should be the same minus the variable "trimnamezz" (i forget what the default variable name is).

That will get the forum display user name trimmed.

Now for the forums index, in functions_forumlist.php:

Find:

Code:

                                        $lastpostinfo['lastpostdate'] = vbdate($vbulletin->options['dateformat'], $lastpostinfo['lastpost'], 1);

                                        $lastpostinfo['lastposttime'] = vbdate($vbulletin->options['timeformat'], $lastpostinfo['lastpost']);

                                        $lastpostinfo['trimthread'] = fetch_trimmed_title($lastpostinfo['lastthread']);

and add this below:

Code:

                                        $lastpostinfo['trimnamez'] = fetch_trimmed_title($lastpostinfo['lastposter']);

Then open up the particular template for the forum index and use the variable trimnamez in place of the default one.

rmd708

04-29-2006 05:25 AM

The strip footer seems to have problems. For example I found using {Yahoo! Groups} in the strip footer would strip the body of countless messages. I assume the '!' is being read as some type of wildcard, but am not sure about it.

trackpads

04-29-2006 01:04 PM

Thanks, it works great!

The only one that is missing is the subforum bits, see my screenie. I have looked everywhere and cant find the right code, how did you solve this?

Thanks again!

rmd708

04-29-2006 02:41 PM

I don't use subforums, so I never tried to fix that one.

Try one of these two:

1) Try the same variable in the template in case it uses the same function file.

If that doesn't work...

2) Find out which function includes file deals with the subforum display, then add the same code as above to it and then reference the variable.

WritersBeat

05-05-2006 03:50 AM

Does this work for 3.5.4?

newmomsforum

05-07-2006 11:55 AM

Quote:

Originally Posted by WritersBeat

Does this work for 3.5.4?

Yes, I'm running this on 3.5.4 :)

newmomsforum

05-07-2006 11:58 AM

Hi Guys

When I attach the URL of my site in my Default Footer using html, the display gets all screwed up, BB code has the same impact. Am I missing something?

Cheers :)

intinig

06-09-2006 12:24 PM

I am using this hach as a gateway to a yahoogroups mailing list. We're Italian, so we use accented letters like ??????. After mails with accented characters are imported in the system I get lots of rubbish instead of those characters (http://italianmagic.net/forum for examples). Any clue?

deejayh

06-25-2006 08:30 PM

First post after buying VBulletin - purchased it for this addon!

I have installed this, but cannot get a newsfeed - tried various microsoft and my own ISP though I believe I cannot connect to them directly from my server? (not allowed?):

Quote:

Gateway version 2.3.2 1 group(s) gatewayed.
Could not connect to NNTP-server. (Connection timed out (110))

Not connected
Not connected

Anyone know of a free newsfeed source to test to see if my installation works.

Is this add on / mod still supported??

Really need this for my forum.
regards,
Dave

deejayh

06-28-2006 09:05 PM

I guess from the non response that this mod is dead & nearly buried?

Anyone got this working?

britannia

06-29-2006 08:07 AM

We really need this too.

If this is not supported - Is there anotyher one similar to this?

thanx

deejayh

06-29-2006 05:04 PM

Hi britannia,

I think this is dead! Cannot find when Lierduh was last online!
Really annoying as I have just had my license for 2 weeks, which I purchased specifically for just for adding this!

Looks like I may have to sell it and go for another forum script - fortunately I have not gone live - just used impex to transfer everything to test and to add this add on.

We live and learn!

best regards,
Dave

ubuntu-geek

07-01-2006 05:25 PM

Quote:

Originally Posted by deejayh

You might make sure your server has the nntp port open. It appears that could be the issue.

deejayh

07-02-2006 05:19 PM

Thanks for that - I was wondering the same!

Contacted my hosts:

Quote:

you cannot import these feeds directly to your vbulleting installation on the server. You may need to setup a local copy and then import the mysql to the server.

Damn it!

Anyone know how to setup a local copy and then import the mysql to the server?

thanks,
Dave

deejayh

07-02-2006 05:37 PM

Thinking about it, do I realy need my hosts server to have port 119 open?

Surely I am connecting to the selected SERVER - news server port 119!!

A general newsreader does not use 119 on your own PC -just connects to the news servers port 119?

or am I getting it wrong??

But.... I have tried loads of servers even the microsoft one suggested - still no connection!! maybe I am wrong!

Help.....

deejayh

07-05-2006 02:13 PM

bummpppp!

Quote:

Thinking about it, do I really need my hosts server to have port 119 open?

Surely I am connecting to the selected SERVER - news server port 119!!

A general newsreader does not use 119 on your own PC -just connects to the news servers port 119?

or am I getting it wrong??

How does this script connect to the newserver?

thanks,
Dave

TMM-TT

07-05-2006 02:24 PM

Quote:

Originally Posted by deejayh

How does this script connect to the newserver?

As a client connects to a server.

There's some read-only servers to try with. Or are you looking for servers that allows both read and post?

deejayh

07-05-2006 03:04 PM

Quote:

Gateway version 2.3.2 1 group(s) gatewayed.
Could not connect to NNTP-server. (Connection timed out (110))

Not connected
Not connected

Then ubuntu-geek said:

Quote:

You might make sure your server has the nntp port open. It appears that could be the issue.

So I spoke with my host who said that port 119 is blocked.
Then I thought, surely this add-on is not talking thro my host servers port 119 - but connecting to the selected new servers port 119. So I would not need to have port 119 open on my host? Maybe I am wrong?

Just need to get it working!

Thanks again TMM-TT:)

Regards,
Dave

TMM-TT

07-05-2006 03:51 PM

Quote:

Originally Posted by deejayh

Thanks for the reply TMM-TT,

I would prefer to recieve and send - but at the moment I just need to be able to connect and download news - to ensure this add-on works - before I pay for a newsfeed.

[...]

So I spoke with my host who said that port 119 is blocked.

Then I thought, surely this add-on is not talking thro my host servers port 119 - but connecting to the selected new servers port 119. So I would not need to have port 119 open on my host? Maybe I am wrong?

No, as long as the outgoing port 119 is not blocked, it should work fine. Try connect to news.tornevall.net at that port and see what answer you get.

By the way - buying accounts can be a bit "bad", so be careful with the choice there. :)
Normally newsproviders only allows one user per account which means that sharing such account with others may not be allowed.

deejayh

07-05-2006 05:28 PM

Thanks TMM-TT,

What newsgroup shall I add?

regards,
Dave

deejayh

07-05-2006 05:39 PM

tried:
server: news.tornevall.net
Forum: testing
newsgroup:uk.news
Last Message: 0
left everything else blank

got:

Quote:

Gateway version 2.3.2 2 group(s) gatewayed.
Could not connect to NNTP-server. (Connection timed out (110))

Not connected
Not connected
Could not connect to NNTP-server. (Connection timed out (110))

Not connected
Not connected

Aylwin

07-05-2006 05:47 PM

Quote:

Originally Posted by srpompon

Now the attachs work in my 3.5.3, for this i copy a functions_image.php file from another old vb instalation to my includes.

And i comment some lines in the file incliudes/functions_nntp.php

// if (!$forumperms)
// {
// logging("This forum does not allow attachments, therefore attachment ignored.");
// }
// else
// {
$forumperms2 = true;
// }

Does anyone know if attachments work with mailing lists?

Also, can someone please attach functions_image.php? I'd like to try to get this working. Thanks!

theaonline

07-08-2006 01:53 AM

My outgoing emails have their extra carraige returns/line breaks snipped. Does anybody know where I can fix this?

All times are GMT. The time now is 08:12 AM.

Page 8 of 19

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01760 seconds Memory Usage 1,847KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (5)bbcode_code_printable (13)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: