Links manager error 1109 Unknown table 'p' in field list

I just installed links manager advanced on my new site and I am getting this error for each category section:

1109 Unknown table 'p' in field list
in:
[select count(p.links_id) as total 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 = '2']

Follow ups will be posted here. Please post there. For easy navigation and problem findings with the search option.

The problem was that I had a file from links manager 2.0 still in zen-cart. I removed it and it seems to be working find.

Its working now? or you removed the whole mod?

for the people who has the number 5 in the description box when visitors try to insert thier description

find in includes/templates/template_default/templates/tpl_links_submit_default.php
around line 93

  <td class="main"><?php echo zen_draw_textarea_field('links_description', 'soft', 25, 5) . ' ' . (zen_not_null(ENTRY_LINKS_DESCRIPTION_TEXT) ? '<span class="inputRequirement">' . ENTRY_LINKS_DESCRIPTION_TEXT . '</span>': ''); ?></td>

replace with

 <td class="main"><?php echo zen_draw_textarea_field('links_description', 'soft', 25) . ' ' . (zen_not_null(ENTRY_LINKS_DESCRIPTION_TEXT) ? '<span class="inputRequirement">' . ENTRY_LINKS_DESCRIPTION_TEXT . '</span>': ''); ?></td>

the sort order is still being operated on for who is interested in that feature.

Rob

the sorting option has been fixed, the links in the sidebox for the links should show properly, the sorting does not function once in the view all links or all categories section.

upgraded version in downloads once approved.

knuckle-101:

Its working now? or you removed the whole mod?

Yes, It works.