Syntax Error!

[sftryeler]

Hello all! I'm fairly new to everything but can sometimes work my problems out. I installed the abstract zones contrib. and everything works fine except for when i go to my reports I get 2 errors.

 

--------------------------------- #1

Best Products Purchased

 

 

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 '*) as total from products p, products_description pd where pd.

 

select count(distinct *) as total from products p, products_description pd where pd.products_id = p.products_id and pd.language_id = '1' and p.products_ordered > 0

 

[TEP STOP]

 

 

---------------------------------#2

Best Customer Orders-Total

 

 

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 '*) as total from customers c, orders_products op, orders o whe

 

select count(distinct *) as total from customers c, orders_products op, orders o where c.customers_id = o.customers_id and o.orders_id = op.orders_id

 

[TEP STOP]

 

 

 

 

I just don't know where to start. If someone could help me out I'd really appreciate it :lol: