problem configuring customers and reports

[cangeceiro]

i just got oscommerce installed and everything works fine, but when i go to the admin page and goto reports i get this

 

Best Viewed 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 '-20, 20' 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 -20, 20

 

get the same thing when i go to the "customers" section, i am using php4.3 and mysql4.1

[cangeceiro]

i just got oscommerce installed and everything works fine, but when i go to the admin page and goto reports i get this

 

Best Viewed 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 '-20, 20' 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 -20, 20

 

get the same thing when i go to the "customers" section, i am using php4.3 and mysql4.1

<{POST_SNAPBACK}>

 

 

ok i figured this one out on my own, and i would consider this a bug personally. the problem existed when i deleted the only customer listed in my database. i just redid the database with the provided install script and it works again. maybe something that should be noted/fixed at somepoint