vb.org Archive
Page 6 of 10 « First 45 6 78 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)
-   -   Email posts into forum (https://vborg.vbsupport.ru/showthread.php?t=40595)

NuclioN 01-08-2003 03:05 AM
Altough the mail pipe is working correct, members having problems with the reply errormail. This errormail is blanc.
Sometimes a mailed reply is succesfull, other times not. And wierd is that the admins are instantly got the "U have no permission etc" error-logout message when they check the reply on the forum after sending it trough mail. (??)

USODJA 02-02-2003 01:48 PM
Database error in vBulletin 2.2.9:

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

mysql error number: 1109

Kars10 02-02-2003 01:49 PM
@ USODJA, look @ Post 46...

USODJA 02-02-2003 02:21 PM
Thanks, that worked, now for the pipeline...LOL

And put on glasses to see other posts....

mcyates 02-05-2003 02:25 PM
Sorry i'm stupid, BUT how do i change this, what file / database table

Quote:
Originally posted by Xenon
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

squawell 02-05-2003 02:26 PM
i have a problem....

when i get the mail....what should i do next ???

ex:how to reply??can someone give me some screenshot will be easy understand....because i confused....

thankz.....

USODJA 02-06-2003 06:08 PM
Quote:
Originally posted by mcyates
Sorry i'm stupid, BUT how do i change this, what file / database table
Functions.php ...

sabret00the 02-23-2003 12:16 PM
Code:
In functions.php, replace this:
---- start code ----------------------------------------------------------
  $useremails=$DB_site->query("SELECT user.*
                              FROM subscribethread,user
                              WHERE subscribethread.threadid='$threadid'
                                AND subscribethread.userid=user.userid
---- end code ------------------------------------------------------------
With this:
---- start code ----------------------------------------------------------
  $fieldid = 7; // ID of the email password field in the user's profile
  $useremails=$DB_site->query("SELECT user.*,userfield.field$fieldid
                              FROM subscribethread,user,usergroup,userfield
                              WHERE subscribethread.threadid='$threadid'
                                AND subscribethread.userid=user.userid
                                AND userfield.userid=user.userid
---- end code ------------------------------------------------------------
my functions.php aint got that, it might have something do with another hack, i got something similar so i might try editing that, just wanna make sure i don't thuck anything else up

Big Daddy Chemo 03-02-2003 04:41 PM
Quote:
This message was created automatically by mail delivery software (Exim).

A message that you sent could not be delivered to one or more of its recipients. This is a permanent error. The following address(es) failed:

pipe to |/home/bdcnut2/public_html/forum/getpost.php
generated by post@*MYDOMAIN*.com
Child process of virtual_address_pipe transport returned 69 (could mean service or program unavailable) from command:
/home/bdcnut2/public_html/forum/getpost.php
Can someone help me out here? I see there were others with the same error message so if you have worked through this with Exim please share the knowledge.

Now, I have a dedicated server and I added the pipe in my alias file (etc/valiases/mydomain.com). At the command line I ran newaliases. Still get the above error.

I then deleted the entry, newaliases at the command line, and added them through cPanel6. Still the same error.

Little help from the knowledgeable?

Chemo

amp2000 05-02-2003 05:37 PM
I've been trying this all day & am getting really confused, I have vBulletin 2.3.0 & have tried to install it with that, but my replies never go into the Forum.
in the code_changes.txt it says
PHP Code:
In functions.php, replace this:
---- start code ----------------------------------------------------------
  $useremails=$DB_site->query("SELECT user.*
                               FROM subscribethread,user
                               WHERE subscribethread.threadid='$threadid'
                                 AND subscribethread.userid=user.userid
---- end code ------------------------------------------------------------
With this:
---- start code ----------------------------------------------------------
  $fieldid = 7; // ID of the email password field in the user's profile
  $useremails=$DB_site->query("SELECT user.*,userfield.field$fieldid
                               FROM subscribethread,user,userfield
                               WHERE subscribethread.threadid='$threadid'
                                 AND subscribethread.userid=user.userid
                                 AND userfield.userid=user.userid
---- end code ------------------------------------------------------------
And change the $fieldid variable to the right field ID. 
Now I dont have that in my functions.php, I have this
PHP Code:
$useremails=$DB_site->query("SELECT user.*, style.templatesetid
                               FROM subscribethread,user,usergroup
                               LEFT JOIN style ON (IF(user.styleid=0, 1, user.styleid)=style.styleid)
                               WHERE subscribethread.threadid='$threadid'
                                 AND subscribethread.userid=user.userid
                                 AND usergroup.usergroupid=user.usergroupid
                                 AND user.userid<>'$userid'
                                 AND user.usergroupid<>'3'
                                 AND usergroup.canview = 1
                                 AND user.lastactivity>'$lastposttime[dateline]'"); 
so I replaced it with this
PHP Code:
$fieldid = 5; // ID of the email password field in the user's profile
$useremails=$DB_site->query("SELECT user.*,userfield.field$fieldid, style.templatesetid
                               FROM subscribethread,user,usergroup,userfield
                               LEFT JOIN style ON (IF(user.styleid=0, 1, user.styleid)=style.styleid)
                               WHERE subscribethread.threadid='$threadid'
                                 AND subscribethread.userid=user.userid
                                 AND userfield.userid=user.userid
                                AND usergroup.usergroupid=user.usergroupid
                                 AND user.userid<>'$userid'
                                 AND user.usergroupid<>'3'
                                 AND usergroup.canview = 1
                                 AND user.lastactivity>'$lastposttime[dateline]'"); 
I think that is right. I have also figured out the pipe with the e-mail by putting
PHP Code:
post: | /usr/bin/php /tmp/getpost.php 
in my /etc/aliases file & restarted postfix & ran newaliases
Now here is where I get really confused, I receive the email telling me there was a reply to my post & I reply to it by replying to the e-mail but the post never makes it to the forum. If I dont have getpost.php world writable I get an error in my delivery failure report saying permission denied on getpost.php.
If I do have getpost.php world writable my reply is appended to the end of getpost.php.

Any ideas what's going on here people???

Thanks in advance for any replies.

amp2000


All times are GMT. The time now is 01:54 PM.
Page 6 of 10 « First 45 6 78 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.01527 seconds
  • Memory Usage 1,777KB
  • 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
  • (3)bbcode_code_printable
  • (4)bbcode_php_printable
  • (3)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