Link Manager 3.0 Support Thread

[clydejones]

Clyde I have been scouring this thread and either I am blind or I have overlooked the answer to this.

I have a clean install of this mod on a 1.3.7 cart and all appears fine until I click on a link category and then I get this :

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 '' at line 1
in:
[select count(l.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 = '6'order by ]

You can see it in action here :
http://www.leatherrider.com/index.php?main_page=links

Click a category and that error pops.

Is there a fix for this ?

Thanks In Advance!

Tina,

can you open includes/templates/YOUR_TEMPLATE/templates/tpl_links_default.php

replace lines 110 and 111 (these are the lines in my copy of the file)
with the following:

// We show them all
    $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";

See if that fixes the problem

[TinaS]

Unfortunately - this didn't solve the problem Clyde

[clydejones]

Unfortunately - this didn't solve the problem Clyde

Tina,

Which version of Mysql is being used?

[clydejones]

Unfortunately - this didn't solve the problem Clyde

Tina,

I've checked several of the sites listed in this thread as well as three of my own sites, and have not been able to reproduce this error.

There was only one other post about this that I could find HERE

But everything seems to be working on that site now (you might want to check with the author of that post to see how the issue was resolved.)

[Johnnyc]

Clyde,

I just wanted to stop by and say Thank You for your hard work in creating and supporting this masterpiece! I downloaded Link Manager today and had it up and running in about 20 minutes.

Thanks again!!

[fepb]

Hi Clyde,

Great contribution, thanks a bunch! I've installed this mod in my test store and am experiencing one little glitch.

In /includes/languages/english/custom/links_submit.php I've defined the following:

define('NAVBAR_TITLE', 'Submit A Link');
define('NAVBAR_TITLE_1', 'Links');
define('NAVBAR_TITLE_2', 'Suggest a Website');
define('HEADING_TITLE', 'Resource Submission');

Now "Resource Submission" appears as the heading/title of all of my store pages and has replaced "Shopping Cart" and "Welcome to my Store", "Shipping & Returns", etc.

And "Submit A Link" appears in the navbar part of the page so that it becomes:

Home :: Submit A Link

This only happens with store pages like the ones mentioned above, About Us, Shopping Cart, Main Page, Page 2, Gift Certificate FAQ, etc. but not with the EZ Pages or Categories and Products pages.

Any ideas on why it might be doing this?

Thanks!

[fepb]

Oops, just solved my own problem from my previous post. Apparently I had accidentally uploaded a copy of the links_submit.php language file into my extra_definitions folder.



... in case anyone else has the problem.

Cheers.

And thanks again, Clyde, for the great contribution!

[clydejones]

Oops, just solved my own problem from my previous post. Apparently I had accidentally uploaded a copy of the links_submit.php language file into my extra_definitions folder.



... in case anyone else has the problem.

Cheers.

And thanks again, Clyde, for the great contribution!

Glad you got it solved

[kasnah36]

please past the url for Links Manager 3.0 so we can download it! i can find the download section!

[clydejones]

please past the url for Links Manager 3.0 so we can download it! i can find the download section!

The link to the download section is at the top of forum page (called downloads).

Links manager is located in the section called sideboxes and is at the top of page 2.