Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

[TEP STOP] help please/


eko

Recommended Posts

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

 

[TEP STOP]

 

 

hi get this error when i press the newsletter manager and most viewed items. can someone please help i would be very greatfull. thank you very much :thumbsup:

Link to comment
Share on other sites

1064 means you have no information in your database for that particular page.

 

Check this link, it will tell you what to do.

http://www.oscommerce.com/forums/index.php?sho...=144095&hl=1064

Wendy James

 

Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...