J 3.3.6
CB 2.0.5 - pkg_communitybuilder_2.0.5.ci.2015.02.11.00.20+ade62a1e8
CBSubs-4.0.0-rc.1.ci.2015.02.07.00.20-unzip1st-85b2ccd27.zip
E.g.: CBSubs Payments Center overview as showed in the attachment.
When I click the 'Paid On' dates, 'Completed' amounds and 'Pending' amounds the filter works fine.
When I click the 'New Registrations, 'Upgrades' and/or 'Renewals' I get the following errors;
E.g.: For 'New Registrations';
1064 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 '= '1' ) AND ( a.`time_paid_date` = '2015-02-18' )' at line 2 SQL=SELECT COUNT(*) FROM `xyz_cbsubs_payments` AS a WHERE ( (.`newregs` = '1' ) AND ( a.`time_paid_date` = '2015-02-18' )
E.g.: For 'Upgrades';
1064 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 '= '1' )' at line 2 SQL=SELECT COUNT(*) FROM `xyz_cbsubs_payments` AS a WHERE ( a.`time_paid_date` = '2015-02-18' ) AND ( (.`upgrades` = '1' )
E.g.: For 'Renewals';
1064 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 '= '1' )' at line 2 SQL=SELECT COUNT(*) FROM `xyz_cbsubs_payments` AS a WHERE ( a.`time_paid_date` = '2015-02-18' ) AND ( (.`renewals` = '1' )
Are these known issues in CBSubs?
Br.