vb.org Archive

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)

lierduh 10-27-2004 01:30 AM

Quote:

Originally Posted by theispreport
Any chance of adding this as a feature? Or if its not to much guide me to the section of code that would need changing.. :)

I do not understand the need for such. Do you want a working email address to be used, yet you change the username each time someone posts? What would the usernet user say? Why would you want to fake the identity while having a working email address? The normal usenet users will see the same user posting under different nicks.

theispreport 10-27-2004 02:00 AM

Quote:

Originally Posted by lierduh
I do not understand the need for such. Do you want a working email address to be used, yet you change the username each time someone posts? What would the usernet user say? Why would you want to fake the identity while having a working email address? The normal usenet users will see the same user posting under different nicks.

Actually I am using this to post back to a mailing list, offering this as a solution to visitors who dont want to get 200+ emails a day. The benefit of having the senders named changed and the email address stay the same is, only 1 email address has to be registered to the mailing list and people on the mailing list know the post is from more then one user.

I hope i explained this ok.

esfron 10-27-2004 07:12 AM

Run 2.3.1 + fresh install vb 3.0.3 (reloaded scripts and re-installed forum with an empty MySQL database every time) with two differents news servers (public and paid). Got always same problem: MySQL error + posts correctly imported and threaded but with wrong statistics, it doubles the amount of posts : Threads: 4, Posts: 12 (see screenshot). I have to update counters to correct problem at every cron job.

NNTP Gateway_settings: all default.
NNTP Gateway Newsgroup: see screenshot.

Config.php checked.

Any ideas ?


HTML Code:

Gateway version 2.3.1  1 group(s) gatewayed.

Connecting to server, server says: 200 NNTP Service 6.0.3790.206 Version: 6.0.3790.206 Posting Allowed

Info for microsoft.public.netiquette at msnews.microsoft.com: 211 7 5366 5429 microsoft.public.netiquette

Getting message number 5367:
'Re: 8-30-04' from John Eddy [MSFT]. New thread.
Getting message number 5368:
'Re: 8-30-04' from rosie. Thread found by References.
Getting message number 5369:
'Re: 8-30-04' from John Eddy [MSFT]. Thread found by References.
Getting message number 5425:
'Newsgroup postings' from Joan. New thread.
Getting message number 5426:
'Re: Newsgroup postings' from John Eddy [MSFT]. Thread found by References.
Getting message number 5429:
'Re: Newsgroup postings' from Joan. Thread found by References.
<html><head><title>Forums Database Error</title><style type="text/css"><!--.error { font: 11px tahoma, verdana, arial, sans-serif; }--></style></head>
<body></table></td></tr></table></form>
<blockquote><p class="error">&nbsp;</p><p class="error"><b>There seems to have been a slight problem with the Forums database.</b><br />
Please try again by pressing the <a href="javascript:window.location=window.location;">refresh</a> button in your browser.</p><p class="error">An E-Mail has been dispatched to our <a href="mailto:cccxxxxxx">Technical Staff</a>, who you can also contact if the problem persists.</p><p class="error">We apologise for any inconvenience.</p></blockquote>

<!--
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: Wednesday 27th of October 2004 03:45:27 AM
Script: http://www.xxxxxx.org/forum/gateway.php?debug=1
Referer:
Username: Unregistered
IP Address: xxxxxxxxx
 -->


</body></html>


lierduh 10-27-2004 09:43 AM

Quote:

Originally Posted by theispreport
Actually I am using this to post back to a mailing list, offering this as a solution to visitors who dont want to get 200+ emails a day. The benefit of having the senders named changed and the email address stay the same is, only 1 email address has to be registered to the mailing list and people on the mailing list know the post is from more then one user.

I hope i explained this ok.

Each post has the user name in the signature area any way. You can set the Common user as eg. "X Forum Gateway" and the footer will identify the real user.

lierduh 10-27-2004 09:59 AM

Quote:

Originally Posted by esfron
Run 2.3.1 + fresh install vb 3.0.3 (reloaded scripts and re-installed forum with an empty MySQL database every time) with two differents news servers (public and paid). Got always same problem: MySQL error


In gateway.php, find: $good_to_set_postid = 1;

Before that, insert one line:
print_r($get_max_postid);

Post the result again.

esfron 10-27-2004 10:36 AM

@ lierduh

I am just running the script http://www.xxxxxx.org/forum/gateway.php?debug=1 (without re-install). I got:

Array ( [postid] => 6 ) Gateway version 2.3.1 1 group(s) gatewayed. Connecting to server, server says: 200 NNTP Service 6.0.3790.206 Version: 6.0.3790.206 Posting Allowed Info for microsoft.public.netiquette at msnews.microsoft.com: 211 7 5366 5429 microsoft.public.netiquette

esfron 10-27-2004 11:20 AM

reinstall:

Array ( [postid] => ) Gateway version 2.3.1 1 group(s) gatewayed. Connecting to server, server says: 200 NNTP Service 6.0.3790.206 Version: 6.0.3790.206 Posting Allowed Info for microsoft.public.netiquette at msnews.microsoft.com: 211 7 5366 5429 microsoft.public.netiquette Getting message number 5367: 'Re: 8-30-04' from John Eddy [MSFT]. New thread. Getting message number 5368: 'Re: 8-30-04' from rosie. Thread found by References. Getting message number 5369: 'Re: 8-30-04' from John Eddy [MSFT]. Thread found by References. Getting message number 5425: 'Newsgroup postings' from Joan. New thread. Getting message number 5426: 'Re: Newsgroup postings' from John Eddy [MSFT]. Thread found by References. Getting message number 5429: 'Re: Newsgroup postings' from Joan. Thread found by References.


There seems to have been a slight problem with the Forums database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.


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: Wednesday 27th of October 2004 08:17:09 AM
Script: http://www.xxxxxxxxorg/forum/gateway.php?debug=1
Referer:
Username: Unregistered
IP Address: xxxxx

lierduh 10-27-2004 11:28 AM

Quote:

Originally Posted by esfron
reinstall:

Array ( [postid] => ) Gateway version 2.3.1 1 group(s) gatewayed. IP Address: xxxxx

Here is your problem. Do you only have this problem when you do a refresh installation? You will get this problem if you do not even have one post in the post table.

Otherwise your problem might be related to the version of php and MySQL. Basically it returned nothing when the query tried to find the max(postid). It returned 6 in your last message, now it does not return anymore.

esfron 10-27-2004 12:38 PM

Quote:

Originally Posted by lierduh
Here is your problem. Do you only have this problem when you do a refresh installation? You will get this problem if you do not even have one post in the post table.

.

Yes, I have this when I do a fresh installation without post in the post table.
Maybe it's the problem. I reinstalled it. Posted 2 messages. Now, I have somthing new. It tries to download instead of displaying the contents... I run it with mozilla. I got:

Gateway version 2.3.1 1 group(s) gatewayed.

Connecting to server, server says: 200 NNTP Service 6.0.3790.206 Version: 6.0.3790.206 Posting Allowed

Info for microsoft.public.netiquette at msnews.microsoft.com: 211 7 5366 5429 microsoft.public.netiquette



Without MySQL error but the stats are wrong again (double post).

esfron 10-27-2004 12:49 PM

I'll redo tonight.

Just one more question.

Can I run it only with mozilla or mozilla firefox ?
With IE, I have to fix the registry.

Thanks for your time.


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

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.01970 seconds
  • Memory Usage 1,763KB
  • 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_html_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