vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Major Additions - Email Integration (New threads/replies by email) (https://vborg.vbsupport.ru/showthread.php?t=151222)

vocoder 07-19-2007 02:13 PM

thanks for the answers!

I get an error when trying to install the product:

Database error in vBulletin 3.5.4:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO plugin
(`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`)
VALUES
('1', '5', 'Quote template', 'cache_templates', '$globaltemplates = array_merge($globaltemplates, array(\'bbcode_quote\'));', 'emailreplyint');

MySQL Error : Unknown column 'executionorder' in 'field list'
Error Number : 1054

These are the only fields in my plugin table:
pluginid
title
hookname
phpcode
product
devkey
active

Do I need to upgrade to the latest version of vb for this to work?

Tralala 07-19-2007 02:48 PM

I have just installed and am in the process of testing this baby out. Very excited.

For the most part the reason I love this new hack is that it allows for the posting of threads and replies via email. My users will really appreciate it.

I previously had RedTyger's code installed "Instant new thread notification" -- and I notice you used that code in the process of developing this new one. Now when I go to Forum Tools -> Subscription Type, I see two identical entries under Notification type called "Instant Notification by email."

No problem, I go into AdminCP and disable the previous hack by RedTyger, and now one of them is gone from the Subscription Type pulldown. But I realize that means users can no longer subscribe to instant notification of "new threads only." And I'd like to retain that option, if possible. So perhaps for a future version, this hack could offer two types of subscription:

-Instant notification by email of new threads only
-Instant notification by email of new threads and all replies

I request this simply because the way my forum is structured, the 2nd option might be too much for some folks and will ultimately flood their email inbox, scaring them away. The 1st option, of course, is enough to keep them in the loop of new topics and announcements, and may even entice them to login to the forum and be more active via the web.

Thanks for the consideration. I suppose I could go in and rename these things myself to get them to coexist peacefully... but figured I'd request it for the benefit of others.

Cyricx 07-19-2007 02:55 PM

Quote:

Originally Posted by vocoder (Post 1295714)
thanks for the answers!

I get an error when trying to install the product:

Database error in vBulletin 3.5.4:

Invalid SQL:

MySQL Error : Unknown column 'executionorder' in 'field list'
Error Number : 1054

Do I need to upgrade to the latest version of vb for this to work?

Vocoder - You'll either need to upgrade, or edit the product xml file and change all of the <plugin active="1" executionorder="5"> to just <plugin active="1">

Vbulletin 3.6 added executionorders to the plugins which is something 3.5 didn't have.

Hypothetically, this modification should work on 3.5, but I'm only offering support for 3.6 boards due to the complexity of the modification.

Quote:

Originally Posted by Tralala (Post 1295735)
Thanks for the consideration. I suppose I could go in and rename these things myself to get them to coexist peacefully... but figured I'd request it for the benefit of others.

You've got some kick ass ideas!! Thank you!!! :)

I had planned on a future version getting this to coexist with subscribed forums/threads. So if you subscribed to a thread that email integration was turned on in, you would be able to reply to the email you get for subscribed threads :), and it's definatley in my brain for a future version.

The new thread only thing is kick ass as well! And should not be hard for me to code at all! I'll add it to my list and it should make it into 2.0

I want to let 1.x ride a little bit to find out what other email programs are not behaving well before I start on 2.0 though :)

Keep the suggestions coming!!

vocoder 07-19-2007 02:58 PM

yeah, I went and upgraded to the latest vB and it installed just fine.

When a new post is created, it sends out the email just fine, however when I reply to that email, it never shows up in the forum. I'm using Exchange for the email server, and have IMAP enabled, but still think there may be some problem with that setup....is there a good way to test?

I'm just wondering if when it sends the email, is it also using the imap server that is specified for the forum, or is it perhaps using localhost (vb is running on a linux server with mail)

Tralala 07-19-2007 03:12 PM

Okay, so I set up a new mailbox on my server and confirmed that I could email to it, as well as check it. (BTW, a good free web tool to confirm this is Mail2Web.)

I know my email hoster supports POP3 and IMAP because I have set up regular email accounts and clients using both over the years.

But, with this hack, I chose POP3, and then just ran the cron job manually and got this error:

Quote:

