reggs12

I can’t do that. There are other fields that are based upon the current date so no matter what I have to change the logic around coming from the database. The only way I would be able to use p.calendar_end is if what was saved in the database didn’t need to be reworked. I know it doesn’t look like that field needs to be split up like that but there are other fields that definitely do. So I go back to asking why the WHERE statement breaks the search and if there is some way to get around it?

This statement works as long as you make “calendar_term” a date field.

SELECT p.ID,p.post_title,pp.post_date,
CONCAT(SUBSTRING(p.calendar_end, 1, 4),'/',SUBSTRING(p.calendar_end, 5, 2),'/',SUBSTRING(SUBSTRING(p.calendar_end, 5), -2)) as calendar_term
FROM payments as p
LEFT JOIN payments_posts AS pp ON pp.post_id = p.post_id

As soon as I add the WHERE to the bottom it returns all records instead of just one like the initial error caused by not assigning calendar_term to be a date field.

SELECT p.ID,p.post_title,pp.post_date,
CONCAT(SUBSTRING(p.calendar_end, 1, 4),'/',SUBSTRING(p.calendar_end, 5, 2),'/',SUBSTRING(SUBSTRING(p.calendar_end, 5), -2)) as calendar_term
FROM payments as p
LEFT JOIN payments_posts AS pp ON pp.post_id = p.post_id
where p.post_last_save_date = pp.post_date

Do I need to edit the way the plugin handles the query and if so what file and line number would that be? Thanks for your help.

FYI I set up a view in mysql and got the same error. Looks like you can’t include the set command inside the view.

Ok I will look into that thanks.