Inactive Users Email Reminders For 3.7.x

[C Braithwaite]

Inactive reminder emails. This mod was designed to send out a reminder to inactive members to try and win them back. Earlier versions of this plugin have had great success, and has been installed on 1000's of forums.

This mod is a revised version of my 3.6 modification.
Someone pointed out that I needed to make a new thread in the right forum for this.

***1.2.7 Update***
Fixed the \ in the message.
Changed the way the mails are processed to try and stop duplicates
Made the bounce management monitor ALL outgoing emails
Added more stats
Added bounced email messaage viewing with management options.
***1.2.7 Update***
This update includes built in support for bouncing emails. The script will automatically detect the bounced mail, mark it as bounced so the user is not to be contacted again so as to avoid spam, and then move that user into a seperate usergroup. This plugin is still in it's testing stages, but I have addressed the bugs mentioned previously regarding the emailing side of things.

This is important so keep reading
To install this plugin and take advantage of the bounced email features you are going to need to follow these instructions very carefully. I can not gaurentee that they will work to the letter as this will be based on each persons individual hosting settings.

Step 1: Pre Install
Before you touch this product you need to do the following

Create an "inactive" usergroup
Set up a "bounce to" email address
Pick an email address that you want to use as your bounced email address. Im using "bounce@icora.co.uk". feel free to use whatever you wish.
Add a email message filter
This is the hard part. You need to set up a filter that will 'pipe' an email sent to the above email address.
I am using Cpanel 11 and this is how i have mine set up:
Rules: 'To' 'Equals' 'bounce@icora.co.uk'
Actions: 'Pipe to program' with the setting: |/usr/local/bin/php /home/icora/public_html/forum/bounce.php
This will depend entirely on your settings and structure so you may have to do a little research. It would be very helfull if people who have to use diferent configurations would post them on here.
Go into vBulletin options, and find the options for 'Emails'. there is a setting asking you if you want to use '-f'. set this to yes.
While still inn the email options set the 'Bounce Email Address' to your above address.

Step 2: Install
Remove all previous trace of this modification, and upload all the files in the "upload" folder to your base directory of the server.
Go into your product management section and add a new product. upload the XML file with overwrite selected.
Refresh your admin CP to load the new menu items. Just under the "users" group you will find an "Inactive Reminders" group. open that up and click on settings.
Play with these settings and options to suit for the most part. when you come down to the bounce settings you MUST use the same email address as the one you created above.
Set to active and save.

I must re-iterate that this version has not been widely tested, but the simulations i have ran have worked. I look forward to your feedback!


Features:

Select the period of time before a user is considered inactive.
Select how many emails to send to each inactive user per inactivity period
Choose weather inactivity is based on members "Last Post" or their "Last Visit"
Specify how often followup emails are sent
Specify alternative emails to send to reduce repetition
Keep a log of all inactive users contacted


Planned Updates:

More detail in reports
...such as
Which useres returned
Effectivness stats
Email validity


**1.2.1 Update***
Added more detail to the reports section. You can now see the email address, and quickly indicate which emails were invalid. You can link directly to that user to edit as you wish.
I have fixed some errors which have been crashing people's database. Please post any problems if you can.

**1.2.3 Update***
Fixed several problems with escaping strings
Stopped database errors locking up site
***

**1.2.4 Update***
Added a "From Email" so you can specify your own email address to send the reminders from.
Fixed potential bug for people who do not use the mail queue.

Anyone having problems with sending emails out too fast, and multiple emails being sent need to consider changing their email settings in vbulletin options.
People with emails going out too fast - edit Number of Emails to Send Per Batch to a lower amount
People with multiple emails sending - edit Use Mailqueue System to "Yes, with locking"
***

**1.2.5 Update***
Added more stats in the reports page, also added a "Send test email" option so users can test the functionality of the mod
***

**1.2.6 Update***
Identical to 1.2.5, however EzBounce support added.
***

**Opps Update***
Sorry i somehow managed to not include the file in the zip. My bad.
***

[samet54]

oo thank arkadasım

[Megatr0n]

Have the initial bugs that've been reported in the 3.6 thread been fixed?

[yahoooh]

thank u very much
installed

[C Braithwaite]

Have the initial bugs that've been reported in the 3.6 thread been fixed?

Yes they have.

[abrecher]

This mod is crashing my database. I had to uninstall.

[taxick]

Nice - Thanks for mod, it works fine

[SwollenCranium]

This mod is crashing my database. I had to uninstall.



Same here.

'Disable hooks' was my only way to gain access.


Uninstalled.

[Gene Steinberg]

Just some suggestions: How about having this product email you a daily reminder report in the same fashion as the other product that performs this function?

Also, when you get a message that a member's email address is no longer valid, how about an option to automatically disable that person's membership? It beats manual, particularly when you've got several dozen or more to go through?

Peace,
Gene

[Endurer]

I have the 3.6 version installed, should I uninstall that one and install this one?

[wingrider]

There is a syntax error in your code. It brought my system down completely... Database Error. I can't even access the AdminCP. Others BEWARE before installing this upgrade.

[Gene Steinberg]

Maybe, but I haven't had any trouble at all.

[C Braithwaite]

Just some suggestions: How about having this product email you a daily reminder report in the same fashion as the other product that performs this function?

Also, when you get a message that a member's email address is no longer valid, how about an option to automatically disable that person's membership? It beats manual, particularly when you've got several dozen or more to go through?

Peace,
Gene
I'm about to upload an update that does just that.. watch this space..
Same here.
'Disable hooks' was my only way to gain access.
Uninstalled.
This mod is crashing my database. I had to uninstall.
There is a syntax error in your code. It brought my system down completely... Database Error. I can't even access the AdminCP. Others BEWARE before installing this upgrade.

Sorry this has messed up for you guys - is there any chance you still have a copy of the email with the error? problem is, it works fine on mine so its hard to test...

I have the 3.6 version installed, should I uninstall that one and install this one?

no.

[wingrider]

C Braithwaite, Apparently the error is coming from the content of the outgoing message, which I changed in the CP from your default message. Looking below, I see a '\' symbol in the word 'haven\'t', but it does not display that way in the MySQL database table.

Can you tell me how to remove the plugin when I don't have AdminCP access? I have FTP and PHPMyAdmin, so maybe you can tell me what file to remove to make it stop sending data to the mailqueue. Any help would be appreciated. Sorry to turn your thread into a support center. I have a ticket open with vBulletin support.

Don
--------------------------------------------------------------------------------------------

<!--
Database error in vBulletin 3.7.2:

