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

Page 58 of 74

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - NNTP Gateway for Usenet ( Newsgroups ), Mailing Lists (https://vborg.vbsupport.ru/showthread.php?t=92588)

b00k	12-13-2007 03:53 PM

-----------

dodgez

12-29-2007 02:45 PM

Anyone know the fix to run it on 3.7?

Code:

Database error in vBulletin 3.7.0 Beta 3:



Invalid SQL:



                       INSERT INTO vb3_cronlog

                               (varname, dateline, description, type)

                       VALUES

                               ('gateway14',

                               1198943338,

                               'Ran NNTP Gateway<br />',

                               0);



MySQL Error   : Duplicate entry '64376' for key 1

Error Number  : 1062

Amenothep

12-29-2007 11:56 PM

Quote:

Originally Posted by TSR (Post 1400511)

I have been reading through this thread and haven't seen an answer for this yet.

I'd check postcount .. :)

AWS	12-30-2007 04:29 AM

Quote:

Originally Posted by dodgez (Post 1411424)

Anyone know the fix to run it on 3.7?

Code:

Database error in vBulletin 3.7.0 Beta 3:



Invalid SQL:



                       INSERT INTO vb3_cronlog

                               (varname, dateline, description, type)

                       VALUES

                               ('gateway14',

                               1198943338,

                               'Ran NNTP Gateway<br />',

                               0);



MySQL Error   : Duplicate entry '64376' for key 1

Error Number  : 1062

Evidently something changed with the cron scripts in vbulletin. In your cron task uncheck the option to write to log.

b00k	01-03-2008 03:05 PM

-----------

solokron

01-10-2008 08:06 PM

Why would I receive the following:

Code:

<form><textarea rows="15" cols="70" wrap="off" id="message">Database error in vBulletin 3.6.8:



Invalid SQL:



                        SELECT post.*, thread.*,

                        post.dateline AS postdateline, post.msgid AS postmsgid,

                        thread.title AS threadtitle, post.visible AS postvisible,

                        thread.visible AS threadvisible

                        FROM post as post LEFT JOIN thread as thread

                        ON (thread.threadid = post.threadid

                        AND post.userid = thread.postuserid

                        AND post.postid = thread.firstpostid)

                        WHERE post.isusenetpost = 0

                        AND post.postid &gt; 

                        AND thread.forumid = 27;



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 'AND thread.forumid = 27' at line 11

Error Number : 1064

Date         : Monday, December 10th 2007 @ 07:00:51 PM

Script       : http://www.mydomain.com/forum/gateway.php?debug=1

Referrer     : 

IP Address   : 000.000.000.000

Username     : admin

Classname    : vB_Database</textarea></form>

forumid = 27 is a valid id and is writable.

KW802

01-11-2008 04:08 AM

Quote:

Originally Posted by solokron (Post 1419159)

Why would I receive the following:

Code:

... 

            AND post.postid &gt; 

            AND thread.forumid = 27;

...

If you check ACP => NNTP Gateway Options => NNTP Gateway Settings, is there a value for the "The max postid in post table when the script was last run." settings?

mindfrost82

01-12-2008 06:18 PM

I just installed this and so far it is running good, with the exception of 1 problem.

Certain messages will generate a "PHP has encountered a Stack overflow" error. The only way I can figure out to get around it is to go in and manually change the last downloaded message number so that it skips that message.

Any ideas on how to fix this? I'm running a Windows 2003 server. I have already tried increasing the memory limit in PHP and it doesn't seem to have helped.

solokron

01-14-2008 06:18 PM

It's empty.

Quote:

Originally Posted by KW802 (Post 1419373)

If you check ACP => NNTP Gateway Options => NNTP Gateway Settings, is there a value for the "The max postid in post table when the script was last run." settings?

KW802

01-14-2008 06:36 PM

Quote:

Originally Posted by solokron (Post 1421384)

It's empty.

Find the last post ID in your vBulletin and then insert that ID as the value.

All times are GMT. The time now is 01:40 PM.

Page 58 of 74

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01832 seconds Memory Usage 1,749KB 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 (4)bbcode_code_printable (5)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
Messages: