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)

AWS 02-15-2005 04:39 PM

Have you checked the newsgroup? Usenet posts when using a newsreader don't get posted right away. The poster might have posted and didn't see it appear and posted again.
I don't know what is cauing the weird username. Maybe a bug in the persons news reader.

SaN-DeeP 02-15-2005 04:59 PM

Quote:

Originally Posted by AWS
Have you checked the newsgroup? Usenet posts when using a newsreader don't get posted right away. The poster might have posted and didn't see it appear and posted again.
I don't know what is cauing the weird username. Maybe a bug in the persons news reader.

I have checked couple of times about this problem but not able to debug...
When importing from newsgroups, couple of messages gets imported twice or thrice as well the weird username problem appears while browsing those forums.

Regards,

BilldaCat 02-16-2005 06:27 PM

Quote:

Originally Posted by BilldaCat
Confirming this problem as well on my boards. Has anyone found a fix?

bumping this again, still looking for a solution.

(posts being counted twice in total count)

lierduh 02-21-2005 03:15 AM

Quote:

Originally Posted by BilldaCat
Confirming this problem as well on my boards. Has anyone found a fix?

Will fix this non-critical problem before next release. I need to set up a test forum to debug. In the meantime, please use the counter-reset function.

lierduh 02-21-2005 03:17 AM

Quote:

Originally Posted by infiniterb
Ok, I spoke with my host and he's saying there's nothing on their end that should prevent the gateway.php from accessing more than one group at a time. So, lierduh, I'm ruling out that my web hosts server allows only one group to be accessed at one time.

Any other ideas?

Have you checked with NNTP server host instead of web host?

lierduh 02-21-2005 03:24 AM

Quote:

Originally Posted by SaN-DeeP
I have checked couple of times about this problem but not able to debug...
When importing from newsgroups, couple of messages gets imported twice or thrice as well the weird username problem appears while browsing those forums.

Regards,

Not sure why it gets imported twice. Have you confirmed this with a normal news reader?

Weird user name problem is caused by other language encoding in the user name. The script has ability to decode, make sure your php server has "imap_mime_header_decode" function.

SaN-DeeP 02-22-2005 10:15 AM

Quote:

Originally Posted by lierduh
Not sure why it gets imported twice. Have you confirmed this with a normal news reader?

Weird user name problem is caused by other language encoding in the user name. The script has ability to decode, make sure your php server has "imap_mime_header_decode" function.

"imap_mime_header_decode" function is enabled on server.
I checked the message with normal news readers, only 1 message appears in news reader.

Slave 02-23-2005 08:24 AM

Just installed .. worked like a charm .. :)

joeMJ 02-28-2005 10:38 AM

Hello,

I installed this script as recommended. Port 119 is open and it synchronized Newsgroup (with some ISO/ encoding problems) the newsgroup in my forums. I'd like to synchronize msnews, microsoft.public.de.smartphone.

Server is Win2003, Web Edition, actual php and mysql.

Link to NG=>VB Forums is here

Problem:

I answered a post in the newsgroup (as you see here).
Then I manually started gateway.php

Errormessage I get, when I started gateway.php:

Code:

Datenbankfehler in vBulletin 3.0.7:

Ungueltige SQL-Abfrage:
                        SELECT email, field1 AS signature, usertitle, customtitle
                        FROM user AS user
                        LEFT JOIN userfield AS userfield
                        ON user.userid = userfield.userid
                        WHERE user.userid = 1
               
mysql error: Unknown column 'field1' in 'field list'

mysql error number: 1054

Datum: 28.02.2005 13:07:43
Skript: http://www.mobilejoe.de/joeforums/gateway.php
Referer:
Benutzername: joe
IP-Adresse: 217.84.8.114

debug=1:

Code:

Gateway version 2.3.2  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.de.smartphone at msnews.microsoft.com: 211 137 1040 1212 microsoft.public.de.smartphone

<html><head><title>mobilejoe.de Datenbankfehler</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>Es trat ein Problem mit der mobilejoe.de Datenbank auf.</b><br />
Bitte versuchen Sie es erneut, indem Sie die Seite neu laden (<a href="javascript:window.location=window.location;">Aktualisieren, Refresh, Reload</a> usw. im Browser klicken).</p><p class="error">Eine E-Mail wurde an den <a href="mailto:joe@mobilejoe.de">Technischen Administrator</a> geschickt, den Sie ebenfalls kontaktieren k?nnen, falls das Problem weiterhin auftritt.</p><p class="error">Wir entschuldigen uns f?r die Unannehmlichkeiten.</p><form><textarea class="error" rows="15" cols="100" wrap="off">Datenbankfehler in vBulletin 3.0.7:

Ungueltige SQL-Abfrage:
                        SELECT email, field1 AS signature, usertitle, customtitle
                        FROM user AS user
                        LEFT JOIN userfield AS userfield
                        ON user.userid = userfield.userid
                        WHERE user.userid = 1
               
mysql error: Unknown column 'field1' in 'field list'

mysql error number: 1054

Datum: 28.02.2005 14:55:25
Skript: http://www.mobilejoe.de/joeforums/gateway.php?debug=1
Referer:
Benutzername: joe
IP-Adresse: 217.84.8.114
</textarea></form></blockquote>

</body></html>

(screenshot below)

Can please anyone help me in that problem?


Thank you very much!
cheers
joe

lierduh 02-28-2005 07:18 PM

Quote:

Originally Posted by joeMJ
Hello,
Code:

Datenbankfehler in vBulletin 3.0.7:

Ungueltige SQL-Abfrage:
                        SELECT email, field1 AS signature, usertitle, customtitle
                        FROM user AS user
                        LEFT JOIN userfield AS userfield
                        ON user.userid = userfield.userid
                        WHERE user.userid = 1
               
mysql error: Unknown column 'field1' in 'field list'

mysql error number: 1054

Datum: 28.02.2005 13:07:43
Skript: http://www.mobilejoe.de/joeforums/gateway.php
Referer:
Benutzername: joe
IP-Adresse: 217.84.8.114

joe

Basically it says 'field1' field is not presented in your 'userfield' table. I can't explain why you don't. You can check whether you have 'userfield' table, and is there 'field1' in this table. 'field1' stores the signature of the users. Failing that, you can alway turn off the signature in the settings, or in the post interface.


All times are GMT. The time now is 12:41 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.01818 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
  • (3)bbcode_code_printable
  • (7)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