1064 error help

[alhunter27]

Hello everyone,

When I click to the Online Catalog link to view my store, the following error message appears in place of the left catagory column:

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 '' at line 8
in:
[select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' and r.status = 1 limit ]

How do I correct this problem?

Thanks,
Al

[DrByte]

Posting duplicates of the same question in multiple places results in incomplete/disjointed discussions, without knowing the resolution. It also confuses people who may be helping in one thread but not knowing what's happening in your other thread of the same topic. Thus, double-posting the same thing in multiple places is frowned upon. Please continue your discussion in your other thread: http://www.zen-cart.com/forum/showthread.php?t=110512