Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Links Manager Problem


tsvenkat

Recommended Posts

Posted

Links Manager Contribution give error as below :

 

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 l.links_status = '4' and ld.language_id = '1' order by ld.links_title limit -20, 20

 

[TEP STOP]

 

plz advice

Posted

As mentioned in the Links Manager suport thread, it is not a Links Manager problem (you should always check the support thread before posting). The fix is to find the following line in admin/includes/classes/split_page_results.php

$sql_query .= " limit " . $offset . ", " . $max_rows_per_page;

and change it to

$sql_query .= " limit " . max($offset, 0) . ", " . $max_rows_per_page;

or, better yet, install the security update for oscommerce.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

All of My Addons

Get the latest versions of my addons

Recommended SEO Addons

Archived

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

×
×
  • Create New...