Error 1064

[jeremy26]

I have a problem and i don't know how to solve this.

I read the post from forum about this error but i do not succed.

The error apears only on index.php

Please help me..

"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 'select distinct p.products_id, pd.products_name from products p

 

SELECT *, RAND() AS rand_id FROM (select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '4' order by p.products_ordered desc, pd.products_name limit 20) AS a ORDER BY rand_id LIMIT 10

[TEP STOP]"

 

Thanks in advance

[♥Vger]

Looks like you've installed a contribution incorrectly.

 

Vger

[jeremy26]

My shop works very fine on my local computer where i have easyphp 1.8.0.1 (phpmyadmin 2.6.1

mysql 4.1.9).

On my server i have phpMyAdmin 2.6.4-pl2 (MySQL 4.0.25).

I do not know what to do .

Please help.

I receive the error on the right side of my shop.

 

Thanks in advance

[jeremy26]

The problem : best sellers..