CBSubs Mailer Issue

Kyle,

Perfect! Seems to be generating the emails now. Thanks!

Hey. One other questions. I am trying to send a 60 day renewal reminder. All my expiration dates are forced to the first of every month. Since I missed the "60 Days Before" Expiration Date for June 1, 2013, I can seem to figure out how to set the date condition for this to generate the emails. I did not have a problem with the 30 days. It's when you get over 5 weeks where the date conditions are not as granular and forces months. How do I configure the dates?

Thanks,
Joe

You're wanting to send the expiration notice even though the user has passed the expiration notice window? For example you've set it to send the notice 60 days before expiring, but they're past that window and you want to force it to send anyway? Please clarify as don't fully understand what you're wanting.

Kyle,

You are correct. Here's what we do. During registration, I automatically set the sign-up day to the first of the month. So when the registration completes processing, I have an expiration date on the first of the month. I have 3 renewal notices, 30, 60 and Expiration. 30 sends 1 month before, 60 2 months before and expiration at expiration date. These all run by cron. All the crons are set to run on the 1st of the month. If for any unexplained reason, I miss sending these message, I want them to still run up to 2 weeks after. Here's how I have 60 day configured:

1. Automatically Send: 2 months before
2. Relative date: Subscription's Expiry Date
3. Plans Condition applies: Set to 5 of my Plans
4. State: Active
5. Do not send message if it's later than: 1 month and 15 days before
6. Max in total: 0
7. Max per customer: 0

So based on this configuration, I should see it email all folks with a expiration date of June 1, 2013. I keep coming up with 0 records.

However, I just noticed as I was typing this message that an error message is on the mailers screen when I close the second tab opened by the mailer processor. The error is as follows:

Missing private xml method ajaxversioncheck

This is happening with the mailers that work and does not seem to be affecting the mailer processing. It did run all the CB checks from the tools menu and it does not find any issue. Sorry for the long winded message!

Thanks,
Joe

krileon wrote: I've repaired your _assets database table and appears to be working fine now. The reason this happens is on J2.5 when migrating from J1.5 you end up with rows in _assets that have a parent of 0, but only row with id of 1 should be 0 and all others at the least be 1; I've corrected the other 0 parent rows and the error appears to be gone. Please test and confirm is working fine for you now.

how did you repair it?> just by using the "repair" tool in phpmyadmin? I'm having same issue

ThePiston wrote:

krileon wrote: I've repaired your _assets database table and appears to be working fine now. The reason this happens is on J2.5 when migrating from J1.5 you end up with rows in _assets that have a parent of 0, but only row with id of 1 should be 0 and all others at the least be 1; I've corrected the other 0 parent rows and the error appears to be gone. Please test and confirm is working fine for you now.

how did you repair it?> just by using the "repair" tool in phpmyadmin? I'm having same issue

Please read my 2 replies below to this topic as I've detailed how to fix this as well as what I did to fix it.

www.joomlapolis.com/forum/153-professional-member-support/220539-cbsubs-mailer-issue?start=6#224452

www.joomlapolis.com/forum/153-professional-member-support/220539-cbsubs-mailer-issue?start=6#224490

did you follow the instructions on the Joomla docs page to fix assets table or did you just do it through phpmyadmin? The instructions say to "move" the articles into new categories but there's no move tool in 2.5 and I have hundreds of articles.