Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1064 SQL Syntax error


Guest

Recommended Posts

Posted

I am installing Add_on "Protect Images with Unlimited Images Per Product" (from here) Getting most of my errors worked out, but this one I'm lost on. It happens when you try to see products review from the products page.

 

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 '.image_display, pd.products_name from products p, products_description pd where ' at line 1

 

select p.products_id, p.products_model, p.products_image, p.products_price, p.products_tax_class_id, p.image_folder p.image_display, pd.products_name from products p, products_description pd where p.products_id = '89' and p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1'

 

Also is there a thread for this add-on? I could not find it.

Where would I find the page to modify the text for the reviews that say "of 5 STARS" Thank you. :D

Posted

Botched edit of the SQL query code by someone or something.

...p.image_folder p.image_display,...

You need a comma after p.image_folder.

Archived

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

×
×
  • Create New...