Invalid SQL:
INSERT INTO mailqueue (dateline,toemail,fromemail,subject,message,header ) VALUES ('1219000005','lclowry@execulink.com','rvpicsmail@ sbcglobal.net','We Miss You!!','&lt;p&gt;Dear Travelin'on&lt;/p&gt;

&lt;p&gt;We haven\'t seen you check in with RVPics for a while. Your participation is very important to us. Please stop by when you have a chance.&lt;/p&gt;

&lt;p&gt;Regards&lt;br/&gt;
The Team
&lt;a href=&quot;http://www.rvpics.com/forums/index2.php&quot;&gt;RV Pics&lt;/a&gt;&lt;/p&gt;','MIME-Version: 1.0
Content-type: text/html; charset=iso-8859-1
To: Travelin'on &lt;lclowry@execulink.com&gt;
From: RV Pics Reminder Service &lt;rvpicsmail@sbcglobal.net&gt;
');

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'on&lt;/p&gt;

&lt;p&gt;We haven\'t seen you check in with RVPics for a while. Your partic' at line 1
Error Number : 1064
Request Date : Sunday, August 17th 2008 @ 01:06:45 PM
Error Date : Sunday, August 17th 2008 @ 01:06:45 PM
Script : http://www.rvpics.com/forums/index.php
Referrer :
IP Address : 75.6.163.23
Username :
Classname : vB_Database
MySQL Version :
-->

[C Braithwaite]

any feedback is great - sorry abut this... go into phpmyadmin and find "datastore" delete the entry "pluginlist" ad then you can disable the product from there.

the \ are supposed to stop the errors.. i will double check but i think i've fixed it in this version..

[wingrider]

OK, I got as far as deleting 'pluginlist'. How do I disable the product? I still can't open the AdminCP... I get: Warning: array_merge() [function.array-merge]: Argument #1 is not an array in [path]/includes/init.php on line 271 on the html page.

[Ross L]

OK, I got as far as deleting 'pluginlist'. How do I disable the product? I still can't open the AdminCP... I get: Warning: array_merge() [function.array-merge]: Argument #1 is not an array in [path]/includes/init.php on line 271 on the html page.

The easiest way is to go to your config.php and just after the

<?php

add this


define('DISABLE_HOOKS', true);

This disables all plugins on the site.

Then login to your ADMINCP and uninstall the product. Then just delete that line from config file and reupload it.

[Gene Steinberg]

any feedback is great - sorry abut this... go into phpmyadmin and find "datastore" delete the entry "pluginlist" ad then you can disable the product from there.


the \ are supposed to stop the errors.. i will double check but i think i've fixed it in this version..

I can't find such an entry in datastore. Where is it supposed to be. The forum is locked up tight after installing your new version. This was a bad move.

:(

[wingrider]

Back up and working (minus this plugin, unfortunately). Thanks to all for the help.

Don

[Gene Steinberg]

Back up and working (minus this plugin, unfortunately). Thanks to all for the help.

Don
Back up here too.

But the 1.2.2 version is toxic and I will not use this product until I know it works.

One more thing: Just listing the names of people whose emails are incorrect isn't sufficient for my purposes. There ought to be a way to move those members into a new category until that's resolved.

But first fix the database problem.

Peace,
Gene

[tirol07]

this hack defect :(
admincp and forumhome I not entry. Uninstalled.

[djbaxter]

One more thing: Just listing the names of people whose emails are incorrect isn't sufficient for my purposes. There ought to be a way to move those members into a new category until that's resolved.

Use the EZ Bounce Manager add-on. It works well in combination with this one.

[Gene Steinberg]

Use the EZ Bounce Manager add-on. It works well in combination with this one.

I would find that -- where?

All I can find in 3.7 mod is something called Auto Bounce Messages Management, which doesn't work very well.

Peace,
Gene

[Barakat]

OOOooops ,,, while trying to browse who is online ....

Database error in vBulletin 3.7.2

Invalid SQL:

SELECT userid, username, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM user AS user
WHERE userid IN (083798','83799','83801);

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '','83799','83801)' at line 3
Error Number : 1064
Request Date : Monday, August 18th 2008 @ 07:28:39 AM
Error Date : Monday, August 18th 2008 @ 07:28:39 AM
Script : http://www.*****.com/online.php
Referrer : http://www.*******.com/index.php
IP Address :********
Username : **********
Classname : vB_Database
MySQL Version : 5.0.37-standard-log

[hotpursuite]

This product is giving an error! 3.7.2 Harmonious.

[Silver740]

3.7.2 and this product messed up my site.

Had to do the config.php addition...go into admincp and uninstall the product.

BEWARE!

[C Braithwaite]

**Update 1.2.3**

I have updated this modification, fixing many of the mentioned bugs.
i have also fixed the plugin so it SHOULD NOT lock up your website!

Sorry for any problems people have had.

Edit - will someone confirm if the WOL page is fixed now?

[Megatr0n]

Have you tested this on your own site to ensure those same problems don't occur?

[C Braithwaite]

Have you tested this on your own site to ensure those same problems don't occur?

yeah i've tested using a 3.6.8 & 3.7.2 versions. i dont have the errors, but i have much much fewer users than some, and on my 3.7.2 site it's a fresh install which was done specifically for testing this mod, and i dont get ANY errors.

I take it that as there are no reports of problems that i have fixed a lot of them?

[RedTrinity]

I just updated to the latest copy to trial on a couple of test accounts of my own, and appears to be working well... however it is sending 4 copies of the reminder email to each one. There are 2 entries for each emailed member being listed in the log, so I am assuming its sending 2 copies for each?

Either way it should be just one log entry appearing, and one copy of the email being sent out to each member.

There is no recipient name being listed with the reminder email, its blank. Also basic HTML is not working (tried to use anchor links) which would be great if it worked otherwise :)

Hope this constructive feedback helps to iron out the bugs.

Cheers.

[C Braithwaite]

I just updated to the latest copy to trial on a couple of test accounts of my own, and appears to be working well... however it is sending 4 copies of the reminder email to each one. There are 2 entries for each emailed member being listed in the log, so I am assuming its sending 2 copies for each?

Either way it should be just one log entry appearing, and one copy of the email being sent out to each member.

There is no recipient name being listed with the reminder email, its blank. Also basic HTML is not working (tried to use anchor links) which would be great if it worked otherwise :)

Hope this constructive feedback helps to iron out the bugs.

Cheers.

This is fantastic feedback! It looks like im getting closer to the goal! I will look into this and try and resolve the issue straight away.

[Gene Steinberg]

I did get a few complaints of people getting multiple copies, and I see some duplicate listings in the logs, so perhaps there's something to test.

I've tried external bounce management products, one for 3.7, and the EZ one, which is supposed to work in 3.7, but is listed in the 3.6 folder.

Neither works, really. The latter is mostly non-functional, and the coder isn't responding to my post on the subject. The former is being distributed mostly unsupported.

Can you possibly build that feature into your product? I think it's the missing link, and the other options are failures. :(

Peace,
Gene

[yahoooh]

it send e-mail but not support unicode utf-8

[C Braithwaite]

I did get a few complaints of people getting multiple copies, and I see some duplicate listings in the logs, so perhaps there's something to test.

I've tried external bounce management products, one for 3.7, and the EZ one, which is supposed to work in 3.7, but is listed in the 3.6 folder.

Neither works, really. The latter is mostly non-functional, and the coder isn't responding to my post on the subject. The former is being distributed mostly unsupported.

Can you possibly build that feature into your product? I think it's the missing link, and the other options are failures. :(

Peace,
Gene

it send e-mail but not support unicode utf-8

can you both give me more details of requirements?

[Gene Steinberg]

can you both give me more details of requirements?
I'd like to see something that would, if a reminder message bounced, automatically send that user a PM to update his or her email address. If it happens a second time, the member is, in addition to getting another PM, automatically moved into another usergroup (Users Awaiting Email Confirmation or whatever group you create or select).

I'm assuming here that some users would return even without the inactive message and thus see they have to update their email addresses.

This may entail a bit of work, but in terms of running a forum efficiently and keeping members up to date, it would work beautifully. It may, in further consideration, be done as a separate product, to help with a general housecleaning of a forum, in which case any bounced email to a member would trigger it.

As I said, no existing product gets the job done efficiently -- or at all.

Peace,
Gene

[C Braithwaite]

I will seriously consider doing this. As a separate project or addition to this one i expect... i expect. For the time being i will work on removing all of the bugs in this mod.

[Gene Steinberg]

I will seriously consider doing this. As a separate project or addition to this one i expect... i expect. For the time being i will work on removing all of the bugs in this mod.
Thanks. Meantime, I'll bumble along. That's what I do best. :)

Peace,
Gene

[Megatr0n]

Does this update fix all the bugs reported in GamerGirl27's post?

[grahamsmythe]

I just downloaded this update, and although the documentation shows it's version 1.2.4, version 1.2.2 is actually posted.

As far as I can make out, version 1.2.2 doesn't give you the option to change the email address of who the reminder came from

Nice product though!

[Gene Steinberg]

I just downloaded this update, and although the documentation shows it's version 1.2.4, version 1.2.2 is actually posted.

As far as I can make out, version 1.2.2 doesn't give you the option to change the email address of who the reminder came from

Nice product though!
I noticed the same thing.

Something missing here?

Peace,
Gene

[Gene Steinberg]

One more thing: Not having the predefined From address as a setting, it uses "nobody" on my server. I do have the Webmaster email set in the standard vBulletin Admin CP options.

Peace,
Gene

[C Braithwaite]

Does this update fix all the bugs reported in GamerGirl27's post?
I have been through the code and done several tests, and after doing some research i have come to the conclusion that it's down to larger forums and the mailqueue locking. as noted above, locking should be enabled if any issues are encountered.
I just downloaded this update, and although the documentation shows it's version 1.2.4, version 1.2.2 is actually posted.

As far as I can make out, version 1.2.2 doesn't give you the option to change the email address of who the reminder came from

Nice product though!
ignore the 1.2.2. i forgot to update that on the product. the code has changed.

One more thing: Not having the predefined From address as a setting, it uses "nobody" on my server. I do have the Webmaster email set in the standard vBulletin Admin CP options.

Peace,
Gene
You must set a from email address. this is required.

[RedTrinity]

You must set a from email address. this is required.

I just installed latest version (first as update, then as a new install) and can't seem to find what has changed, the options page looks the same as before? :confused: Also unable to locate where to add the email address...

Otherwise, I look forward to trying it out.

[Megatr0n]

Yeah, where do you add the from address?

[djbaxter]

Use the EZ Bounce Manager add-on. It works well in combination with this one.

I would find that -- where?

All I can find in 3.7 mod is something called Auto Bounce Messages Management, which doesn't work very well.

Peace,
Gene

Sorry - I was offline for a while. See https://vborg.vbsupport.ru/showthread.php?t=138884 - it's a vB 3.6x add-on but works well in my installation of 3.72 PL2.

With some add-ons, you need to edit the PHP file to add the EZ Bounce headers. Let me know if that's the case for you using the new version of this add-on but what you need to add will look something like this...

Find in product-remindermail.xml:

$headers = "MIME-Version: 1.0" . "\r\n";
$headers .= "Content-type: text/html; charset=iso-8859-1" . "\r\n";
$headers .= "To: $username <$email>" . "\r\n";
$headers .= "From: " . $vbulletin->options['bbtitle'] . " Reminder Service <" . $vbulletin->options['webmasteremail'] . ">" . "\r\n";

Add below:

$bounceurl = $vbulletin->options['ezb_admincpurl'] . "/ezbounce.php?u=" . $userid;
$bouncestring = "<a href=\"$bounceurl\" target=\"_blank\">$bounceurl</a>";
$headers .= 'X-EZbouncer: ' . $bouncestring . $delimiter;

Save and then reinstall the product from your Admin CP, using overwrite.

[Gene Steinberg]

Sorry - I was offline for a while. See https://vborg.vbsupport.ru/showthread.php?t=138884 - it's a vB 3.6x add-on but works well in my installation of 3.72 PL2.

With some add-ons, you need to edit the PHP file to add the EZ Bounce headers. Let me know if that's the case for you using the new version of this add-on but what you need to add will look something like this...

Find in product-remindermail.xml:

$headers = "MIME-Version: 1.0" . "\r\n";
$headers .= "Content-type: text/html; charset=iso-8859-1" . "\r\n";
$headers .= "To: $username <$email>" . "\r\n";
$headers .= "From: " . $vbulletin->options['bbtitle'] . " Reminder Service <" . $vbulletin->options['webmasteremail'] . ">" . "\r\n";

Add below:

$bounceurl = $vbulletin->options['ezb_admincpurl'] . "/ezbounce.php?u=" . $userid;
$bouncestring = "<a href=\"$bounceurl\" target=\"_blank\">$bounceurl</a>";
$headers .= 'X-EZbouncer: ' . $bouncestring . $delimiter;

Save and then reinstall the product from your Admin CP, using overwrite.
I hope that is it. I've had no luck getting a bounce-related plugin to function.

Peace,
Gene Steinberg

[Charlie98902]

Do I need to edit this to show my URL and forum team or does this do it automatically with the coding done?

The $forumtitle Team
<a href="$homeurl">$bbtitle</a></p>

Also I use a gmail account so will my message be said from nobody too?

[Gene Steinberg]

First of all, thanks a lot for the code suggestion: It worked like a charm and now the EZ Bounce header is fully functionally in the bounced messages.

One more thing: Maybe the coder of this plugin can add an option to activate EZ Bounce header support, so we don't have to manually edit the product each time it's updated.

Unless, of course, he comes up with a better idea -- and I still have hopes for that. :)

Peace,
Gene

[C Braithwaite]

Sorry - I was offline for a while. See https://vborg.vbsupport.ru/showthread.php?t=138884 - it's a vB 3.6x add-on but works well in my installation of 3.72 PL2.

With some add-ons, you need to edit the PHP file to add the EZ Bounce headers. Let me know if that's the case for you using the new version of this add-on but what you need to add will look something like this...

Find in product-remindermail.xml:

$headers = "MIME-Version: 1.0" . "\r\n";
$headers .= "Content-type: text/html; charset=iso-8859-1" . "\r\n";
$headers .= "To: $username <$email>" . "\r\n";
$headers .= "From: " . $vbulletin->options['bbtitle'] . " Reminder Service <" . $vbulletin->options['webmasteremail'] . ">" . "\r\n";

Add below:

$bounceurl = $vbulletin->options['ezb_admincpurl'] . "/ezbounce.php?u=" . $userid;
$bouncestring = "<a href=\"$bounceurl\" target=\"_blank\">$bounceurl</a>";
$headers .= 'X-EZbouncer: ' . $bouncestring . $delimiter;

Save and then reinstall the product from your Admin CP, using overwrite.

hey djbaxter - if you could help me outon thtis one. what is the variable name for the ezbouncer "enabled" option?

if you can get me that i will add it to the code so that it adds the headers if the ezbounce thingy is installed and enabled?

[C Braithwaite]

First of all, thanks a lot for the code suggestion: It worked like a charm and now the EZ Bounce header is fully functionally in the bounced messages.

One more thing: Maybe the coder of this plugin can add an option to activate EZ Bounce header support, so we don't have to manually edit the product each time it's updated.

Unless, of course, he comes up with a better idea -- and I still have hopes for that. :)

Peace,
Gene

for the moment i will add support for ezbounce. but once im happy with the workings of the inactive reminders i will start to add my own functionallity for bounced emails.

[C Braithwaite]

Figured it out (i think) without EzBounce im unable to test - will someone test for me and let me know?

[taxick]

Hmm, can i send a test email ?????? I can?t fine this options....

Will the mod crate a Scheduled Tasks???? I can?t see eny????

PS. Efter i updated my version to 1.2.5 I can see the "Email From" now..

When all come to all, im not sure the mod working on forum!

Sorry for my bad english

[dirtycrow]

Hmm, can i send a test email ?????? I can?t fine this options....

Will the mod crate a Scheduled Tasks???? I can?t see eny????

PS. Efter i updated my version to 1.2.5 I can see the "Email From" now..

When all come to all, im not sure the mod working on forum!

Sorry for my bad english
a Scheduled Task? i don't see one added either

[C Braithwaite]

Hmm, can i send a test email ?????? I can?t fine this options....

Will the mod crate a Scheduled Tasks???? I can?t see eny????

PS. Efter i updated my version to 1.2.5 I can see the "Email From" now..

When all come to all, im not sure the mod working on forum!

Sorry for my bad english

:) You can send the test email from the "Reports" page.

[C Braithwaite]

a Scheduled Task? i don't see one added either

no Scheduled Task

[taxick]

:) You can send the test email from the "Reports" page.

I have no options to do that on the Report page....

I have try to complety reinstall the hack agian.. Not work.

[teamgofast]

Warning: mail() [function.mail]: SMTP server response: 503 5.5.2 Need Rcpt command. in [path]\includes\init.php(293) : eval()'d code on line 129

Warning: mail() [function.mail]: SMTP server response: 503 5.5.2 Need Rcpt command. in [path]\includes\init.php(293) : eval()'d code on line 129

Warning: mail() [function.mail]: SMTP server response: 503 5.5.2 Need Rcpt command. in [path]\includes\init.php(293) : eval()'d code on line 129

any idea

[bhanuprasad1981]

Dear bhanu
\r\n\r\n

We miss you. Our website is not the same without you. Come back and join in the fun?
\r\n\r\n

Kindest Regards
\r\nThe Team\r\nmysite

i get email with this extra things "\r\n\r\n"how can i stop / change

[Gene Steinberg]

I have no options to do that on the Report page....

I have try to complety reinstall the hack agian.. Not work.
Nor do I, but version numbers are correct, and the other features, including support for EZ Bounce, are intact.

So?

Peace,
Gene

[Gene Steinberg]

for the moment i will add support for ezbounce. but once im happy with the workings of the inactive reminders i will start to add my own functionallity for bounced emails.
Excellent.

Peace,
Gene

[grahamsmythe]

A couple of things...

1. Where do I put the 'remindermail.php' file?

2. Why can't I put dynamic variables into the Message Title?

[taxick]

Nor do I, but version numbers are correct, and the other features, including support for EZ Bounce, are intact.

So?

Peace,
Gene

Im running 1.2.6! And have still have no options to send are test mail!

I have looked in the reports page, and there is no options to do it

Im rally dont now, is this plugins i working on my forum. I dont have eny way to test it

And whats is EZ Bounce????

[RedTrinity]

I just installed latest version (first as update, then as a new install) and can't seem to find what has changed, the options page looks the same as before? :confused: Also unable to locate where to add the email address...

Otherwise, I look forward to trying it out.

Bumping as I am still waiting for a response, much appreciated :)

[Gene Steinberg]

One bug I found in 1.2.6: It fails to recognize the "from" email address you've entered. Mail is going out with a "nobody" address. Yes, the proper address is entered in your product and in the regular places in the Admin CP.

Peace,
Gene

[C Braithwaite]

Nor do I, but version numbers are correct, and the other features, including support for EZ Bounce, are intact.

So?

Peace,
Gene

Sorry - i messed up with uploading the files.

A couple of things...

1. Where do I put the 'remindermail.php' file?

2. Why can't I put dynamic variables into the Message Title?

1. remindermail.php goes in your admincp folder
2. this is soemthing i have not considered - i will look into this and add it in for you. thanks for the suggestion.

Im running 1.2.6! And have still have no options to send are test mail!

I have looked in the reports page, and there is no options to do it

Im rally dont now, is this plugins i working on my forum. I dont have eny way to test it

And whats is EZ Bounce????

Sorry - as above, i messed up.

Bumping as I am still waiting for a response, much appreciated :)

"From Email" is loacated at the bottom of the settings. Just make sure you have the most up to date vversion.

One bug I found in 1.2.6: It fails to recognize the "from" email address you've entered. Mail is going out with a "nobody" address. Yes, the proper address is entered in your product and in the regular places in the Admin CP.

Peace,
Gene
That is quite correct. I am looking into this now. Thank you for your bug report.

[Gene Steinberg]

Dear bhanu
\r\n\r\n

We miss you. Our website is not the same without you. Come back and join in the fun?
\r\n\r\n

Kindest Regards
\r\nThe Team\r\nmysite


i get email with this extra things "\r\n\r\n"how can i stop / change
I sent a test email and had the same problem. Whoops! :(

Peace,
Gene

[RedTrinity]

"From Email" is loacated at the bottom of the settings. Just make sure you have the most up to date vversion.

Thanks, I just downloaded the latest one from today (with bounce management) and its now updated :)

I have one little request, any chance of html support with this product?

Otherwise, its coming along really well. Congrats!

Cheers :)

[RedTrinity]

Ok it is still sending 2 emails to each user, just thought I would let you know. Also just to expand on the previous report by Genesteinberg - the test emails are being sent from the specified email address on the options page, but the actual ones going out to users are still going out with no sender.

Cheers :)

[taxick]

I sent a test email and had the same problem. Whoops! :(

Peace,
Gene

This hack is gonne be good, but there is some bugs ind that now..

I have the same problem with \r\n\r\n

[C Braithwaite]

Thanks, I just downloaded the latest one from today (with bounce management) and its now updated :)

I have one little request, any chance of html support with this product?

Otherwise, its coming along really well. Congrats!

Cheers :)

It should send in HTML...

Ok it is still sending 2 emails to each user, just thought I would let you know. Also just to expand on the previous report by Genesteinberg - the test emails are being sent from the specified email address on the options page, but the actual ones going out to users are still going out with no sender.

Cheers :)

Have you tried "use mail queue? - yes, with locking"? or could you maybe disable the mailqueue and let me know if it still sends 2 emails?

This hack is gonne be good, but there is some bugs ind that now..

I have the same problem with \r\n\r\n


I'm going to get all the bugs removed. it's hard when i don't experience the bugs. :)

[Charlie98902]

Which files do I use? Screen below. It seems there is identical files now?

[mikelbeck]

I downloaded the latest version today (8/23) but it doesn't seem to include the EZBounce line in the header?

[Gene Steinberg]

OK, if this helps, here's a screen shot of a bounced email reminder.

You can see, here, exactly what the formatting problem looks like -- and it was sent by "nobody," despite correct configurations all around.

Peace,
Gene

[i156]

Installed easy and is working great for me.

[grahamsmythe]

1. remindermail.php goes in your admincp folder


How comes there's two 'remindermail.php' files in the package download?

[C Braithwaite]

OK, if this helps, here's a screen shot of a bounced email reminder.

You can see, here, exactly what the formatting problem looks like -- and it was sent by "nobody," despite correct configurations all around.

Peace,
Gene

That is a mess. could you post the headers?

How comes there's two 'remindermail.php' files in the package download?

i added two files by mistake. im updating the product soon.

[Gene Steinberg]

That is a mess. could you post the headers?



i added two files by mistake. im updating the product soon.
As you wish. This is a typical set of headers from these bounced messages, showing the formatting problem and the incorrect sender address (minus the recipient's email):

------ This is a copy of the message, including all the headers. ------

Return-path: <nobody@server.paracast.net>
Received: from nobody by server.paracast.net with local (Exim 4.69)
(envelope-from <nobody@server.paracast.net>)
id 1KWvAy-00007Z-FR
for <name deleted>; Sat, 23 Aug 2008 08:37:16 -0700
To:
Subject: We miss you!
X-PHP-Script: forum.theparacast.com/showthread.php for 68.204.201.64
MIME-Version: 1.0
Content-type: text/html; charset=iso-8859-1
To: A <name deleted>
From: The Paracast Discussion Forums Reminder Service <news@theparacast.com>
X-EZbouncer: <a href="http://forum.theparacast.com/admincp/ezbounce.php?u=155" target="_blank">http://forum.theparacast.com/admincp/ezbounce.php?u=155</a>
Message-Id: <E1KWvAy-00007Z-FR@server.paracast.net>
Sender: Nobody <nobody@server.paracast.net>
Date: Sat, 23 Aug 2008 08:37:16 -0700

Hello, A!\r\n\r\nWe\'ve noticed that you\'ve not been active on The Paracast Discussion Forums for quite some time now, and we miss you!\r\n \r\nCould we not tempt you back?\r\n\r\nIf you don\'t remember your password, you can request it here: http://forum.theparacast.com/login.php?do=lostpw\r\n\r\nWe hope to see you soon.\r\n\r\nKindest Regards\r\nGene and David\r\nThe Paracast Discussion Forums\r\nhttp://forum.theparacast.com

I look forward to the update.

Peace,
Gene

[mikelbeck]

i added two files by mistake. im updating the product soon.

Will it fix the missing EZBounce line in the header as well?

[C Braithwaite]

As you wish. This is a typical set of headers from these bounced messages, showing the formatting problem and the incorrect sender address (minus the recipient's email):



I look forward to the update.

Peace,
Gene

From what I have read while doing my research this "nobody" problem is actually the settings on your forum. This issue should be fixed if and when you upgrade to the latest version.

Will it fix the missing EZBounce line in the header as well?
Not as such - i've added my own automated real-time bounce management.

[Megatr0n]

Before I update is there suppose to be too reminder.php files? If not which, one do we delete?

[C Braithwaite]

Before I update is there suppose to be too reminder.php files? If not which, one do we delete?

there is only 1 in the new zip - delete all previous files.

Edit - please read the install instructions (posted above) carefully!

[RedTrinity]

It should send in HTML...

How about formatting of anchor tags - ie:

<a href="http://www.test.com.au">Click here to visit our site</a>

Into:

Click here to visit our site (http://www.test.com.au)

If that makes sense? This is not working at the moment, but would love to see it implemented as it makes emails a LOT cleaner!

Have you tried "use mail queue? - yes, with locking"? or could you maybe disable the mailqueue and let me know if it still sends 2 emails?

Yep I tried locking the mail queue, but 2 emails are still being sent out :)

Cheers :)

[Gene Steinberg]

there is only 1 in the new zip - delete all previous files.

Edit - please read the install instructions (posted above) carefully!
I uninstalled the previous version, removed EZ Bounce, and installed your new version.

First problem: I cannot get it to store the setting to move the bounced messages to the Bounced usergroup I created in two of my forums. In both cases, I could make it work with Users Awaiting Email Confirmation, which is not what I wanted.

Second, the formatting is still messed up:

Hello, Test User! We\'ve noticed that you\'ve not been active on Attack of the Rockoids Forums for quite some time now, and we miss you! Could we not tempt you back? If you don\'t remember your password, you can request it here: http://forum.rockoids.com/login.php?do=lostpw We hope to see you soon. Kindest Regards Gene Steinberg Attack of the Rockoids Forums http://forum.rockoids.com

In the above case, the actual message is correctly formatted with paragraph breaks and all.

Third, wouldn't it also be nice to automatically insert a PM in which the user was notified that their email bounced, as EZ Bounce does, and, at the same time, disable their privileges appropriately in the new usergroup (not receive email from people, etc.)?

It's getting there, though.

Peace,
Gene

[C Braithwaite]

I uninstalled the previous version, removed EZ Bounce, and installed your new version.

First problem: I cannot get it to store the setting to move the bounced messages to the Bounced usergroup I created in two of my forums. In both cases, I could make it work with Users Awaiting Email Confirmation, which is not what I wanted.

Second, the formatting is still messed up:



In the above case, the actual message is correctly formatted with paragraph breaks and all.

Third, wouldn't it also be nice to automatically insert a PM in which the user was notified that their email bounced, as EZ Bounce does, and, at the same time, disable their privileges appropriately in the new usergroup (not receive email from people, etc.)?

It's getting there, though.

Peace,
Gene
I will work on the formatting issue - thanks for the bug report.

I could add the option of sending a PM but you have to take into account that 1) the user has been inactive for a long time and 2) there is no way of letting the user know they have a new pm.

