Quote Originally Posted by clydejones View Post
Open includes/templates/YOUR_TEMPLATE/templates/tpl_links_default.php

find the following line of code (around line 19):
PHP Code:
$categories_query = $db->Execute("select lc.link_categories_id, lcd.link_categories_name, lcd.link_categories_description, lc.link_categories_image from " . TABLE_LINK_CATEGORIES . " lc, " . TABLE_LINK_CATEGORIES_DESCRIPTION . " lcd where lc.link_categories_id = lcd.link_categories_id and lc.link_categories_status = '1' and lcd.language_id = '" . (int)$_SESSION['languages_id'] . "' order by lcd.link_categories_name"); 
and replace it with this line:

PHP Code:
$categories_query = $db->Execute("select lc.link_categories_id, lcd.link_categories_name, lcd.link_categories_description, lc.link_categories_image from " . TABLE_LINK_CATEGORIES . " lc, " . TABLE_LINK_CATEGORIES_DESCRIPTION . " lcd where lc.link_categories_id = lcd.link_categories_id and lc.link_categories_status = '1' and lcd.language_id = '" . (int)$_SESSION['languages_id'] . "' order by lcd.link_categories_sort_order"); 
I tried this fix on 2 sites
it fixes the sort order for the online catalog, but no in the admin area

both site also get this error when you click on "view all link"
1054 Unknown column 'lcd.link_categories_sort_order' in 'order clause'
in:
[select lc.link_categories_id, lcd.link_categories_name, lcd.link_categories_description, lc.link_categories_image from link_categories lc, link_categories_description lcd where lc.link_categories_id = lcd.link_categories_id and lc.link_categories_status = '1' and lcd.language_id = '1' order by lcd.link_categories_sort_order]