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

Page 67 of 99

« First

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)

rishel

11-20-2003 04:07 PM

Because of the content, the content in our ng group doesnt pass away, its always needed. Its automotive based, and there are a wide array of years that people want to search for.

Its a shame really, I was really hoping to bring in a lot more.

allan grossman

11-20-2003 04:20 PM

Ah. I gotcha now.

Did you have any luck trying trying to download fewer headers at once?

liquidblaze

11-27-2003 08:25 AM

I just wanted to sync the NG with my board for the first time on the new host and got this:

Quote:

Invalid SQL: SELECT post.postid,post.username,post.userid,post.datelin e,post.attachmentid,post.pagetext,post.showsignatu re,post.ipaddress,thread.title,post.threadid,threa d.forumid,thread.msgid,thread.prefix FROM thread,post WHERE post.isusenetpost=0 AND thread.threadid=post.threadid AND (thread.forumid=25)
mysql error:

mysql error number: 0

any ideas what I could do?

liquidblaze

11-27-2003 09:15 PM

I found the problem. had to re-run
ALTER TABLE thread ADD prefix varchar (24);
to get the sync working again - it was a problem with an importing script i had. thanks for this great hack man :)

KevinM

11-29-2003 01:05 PM

I am attempting to put this into a clean vb3 board.

I am using the gateway script adapted by lierduh, with the rest being from Gilby's original.

I get the following error when running gateway.php for the first time:

Quote:

Database error in vBulletin 3.0.0 Beta 7:

Invalid SQL: SELECT post.postid,post.username,post.userid,post.datelin e,post.attachmentid,post.pagetext,post.showsignatu re,post.ipaddress,thread.pollid,thread.title,post. threadid,thread.forumid FROM thread,post WHERE post.isusenetpost=0 AND thread.threadid=post.threadid AND post.dateline=thread.dateline AND post.userid=thread.postuserid AND (thread.forumid=2) mysql error: Unknown column 'post.attachmentid' in 'field list'

mysql error number: 1054

Any ideas?

jarvis

11-29-2003 02:54 PM

All,

I have had this hack running on/off for over a year now. One of the big things that keeps me from consistently using it is the search feature and new posts count when a user logs in.

Anyways, I have fixed the search feature to discriminate between Usenet and normal forum posts but have not yet figured out how to disciminate between the new posts counter to exclude the two types of posts.

Rambling, I know, but I would like to see two numbers versus one large. :D

Anyways, I am by no means a php coder. I am horrible in coding, but I did figure it should be pretty easy to exclude a forumid from the $newposts routine?

Any help would be greatly appreciated!! :D

Thanks!

lierduh

12-03-2003 07:31 PM

Quote:

Originally Posted by KevinM

Are you sure you are using gatewas.php patched by me?

attachmentid is not in any of the SELECT queries in my gateway.php. However, I did find a typo in one of the SQL statement regarding attachment, which does not give errors like the one you have anyway. I have uploaded the fixed gateway.php. Please grab the new one if you want to try it out.

csimo

12-07-2003 05:28 PM

I'm not trying to cross any lines here, but does this work with vb3? If so it would be a lifesaver for me. Instructions? Info?

Thanks!

nkouts

12-07-2003 07:45 PM

Quote:

Originally Posted by jarvis

csimo - would love to know as well :)

Gardener

12-08-2003 08:59 PM

lierduh,

Great work on this hack. I had it up and running on the beta release. Then I upgraded to gamma and reinstalled the hack and the latest gateway.php file you have and this is the error I'm getting:

Fatal error: Call to undefined function: convert_url_to_bbcode() in \www\vb3\gateway.php on line 181

All times are GMT. The time now is 09:36 AM.

Page 67 of 99

« First

Last »

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01881 seconds Memory Usage 1,746KB 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_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: