Hi, on my client site, using J3.4.1 and the latest versions of CB and CB Subs, I get the following error when doing a statistics search

1054 Unknown column 'a.time_completed' in 'where clause' SQL=SELECT COUNT( DISTINCT b.`time_completed_yearmonth` ) FROM `jos_cbsubs_payment_items` AS a LEFT JOIN `jos_cbsubs_payment_baskets` AS b ON b.`id` = a.`payment_basket_id` LEFT JOIN `jos_cbsubs_currencies` AS c ON c.`currency` = 'AUD' LEFT JOIN `jos_cbsubs_currencies` AS d ON d.`currency` = a.`currency` LEFT JOIN `jos_cbsubs_payment_baskets` AS e ON e.`id` = a.`payment_basket_id` WHERE ( b.`time_completed_yearmonth` > '0000-00' ) AND ( a.`plan_id` = 2 ) AND ( a.`currency` = 'AUD' ) AND ( a.`time_completed` >= '2015-05-31 22:00:00' ) AND ( a.`time_completed` > date_sub(NOW(), INTERVAL 1 MONTH) )

Can you help explain why this is happening and what I should do to fix it?

Thanks, JR

Hi, I have loaded both nightly builds and still get the error.

I am doing a search using Payment Free Query and then a search on one plan and with a starting date of 1st June, 2015. I have also tried doing searches with Payments Monthly, Sales Monthly, etc. They all lead to a similar error. I have tried searches with a defined start and end date but still get an error.

??

Yes, try selecting New Membership Subscription from the Plans dropdown. I get an error every time.
Thanks - JR