Link Manager 3.0 Support Thread

[clydejones]

Retesting viewing links. Clicking on view all links brings up category descriptions, clicking on one of them results in:
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 '-0, MAX_DISPLAY_LINKS' at line 1
in:
[select l.links_image_url, ld.links_title, ld.links_description, ld.links_title, l.links_clicked, l.links_id from links_description ld, links l, links_to_link_categories l2lc where l.links_status = '2' and l.links_id = l2lc.links_id and ld.links_id = l2lc.links_id and ld.language_id = '1' and l2lc.link_categories_id = '8'order by ld.links_title limit -0, MAX_DISPLAY_LINKS]

Page numbering of the page is wacked: -4 -3 -2 -1 0

open includes/templates/YOUR_TEMPLATE/tpl_links_default.php

at around line 100 replace the existing line of code with the following

    $listing_sql = "select " . $select_column_list . " l.links_id from " . TABLE_LINKS_DESCRIPTION . " ld, " . TABLE_LINKS . " l, " . TABLE_LINKS_TO_LINK_CATEGORIES . " l2lc where l.links_status = '2' and l.links_id = l2lc.links_id and ld.links_id = l2lc.links_id and ld.language_id = '" . (int)$_SESSION['languages_id'] . "' and l2lc.link_categories_id = '" . (int)$current_category_id . "'" . "order by $sortorder";