if anyone feels that it is a good idea then i will be happy to do so but do take these to points into consideration.

thanks for the suggestion all the same

[C Braithwaite]

I uninstalled the previous version, removed EZ Bounce, and installed your new version.

First problem: I cannot get it to store the setting to move the bounced messages to the Bounced usergroup I created in two of my forums. In both cases, I could make it work with Users Awaiting Email Confirmation, which is not what I wanted.

what version are you running where the settings dont store? are they pre 3.7 boards?

[Gene Steinberg]

what version are you running where the settings dont store? are they pre 3.7 boards?
All three forums are separate vBulletin 3.7.2P2 licenses, with basically the same mods and settings. And look and feel, for that matter, but they deal with different subject matter.

Peace,
Gene

[Gene Steinberg]

I will work on the formatting issue - thanks for the bug report.

I could add the option of sending a PM but you have to take into account that 1) the user has been inactive for a long time and 2) there is no way of letting the user know they have a new pm.

if anyone feels that it is a good idea then i will be happy to do so but do take these to points into consideration.

thanks for the suggestion all the same
I'm assuming, probably as EZ Bounce's author does, that the user with the invalid email address might eventually login and thus be notified that they need to update their email address. :)

Then again, I'm also hoping for a product that'll let you send mass PMs to a specific usergroup. The only thing I can find is a hack that does this directly to members you check in the member list, but that's not what I want to do.

Peace,
Gene

[Gene Steinberg]

And: does the report section notify you that bounced addresses are being appropriately moved? I installed your filter in cPanel and would love to test the thing. :)

Peace,
Gene

[Gene Steinberg]

One more thing:

Evidently it isn't recognizing the bounce email address, and thus the bounce handling isn't functional.

I did create a bounce email address for that domain, and configured the mail filter per your instructions.

Here's what I received this evening (at least the formatting is not as bad as it was previously):

------ This is a copy of the message, including all the headers. ------

Return-path: <nobody@server.paracast.net>
Received: from nobody by server.paracast.net with local (Exim 4.69)
(envelope-from <nobody@server.paracast.net>)
id 1KX5eR-0005wB-IA
for <email omitted>; Sat, 23 Aug 2008 19:48:23 -0700
To:
Subject: We miss you!
X-PHP-Script: forum.theparacast.com/showthread.php for 65.55.211.161
MIME-Version: 1.0
Content-type: text/html; charset=iso-8859-1
To: <email omitted>
From: The Paracast Discussion Forums Reminder Service <news@theparacast.com>
X-Remindermail-BounceId: 272
X-Remindermail-BounceSalt: :jC
Message-Id: <E1KX5eR-0005wB-IA@server.paracast.net>
Sender: Nobody <nobody@server.paracast.net>
Date: Sat, 23 Aug 2008 19:48:23 -0700


Hello, <name omitted>!

We\'ve noticed that you\'ve not been active on The Paracast Discussion Forums for quite some time now, and we miss you!

Could we not tempt you back?

If you don\'t remember your password, you can request it here: http://forum.theparacast.com/login.php?do=lostpw

We hope to see you soon.

Kindest Regards
Gene and David
The Paracast Discussion Forums
http://forum.theparacast.com

[C Braithwaite]

One more thing:

Evidently it isn't recognizing the bounce email address, and thus the bounce handling isn't functional.

I did create a bounce email address for that domain, and configured the mail filter per your instructions.

Here's what I received this evening (at least the formatting is not as bad as it was previously):

did you enable '-f'? this is very important.

[Gene Steinberg]

Yes. I double checked.

Peace,
Gene

[C Braithwaite]

Yes. I double checked.

Peace,
Gene

okay - i tihnk i have it. and i cant believe i missed this out. in the email options where you enabled the "-f" option, just above that there is a "Bounce Email Address". set this to your bounce email address.

[turbosatan]

edited as i made a silly mistake which i figured out straight after

[C Braithwaite]

edited as i made a silly mistake which i figured out straight after

let me know if it's working okay? i still cant understand why you are getting the \ in your message...

[turbosatan]

let me know if it's working okay? i still cant understand why you are getting the \ in your message...

it is working.

i had uploaded one of the files to the incorrect directory.

it does seem to have sent all emails successfully now according to the logs. i would be interested in furtherreporting to show tyhe success rate of the email etc.

is there any way of coparing the list of emailed users with next weeks visitors?

[C Braithwaite]

it is working.

i had uploaded one of the files to the incorrect directory.

it does seem to have sent all emails successfully now according to the logs. i would be interested in furtherreporting to show tyhe success rate of the email etc.

is there any way of coparing the list of emailed users with next weeks visitors?

is it still sending emails with the \ backslash?

I do plan to update the statistics shown so you can see which users are returning, % effectiveness rate etc etc. i just need to plan how im going to do it so as not to put too many queries on each page.

[turbosatan]

is it still sending emails with the \ backslash?

I do plan to update the statistics shown so you can see which users are returning, % effectiveness rate etc etc. i just need to plan how im going to do it so as not to put too many queries on each page.

i think you may have me mixed up with someone else. i have never mentioned a backslash in any of my posts.

is there anything i can do to help get the additional reporting working?

[C Braithwaite]

i think you may have me mixed up with someone else. i have never mentioned a backslash in any of my posts.

is there anything i can do to help get the additional reporting working?

sorry, i did get mixed up lol


feel free to offer suggestions about the information that you might want to see displayed.

[turbosatan]

feel free to offer suggestions about the information that you might want to see displayed.

I would ideally like to see on the reporting page additional fields to show the following

same basic setup as now showing username valid email bounced etc.

i would also like to see a date when the person was last emailed and a flag of some sort if they have visited since.

also possibly a php file which manages the link in the email. so for instance you have www.myforum.com/reminderparser.php which tracks when someone clicks on the link in the email to come back to the forum.

there may be an easier way of doign this which i dont understand.

perhaps colour coding the usernames to indicate different states such as

to be emailed
been emailed but not returned
been emailed multiple times and not returned
been emailed and clicked through link but not posted
been emailed and clicked through link and posted
been emailed and returned byu other means and posted.

etc etc

basically gather as much info about how effective a specific email has been so different types of email can be tried. was i more successful when i just said please come back or was i more successful when i did a newsletter style email giving them more details about whats happening on the forum?

[Moparx]

I tried to send myself a test email and received a Database Error.
Database error in vBulletin 3.7.2:

Invalid SQL:
INSERT INTO vb3_remindermail_log (username,userid,dateline,validemail,email) VALUES ('Test User','0','1219592330','1','EMAILREMOVED');

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

The test Email still went through though.

[Gene Steinberg]

okay - i tihnk i have it. and i cant believe i missed this out. in the email options where you enabled the "-f" option, just above that there is a "Bounce Email Address". set this to your bounce email address.
I did. It just doesn't work.

One more thing: This is a confusing setup parameter. Your From email address in your own preference page shouldn't reflect the bounce email, but simply the one from which the reminder emanates. The bounce should always be regarded as the one set in the standard vBulletin settings under email.

Still getting the formatting crap. :(

Peace,
Gene

[C Braithwaite]

I tried to send myself a test email and received a Database Error.


The test Email still went through though.

which version of the mod are you using?

[RedPoint]

sorry Brithwaite,
i marked as uninstall - its for me to hard to make all the preinstall settings.

I need a addon/plugin that ist run over upload and install and not that i must sett files and more files to install that addon.

Regards and more success

[tekguru]

Posted to allow youto follow on from the other thread....

Okay just bitten the bullet and installed version 1.2.7 and hit two problems.

1) The product would not install into vB 3.7.2 PL2 until I adjusted the 'maxversion' to 3.7.3.

2) I have at the moment 33,378 users registered and the Mod decided that 29,727 users were inactive. This is with setting the inactive period to 90 days. That seems way too high a ratio?

[C Braithwaite]

sorry Brithwaite,
i marked as uninstall - its for me to hard to make all the preinstall settings.

I need a addon/plugin that ist run over upload and install and not that i must sett files and more files to install that addon.

Regards and more success

you can still use the mod without the settings, however you must be aware that the bouncing emails wont work. the inactive reminders still go out as normail

[C Braithwaite]

Posted to allow youto follow on from the other thread....

ive checked over the code and im quite sure everything is as it should be.

[tekguru]

1) Now upgraded to the correct version. Seems to be working but even with period of inactivity set to 60 days still getting 27275 inactive users. Could be right I guess.

Could I ask you to clarify how the options work together?

