vb.org Archive
Page 59 of 101 « First 9495758 59 606169 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   NNTP Gateway for Usenet ( Newsgroups ), Mailing Lists (https://vborg.vbsupport.ru/showthread.php?t=65152)

mcyates 10-23-2004 04:26 PM
are there any news servers i can use which connect to uk.sport.football which will enable my users to post on it?

trackpads 10-23-2004 11:40 PM
lierduh,

Small question here. I have moderation turned on in a forum that USENET posts are going to but they are going straight to the forum instead of the mod queue. This might be a long stretch but is it possible to have all usenet posts go into the mod queue?

Thanks again for all your work,

-Jason

lierduh 10-24-2004 01:32 AM
Quote:
Originally Posted by esfron
Uploaded script again (from vbulletin.org), installed on a fresh vb 3.0.3.

Same mysql error:

Database error in vBulletin 3.0.3:

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 3

mysql error number: 1064

Date: Saturday 23rd of October 2004 03:03:04 AM
Script: http://www.xxxxxxx/forumtest/gateway.php?debug=1
Referer:
Username: Unregistered
IP Address: xxxxx


Any idea ?

According to the error messsage, the problem is "SET value = ", it is empty instead of a number. The number is fetched through:

"SELECT MAX(postid) as postid FROM post"

This is a very standard query and should work. If you can run MySQL query either through shell or phpmyadmin etc, try out that query and see what error do you get. By the way, what version of MySQL do you run?

lierduh 10-24-2004 01:34 AM
Quote:
Originally Posted by James T Brock
The debug message doesn't give any errors. It just shows headers for posts being imported and makes no mention of errors or outgoing threads.

Maybe I need to find a new host.
Sorry, can't help without the debug message. You know, if there is embarrassing groups you do not want to show to the public, you can alway edit that out.;) (only joking)

lierduh 10-24-2004 01:37 AM
Quote:
Originally Posted by esfron
Is it possible to run gateway in sub-forums i.e. forum/forumhttp/forumnntp ?
Should be ok, but you will need to modify the scripts due to the relative directory locations.

esfron 10-24-2004 02:44 AM
Quote:
Originally Posted by lierduh
According to the error messsage, the problem is "SET value = ", it is empty instead of a number. The number is fetched through:

"SELECT MAX(postid) as postid FROM post"

This is a very standard query and should work. If you can run MySQL query either through shell or phpmyadmin etc, try out that query and see what error do you get. By the way, what version of MySQL do you run?
Run query but no mysql error. Got: Showing rows 0 - 0 (1 total, Query took 0.0002 sec)
SQL-query:
SELECT MAX( postid ) AS postid
FROM post


MySQL version 4.0.20-standard

Run script on two differents hosts and fresh install with two differents news servers (public and paid). Got same mysql error. I just noticed that Odoin got the same error:

https://vborg.vbsupport.ru/showpost....&postcount=505
https://vborg.vbsupport.ru/showthrea...022#post550022

esfron 10-24-2004 03:47 AM
Quote:
Originally Posted by lierduh
It is possible your news server changed your organization to a default one. Please check the header of the messages posted from your forums. You should be able to check with your normal news reader, failing that, use Google.

The original script only checks the useragent. The reason I added the organization check is if two forums are using the same news server with the same useagent, then the messages posted from the fellow forums will be skipped! I can add an option to disable organization check with the next version. Weekend is coming...:) In the meantime, find:

Code:
        if ($message['user-agent'] == $settings['useragent'] AND
                $message['organization'] == $settings['organization']) {

and replace it with:

        if ($message['user-agent'] == $settings['useragent']) {

I have the same problem. Forum pulls the posts made to it back into the topic so there is double posts..

{I don't find if ($message['user-agent'] == $settings['useragent'] AND
$message['organization'] == $settings['organization']) {

Where is it ?

lierduh 10-24-2004 04:32 AM
Quote:
Originally Posted by esfron
I have the same problem. Forum pulls the posts made to it back into the topic so there is double posts..

{I don't find if ($message['user-agent'] == $settings['useragent'] AND
$message['organization'] == $settings['organization']) {

Where is it ?
This is referring to an older version. The new version has this function built into AdminCP.

Find: SET value = {$get_max_postid['postid']}
change it to

SET value = $get_max_postid[postid]

and see if you still get the error.

AWS 10-24-2004 03:18 PM
I've had this hack running since it was released. Haven't had one problem. It even brings more traffic to the site and I have users signing up to use the gateway only. Many people don't understand how to use a newsreader or are intimidated by one and this hack makes it easy for them.

Just wanted to say thank you for a great hack.

Lord Brar 10-24-2004 03:36 PM
;) Don't mean to sound too dumb... But How exactly do I upgrade? there are no instructions for it in the readme file :P


All times are GMT. The time now is 01:38 AM.
Page 59 of 101 « First 9495758 59 606169 Last »
Show 40 post(s) from this thread on one page

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.02227 seconds
  • Memory Usage 1,747KB
  • 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
  • (1)bbcode_code_printable
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)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