vb.org Archive - View Single Post - NNTP Gateway for Usenet ( Newsgroups ), Mailing Lists

joeMJ · #**780** 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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01054 seconds Memory Usage 1,772KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD_SHOWPOST (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_box (1)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit_info (1)postbit (1)postbit_onlinestatus (1)postbit_wrapper (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit reputationlevel showthread	Included Files: ./showpost.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showpost_start bbcode_fetch_tags bbcode_create postbit_factory showpost_post postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start showpost_complete
Messages: