Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

I really need help here....


Recommended Posts

I posted this on another board with no response....


I installed the Shoppe Enhancement Controller v2.2 for MS2 (SECv2_2MS2) several times and every time I get this error:



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_DISPLAY_PRODUCTS_SPECIALS' at line 1

select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and s.status = '1' order by rand() DESC limit MAX_DISPLAY_PRODUCTS_SPECIALS




The screen is pink at the top and the rest is a really dark teal. Not what I've seen others' sites look like after installing the enhancement. This is a fresh install by the way. I ran the file in phpmyadmin as well as uploaded the entire catalog file. Please help me with this!! :blink:

Link to comment
Share on other sites


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

  • Create New...