Subscription Ending Alert

Ha!

Thank you, I saw this option moments after I ask the question... sorry for taking up your time.

D. Ashley

It is ok. May be it will be usefull for someone else.

hello Sergey, You answered my question regarding sending an alert to members when their subscription is ending. I set up an alert for 30, 15, and 2 days. I then set my subscription to end on Feb. 2nd but, I havent recieve any alert. (I checked my junk mail.)

Is there any way to test the end subscription alert?

D. Ashley

Did you configure cron?

http://docs.mintjoomla.com/en/emerald/emerald-quick-start/

I have used the cron section on the cpnael for mey server to enter: wget http://4thfrodshamscouts.org.uk/index.php?option=com_emerald& ;task=emcron.send_expire_alerts&secret=XXXXX

where XXXX has ben replaced wiht the secret word set in emerald and set it to run twice per day.

I configured the plans to issue alerts 28,14,7 1 days before expiry

I also configured a test subscription which should have generated an alert email but I am not getting any alerts.

I set the cpanel to send me an email when the cron job is run but am not getting notification that it is being run.

What am I doing wrong?

Rather that having to go to my cPanel to setup the cron job, could you not provide a php file which generates and runs the cron job once itself based on the parameters set in. When I used Acyba subscriptions I did not have to create a cron job the component did it all.

Sergey,

I folllowed your instruction to set up a cron. I use EasyCron to run this script: http://www.womenabout.org/cms/wab2.5/index.php?option=com_emerald& ;task=emcron.send_expire_alerts&secret=[mysecret word here]

This is the log oputput from the cron: HTTP/1.1 200 OK Date: Thu, 05 Feb 2015 21:08:57 GMT Server: Apache X-Powered-By: PHP/5.3.28 Set-Cookie: 2b8a6a5b53fbc4d496b8476291111bbf=3b793bb2be041c9a2cd476def67ae1d9; path=/; HttpOnly Set-Cookie: jsn_mobilize_site=deleted; expires=Thu, 01-Jan-1970 00:00:01 GMT; path=/cms/wab2.5/ Set-Cookie: jsn_mobilize_site=deleted; expires=Thu, 01-Jan-1970 00:00:01 GMT; path=/cms/wab2.5/ Content-Length: 0 Content-Type: text/html

I set my alerts 30, 15, 5. I end one of my subscription to end in 5 days, but I have not received any alert.

Thanks, D. Ashley

chambersc I configured the plans to issue alerts 28,14,7 1 days before expiry

28,14,7 1 or 28,14,7,1? Whet is 7 1 with whitespace in between?

If you just open this url in browser what do you get?

 http://4thfrodshamscouts.org.uk/index.php?option=com_emerald& ;task=emcron.send_expire_alerts&secret=XXXXX

Of course you change xxx to your password. ANd turn Joomla global configuration for error reporting to max before you test.

zanni I set my alerts 30, 15, 5.

With white spaces?

When I add this to browser URL: http://4thfrodshamscouts.org.uk/index.php?option=com_emerald& ;task=emcron.send_expire_alerts&secret=hamburger

With global set to max. I get the message below. "Secret code is wrong. Add secret word in Emerald global config and add &secret=secretword to URL".

The secret word is correct.

D. Ashley

Zanni you need your own web link not mine :-)

http://4thfrodshamscouts.org.uk/index.php?option=com_emerald& ;task=emcron.send_expire_alerts&secret=xxxx where xxx is my secret word I get a white page displayed with debug enabled and maximum error reporting on

PS. if I put the wrong secret wortd in I get Secret code is wrong. Add secret word in Emerald global config and add &secret=secretword to URL. so I know error reporting is working.

All other emails generated by other joomla components are working fine.

I have turned error reporting off again

Zanni you need your own web link not mine :-)

Yes, That is quite funny. :-) As I mentioned, I did use my own link the first time: http://www.womenabout.org/cms/wab2.5/index.php?option=com_emerald& ;task=emcron.send_expire_alerts&secret=hamburger. Nothing happened. Also, should I add white space to the alert dates. I'm not sure if thats what you're telling me to do.

Still, the script is not working.

D. Ashley

If I access your URL there is no wrong secret error. That is gone. how do you know it is not working. Do you have error reporting turned max in global Joomla configuration?

Hi,

I do have the error reporting set to maximun in Global Config.

I run the script and I'm getting nothing, just a blank screen. When I run I run the script at EasyCron.com, the log give this detail: HTTP/1.1 200 OK Date: Mon, 09 Feb 2015 19:31:43 GMT Server: Apache X-Powered-By: PHP/5.3.28 Set-Cookie: 2b8a6a5b53fbc4d496b8476291111bbf=a133693416d6756924539147062edc63; path=/; HttpOnly Set-Cookie: jsn_mobilize_site=deleted; expires=Thu, 01-Jan-1970 00:00:01 GMT; path=/cms/wab2.5/ Set-Cookie: jsn_mobilize_site=deleted; expires=Thu, 01-Jan-1970 00:00:01 GMT; path=/cms/wab2.5/ Content-Length: 0 Content-Type: text/html

In addition, the subscriptions that I have expiring in the time frame for alerts are not being processed. I am not getting any email of pending expiration.

Again, should I add white space to the alert dates. I'm not sure if thats what you're telling me to do.

D. Ashley

The alert system is just not working on my Joomla 3x. However, on my older Joomla site using Mighty Mbership (with no cron script) the alerts are processing just fine.

I really need help figuring this issue out.

D. Ashley

Give me admin access to your site I will check.

I sent the admin access via private message.

Hi,

I see that some one has been working on the alert cron. \n\nBut I haven't heard anything back about successfully running, or not, of the script.

D. Ashley

OK, I fixed it.

Sergey OK, I fixed it.

Hi Sergey,

Thank you for fixing the problem. I don't want to take too much of your time. But, could you tell me, briefly, what you had to do to fix the problem?

I'd like to know for the future.

Again, thank you. D. Ashley

Before last send date in DB was stored as NULL and SQL condition used IS NULL to get un-notified subscritpion. But DB has changed and now default value is 0000-00-00 00:00:00 so I had to add another condition.