eko Posted February 22, 2006 Posted February 22, 2006 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:
Wendy James Posted February 22, 2006 Posted February 22, 2006 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.
eko Posted February 22, 2006 Author Posted February 22, 2006 thanks for the quick reply there. :rolleyes: its very thanked
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.