1064 - An error in my SQL syntax

[soibien]

Wel, thankyou because i fixed error session_save_path(): but i have some other problem.

When i log on to admin and click Reviews in catalog have error:

Reviews  

Products Rating Date Added Action  
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 reviews_id, products_id, date_added, last_modified, reviews_rating from reviews order by date_added DESC limit -20, 20

[TEP STOP]

 

and click Products Expected in catalog have error:

 Products Expected  

Products Date Expected Action  
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 pd.products_id, pd.products_name, p.products_date_available from products_description pd, products p where p.products_id = pd.products_id and p.products_date_available != '' and pd.language_id = '1' order by p.products_date_available DESC limit -20, 20

[TEP STOP]

How do i do.

Sorry i'm vietnamese and i can't speak English well.

[Guest]

Update your osCommerce store - the download has instructions on how to update an existing installation :)

 

Matti