oscmax 1.7 does not work in newer mysql ?

[Yari_Gio]

Hey guys, my hosting company is telling me that the errors I'm having on a fresh install of oscmax 1.7 is due to the fact that they are running newer versions of php (they are running version 4.4.1) and mysql (they are running 4.1.14-standard).

The problem im having is going under the "reports" area causes an error. The error is:

*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 '-10, 10' at line 1

select p.products_id, pd.products_name, pd.products_viewed, l.name from
products p, products_description pd, languages l where p.products_id =
pd.products_id and l.languages_id = pd.language_id order by
pd.products_viewed DESC limit -10, 10


any one have any idea ? this is a totalt fresh install, no products no nothing.

EDIT!! humm more data. I added a product, and i whent to the catalog area and viewed it. Now if i go under the admin area and go under most viewed i get stats, but if i go under the other two categories (most boght, or hehe forogt the other one) it still comes up with the error above. I dont rember that ever happening before, is there a probem with the way that codes works wiht the new mysql language ? any one hear of anything ?

[zonzo_1]

here is the fix !!! it does have ot do with the newer mysql version


http://blogs.oscommerce.com/christia...ry&eid=362