Originally Posted by Cyricx (Post 1281490)
Undefined Function

If you get the error the below error you will need to enable IMAP support on your server. If you host your own server, check your php.ini file, the line for imap support will be commented out. If you do not host your own server, request your host to enable this.
  • Fatal error: Call to undefined function: imap_open() in
    /*****/includes/cron/emailintegration.php on line 70

:(

I was afraid that might happen.

Quote:

Originally Posted by Cyricx (Post 1281490)
To verify if you have IMAP installed go to your admincp -> Maintence -> View Php Info and you should see something like this:

imap

IMAP c-Client Version 200X

Sure enough, I looked in there and didn't see anything listed about "imap."

Just wondering, is enabling IMAP support necessary even if we've chosen POP3 in the Forum Manager prefs? I ask this because getting my webhoster to do anything, even as simple as enabling the line for imap support, is often an uphill battle.

vocoder 07-19-2007 03:13 PM

I ran the cron and seem to be getting the

Call to undefined function imap_open() in /var/www/bb/includes/cron/emailintegration.php on line 70

error. I recall seeing posts about this here, I'll look to see what is causes this.

Tralala 07-19-2007 03:21 PM

One more question. When emails are fetched from the mailbox to be posted, are they deleted from the mailbox, too? (Just asking because I don't want to see that mailbox be filled up eventually.)

Tralala 07-19-2007 03:22 PM

Quote:

Originally Posted by vocoder (Post 1295764)
I ran the cron and seem to be getting the

Call to undefined function imap_open() in /var/www/bb/includes/cron/emailintegration.php on line 70

error. I recall seeing posts about this here, I'll look to see what is causes this.



See the FAQ in post #2.
https://vborg.vbsupport.ru/showpost....90&postcount=2

vocoder 07-19-2007 03:29 PM

okay, I enabled the php imap extension...now i am getting different errors. it looks as though its trying to use the POP3 port instead of hte IMAP port, even though I have IMAP selected?

It should be using port 143, right, not 110? these are the errors i now get:

Warning: imap_open() [function.imap-open]: Couldn't open stream {mail.mymailserver.com:110/pop3/notls}INBOX in /includes/cron/emailintegration.php on line 70

Warning: imap_headers(): supplied argument is not a valid imap resource in /includes/cron/emailintegration.php on line 73

Warning: imap_close(): supplied argument is not a valid imap resource in /includes/cron/emailintegration.php on line 807

EDIT: my settings are correct, I tested it with thunderbird IMAP just to doublecheck. and it works fine with thunderbird. I think it has to do with the port.

Cyricx 07-19-2007 03:38 PM

Quote:

Originally Posted by Tralala (Post 1295773)
One more question. When emails are fetched from the mailbox to be posted, are they deleted from the mailbox, too? (Just asking because I don't want to see that mailbox be filled up eventually.)

Yes on each loop of reading each message, either when it gets an error or when it completes the process of working with that email it marks it to be deleted. Then just before it closes that mailbox, it deletes all those emails :)



Quote:

Originally Posted by vocoder (Post 1295778)
okay, I enabled the php imap extension...now i am getting different errors. it looks as though its trying to use the POP3 port instead of hte IMAP port, even though I have IMAP selected?

It should be using port 143, right, not 110? these are the errors i now get:

Warning: imap_open() [function.imap-open]: Couldn't open stream {mail.mymailserver.com:110/pop3/notls}INBOX in /includes/cron/emailintegration.php on line 70

Warning: imap_headers(): supplied argument is not a valid imap resource in /includes/cron/emailintegration.php on line 73

Warning: imap_close(): supplied argument is not a valid imap resource in /includes/cron/emailintegration.php on line 807

EDIT: my settings are correct, I tested it with thunderbird IMAP just to doublecheck. and it works fine with thunderbird. I think it has to do with the port.

Please try the other options such as with official and self signed certificate as well.

There are 3 different pop3 and 3 different imap connections due to the varied kinds of ways people can setup their servers :)

To your previous question, the emails being processed to the forum are controlled through the cron job, if the cron cannot connect, it will not process those emails :)

however, it will still send out emails when someone posts from the forums. :)


All times are GMT. The time now is 03:59 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.01837 seconds
  • Memory Usage 1,764KB
  • 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