Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1064 - SQL syntax errors


Irin

Recommended Posts

Hello,

 

I'm getting the following SQL syntax errors

in admin/specials:

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, p.products_model, p.products_price, s.specials_id, s.specials_new_products_price, s.specials_date_added, s.specials_last_modified, s.expires_date, s.date_status_change, s.status from products p, specials s, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = s.products_id order by p.products_model limit -20, 20

in admin/products_expected:
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_model, 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

How can I correct these errors?

 

Any help would be appreciated. Thanks,

Irina.

Link to comment
Share on other sites

Look at the '1064' link below my name for the answer to the question.

 

Vger

Thanks a lot for replying to my post, Vger. I did exactly what you suggested in that reference. Works great now, no more errors in neither admin nor catalog.

 

Thanks very much. You're awesome.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...