Errors in 2 different reports

[grotius]

Hi,

 

I am having problems with 2 different reports.

I get the following error under the reports contribs.

 

1) the 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 wher

 

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]

 

2) 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.p

 

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]

 

I am running the following database: MySQL 4.1.21-standard-log.

 

I do hope someone can help me. Thanks in advance.

[Guest]

Hi,

 

I am having problems with 2 different reports.

I get the following error under the reports contribs.

 

1) the Best Customer Orders-Total

2) Best Products Purchased

I am running the following database: MySQL 4.1.21-standard-log.

 

I do hope someone can help me. Thanks in advance.

 

You have SEO-G installed so read this:

http://www.oscommerce.com/forums/index.php?s=&...t&p=1070228

 

Probably I am going to create a separate split class with the next version, so I won't have to deal with each contribution's problems.