- Inactivity period is obvious :) (Set to 60 days for me)

- How many emails maximum to send to each inactive user per inactive period. (0 for unlimited) - does this mean that if set to 3 then a user will get maximum of 3 emails after being inactive for 60 days? Then another 3 if inactive for 120 days?

- After the first email, how long should the system wait before sending out subsequent emails? (Days) This I have set to 28, but if max emails is set as above then this would clash with the above?

So could you clarify how we should set it please?

2) As per attached is the Mod working incredibly quickly to send emails (and possibly travelling in time), or is the Users that have been sent the maximum number of emails count incorrect?

3) As per the attached there seems to be a spurious table (zero height) just above the test email box?

[tekguru]

More......

- The report page is getting incredibly long (understandable) - it might be an idea to paginate it and allow one to filter it based on bounced users only. Also to be able to erase the table - thinking of data storage sizes here.

- If one does not wish to use the bounce change usergroup feature how does one turn that facility off as it only lists the usergroups, there is not an option for 'none'.

[tekguru]

More 2 .....

1) The message to be sent specififes:

<p>Kindest Regards<br/>
The $forumtitle Team
<a href="$homeurl">$bbtitle</a></p>

But translates into (from looking at the test message):

Kindest Regards
The Team 4WinMobile.com


So it looks like the '$forumtitle' variable is not being parsed?

[djbaxter]

As you wish. This is a typical set of headers from these bounced messages, showing the formatting problem and the incorrect sender address (minus the recipient's email):



I look forward to the update.

Peace,
Gene

From what I have read while doing my research this "nobody" problem is actually the settings on your forum. This issue should be fixed if and when you upgrade to the latest version.

No, it's a server configuration issue. Generally, files sent by a PHP script are sent from nobody@domain.com unless you configure the server to do otherwise.


Not as such - i've added my own automated real-time bounce management.

I think this is a step backwards, to be blunt. EZ Bounce works on all email sent out by the forum, such as notifications, etc. It would be far better to have an option to specifiy the EZ Bounce headers, or even just to set them automatically if the admin indicates that EZ Bounce is installed.

Why reinvent the wheel? Especially when you're trying to reinvent only half the wheel...

More......

- The report page is getting incredibly long (understandable) - it might be an idea to paginate it and allow one to filter it based on bounced users only. Also to be able to erase the table - thinking of data storage sizes here.

That's why the email notifications are a much better idea... no logs to delete or edit.

[C Braithwaite]

- How many emails maximum to send to each inactive user per inactive period. (0 for unlimited) - does this mean that if set to 3 then a user will get maximum of 3 emails after being inactive for 60 days? Then another 3 if inactive for 120 days?

No, that would be 3 emails total. if the users comes back to the forum but then goes inactive again he would be sent another 3 emails. if he never came back then he would never receive another email.

- After the first email, how long should the system wait before sending out subsequent emails? (Days) This I have set to 28, but if max emails is set as above then this would clash with the above?

if you have 60 days set for activity then on day 60 an email will go out. 28 days later the second email will go out, and another 28 days after that the 3rd email would go out.

2) As per attached is the Mod working incredibly quickly to send emails (and possibly travelling in time), or is the Users that have been sent the maximum number of emails count incorrect?

the plugin does work fast, and you will initially get a very large mailqueue, however i think that perticular statistic may be wrong and will have to look into it.

3) As per the attached there seems to be a spurious table (zero height) just above the test email box?
that is very random, and again i will have to look into it. thanks for pointing this out to me though.
More......

- The report page is getting incredibly long (understandable) - it might be an idea to paginate it and allow one to filter it based on bounced users only. Also to be able to erase the table - thinking of data storage sizes here.

Good idea. Will add this.

- If one does not wish to use the bounce change usergroup feature how does one turn that facility off as it only lists the usergroups, there is not an option for 'none'.
good point. i will set an "enable group move" option.

More 2 .....

1) The message to be sent specififes:

<p>Kindest Regards<br/>
The $forumtitle Team
<a href="$homeurl">$bbtitle</a></p>

But translates into (from looking at the test message):



So it looks like the '$forumtitle' variable is not being parsed?
Correct. I need to fix this.

[C Braithwaite]

No, it's a server configuration issue. Generally, files sent by a PHP script are sent from nobody@domain.com unless you configure the server to do otherwise.

with sendmail you can specify -f to force a from address. im not saying its not server configuration, however in a lot of cases it can be fixed with -f

I think this is a step backwards, to be blunt. EZ Bounce works on all email sent out by the forum, such as notifications, etc. It would be far better to have an option to specifiy the EZ Bounce headers, or even just to set them automatically if the admin indicates that EZ Bounce is installed.

Why reinvent the wheel? Especially when you're trying to reinvent only half the wheel...

You have a valid point, and this is the very reason why for the next version the modification will handle ALL emails sent out. I realised this was the only way when one member mentioned he uninstalled ezbounce.

from what i understand, with ezbounce you have to manually click a link in each bounced email to modify the user? that's just a manual process with a shortcut in my eyes. my vision was pure automation, and on request i might add.

That's why the email notifications are a much better idea... no logs to delete or edit.
he would just get a giant email instead - i am working on ways to organise the data better.

[tekguru]

I too have uninstalled EZ Bounce as it was installed for me previously. If this Mod can replace that functionality automatically I'd be happy as it was a nightmare clicking on the bounce links.

A giant emial works for me unless detailled stats analysis is goignto be built into the Mod, if not the email is better as we can review and delete without the clogging of the database with unneeded data.

Cheers for clarifying the use of the settings, might be an idea to add this detail in the header of the Mod config page to that folks with poor memories like me will remember or of course for new users of the Mod :)

Glad me other bug reports and suggestions proves useful, look forward to the next version. In the interim if we want to clear the table built up what table do we need to empty?

[C Braithwaite]

I too have uninstalled EZ Bounce as it was installed for me previously. If this Mod can replace that functionality automatically I'd be happy as it was a nightmare clicking on the bounce links.

A giant emial works for me unless detailled stats analysis is goignto be built into the Mod, if not the email is better as we can review and delete without the clogging of the database with unneeded data.

Cheers for clarifying the use of the settings, might be an idea to add this detail in the header of the Mod config page to that folks with poor memories like me will remember or of course for new users of the Mod :)

Glad me other bug reports and suggestions proves useful, look forward to the next version. In the interim if we want to clear the table built up what table do we need to empty?

i actually have a version here sat on my hard drive that fully automates the bounce system. im just testing it as much as i can at the moment. i am going to be coding detailed stats and will also provide an email summery every day.

if the data stored is too large, you could set the days to keep the data to something small - currently it's for 1 month, but you could quite easily set it to 1 day (you could even set it to 0.25 or somemthing and it will clear every 6 hours!) or if you need to, there is a table called "remindermail_log" empty it.
i will add options to erase the database too.

im going to do a propper manual also..

[Moparx]

which version of the mod are you using?
1.2.7

[C Braithwaite]

1.2.7

it looks like the database was not set up properly on install. try un-installing the product and re-installing the product (as opposed to just overwriting). did you maybe upgrade from a previous version without uninstalling it first?

[Moparx]

it looks like the database was not set up properly on install. try un-installing the product and re-installing the product (as opposed to just overwriting). did you maybe upgrade from a previous version without uninstalling it first?

Hmm.. I believe I did just overwrite the product this last time around.
The problem has been fixed.

[Gene Steinberg]

Alas, that can also zero the counters, which means, alas, that people might get their reminder emails all over again before the interval, right?

Worse, my members are still getting multiple copies of these reminders, and they're getting pissed off.

Everything is set correctly. I double checked.

Peace,
Gene

[Moparx]

Alas, that can also zero the counters, which means, alas, that people might get their reminder emails all over again before the interval, right?

Worse, my members are still getting multiple copies of these reminders, and they're getting pissed off.

Everything is set correctly. I double checked.

Peace,
Gene
Yes, uninstalling clears everything so everyone will be sent emails once again.

[C Braithwaite]

Alas, that can also zero the counters, which means, alas, that people might get their reminder emails all over again before the interval, right?

Worse, my members are still getting multiple copies of these reminders, and they're getting pissed off.

Everything is set correctly. I double checked.

Peace,
Gene
have you tried maiqueue with table locking?

if you want to avoid sending emails out agian you need to run a query:
go to unixtimestamp.com and get the current time.
go into phpMyAdmin(if you cant do it from within vbulletin)
run query "UPDATE user SET reminder_emaildate = 'unix-timestamp-goes-here'" before you enable the product.

[Gene Steinberg]

have you tried maiqueue with table locking?

if you want to avoid sending emails out agian you need to run a query:
go to unixtimestamp.com and get the current time.
go into phpMyAdmin(if you cant do it from within vbulletin)
run query "UPDATE user SET reminder_emaildate = 'unix-timestamp-goes-here'" before you enable the product.
Table locking is enabled. All settings are enabled.

It's too late about the emails going out again. They did. Problem is that they go out over and over and over again, even if the intervals are correct. I've complained about this before.

This is not coming along too well, now is it. :(

Peace,
Gene

[Gene Steinberg]

I just got some more irate messages from our members. This has become a nightmare, and I've disabled your product on two of our forums. I will leave it going on a third, less-trafficked forum for the time being for testing, but won't deploy it again until this works reliably.

Now some of our members think we're just evil spammers. :(

Peace,
Gene

[C Braithwaite]

i really dont understand why you are having a problem - i cant re-create the problem. and i am trying. on my board(s) they stop exactly when they are supposed to..

[Gene Steinberg]

i really dont understand why you are having a problem - i cant re-create the problem. and i am trying. on my board(s) they stop exactly when they are supposed to..
If you want to help us with the third forum, at http://forum.rockoids.com, fine and dandy. Send me a PM and I'll give you administrator access and whatever you need to test it and see what's up.

Fair enough?

Meantime, I've had to make abject apologies to our members, and I hope that'll be that. :)

Peace,
Gene

[C Braithwaite]

If you want to help us with the third forum, at http://forum.rockoids.com, fine and dandy. Send me a PM and I'll give you administrator access and whatever you need to test it and see what's up.

Fair enough?

Meantime, I've had to make abject apologies to our members, and I hope that'll be that. :)

Peace,
Gene

What im going to do first is a little bit more testing. I've just installed this onto a more active board that i can access every area of to do my testing..

i will get back to you however if i think it may help.


blame it all on me.. ? you probably have! lol

[Gene Steinberg]

Well, we shared the blame. :)

Peace,
Gene

[RedTrinity]

i really dont understand why you are having a problem - i cant re-create the problem. and i am trying. on my board(s) they stop exactly when they are supposed to..

Just FYI, I reported the same issue a few pages back:


Have you tried "use mail queue? - yes, with locking"? or could you maybe disable the mailqueue and let me know if it still sends 2 emails?

Yep I tried locking the mail queue, but 2 emails are still being sent out :)

It should send in HTML...

How about formatting of anchor tags - ie:

<a href="http://www.test.com.au">Click here to visit our site</a>

Into:

Click here to visit our site (http://www.test.com.au)

If that makes sense? This is not working at the moment, but would love to see it implemented as it makes emails a LOT cleaner!

Mail queue locking/disabling did not work for me either, its still sending multiple copies out. So its not an isolated issue happening.

Also it would be great if you were to consider my suggestion regarding anchor html formatting.

Cheers ;)

[C Braithwaite]

Just FYI, I reported the same issue a few pages back:



Mail queue locking/disabling did not work for me either, its still sending multiple copies out. So its not an isolated issue happening.

Also it would be great if you were to consider my suggestion regarding anchor html formatting.

Cheers ;)

hiya, yes i know you brought it to my attention. i am working on it.

[realmr]

does this add-on has an option to delete the un-confirmed users after x no. of days ?

[tekguru]

Well I left the Mod running overnight amd have had a number of complainst about duplicated messages, two users insisting I delete their accounts.

The log showed as attached, not sure if it helps at all...

[C Braithwaite]

does this add-on has an option to delete the un-confirmed users after x no. of days ?

you can have them moved to a usergroup of your choice..but not delete them.

[C Braithwaite]

Well I left the Mod running overnight amd have had a number of complainst about duplicated messages, two users insisting I delete their accounts.

The log showed as attached, not sure if it helps at all...

thanks. you should maybe delete that email as it contains email addresses.

what i need to find out is if the emails were sent out at the same time. do you have access to phpMyAdmin?

if so, could you open up the "remindermail_log" table and do a search on

"userid" and "dateline"

then post them here for me would you?

[djbaxter]

with sendmail you can specify -f to force a from address. im not saying its not server configuration, however in a lot of cases it can be fixed with -f

You have a valid point, and this is the very reason why for the next version the modification will handle ALL emails sent out. I realised this was the only way when one member mentioned he uninstalled ezbounce.

from what i understand, with ezbounce you have to manually click a link in each bounced email to modify the user? that's just a manual process with a shortcut in my eyes. my vision was pure automation, and on request i might add.

he would just get a giant email instead - i am working on ways to organise the data better.

An email is easier to delete.

The other thing is that automation of a system like EZ Bounce is also a bad idea. Many of the bouncebacks are not from invalid email addresses but from "mailbox full", "mailbox temporarily unavailable", and such. Those members shouldn't be bounced and for that reason I prefer to inspect the bouncebacks individually. This takes a while the first time or two after it's installed but basically after the first sweep through the member database it's only typically a few a week.

[tekguru]

thanks. you should maybe delete that email as it contains email addresses.

what i need to find out is if the emails were sent out at the same time. do you have access to phpMyAdmin?

if so, could you open up the "remindermail_log" table and do a search on

"userid" and "dateline"

then post them here for me would you?

Not a problem now deleted.

Also the search resulted in what you can see attached, hope this helps. Mod now disabled until this can be fixed.

I must admity I also second the EZ Bounce system for monitoring bounce backs unless it can be made intelligent of course.

[C Braithwaite]

Not a problem now deleted.

Also the search resulted in what you can see attached, hope this helps. Mod now disabled until this can be fixed.

I must admity I also second the EZ Bounce system for monitoring bounce backs unless it can be made intelligent of course.

i'm sure this will help. thanks

I thought you said you would love an automation system as you found clicking on the links "a nightmare"?

[jlew24asu]

so is this mod good to go now? :)

[C Braithwaite]

so is this mod good to go now? :)

some people are having issues with sending multiple emails. I'm trying to figure out why.

[tekguru]

i'm sure this will help. thanks

I thought you said you would love an automation system as you found clicking on the links "a nightmare"?

Grin I did didn't ! ? :)

[C Braithwaite]

Grin I did didn't ! ? :)

don't worry though - i will come up with a solution for all.

[tekguru]

Good luck :)

[Gene Steinberg]

Good luck :)
Based on your latest version as of this writing, 1.2.8, the test email displays as follows:

Hello, Test User! We\'ve noticed that you\'ve not been active on Attack of the Rockoids Forums for quite some time now, and we miss you! Could we not tempt you back? If you don\'t remember your password, you can request it here: http://forum.rockoids.com/login.php?do=lostpw We hope to see you soon. Kindest Regards Gene Steinberg Attack of the Rockoids Forums http://forum.rockoids.com


