vb.org Archive
Page 94 of 99 « First 44849293 94 9596 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   NNTP Gateway (Usenet/Newsgroups) (https://vborg.vbsupport.ru/showthread.php?t=35247)

hubba 05-12-2004 12:53 PM
>p?NG postings

Uff... :D

On the forumhome "new posts" and "new themes" counting includes the Newsgroupposts, that I would like to exclude, so that only "real" forumposts are added...

allan grossman 05-12-2004 01:05 PM
Quote:
Originally Posted by lierduh
I made a stupid mistake at the last minute. Please download the gateway.php again. I have attached a "a" to the end of the file name. The only thing changed was two lines in the gateway.php script. There is no need to replace the other files.
So all the joy I had trying to get this to work last night has been addressed? :D

Thanks, lierduh - I really appreciate all your hard work.

Imhotep 05-12-2004 01:14 PM
I think I am still having issues with VB posts going out to Usenet. I'm giving it a bit of time... for the post to propagate... but it still looks like they're not showing up. This is for new posts and replies.

hmmmm...

I bascially dropped my NNTP SQL tables and installed them fresh from the new ZIP file. I also replaced the PHP files.

hubba 05-12-2004 04:19 PM
installed the updated script. Now MySQL error:

UPDATE post AS post, thread AS thread SET isusenetpost = 1 WHERE
post.threadid = thread.threadid AND
isusenetpost = 0 AND
thread.forumid NOT IN (200,201,202)

mysql error: Column: 'isusenetpost' in field list is ambiguous

Imhotep 05-12-2004 04:28 PM
oh buggar! now I have an even bigger problem. This is from my host...

Quote:
Hello,

I have disabled your crontab which ran the "gateway.php" script. This crontab
was causing load issues on the server every 5 minutes, which is when the
script was being run. This is far too resource intensive to be run on a shared
server at such a short interval. Please do not re-enable this script as it
will continue to cause issues on the server if left to run.
:ermm:

Is there any way to make this script less system intensive? :rolleyes:

allan grossman 05-12-2004 04:42 PM
Quote:
Originally Posted by Imhotep
oh buggar! now I have an even bigger problem. This is from my host...



:ermm:

Is there any way to make this script less system intensive? :rolleyes:
Run it less often ;)

I run mine every 15 minutes. Once the newsgroups are populated the script doesn't beat hell out of the server.

hubba 05-12-2004 05:28 PM
Got it. Just renamed all instances of "isusenetpost" in gateway.php to "isusenetp" and the sql field to "isusenetp".

Edit...

Now all seems to be OK, the script shows "240 posting OK" but no new postings are made in the forum...

hubba 05-12-2004 09:12 PM
Again got it ;) just deleted all posts in the forum, run the gateway and it works

Imhotep 05-12-2004 09:43 PM
Quote:
Originally Posted by allan grossman
Run it less often ;)

I run mine every 15 minutes. Once the newsgroups are populated the script doesn't beat hell out of the server.

Well bollocks! Lunarpages just told me to not run the script ever again. :ermm:

Quote:
I would suggest that you not enable the script again, as advised by the Tech.
I can't imagine it putting that much load on the server... especially if it only collects new messages.

this sucks...

lierduh 05-12-2004 10:23 PM
Quote:
Originally Posted by hubba
installed the updated script. Now MySQL error:

UPDATE post AS post, thread AS thread SET isusenetpost = 1 WHERE
post.threadid = thread.threadid AND
isusenetpost = 0 AND
thread.forumid NOT IN (200,201,202)

mysql error: Column: 'isusenetpost' in field list is ambiguous
Check if your thread table has an 'isusenetpost' field. There shouldn't be one in the thread table. Only in the post table.


All times are GMT. The time now is 09:22 AM.
Page 94 of 99 « First 44849293 94 9596 Last »
Show 40 post(s) from this thread on one page

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.01988 seconds
  • Memory Usage 1,741KB
  • 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
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)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