1064 You have an error in your SQL syntax;

[bubbadan]

I have read through every question regarding this error on the forum and none of the solutions address my issue. Basically I get an error whenever i try to access any "Special" such as Specials, new products, featured products etc.

Here is the full error message when trying to access New Products

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 zen_products p left join zen_manufacturers m on (p.manufacture' at line 1
in:
[select count(distinct *) as total FROM zen_products p left join zen_manufacturers m on (p.manufacturers_id = m.manufacturers_id) left join zen_products_to_categories p2c on p.products_id = p2c.products_id left join zen_products_description pd on p.products_id = pd.products_id WHERE p.products_status = 1 AND pd.language_id = 1 ]

Here is the full error message when trying to access Specials
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 zen_products p LEFT JOIN zen_specials s on p.products_id = s.p' at line 1
in:
[select count(distinct *) as total FROM zen_products p LEFT JOIN zen_specials s on p.products_id = s.products_id LEFT JOIN zen_products_description pd on p.products_id = pd.products_id LEFT JOIN zen_manufacturers m on p.manufacturers_id = m.manufacturers_id LEFT JOIN zen_products_to_categories p2c on p.products_id = p2c.products_id WHERE p.products_status = '1' AND s.status = 1 AND pd.language_id = 1]

And for Featured Products
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 zen_products p LEFT JOIN zen_manufacturers m on p.manufacturer' at line 1
in:
[select count(distinct *) as total FROM zen_products p LEFT JOIN zen_manufacturers m on p.manufacturers_id = m.manufacturers_id LEFT JOIN zen_featured f on p.products_id = f.products_id LEFT JOIN zen_products_to_categories p2c on p.products_id = p2c.products_id LEFT JOIN zen_products_description pd on p.products_id = pd.products_id WHERE p.products_status = 1 and f.status = 1 and pd.language_id = 1 ]


I do use Easy Populate to load my products if this would make any reason why this is happening.
I will admit I am a bit braindead when it comes to mysql - any help would be greatly appreciated.

[schoolboy]

What VERSION of:

Zencart
PHP
MySQL

[niccol]

And also :

what template?
what addons that might effect these pages?

this bit of the sql statements is going to create an error:

select count(distinct *)

And it is not standard in any version I know of.