vb.org Archive

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)

mzeitler 04-30-2007 06:14 AM

Hi,

I am pretty happy with the add-on. However some of the threads are duplicated since the usenet poster crossposts into multiple groups.

Is there a way to prevent this duplication from happening?

Since I compbine multiple usenet groups into one master group on my site, this is really annoying.

Matthias

amaarvell 04-30-2007 06:19 AM

hi guys

I am still having the problem I posted on reply 499
the anoying thing is occasionally the odd post gets through (3 so far)
this is wracking my head .. please help me someone

bkaul 04-30-2007 05:26 PM

Quote:

Originally Posted by bkaul (Post 1235871)
Attachment 63669

The link is to showthread.php?p=0#post0 rather than the actual post number, when the post is one that is generated by the gateway. Any ideas on what modifications would be necessary to fix this bug?

Clarification: I think this is only true of the initial post in a newly created thread, before any replies. Replies to existing threads appear to work properly.

tadast 05-04-2007 07:27 AM

Quote:

Originally Posted by panda1 (Post 1230810)
Rik,
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 : Wednesday, April 18th 2007 @ 04:59:06 PM
Script : http://forums.networkingland.com/adm...cron&cronid=19
Referrer : http://forums.networkingland.com/admincp/index.php
IP Address : 212.35.77.232
Username : admin
Classname : vB_Database

There are ' missing in the gateway.php code, change

Code:

                SET value = " . ((empty($get_max_postid))?(0):

($get_max_postid['postid'])) . " WHERE varname = 'last_postid'

to
Code:

                SET value = '" . ((empty($get_max_postid))?(0):

($get_max_postid['postid'])) . "' WHERE varname = 'last_postid'

That would fix the problem.

panda1 05-04-2007 06:05 PM

Quote:

Originally Posted by tadast (Post 1241156)
There are ' missing in the gateway.php code, change

Code:

                SET value = " . ((empty($get_max_postid))?(0):

($get_max_postid['postid'])) . " WHERE varname = 'last_postid'

to
Code:

                SET value = '" . ((empty($get_max_postid))?(0):

($get_max_postid['postid'])) . "' WHERE varname = 'last_postid'

That would fix the problem.

Thank you tadast for the help!


Now I have this NTTP newsgroup hack working fine with VB 3.5.6 in my new forum http://forums.networkingland.com.

But I am still facing posting problems, I am using www.teranews.com news server with posting allowed.


Frankly speaking, I am very happy with this hack, it saved me months of work! many thanks to the coder who created this hack in the first place and to all of you fellows for the help.

amaarvell 05-05-2007 08:57 AM

Guys I have this installed but I cant get it working

Gateway debug says its fine
but the cron fails every time

vbulletin say its nothing to do with them and my web host says its nothing to do with them

the script appears to be installed correctly
and my head is in bits trying to sort it

please help

amaarvell 05-05-2007 08:59 AM

Quote:

Originally Posted by panda1 (Post 1241475)
Now I have this NTTP newsgroup hack working fine with VB 3.5.6 in my new forum http://forums.networkingland.com.

you are running the gateway on the same usenet groups as me and on the same vb version .. any idea what i am doing wrong ... www.vistareadygames.com

cheers

X-Man70 05-06-2007 05:05 PM

when i start the gateway in debug mode 1, i become an erreo msg. can someone help me ?

Datenbankfehler in vBulletin 3.6.5:

Invalid SQL:

SELECT post.*, thread.*,
post.dateline AS postdateline, post.msgid AS postmsgid,
thread.title AS threadtitle, post.visible AS postvisible,
thread.visible AS threadvisible
FROM post as post LEFT JOIN thread as thread
ON (thread.threadid = post.threadid
AND post.userid = thread.postuserid
AND post.postid = thread.firstpostid)
WHERE post.isusenetpost = 0
AND post.postid > 0
AND thread.forumid = 40;

MySQL-Fehler : Lost connection to MySQL server during query
Fehler-Nr. : 2013

panda1 05-07-2007 09:48 AM

Quote:

Originally Posted by amaarvell (Post 1241801)
you are running the gateway on the same usenet groups as me and on the same vb version .. any idea what i am doing wrong ... www.vistareadygames.com

cheers

Hi Amaarvel,

You are right we are running the same VB version 3.6.5 and the same newsgroup server!

It wasn't a staright forword job, actully it took me some time to fix it ( I am not a coder)

Which satge you are stuck in ?

Can you post the debug log if you reached that stage.

More details will help both of us.

amaarvell 05-07-2007 02:02 PM

Hi Panda
as far as i know its set right
if i use the debug it says its gateway'ed open

but thats it
the cron runs the gateway script every 15 minutes
but in the last 10 days i have got 4messages through

I know its a microsoft server but it should be a whole lot faster than that

any help i get will save the samaratins a head ache


All times are GMT. The time now is 04:53 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04443 seconds
  • Memory Usage 1,750KB
  • 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
  • (4)bbcode_code_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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