Something is not yet fixed. :(

And it's still missing paragraph breaks.

Peace,
Gene

[Seb@]

every day new update of this

LOL

[Gene Steinberg]

OK, I got it to take the paragraph breaks, but the back slashes are still there. :(

Also, it still refuses to accept the setting for my bounce usergroup, and picks a different usergroup, seemingly at random. :(

Peace,
Gene

[nesta2006]

i think again you should update that!
remindermail.php this file now write on page!
empty!

[mikelbeck]

Well... this is mostly working.

It's sending out e-mails to inactive users.
It's showing that it's received bounced messages back from a few users.
But the users that were bounced weren't moved to the group that I specified.

Before you ask, yes, I have "Enable usergroup change" set to Yes and have specified "Users Awaiting Email Confirmation" as the "Move Bounced Usergroup". But the users who are shown as bounced are still in the "Registered Users" group.

[tekguru]

I'm also getting reports that users are receiving emails even though they have turned to off the option to receive emails from Admins.

[C Braithwaite]

every day new update of this


LOL
lots to fix

OK, I got it to take the paragraph breaks, but the back slashes are still there. :(

Also, it still refuses to accept the setting for my bounce usergroup, and picks a different usergroup, seemingly at random. :(

Peace,
Gene
what versions of vbulletin are you using? i forgot to update the test email code. the rest is fine.

i think again you should update that!
remindermail.php this file now write on page!
empty!
did you update the xml file also?
Well... this is mostly working.

It's sending out e-mails to inactive users.
It's showing that it's received bounced messages back from a few users.
But the users that were bounced weren't moved to the group that I specified.

Before you ask, yes, I have "Enable usergroup change" set to Yes and have specified "Users Awaiting Email Confirmation" as the "Move Bounced Usergroup". But the users who are shown as bounced are still in the "Registered Users" group.

I'm also getting reports that users are receiving emails even though they have turned to off the option to receive emails from Admins.

ii will look into this.

[C Braithwaite]

I'm also getting reports that users are receiving emails even though they have turned to off the option to receive emails from Admins.

looking over my code, that should be impossible - EVERY single query that finds inactive users has "options & 16" in which means only users with option to recieve admin emails. are you sure the user isn't just being dumb - have you checkede their status in the admincp?

[tekguru]

Yep I'm afraid it is right, I checked the settings on the users concerned.

Also BIG problems after installing the new update. See attached, I've had to disable the Mod again as if activated it takes the site offline :(

[C Braithwaite]

Yep I'm afraid it is right, I checked the settings on the users concerned.

Also BIG problems after installing the new update. See attached, I've had to disable the Mod again as if activated it takes the site offline :(

Sorry i just found an error in the install code. im updating the zip straight away

[C Braithwaite]

Sorry i just found an error in the install code. im updating the zip straight away

uploaded fix. i forgot to prefix tables.

[tekguru]

Okay that seems to have resolved that issue (cheers for that).

0.70 / 0.45) even though the Mod reports that 0 people are to be contacted. Number of users set to be processed per cycle is set to 3.

On disabling the Mod the server load has once more dropped to normal levels.

[C Braithwaite]

Okay that seems to have resolved that issue (cheers for that).

0.70 / 0.45) even though the Mod reports that 0 people are to be contacted. Number of users set to be processed per cycle is set to 3.

On disabling the Mod the server load has once more dropped to normal levels.

did you miss out half a post there?

[tekguru]

vB ate it (honest), yep I was saying (or trying to) that server loads had increased to 3.03 / 1.80 once the mod was activated but drops back to the usual 0.70 / 0.45 figure if disabled.

[C Braithwaite]

vB ate it (honest), yep I was saying (or trying to) that server loads had increased to 3.03 / 1.80 once the mod was activated but drops back to the usual 0.70 / 0.45 figure if disabled.

i imagine that it will increase the load especially to begin with - think about all the checking and emailing going out?

[tekguru]

Yes, but......

1) The prior incarnations load was not as high

2) I reports there are no emails to send out?

[jellybaby]

What should the top line on the stats say, mine is blank above Emails sent!

Thanks

[i156]

When I installed it seemed to work but then I noticed I got a lot of emails to a few of my own accounts and now a lot of people have complained about getting so many emails.

My settings were:
3 users per cycle
31 days inactive
2 max mails (it seems this didn't actually apply?)
7 days between subsequent emails
inactivity based on last post no
only on registered users
reports on for 31 days

I've turned it off for now for fear of pissing off more of my members but I'd really like to get this working as I think its a great feature.

[C Braithwaite]

When I installed it seemed to work but then I noticed I got a lot of emails to a few of my own accounts and now a lot of people have complained about getting so many emails.

My settings were:
3 users per cycle
31 days inactive
2 max mails (it seems this didn't actually apply?)
7 days between subsequent emails
inactivity based on last post no
only on registered users
reports on for 31 days

I've turned it off for now for fear of pissing off more of my members but I'd really like to get this working as I think its a great feature.

Do the "Sent Emails" show that multiple emails have gone out?
Also - do you have a large board (how many members?) and if so have you enabled locking on your mailqueue system?

[RedTrinity]

Also - do you have a large board (how many members?) and if so have you enabled locking on your mailqueue system?

I didn't mentioned it earlier but with the multiple emails issue, last time I tested this plugin, I was only emailing reminders out to a total of 2 members (test accounts with my own email addresses) even though our board has just over 1,000 members total.

I don't know whether the "large forum" issue (if you would classify ours as one with that many members - I don't know what number is considered large) affects the plugin in general, or only if its a large number of those members being emailed, but thought it worth a mention in case this info is helpful.

[i156]

I've got around 3500 members. I just put the report into excel and sorted by email and I do notice a lot of people that got multiples. But some are like two or three and then some have gotten like 10-20 of them.

The current stats shows 0 for everything.

[C Braithwaite]

This multiple emails issue is really annoying me.

I have uploaded the latest version, but in DEBUG MODE (ie, it doesnt send out emails, but does everything else). This file will generate a log file with lots of information for me to have a look at.
Can the people that are having problems with multiple emails being sent out, download, uninstall the old one and install this version.
just set yor settings as normal, and send me a PM to let me know you have installed it, and the URL of your forum.

[Gene Steinberg]

This multiple emails issue is really annoying me.

I have uploaded the latest version, but in DEBUG MODE (ie, it doesnt send out emails, but does everything else). This file will generate a log file with lots of information for me to have a look at.
Can the people that are having problems with multiple emails being sent out, download, uninstall the old one and install this version.
just set yor settings as normal, and send me a PM to let me know you have installed it, and the URL of your forum.
Per my PM, I'm getting a database error with the debug version installed, so I've since disabled it.

Check my PM for the particulars.

Peace,
Gene

[C Braithwaite]

Per my PM, I'm getting a database error with the debug version installed, so I've since disabled it.

Check my PM for the particulars.

Peace,
Gene

Cheers - the directory neds to be writable for me to be able to output a log file. are you able to do this?

[yahoooh]

i disable it and wait for fix this big error :

when your hack is enabled

the photopost classifieds will give intrnal server error 500 for any user visit the classifieds
but if he is not logged and visit the classifieds as unregistered user ,the classifieds works

i disable the product and wait for the fix

thanks

[Gene Steinberg]

This multiple emails issue is really annoying me.

I have uploaded the latest version, but in DEBUG MODE (ie, it doesnt send out emails, but does everything else). This file will generate a log file with lots of information for me to have a look at.
Can the people that are having problems with multiple emails being sent out, download, uninstall the old one and install this version.
just set yor settings as normal, and send me a PM to let me know you have installed it, and the URL of your forum.
I got it working now.

First problem: Text encoding is still off.

So:

Dear Test User

We miss you. Our website is not the same without you. Come back and join in the fun?

Kindest Regards The Team Attack of the Rockoids Forums <\"http://www.rockoids.com\">



This is a fresh install, since I deleted the older version, including the product, before installing the new one.

Peace,
Gene

[Brandon Sheley]

another update and nothing changed :(
I swear I have to click that "update" tag every other day, to make it just show installed.. :p

[C Braithwaite]

i disable it and wait for fix this big error :

when your hack is enabled

the photopost classifieds will give intrnal server error 500 for any user visit the classifieds
but if he is not logged and visit the classifieds as unregistered user ,the classifieds works

i disable the product and wait for the fix

thanks

what is the server log saying?

[C Braithwaite]

I got it working now.

First problem: Text encoding is still off.

So:



This is a fresh install, since I deleted the older version, including the product, before installing the new one.

Peace,
Gene

Looking at the log file that is generated, it doesn't look like it's sending to multiple users...

when you say the text encoding, do you mean when you send from the admin CP? i have not yet updated that code, however, the emails that are sent to users is fixed. i will do the admin test email next.

[Gene Steinberg]

Looking at the log file that is generated, it doesn't look like it's sending to multiple users...

when you say the text encoding, do you mean when you send from the admin CP? i have not yet updated that code, however, the emails that are sent to users is fixed. i will do the admin test email next.
Yes, a test email.

The other problem is that it won't save the Bounced usergroup I created for it. It moves to a different usergroup, say two or three down.

Peace,
Gene

[C Braithwaite]

Yes, a test email.

The other problem is that it won't save the Bounced usergroup I created for it. It moves to a different usergroup, say two or three down.

Peace,
Gene

that is most bizarre i will look into that. are you using vbulleitn 3.7x?

[jlew24asu]

very excited for this to finally work :)

[Gene Steinberg]

Yes, I have 3.7.3.

Peace,
Gene

[C Braithwaite]

Yes, I have 3.7.3.

Peace,
Gene

ok

it will just be an error in the displaying of the groups. if you select your groups and then hit save it will store them as that.

[hotpursuite]

Thank You!

[j1mmy]

It appears to have some copyright text at the bottom saysing Inactive reminders designed by X...

Now, because I have a customer theme, this text is showing itself right at the bottom and spoiling the custom theme's footer appearance. IS there anyway to put this text with the other copyright notices above it?

[jlew24asu]

so I'm having trouble following this thread. does this hack work or not?

[Gene Steinberg]

ok

it will just be an error in the displaying of the groups. if you select your groups and then hit save it will store them as that.
That being the case, I set it for the usergroup I wanted and ignored what it displayed. Hopefully this will be fixed.

Peace,
Gene

[Charlie98902]

so I'm having trouble following this thread. does this hack work or not?

It works just fine.

[siriuxs]

Please help me.. when I have activate the plugin, my forum is down:

Database error in vBulletin 3.7.2:

Invalid SQL:
INSERT INTO vb_remindermail_log (username,userid,dateline,validemail,email) VALUES ('@83','738','1220171913','1','nigeriano83@msn.com ');

MySQL Error : Unknown column 'validemail' in 'field list'
Error Number : 1054
Request Date : Sunday, August 31st 2008 @ 10:38:33 AM
Error Date : Sunday, August 31st 2008 @ 10:38:33 AM
Script : http://www.pchs.it/forums/iscrizione-tornei/2034-risultati.html
Referrer :
IP Address : 74.6.18.237
Username :
Classname : vB_Database
MySQL Version :


Please help me..

[C Braithwaite]

it looks like the plugin hasn't been installed properly.

uninstall and then re-install the latest version.

[AWF]

i want to download this but... which zip file do i download? there are 3 of them!

[C Braithwaite]

1.2.8

[Masiello]

This product don't works with vBSEO 3.2 and vBulletin 3.7.3 :(

[RedTrinity]

This product don't works with vBSEO 3.2 and vBulletin 3.7.3 :(

I have it currently installed on 3.7.3 and its working fine.

[C Braithwaite]

This product don't works with vBSEO 3.2 and vBulletin 3.7.3 :(

i think you mean vbseo doesn't work on 3.7.3 - this product works fine ;)

.. there is obviously a conflict between the two, but if i can get more information on the error (such as error messages and variables passed to cause the errors) i may be able to find a solution..

[Masiello]

I have it currently installed on 3.7.3 and its working fine.
Have you vBSEO 3.2 installed too?

[Masiello]

i think you mean vbseo doesn't work on 3.7.3 - this product works fine ;)

.. there is obviously a conflict between the two, but if i can get more information on the error (such as error messages and variables passed to cause the errors) i may be able to find a solution..
thx, anyway I try to ask on vBSEO forums

[Chris B]

My install of this is sending new members the email, does the current version fix this?

[C Braithwaite]

My install of this is sending new members the email, does the current version fix this?
which version are you using?

[jlew24asu]

It works just fine.

lol really? every other post is a reported problem.

[Chris B]

which version are you using?

1.1.3

[C Braithwaite]

lol really? every other post is a reported problem.
all of which i have either fixed or working to fix..
1.1.3
yes, it does fix that problem.

[Megatr0n]

When is the next update coming up to fix the multiple e-mails going out?

[C Braithwaite]

When is the next update coming up to fix the multiple e-mails going out?

i do have some code that i am testing, so far there have been no duplicate emails. if you have had a problem with multiple emails and wish to help, see the post above with the attachment (and set your forum directory to 0777)

[RedTrinity]

lol really? every other post is a reported problem.

Obviously you haven't tried out the latest version since all these bugs were FIXED ;)

When is the next update coming up to fix the multiple e-mails going out?

This problem subsided for me with the latest version also.

Great work C Braithwaite :)

[C Braithwaite]

Obviously you haven't tried out the latest version since all these bugs were FIXED ;)



This problem subsided for me with the latest version also.

Great work C Braithwaite :)

Thank you :up:

[Megatr0n]

Obviously you haven't tried out the latest version since all these bugs were FIXED ;)



This problem subsided for me with the latest version also.

Great work C Braithwaite :)

Which, latest version?

[jlew24asu]

Obviously you haven't tried out the latest version since all these bugs were FIXED ;)



This problem subsided for me with the latest version also.

Great work C Braithwaite :)

I have. :) I am having trouble with the instructions but thats more on me. but I agree, Braithwaite, you've done a great job with this hack. thank you very much.

[Vinyljunky]

Installed EZBounce version

Thanks :up:

[tpearl5]

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]

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]

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?
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]

After updating to vB 3.3.3PL1 this morning (which may be co-incidence) I got the following SQL error:

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]

After updating to vB 3.3.3PL1 this morning (which may be co-incidence) I got the following SQL error:

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]

Can you advise what it is so we can fix manually please?

[C Braithwaite]

Can you advise what it is so we can fix manually please?

open up your plugins, find the one "Update Current User"

find
SET usergroup = reminder_oldgroup
change to
SET usergroupid = reminder_oldgroup

[tekguru]

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:

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]

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:

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]

Cheers thanks!

[fly]

I use Google Mail for Domains. Is there any way to set EZBounce up with it?

[C Braithwaite]

I use Google Mail for Domains. Is there any way to set EZBounce up with it?

im not entirely against support for other mods in here, but in this case i dont even know the answer. i expect someone will.

[fly]

All you'd need (I'd think) would be a cron job that would check an external account for bounced emails.

(I say that like I could do it, lol)

[needtheend]

I use Vbulletin 3.7.3 PL1 and VBSEO 3.2.0

when i installed the reminder plugin i have lots of error mesaages bottom of the site so at the footer in AdminCP. The plugin and vb works (i think) but too many errors we have like that;

Warning: reset() [function.reset]: Passed variable is not an array or object in public_html/includes/functions_vbseo_seo.php on line 63

Warning: Invalid argument supplied for foreach() in includes/functions_vbseo_seo.php on line 64

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /home/mynode/mysite/htdocs/includes/functions_vbseo_url.php on line 420

Warning: strtr() [function.strtr]: The second argument is not an array. in includes/functions_vbseo_url.php on line 424

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /includes/functions_vbseo_url.php on line 420

Do you have any idea or solution to solve this problem?

[tpearl5]

<a href="http://www.vbseo.com/f2/vbseo-3-2-vb-3-7-3-email-reminder-26512/#post165677" target="_blank">http://www.vbseo.com/f2/vbseo-3-2-vb...12/#post165677</a>

[needtheend]

it doesnt solve the problem.
i did what they said. Now i have the same error in functions_vbseo_url.php in line 409

[dabuki]

I'm planning on turning this product on on my site but I would like to get some questions answered. My site is quite large and has been around for many years. This means there are many thousands of inactive users whom I'd like to contact. Is there any way of controlling this product so it only processes a set number of users every day. I left it on the default of 3 users per cycle but I can't see if there is a way to change how often a cycle is run.

[dfc005]

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:

I definitely have table locking enabled. And it's definitely sending out multiple emails. The only thing I can think is that the same query is being executed. My board is quite busy with a large user bases so pages would be getting hit all the time by many concurrent connections.

Looking forward to getting a new release, hopefully with a resolution. Really like the idea of the mod!

[trilljester]

Ouch, looks like this is a nice product, but doesn't work well with VBSEO. I wonder why that is? Isn't this just sending out emails via a cron job? Why would that foul up VBSEO?

