stevennickelby Posted March 21, 2006 Posted March 21, 2006 Hello, I have just installed LinksManager v1.12, and when you go into admin links manager>Links, it comes up with... 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 l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_status from links l left join links_description ld on l.links_id = ld.links_id where ld.language_id = '1' order by ld.links_title limit -20, 20 [TEP STOP] and if you go to llinks manager>Links categories, it comes up with... 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 lc.link_categories_id, lc.link_categories_image, lc.link_categories_status, lc.link_categories_sort_order, lc.link_categories_date_added, lc.link_categories_last_modified, lcd.link_categories_name, lcd.link_categories_description from link_categories lc left join link_categories_description lcd on lc.link_categories_id = lcd.link_categories_id where lcd.language_id = '1' order by lc.link_categories_sort_order, lcd.link_categories_name limit -20, 20 [TEP STOP] does anyone know why?
♥Vger Posted March 21, 2006 Posted March 21, 2006 Read the '1064' link below my name. Better still, upgrade to the updated version of osCommerce MS2, available from downloads at www.oscommerce.com - which contains that fix as well as other bug fixes and security fixes. Vger
stevennickelby Posted March 21, 2006 Author Posted March 21, 2006 Read the '1064' link below my name. Better still, upgrade to the updated version of osCommerce MS2, available from downloads at www.oscommerce.com - which contains that fix as well as other bug fixes and security fixes. Vger Thanks very much Vger, It's working!. :)
Recommended Posts
Archived
This topic is now archived and is closed to further replies.