Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Error in MySQL version - Extra Images


Skedar

Recommended Posts

Posted

Hi,

 

Im install the "Extra Images 1.6.1 but, when I try to add an image appears the following 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 '-20, 20' at line 1

 

select pei.products_extra_image, pei.products_extra_images_id, pei.products_id, pd.products_name,p.products_image from products_extra_images pei left join products p ON pei.products_id = p.products_id left join products_description pd on p.products_id = pd.products_id order by pd.products_name limit -20, 20

 

where do I change the code to work on my version of mysql?

 

is mySQL 5.0.45

 

 

thx a lot!

 

 

(sry for my english)

Archived

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

×
×
  • Create New...