vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   NNTP Gateway for Usenet ( Newsgroups ), Mailing Lists (https://vborg.vbsupport.ru/showthread.php?t=65152)

BustaCap 07-11-2004 09:22 PM

I haven't had any problems since I've been using the hack, but today I added a new newsgroup and got this error:

Quote:

Database error in vBulletin 3.0.1:

Invalid SQL: SELECT post.*, thread.*,
post.dateline AS postdateline, post.msgid AS postmsgid,
post.title AS posttitle, thread.title AS threadtitle
FROM post AS post LEFT JOIN thread AS thread
ON (post.threadid = thread.threadid)
WHERE post.isusenetpost = 0 AND
post.postid > 61294 AND
thread.forumid = 34
mysql error: Got error 134 from table handler

mysql error number: 1030

Date: Sunday 11th of July 2004 01:50:23 PM
Script: http://www.mysite.com/forum/gateway.php
Referer:
Username: Unregistered
IP Address: xx.xx.xx.xx
After I got this error, the other two forums that are importing newsgroups stopped updating. Also, for some reason I couldn't connect to my admincp (even though I could for another site running on the same server). And just now, I can't even connect to the forum. I get this error message:

Quote:

Database error in vBulletin :

Link-ID == false, connect failed
mysql error:

mysql error number: 0

Date: Sunday 11th of July 2004 04:11:01 PM
Script: http://mysite.com/forum/
Referer:
IP Address: xx.xx.xx.x
I had been running gateway.php via a cronjob in my cpanel, but I was worried that gateway.php might have been a runaway job so I deleted it. However, I don't think that actually shut it down.

Any ideas what could be causing this?

Princeton 07-11-2004 09:31 PM

Still waiting for an update. :)

lierduh 07-11-2004 11:08 PM

Quote:

Originally Posted by BustaCap
I haven't had any problems since I've been using the hack, but today I added a new newsgroup and got this error:


Any ideas what could be causing this?

One of your table is corrupted. The reason could be a lot of things. One thing the gateway can do is pushing the server to the limit when importing large amount of data, ie. the initial importing for a newsgroup. That should not cause your database to corrupt though.

http://www.google.com.au/search?sour...+table+handler

rinkrat 07-12-2004 12:36 AM

I'm getting prompted to download gateway.php when I try and open it in the browser. Is this what it's supposed to do?

rinkrat 07-12-2004 03:35 AM

Quote:

Originally Posted by kkiely
I have this script installed with a news feed but when I run go to mysite.com/gateway.php why does it have a pop up that asks me to down the file with the list of posts that it is importing?

Also, can someone cut and paste me their cron script that they use to update it? I cant get mine to work


This is what I'm getting. Now what do we do next?

lierduh 07-12-2004 03:50 AM

Quote:

Originally Posted by rinkrat
This is what I'm getting. Now what do we do next?

Please refer to the third post on the first page.

john_rsd 07-12-2004 10:11 AM

lierduh

Did you have any ideas on this one?

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

lierduh 07-12-2004 11:56 PM

Quote:

Originally Posted by john_rsd
lierduh

Did you have any ideas on this one?

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

The attachment was not decoded.

If you can post the sample email, I will have a look. I need the email in raw format, you can delete the middle of the attachment. I mainly need to analyse the mime containers.

john_rsd 07-13-2004 07:28 AM

Quote:

Originally Posted by lierduh
The attachment was not decoded.

If you can post the sample email, I will have a look. I need the email in raw format, you can delete the middle of the attachment. I mainly need to analyse the mime containers.

Would it be better if I resend the email directly to you with attachment?
The file is only very small.

I can go to outbox and resend and just change destination address, that way you can get 100% same as I send.

The email path was from my home PC, directly to the mail server for the domain used (same server) and gatweway.php will collect it locally. Or i can place an email address from you as a forward and you can get the output directly from the server.

The emails for the address used are not held/stored at the server

If it helps the file was packed with winrar, but I use .zip extension as more people understand zip (can be opened in WinXp/zip compatible).

allan grossman 07-13-2004 10:37 AM

lierduh, you've done it again ;)

I installed the latest version and it's got all the options I need - so I don't have to hack gateway.php to get things the way I want them. Works just great.

I especially appreciate the 'no altering vB files' option for the control panel. I've decided with vB3 I'm not installing features that alter vB files - well, I did add a oneliner for photopost integration but that's all ;)

Being able to run nntp_settings and nntp_groups helps me out a lot.

Thanks again -


All times are GMT. The time now is 09:14 PM.

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.01385 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
  • (7)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