tsvenkat Posted March 26, 2006 Posted March 26, 2006 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
Jack_mcs Posted March 26, 2006 Posted March 26, 2006 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
Recommended Posts
Archived
This topic is now archived and is closed to further replies.