Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1064 - You have an error in your SQL syntax


Face

Recommended Posts

Hey guys, new to the forum here.

 

Installed osCommerce last night and I receive the following errors when selecting options from Administration:

 

Administration>>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 '-6, 6' 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 -6, 6

 

[TEP STOP]

 

I get a similiar message in the Reviews selection of Administration...

 

Administration>>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 '-6, 6' at line 1

 

select reviews_id, products_id, date_added, last_modified, reviews_rating from reviews order by date_added DESC limit -6, 6

 

[TEP STOP]

 

I'm not sure how to fix this, or if I should continue on the site if I should have to start over. I've tried installing twice (virgin install - no tweaks) with the same errors.

 

Any help is appreciated!

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...