Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

LinksManager V1.12


stevennickelby

Recommended Posts

Posted

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?

Posted

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

Posted
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!.

 

:)

Archived

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

×
×
  • Create New...