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)

panda1 04-18-2007 09:15 PM

Quote:

Originally Posted by Rik Brown (Post 1230483)
I only use the newsgroup option but that part works fine for me with vb 3.6.5. -- Rik


Rik,

Every think went fine with me but when trying to run gateway.php i received the following error:
------------------------------------------------
Database error in vBulletin 3.6.5:

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

--------------------------------------------------

any help to fix this

Panda

manuelsechi 04-19-2007 07:13 AM

hi all
what's happen if i have to change NNTP server?
I done it and I was not able to receive any new news message...

thanx a lot for any help

manuelsechi 04-19-2007 12:59 PM

please help

I was using a NNTP server and everything went fine
I decided to change server, and now I'm not able to receive any message.
The new NNTP server works well, because i use it for another service
so I think now it doesn't work because of the last message id number

I can reset that number but I don't want duplicate messages from usenet in my board...

any idea?

thank u

Rik Brown 04-19-2007 06:07 PM

Quote:

Originally Posted by panda1 (Post 1230810)
Rik,

Every think went fine with me but when trying to run gateway.php i received the following error:
------------------------------------------------
Database error in vBulletin 3.6.5:

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

--------------------------------------------------

any help to fix this

Panda

Panda:

Sorry, I'm not much of help with mySQL. But it looks to me that a variable is not set since the
line "SET value = (some value should be here) WHERE varname = 'last_postid';" is missing a value which should be in your nntp settings. See the "Last Max postid" variable in your NNTP Gateway Settings.

I'd make sure you have the defaults all set there and leave nothing blank.

-- Rik

panda1 04-19-2007 07:06 PM

Quote:

Originally Posted by Rik Brown (Post 1231390)
Panda:

Sorry, I'm not much of help with mySQL. But it looks to me that a variable is not set since the
line "SET value = (some value should be here) WHERE varname = 'last_postid';" is missing a value which should be in your nntp settings. See the "Last Max postid" variable in your NNTP Gateway Settings.

I'd make sure you have the defaults all set there and leave nothing blank.

-- Rik

Thanks Rik!

You are right, this is a testing forum and I have no messages yet and the 'last_postid' should be some thing greater than zero.

I did created one message in my testing board and the problem was fixed, but I still have a problem connecting to google Usenet groups servers.... and I don't know if I am providing the right newsgroups sever URL, username and password!!!

I keep getting the following error message:
----------------------------------------------------
Gateway version 2.3.2 4 group(s) gatewayed.
Could not connect to NNTP-servegoggler. (A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
(10060))

Not connected
----------------------------------------------------

Any help will be appreciated


Panda1:cool:

panda1 04-19-2007 08:19 PM

Quote:

Originally Posted by mpascal (Post 1184915)
Just upgraded from 3.5.2 to 3.6.4

The instructions say:

That worked fine in 3.5.x but in 3.6 there is no such line.
I tried a couple of similar places but then the NNTP links would show up in every menu category.

Thanks
Marino


Marino,

Go to next installation option
---------------------------------------------------------
OPTION B (No need to edit php file)

Just run your AdminCP interface from:

http://forums.yourdomain.com/admincp/nntp_settings.php
http://fourms.yourdomain.com/admincp/nntp_groups.php
---------------------------------------------------------------------------

It worked well with me, but don't forget to copy all hack files to your forum not only the ones in the readme file!!


good luck!

Panda1

silurius 04-20-2007 09:55 PM

Quote:

Originally Posted by woodp (Post 1145596)
I'm running vB3.6.4 and Mailman 2.1.9 and using this script to provide gateways between vB and email.

vB->email: Took a while to figure out all the Mailman idiosyncrasies but this part of the script is running perfectly. I'm certain my users will love it.

email->vB: Struggling with this. I can send an email to MailMan's pop account and it will a) get properly reflected to all users, and b) show up in the MailMan archive. Or I can "reply" to an email from the gateway and it will also a) get properly reflected to all users, and b) show up in the MailMan archive.

What isn't working is vB reading the POP3 account and posting the "email" or "reply" into the message board thread. I'm not certain what might be going on except that MailMan is immediately reading the POP3 account, then clearing it and vB has nothing to import? What else could be going on?

Any ideas out there?

(Noob here - How do I click INSTALL to indicate I'm running this script?)

Did I miss any replies to this question? I'm also attempting to get Mailman->vB working.

silurius 04-23-2007 04:31 PM

Quote:

Originally Posted by silurius (Post 1232241)
Did I miss any replies to this question? I'm also attempting to get Mailman->vB working.

Never mind. Just filling in a few more fields in the list management vB console and subscribing the appropriate address in Mailman seemed to take care of it.

amaarvell 04-24-2007 09:40 PM

Hi

when i do all the tests on the gateway they show as working and open, but when the cron does a scheduled start, I get n error message as below
.................................................. .................................................. .......
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, carl@whereinhull.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.


--------------------------------------------------------------------------------

Apache (Secured-VIPER) Server at www.vistareadygames.com Port 80

.................................................. .................................................. ........

I have checked the logs and its ahowing p as

[Tue Apr 24 23:27:33 2007] [error] [client 83.100.189.61] Premature end of script headers: php-script, referer: http://www.vistareadygames.com/admincp/index.php

Can you shed any light on this

Cheers

bkaul 04-26-2007 02:59 PM

<a href="https://vborg.vbsupport.ru/attachment.php?attachmentid=63669&d=1177602990" target="_blank" title="Name: 1.jpgViews: 34Size: 40.0 KB">1.jpg</a>

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?


All times are GMT. The time now is 10:27 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.01810 seconds
  • Memory Usage 1,757KB
  • 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
  • (6)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