sql error in low stock report

[abonnenc]

Hello,

 

I have installed the low stock report v2.04 on my oscommerce version 2.2rc2a, but when I am in admin and click on low stock report, I have the following error :

 

httpGetVars('sorted', 'ASC', array('ASC', 'DESC')); $orderby = $slsc->httpGetVars('orderby', 'stock'); //db_orderby based on orderby switch($orderby) { case 'stock': default: $orderby = 'stock'; $db_orderby = 'p.products_quantity'; break; case 'model': $db_orderby = 'p.products_model'; break; case 'name': $db_orderby = 'pd.products_name'; break; case 'status': $db_orderby = 'pd.products_status'; break; } ?> No. Nom du Produit Quantité Disponible Modèle Ventes sous 60 jours Est. Stock Statut

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 'limit 0, 30' at line 1

 

select p.products_id, p.products_quantity, pd.products_name, p.products_model, p.products_status from products p, products_description pd where p.products_id = pd.products_id and pd.language_id = '4' and p.products_quantity <= 5 group by pd.products_id order by limit 0, 30

 

I don't know about sql syntax, can someone help me to solve this problem?

 

Thanks

 

Carina