vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Administrative and Maintenance Tools - [DBTech] vBMail v2 (vB4) (https://vborg.vbsupport.ru/showthread.php?t=266142)

chrisbjax 03-27-2012 01:56 PM

Hi Fillip,
After some tinkering, changing the "Navbar Link" Plugin Hook location for vbmail from "global_bootstrap_complete" to "process_templates_complete" - the issue appears to have gone away.

DragonByte Tech 03-27-2012 02:09 PM

But doing so many break the Home tab, which is why I put it where I did :)


Fillip

chrisbjax 03-27-2012 02:30 PM

yes sir, understood.
Disclaimer - I only posted what worked for me. :D


Is there anyway to throttle the messages sent per hour?

DragonByte Tech 03-27-2012 02:41 PM

vBMail uses the vBulletin Mail Queue system, I'm not sure if that has this feature but if it doesn't, then neither does vBMail :)


Fillip

Alan_SP 03-27-2012 09:31 PM

I think that vB Mail Que system sends specified amount of mails (in settings) every page load of front end.

So people should use very low numbers there if they have very busy forums. Or higher, if on small ones.

stemmy 03-28-2012 07:50 AM

I seem to have an issue.

This system was working fine (ish) a few weeks ago.

This system did have an issue with my members subscription system. When the mail program was running and a member paid an upgrade subscription they would not be moved to the new usergroup. Not a real issue as I now leave the mail program disabled until I need to send a message and then activate it, send the message, then de activate it again.

The new issue is this - when the system sends the emails I then get the returned (bounced) emails. I have set up an IMAP email to receive the mail. This system used to work correctly. When I activated the mail program I would then go to the scheduled tasks section and run the two mail program tasks - collect mail and remove members from list. When the tasks ran it would list the members that had been removed from the list and then delete the email from the mailbox.

If I run the system now all seems to work - I get no error messages. When I hit the scheduled task it used to list the members it had removed, I now get no members names in that list, it still shows that its done what it was supposed to do but no names are listed.

If I send another message I still get loads of bounced messages - if the system was working shouldn't these member have been removed from the list already ??

Any help would be appreciated.

Thanks in advance.

DragonByte Tech 03-28-2012 09:53 AM

Quote:

Originally Posted by stemmy (Post 2314153)
This system did have an issue with my members subscription system. When the mail program was running and a member paid an upgrade subscription they would not be moved to the new usergroup. Not a real issue as I now leave the mail program disabled until I need to send a message and then activate it, send the message, then de activate it again.

That issue has already been fixed a few versions ago, it was an issue with the mail_send hook.

You can check if your version is "safe" by opening /dbtech/vbmail/hooks/mail_send.php and check that the code is wrapped in
PHP Code:

if (THIS_SCRIPT != 'payment_gateway'

Deactivating the product after sending emails means that the unsubscribe link will not work, plus many other features of the mailing list that is integral for the functionality of the mod.

Quote:

Originally Posted by stemmy (Post 2314153)
The new issue is this - when the system sends the emails I then get the returned (bounced) emails. I have set up an IMAP email to receive the mail. This system used to work correctly. When I activated the mail program I would then go to the scheduled tasks section and run the two mail program tasks - collect mail and remove members from list. When the tasks ran it would list the members that had been removed from the list and then delete the email from the mailbox.

If I run the system now all seems to work - I get no error messages. When I hit the scheduled task it used to list the members it had removed, I now get no members names in that list, it still shows that its done what it was supposed to do but no names are listed.

If I send another message I still get loads of bounced messages - if the system was working shouldn't these member have been removed from the list already ??

Are you sure you don't deactivate the product before doing that? To my knowledge, nobody else are having these issues.

In addition, you should always check your Bounced Mail list (DBTech - vBMail -> Bounced Mail List -> Show Only Entries Generated By: Unknown Mail -> Submit) - cPanel will not correctly flag certain emails as bounced; example of one email is this:
Code:

Subject    Warning: message 1SBG4k-0004tb-10 delayed 24 hours
Message    This message was created automatically by mail delivery software.
A message that you sent has not yet been delivered to one or more of its
recipients after more than 24 hours on the queue on server.dragonbyte-tech.com.

The message identifier is: 1SBG4k-0004tb-10
The date of the message is: Sat, 24 Mar 2012 01:47:26 +0000
The subject of the message is: Update Galore: vBShout / vBAvatars (+Lite) / vBMail / vBArcade / vBAnalytics / vBNominate

The address to which the message has not yet been delivered is:

kortton+gaiffibre@gmail.com
Delay reason: SMTP error from remote mail server after RCPT TO::
host alt4.gmail-smtp-in.l.google.com [173.194.70.26]:
452-4.2.2 The email account that you tried to reach is over quota. Please direct
452-4.2.2 the recipient to
452 4.2.2 http://support.google.com/mail/bin/answer.py?answer=6558 7si7316708wel.122

No action is required on your part. Delivery attempts will continue for
some time, and this warning may be repeated at intervals if the message
remains undelivered. Eventually the mail delivery software will give up,
and when that happens, the message will be returned to you.

As it's showing as coming from
Code:

Mailer-Daemon@server.dragonbyte-tech.com
instead of the actual email address seen in the email itself.

There is nothing vBMail can do about that, as it's not feasible to try to detect an email address from the error message - there may be multiple matches in these error messages, leading to confusion.

These emails will still show up as Bounced, but the users won't be flagged - thus explaining your issue.

You can fix it by going to the list I suggested, then editing each email taking the email from the message body and putting it in the field that has
Code:

Mailer-Daemon@server.dragonbyte-tech.com
in it, setting Is Bounced Mail to Yes, then saving the message.

Repeat for each email, then run the 2nd scheduled task again. It will then function correctly :)


Fillip

KGodel 03-31-2012 01:23 AM

When attemtping to add a new mailing list, I receive this error:

Quote:

Database error in vBulletin 4.1.11:

Invalid SQL:

SELECT `bitfield`
FROM `mytablehere`
ORDER BY `bitfield` DESC
LIMIT 1;

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

Pandemikk 03-31-2012 02:41 AM

Quote:

Originally Posted by KGodel (Post 2315241)
When attemtping to add a new mailing list, I receive this error:

Please don't remove the table and column names. That makes it virtually impossible to fix.

snowlion 03-31-2012 09:51 AM

This is full message
Code:

Database error in vBulletin 4.1.4:

Invalid SQL:

                                SELECT `bitfield`
                                FROM `sty_dbtech_vbmail_mailinglist`
                                ORDER BY `bitfield` DESC
                                LIMIT 1;

MySQL Error  : Unknown column 'bitfield' in 'field list'
Error Number  : 1054
Request Date  : Thursday, March 29th 2012 @ 12:46:16 AM
Error Date    : Thursday, March 29th 2012 @ 12:46:17 AM
Script        : http://forum.bentinhyeu.info/.../vbmail.php?do=mailinglist
Referrer      : http://forum.bentinhyeu.info/.../vbmail.php?do=mailinglist
IP Address    : ...
Username      : kisibachda
Classname    : vB_Database
MySQL Version : 5.1.56



All times are GMT. The time now is 09:02 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.04773 seconds
  • Memory Usage 1,761KB
  • 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_code_printable
  • (1)bbcode_php_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)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