[C Braithwaite]

I'm planning on turning this product on on my site but I would like to get some questions answered. My site is quite large and has been around for many years. This means there are many thousands of inactive users whom I'd like to contact. Is there any way of controlling this product so it only processes a set number of users every day. I left it on the default of 3 users per cycle but I can't see if there is a way to change how often a cycle is run.

em in the process of adding a delay between processing of users.. i can add a maximum per day also.

I definitely have table locking enabled. And it's definitely sending out multiple emails. The only thing I can think is that the same query is being executed. My board is quite busy with a large user bases so pages would be getting hit all the time by many concurrent connections.

Looking forward to getting a new release, hopefully with a resolution. Really like the idea of the mod!

hopefully this delay will help, but in my most recent version i have had no evidence of this during testing.

Ouch, looks like this is a nice product, but doesn't work well with VBSEO. I wonder why that is? Isn't this just sending out emails via a cron job? Why would that foul up VBSEO?

it doesnt use the cron - it is triggered on page load. i have no idea about vbseo, but i would be happy to alter code if somone could identify the exact error (i dont use vbseo so i can test). it could be something simple as a conflicting variable, but im sure all mine are prefixed...

[dfc005]

it doesnt use the cron - it is triggered on page load. i have no idea about vbseo, but i would be happy to alter code if somone could identify the exact error (i dont use vbseo so i can test). it could be something simple as a conflicting variable, but im sure all mine are prefixed...

I'm sure you've answered this before but what are the reasons behind going away from a cronjob and using on page load instead as the trigger?

[RedTrinity]

Just a suggestion for feature request, it would be great if the log was a bit more detailed - showing date/time that reminder emails were sent out at :)

[birdie]

I do not mind giving links back to the site of the developer of products I use on my forum,

BUT, why does this product show a link at the top of every post to users who are not logged in (eg search engines). The link says "Inactive Reminders By Icora Web Design".

This is overkill - how do I get rid of all but one of them. It looks silly and unprofessional.

Its happening with version 1.2.8. I am using 1.1.3 on another forum in which this does not happen.

[treyb]

The mod work great for me!

[Gersfan]

Working good so far, I've install 1.2.8 !

What about the EzBounce Email thing? Is it bult in? Do I need the mod kept installed or what?

EDIT: Ok I'm confussed, This morning i've checked my mail and I've got a good number of members with a bounced email address, that has been sent back to me. I've went into the mod on the AdminCP and no members have been moved into the group?

Thanks,

[j1mmy]

It appears to have some copyright text at the bottom saying Inactive reminders designed by X...

Now, because I have a custom theme, this text is showing itself right at the bottom below the coloured footer and spoiling the custom theme's footer appearance. Is there anyway to put this text with the other copyright notices above it - because that footer is expected to be the last of the page...

Thanks

[fly]

Has anyone mentioned that this doesn't validate as XHTML compliant?

[C Braithwaite]

I do not mind giving links back to the site of the developer of products I use on my forum,

BUT, why does this product show a link at the top of every post to users who are not logged in (eg search engines). The link says "Inactive Reminders By Icora Web Design".

This is overkill - how do I get rid of all but one of them. It looks silly and unprofessional.

Its happening with version 1.2.8. I am using 1.1.3 on another forum in which this does not happen.

It appears to have some copyright text at the bottom saying Inactive reminders designed by X...

Now, because I have a custom theme, this text is showing itself right at the bottom below the coloured footer and spoiling the custom theme's footer appearance. Is there anyway to put this text with the other copyright notices above it - because that footer is expected to be the last of the page...

Thanks

It is expected to be at the bottom - as a little credit to myself. i would prefer it on the site, but i wont make a fuss about it being removed. if you disable the (if i remember correctly as i dont have access to the plugin at this moment in time) the "Required" plugin, that should disable the link.

Has anyone mentioned that this doesn't validate as XHTML compliant?
thanks for pointing this out. but could you go into more detail?

[Megatr0n]

When will this hack be updated?

[fly]

thanks for pointing this out. but could you go into more detail?

http://validator.w3.org/

Assuming you have it running on your site, run it through that. Its the little tag that you've coded at the bottom of unlogged in pages...

[Gersfan]

It's not working for me, It's not boucning the members that have an invalid email. It's sending the message ok and bouncing it back to my email where i have to manualy click the EZbounce link!

[Griffoneur]

It doesn't appear to be sending out e-mails. It registers in the log but I fail to receive the "test e-mail". I have not set it up for bounced e-mails.

[farzana]

still in BETA.. full version??

[Replicators]

I have to say, the instructions at Add a email message filter
This is the hard part. You need to set up a filter that will 'pipe' an email sent to the above email address.
I am using Cpanel 11 and this is how i have mine set up:
Rules: 'To' 'Equals' 'bounce@icora.co.uk'
Actions: 'Pipe to program' with the setting: |/usr/local/bin/php /home/icora/public_html/forum/bounce.php
This will depend entirely on your settings and structure so you may have to do a little research. It would be very helfull if people who have to use diferent configurations would post them on here.Don't make any sense to me at all, whats the purpose of doing this? Is there a way you can dumb this down for people who don't know wth your talking about? Some websites may not have filtering, and tbh i have no idea what you mean by "pipe".

EDIT: ok i see what it does which is awfully handy, but i wouldn't know how to set up the pipe or w/e, i am using 1and1.com webhosting and there is no options of filtering or w/e.

[bhanuprasad1981]

strange database error i get
"Database error in vBulletin 3.7.3:

Invalid SQL:
UPDATE remindermail_log SET bounced = '1', message = 'From MAILER-DAEMON Thu Oct 09 01:03:06 2008
Received: from mailnull by tube.xxxx.com with local (Exim 4.69)
id 1Knng2-00030v-TB
for xxx@xxxxx.org; Thu, 09 Oct 2008 01:03:06 -0400
X-Failed-Recipients: xxxx@xxxxx.com
Auto-Submitted: auto-replied
From: Mail Delivery System <Mailer-Daemon@xxx.xxxxx.com>
To: xxxxx@xxxxx.org
Subject: Mail delivery failed: returning message to sender
Message-Id: <E1Knng2-00030v-TB@xxxx.xxxxxx.com>
Date: Thu, 09 Oct 2008 01:03:06 -0400

This message was created automatically by mail delivery software.

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:

xxxxx@yahoo.com
SMTP error from remote mail server after end of data:
host d.mx.mail.yahoo.com [66.196.82.7]: 554 delivery error:
dd This user doesn\'t have a yahoo.com account (xxxxx@yahoo.com) [-5] - mta117.mail.re1.yahoo.com

------ This is a copy of the message, including all the headers. ------

Return-path: <xxxx@xxxxx.org>
Received: from nobody by xxx.xxxxx.com with local (Exim 4.69)
(envelope-from <xxxx@xxxxx.org>)
id 1KnmlJ-0002LR-MA
for xxxxx@yahoo.com; Thu, 09 Oct 2008 00:04:29 -0400
To: xxxxxx4@yahoo.com
Subject: Action Required to Activate Membership for Nokiaapps
X-PHP-Script: www.xxxxx.org/showthread.php for 61.247.222.53
From: \"Nokiaapps\" <xxxxxx@gmail.com>
Auto-Submitted: auto-generated
Message-ID: <20081009040310.7b2494904004@www.xxxxxx.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=\"ISO-8859-1\"
Content-Transfer-Encoding: 8bit
X-Priority: 3
X-Mailer: vBulletin Mail via PHP
X-Remindermail-BounceId: 6158
X-Remindermail-BounceSalt: WK>
Date: Thu, 09 Oct 2008 00:04:29 -0400"


please help:confused:

[Haqa]

Nice mod, very useful. Install Clicked and nominated!

H.

[juronx]

doesn't work with VBSEO...

Warning: strtr() [function.strtr]: The second argument is not an array in /home/hidden/domains/hidden.com/public_html/forum/includes/functions_vbseo_url.php on line 404

[yotsume]

When this is no longer beta I will think about installing this. I can not use beta anything on my site. So I will just keep an eye on it's development.

[Fungsten]

I noticed that the Banned users are checked to receive the email. Even if I uncheck it and Save it still remains as checked. Does anyone else have this problem?

[bhanuprasad1981]

any one replying to me :(

[AndyA]

The mod is working great but is there a way to stop it emailing me ( admin ) every day with reports ? Thanks.

[raubin]

Wicked mod mate, very quick and easy install.

Cheers Richie

[Hurricane]

Anyone have this running on a Plesk server? I can't seem to get the pipe working.

[saltedm8]

This mod is sending out a reminder email to even those that only signed up today ( that have not posted yet ) ??

I have checked all my settings and they are fine.. anyone else getting this ?.. cheers

[ikorolis]

Hey ask you something strange happent to me

before using this Email reminder for inactive users 1.1.3 and send to me report

now use yours script and i select send reports but nothing send how to see report

only options have 1.2.8 to see

Inactive Reminders

Settings
Stats
Send Test Email
Emails Sent
Purge Logs

What for all the reports?

[jluerken]

As soon as I set a group here:
Please Select Usergroups
Which usergroups do you want to monitor for inactivity?
I get an error message from vBSeo 3.2.0 on each admincp page:


Warning: reset(): Passed variable is not an array or object in /path/httpdocs/forum/includes/functions_vbseo_seo.php on line 63

Warning: Invalid argument supplied for foreach() in /path/httpdocs/forum/includes/functions_vbseo_seo.php on line 64

[neoxi]

thank you.. installed :)

[Haqa]

This is a really cool mod (Install clicked) and I'm hoping it's going to keep my userbase active!

However (don't you hate it when someone says that?) I discovered a tiny bug in the"Global Bounce Headers" plugin. If a user has an apostrophe (single quote) in their email address the SQL SELECT statement blows up during account creation.

The fix is to quote $toemail with mysql_real_escape_string. This is the fixed plugin:

if(preg_match("/Remindermail/i",$headers)){
$headers = str_replace('text/plain', 'text/html', $headers);
} else {
$result = $vbulletin->db->query_read("SELECT userid,salt FROM " . TABLE_PREFIX . "user WHERE email='" . mysql_real_escape_string($toemail) . "'");
$row = $vbulletin->db->fetch_array($result);
$userid = $row['userid'];
$salt = $row['salt'];
$headers .= "X-Remindermail-BounceId: $userid" . $delimiter;
$headers .= "X-Remindermail-BounceSalt: $salt" . $delimiter;
}

Love it to bits, thanks!

H.

[Fungsten]

I can't seem save the usergroups I want to send reminders out to. So, after I select which usergroups to send and click "save", it says "saved", then all the usergroups come up blank.

VB 3.7.4. It also didn't work with 3.7.3. TIA.

[dmknights]

***Installed***
Very useful. Thank you