I have posted on the zen cart light box page, but have not had a reply yet (inpatient) as my store is down at the moment, would really appreciate some help on this,

Copy of post

Hi, I copied all the contents of the install.sql file in to the install sql page, box, and then hit send, it said 9 something had been sent, but now non of my products show on the site and I have an erorr message on the bottom of my site

please help,


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 'MAX_RANDOM_SELECT_REVIEWS' at line 8
in:
[select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from zen_reviews r, zen_reviews_description rd, zen_products p, zen_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 MAX_RANDOM_SELECT_REVIEWS]