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
:no: 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]
DarkAngel:
@ Daisy:
the zen_lightbox folder goes into your templates folder/images/buttons/english
if that is where you put them then they are right.
@powelli:
jscript_zen_lightbox.php is not the installer file the install.sql is the installer and you need to open it in a text editor then copy/paste it into the sql installer of admin
make sure you add the table prefix if your store has one and if it does not install through there then you need to install it (the same way) from myphpadmin