vb.org Archive
Page 21 of 32 « First 111920 21 222331 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Mini Mods - Inactive Users Email Reminders For 3.7.x (https://vborg.vbsupport.ru/showthread.php?t=188383)

tpearl5 09-03-2008 03:21 PM
Okay, a couple things:
  • I setup a usergroup for 'bounced emails' - when setting the plugin to move users with bounced e-mails to this group, it does not save.
  • The stats page has two rows for 'emails sent' and three for 'bounced emails'
  • I got about 30 bounced emails registered, but my email for bounced emails had almost 900 bounced messages. I'm not sure if the cpanel pipe to program was working properly or not.

dfc005 09-04-2008 10:40 AM
Quote:
Originally Posted by tpearl5 (Post 1613682)
Okay, a couple things:
  • I setup a usergroup for 'bounced emails' - when setting the plugin to move users with bounced e-mails to this group, it does not save.
  • The stats page has two rows for 'emails sent' and three for 'bounced emails'
I had both these problems. It did eventually saved though.

Unfortunately, I'm still getting the problem where it sends multiple emails. Have double and triple checked and I'm using the 1.2.8 version.

I have a feeling it might be the way you are sending the messages. How exactly are you starting the mail send? I have a very large board. So I get the feeling that as multiple users visit the site, they are in fact all getting the same set of emails and initiating the same send. I think a cronjob or something similar would be much more effective.

C Braithwaite 09-05-2008 04:33 AM
Quote:
Originally Posted by tpearl5 (Post 1613682)
Okay, a couple things:
  • I setup a usergroup for 'bounced emails' - when setting the plugin to move users with bounced e-mails to this group, it does not save.
  • The stats page has two rows for 'emails sent' and three for 'bounced emails'
  • I got about 30 bounced emails registered, but my email for bounced emails had almost 900 bounced messages. I'm not sure if the cpanel pipe to program was working properly or not.
I will look into the issue with the usergroup saving (it does actually save, but when you load the page it decides it doesnt want to show the saved group selection properly - i thought that this was a bug only with vbulletin 3.6x but apparantly not)
i have fixed the reports page for the next release - the missing column was supposed to be "returning users" but it is actually bugged so don't count that number as accurate.
when you say your email has 900 messages - do you mean in your inbox? it's not supposed to save the messages in an inbox it should pipe to the program and not even reach your inbox? is the pipe set up correctly? are any of the emails on the reports showing as bounced?
Quote:
Originally Posted by dfc005 (Post 1614288)
I had both these problems. It did eventually saved though.

Unfortunately, I'm still getting the problem where it sends multiple emails. Have double and triple checked and I'm using the 1.2.8 version.

I have a feeling it might be the way you are sending the messages. How exactly are you starting the mail send? I have a very large board. So I get the feeling that as multiple users visit the site, they are in fact all getting the same set of emails and initiating the same send. I think a cronjob or something similar would be much more effective.
i am using the vbmail command and i have tested and tested and tested and i ant find any evidence of a duplicated email. it could well be the case that the same query is being executed like you suggest. in vbulletin's options it mentions about big boards and multiple emails being sent, and suggests the use of enabling it's table locking option to avoid such an error. have you enabled this option? i will code in a short delay to stop the same query from being executed twice (assuming this is the reason behind the multiple emails)

thanks for your feedback, comments, and suggestions. :up:

tekguru 09-05-2008 02:16 PM
After updating to vB 3.3.3PL1 this morning (which may be co-incidence) I got the following SQL error:

Code:
Invalid SQL:
UPDATE vb_user SET bounced = '0', usergroup = reminder_oldgroup WHERE userid = '34332';

MySQL Error  : Unknown column 'usergroup' in 'field list'
Error Number  : 1054
Request Date  : Friday, September 5th 2008 @ 01:46:43 PM
Error Date    : Friday, September 5th 2008 @ 01:46:43 PM
Script        : http://www.4winmobile.com/forums/profile.php?do=updatepassword
Referrer      : http://www.4winmobile.com/forums/profile.php?do=editpassword
Looks to be part of this Mod even though I am running with it disabled at the moment?

C Braithwaite 09-05-2008 05:18 PM
Quote:
Originally Posted by tekguru (Post 1615182)
After updating to vB 3.3.3PL1 this morning (which may be co-incidence) I got the following SQL error:

Code:
Invalid SQL:
UPDATE vb_user SET bounced = '0', usergroup = reminder_oldgroup WHERE userid = '34332';

MySQL Error  : Unknown column 'usergroup' in 'field list'
Error Number  : 1054
Request Date  : Friday, September 5th 2008 @ 01:46:43 PM
Error Date    : Friday, September 5th 2008 @ 01:46:43 PM
Script        : http://www.4winmobile.com/forums/profile.php?do=updatepassword
Referrer      : http://www.4winmobile.com/forums/profile.php?do=editpassword
Looks to be part of this Mod even though I am running with it disabled at the moment?
i made a spelling mistake. it will be fixed in this coming update.

tekguru 09-05-2008 08:08 PM
Can you advise what it is so we can fix manually please?

C Braithwaite 09-06-2008 04:28 AM
Quote:
Originally Posted by tekguru (Post 1615387)
Can you advise what it is so we can fix manually please?
open up your plugins, find the one "Update Current User"

find
PHP Code:
SET usergroup = reminder_oldgroup 
change to
PHP Code:
SET usergroupid = reminder_oldgroup 

tekguru 09-06-2008 05:46 AM
Just looked at the plugins, the only ones are:

Current User Update
Global Bounce Headers
Main
Options Processing
Required
Update Valid Email

and the nearest I can fine is:

Code:
if($vbulletin->GPC['email'] != $vbulletin->userinfo['email']){
  $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET bounced = '0', usergroup = reminder_oldgroup WHERE userid = '" . $vbulletin->userinfo['userid'] . "'");
}
in 'Update Valid Email'...

Confused?

C Braithwaite 09-06-2008 01:01 PM
Quote:
Originally Posted by tekguru (Post 1615651)
Just looked at the plugins, the only ones are:

Current User Update
Global Bounce Headers
Main
Options Processing
Required
Update Valid Email

and the nearest I can fine is:

Code:
if($vbulletin->GPC['email'] != $vbulletin->userinfo['email']){
  $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET bounced = '0', usergroup = reminder_oldgroup WHERE userid = '" . $vbulletin->userinfo['userid'] . "'");
}
in 'Update Valid Email'...

Confused?
yeh, sorry - that is the one.

i dont have the code to hand so i cant check if there are any more instances of that..but i think that's the only bit you need to change..

tekguru 09-06-2008 02:10 PM
Cheers thanks!


All times are GMT. The time now is 09:19 PM.
Page 21 of 32 « First 111920 21 222331 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.01327 seconds
  • Memory Usage 1,757KB
  • 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
  • (2)bbcode_php_printable
  • (6)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