OscAffiliate help for 1.01 version on reports for customer

[ridesign]

I get the following error when i click on the payment report from the catalog-not admin:

1064 - You have an error in your SQL syntax near 'select p.* , s.affiliate_payment_status_name from affiliate_payment' at line 2

 

select count( select p.* , s.affiliate_payment_status_name from affiliate_payment p, affiliate_payment_status s where p.affiliate_payment_status = s.affiliate_payment_status_id and s.affiliate_language_id = '1' and p.affiliate_id = '1' order by p.affiliate_payment_id DESC ) as total

 

Also i get the following error when clicking clickthrough report:

1064 - You have an error in your SQL syntax near 'select a.*, pd.products_name from affiliate_clickthroughs a left join prod' at line 2

 

select count( select a.*, pd.products_name from affiliate_clickthroughs a left join products p on (p.products_id = a.affiliate_products_id) left join products_description pd on (pd.products_id = p.products_id and pd.language_id = '1') where a.affiliate_id = '1' ORDER BY a.affiliate_clientdate desc ) as total

 

[TEP STOP]

 

And i get this error when clicking sales report:

 

1064 - You have an error in your SQL syntax near 'select a.*, o.orders_status as orders_status_id, os.orders_status_name as order' at line 2

 

select count( select a.*, o.orders_status as orders_status_id, os.orders_status_name as orders_status from affiliate_sales a left join orders o on (a.affiliate_orders_id = o.orders_id) left join orders_status os on (o.orders_status = os.orders_status_id and language_id = '1') where a.affiliate_id = '1' order by affiliate_date DESC ) as total

 

[TEP STOP]

 

 

Any help will be greatly appreciated

Site:http://ridesign.staghosting.com/catalog :?:

 

Thank you