vb.org Archive - NNTP Gateway (Usenet/Newsgroups)

Page 97 of 99

« First

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)

lierduh

05-13-2004 09:18 PM

Quote:

Originally Posted by himerus

Mine's also not assigning posts to the proper thread after this change. I'm going to look over the code again for another hour or so, and revert to my last version if I can't get it working properly.

Messed up part is, the posting via the vB adminCP scheduled tasks worked after only minimal tweaking of the new script, and I have it tested to successfully post properly. (which was my only problem before)

I think the main problem is coming from the references. They don't seem to be assigning at all anymore.

I think you are not using the "a" version I uploaded not long after the first upload. I posted a message about this.

I did some quick test with vB adminCP schedule tasks, it worked for me. What is the exact problem and what have you need to do to fix?

himerus

05-13-2004 09:22 PM

Okay, that's a relief, so I can update the table, and reset them all to an empty value without fear of messing it up entirely.

I'm still plugging away at a few of the other oddities. I think some of them may also be since I switched the news server I was using on a few of the groups.

Imhotep

05-13-2004 09:32 PM

well, let us know when it's all ready to go. i just got the green light from my host to try the script again. :D

lierduh

05-13-2004 09:39 PM

Looks like some version of MySQL might not support this SQL statement. I will come up with another one to get around.

Could you do a test on your server. Just run this SQL manually:
=======================================
UPDATE post, thread SET post.isusenetpost = 1 WHERE
post.threadid = thread.threadid AND
post.isusenetpost = 0 AND
thread.forumid NOT IN (25,27,29,34)
=======================================

Quote:

Originally Posted by allan grossman

Got a little trouble here too, lierduh :)

Code:

Database error in vBulletin 3.0.1:



Invalid SQL: UPDATE post AS post, thread AS thread SET isusenetpost = 1 WHERE 

        post.threadid = thread.threadid AND 

        isusenetpost = 0 AND

        thread.forumid NOT IN (25,27,29,34)

mysql error: You have an error in your SQL syntax near 'AS post, thread AS thread SET isusenetpost = 1 WHERE 

        post.threadid = thread.th' at line 1



mysql error number: 1064



Date: Thursday 13th of May 2004 04:24:04 PM

Any thoughts?

hubba

05-13-2004 09:39 PM

>update the table, and reset them all to an empty

How? Alter table thread set.... ???

lierduh

05-13-2004 09:45 PM

Quote:

Originally Posted by hubba

>update the table, and reset them all to an empty

How? Alter table thread set.... ???

UPDATE thread SET msgid = '';

hubba

05-13-2004 09:47 PM

Thx!

lierduh

05-13-2004 11:05 PM

New version release:

**Build X-No-Archive header honouring system
**Improved speed
**Bug fixes
**Verbose output when run manually. Easier to find problem when interating with NNTP server.

change the honor_no-archive record from 0 to 1 to stop importing messages with X-No-Archive header, just as Google Group does.

Download it from:

https://vborg.vbsupport.ru/showpost....&postcount=658

allan grossman

05-14-2004 12:04 AM

Output from the manual query -

==========

Error

SQL-query :

UPDATE post,
thread SETpost.isusenetpost = 1 WHERE post.threadid = thread.threadid AND post.isusenetpost = 0 AND thread.forumid NOT IN ( 25, 27, 29, 34 )

MySQL said:

You have an error in your SQL syntax near ' thread SET post.isusenetpost = 1 WHERE post.threadid = thread.threadid AND post' at line 1

==========

MySQL version is 3.23

Imhotep

05-14-2004 12:24 AM

installed registry patch from M$, ran setlastmsg.php and got...

Quote:

1 group(s) gatewayed.
 
Fatal error: Call to undefined function: logging() in /nfs/home/cghaus2/public_html/forums/nntp.php on line 77

All times are GMT. The time now is 11:49 AM.

Page 97 of 99

« First

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

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