vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   Email posts into forum (https://vborg.vbsupport.ru/showthread.php?t=40595)

tacoX 09-03-2002 08:50 PM

Looks like another rip of yaxay! *Looks Up* thanks chen...

Linux 10-02-2002 03:50 AM

Child process of virtual_address_pipe transport returned 69 (could mean service or program unavailable)

me too I had the same problem , any tips or solution ?

PhotoGenie 10-22-2002 12:45 AM

Can anyone tell me what to do to get the emails sent from the relpy's to show the content of the post. Like the emails I get here that say...

Here are the contents of the post:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Well, I'm glad that no one wants to help me out. */sarcasm* :p
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

I didn't see anything in the code changes to add this. Thanks

ChurchMedia 12-28-2002 11:34 PM

Has anyone actually got this to work? I don't see any reference in the instructions to getpost.php other than "don't put it in your public directory". So, I'm not sure how to apply it.

Also, it creates an error when replying after I make the mods:

Quote:

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT user.*,userfield.field8
FROM subscribethread,user,userfield
WHERE subscribethread.threadid='1'
AND subscribethread.userid=user.userid
AND userfield.userid=user.userid
AND usergroup.usergroupid=user.usergroupid
AND user.userid<>'1'
AND user.usergroupid<>'3'
AND usergroup.canview = 1
AND user.lastactivity>'1041124392' mysql error: Unknown table 'usergroup' in where clause

mysql error number: 1109
The usergroup table shows up and seems to be okay. Any ideas?

Thanks!

SemperFidelis 12-30-2002 08:03 AM

Hmmm
Im getting the exact same error as ChurchMedia
(running vb 2.2.9)
Quote:

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT user.*,userfield.field5
FROM subscribethread,user,userfield
WHERE subscribethread.threadid='2'
AND subscribethread.userid=user.userid
AND userfield.userid=user.userid
AND usergroup.usergroupid=user.usergroupid
AND user.userid<>'1'
AND user.usergroupid<>'3'
AND usergroup.canview = 1
AND user.lastactivity>'1041223298' mysql error: Unknown table 'usergroup' in where clause

mysql error number: 1109

Date: Monday 30th of December 2002 06:03:50 PM
Anyone got any ideas on this one ?

Xenon 12-30-2002 02:14 PM

your query is incorrect
instead of this:
Code:

SELECT user.*,userfield.field5
FROM subscribethread,user,userfield
WHERE subscribethread.threadid

it should be this:
Code:

SELECT user.*,userfield.field5
FROM subscribethread,user,userfield,usergroup
WHERE subscribethread.threadid


Mystis 12-30-2002 09:51 PM

Thanks for releasing it Firefly, I learned quite a bit studying the code!

SemperFidelis 12-30-2002 11:26 PM

Cheers Xenon
That has fixed it all up
:D

NuclioN 01-03-2003 04:24 PM

.procmailrc solution:
_____________________

:0
* (^To:|^CC:|^Cc:) .*emailadres@domain.ltd
|/usr/bin/php4 /path/to/getpost.php
_____________________
cyberty.nl

NuclioN 01-03-2003 04:30 PM

if you get problems with that mysql_connect is an invalid option, edit your php.ini file (OF YOUR CGI PHP, debian /etc/php/cgi/php.ini) and add extenstion=mysql.so
_______


All times are GMT. The time now is 01:44 AM.

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