![]() |
Quote:
|
Quote:
I hope i explained this ok. |
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. |
Quote:
|
Quote:
In gateway.php, find: $good_to_set_postid = 1; Before that, insert one line: print_r($get_max_postid); Post the result again. |
@ 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 |
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 |
Quote:
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. |
Quote:
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). |
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 | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|