Link Manager 3.0 Support Thread

Alex Clarke:

Hi Clyde,

Just noticed an error when trying to add new link categories.

If the sort order field is left blank (which it is by default) then the following error message is displayed.

A work-around is to enter a number into the sort order field.

Maybe this field should be set to '0' by default?

Thanks Alex,

I'll correct this in the next upgrade.

Sounds good. :)

Just to let you know, I'm using PHP 5.2.3 and MySQL 5.0.41 (running in strict mode I beleive, which is probably explains this error).

I'm still trying to find a solution to my other problems, as mentioned this post.

http://www.zen-cart.com/forum/showpost.php?p=460473&postcount=644

So far I've tried the code change you suggested, but had no luck. :(

Alex Clarke:

Sounds good. :)

Just to let you know, I'm using PHP 5.2.3 and MySQL 5.0.41 (running in strict mode I beleive, which is probably explains this error).

I'm still trying to find a solution to my other problems, as mentioned this post.

http://www.zen-cart.com/forum/showpost.php?p=460473&postcount=644

So far I've tried the code change you suggested, but had no luck. :(

This should take care of the sort order issue.

Just unzip the file and upload the admin folder to your server.

[Attachment no longer available]

What kind of server are you on?

I'm running this with apache php5 mysql5 and have no problems.

clydejones:

This should take care of the sort order issue.

Just unzip the file and upload the admin folder to your server.

[Attachment no longer available]

What kind of server are you on?

I'm running this with apache php5 mysql5 and have no problems.

Thanks, that fixed the sort order issue.

I'm currently running IIS 6.

When trying to submit a new link (not via the admin) the page simply refreshes.

Also, clicking on any category (on the links page) does not display any links. Again, the page seems to refresh.

I'm still looking into these issues, but not getting very far at the moment. :(

Alex Clarke:

Thanks, that fixed the sort order issue.

I'm currently running IIS 6.

When trying to submit a new link (not via the admin) the page simply refreshes.

Also, clicking on any category (on the links page) does not display any links. Again, the page seems to refresh.

I'm still looking into these issues, but not getting very far at the moment. :(

I've never used IIS(windows) server.

The mods both Links and Testimonial were developed using xaamp/apache.

A couple of other people running IIS have reported this same issue.

I'm not sure I understand why it would be a problem. the submit button should work the same way as submitting any of the other forms in ZC which both of the mods submission forms are based on.

Let me know if you do find a solution.

Hello,

I like this add-on (congrats to the developer), however I have a few questions...

I didn't see a captcha feature. I have a link submission site (not related) that currently doesnt have captcha and I am getting so many link requests that it is to overwhelming to filter through them.
Does this add-on somehow limit this?

Does the add-on have reciprocal link verification?

The option to instantly list verified links?

Lastly, How difficult would it be to transfer over 3000 links via excel, and could it be done if they were not reciprocal links?

Kind Regards,
Jeff
PCmediaHost

justinhemp:

Hello,

I like this add-on (congrats to the developer), however I have a few questions...

I didn't see a captcha feature. I have a link submission site (not related) that currently doesnt have captcha and I am getting so many link requests that it is to overwhelming to filter through them.
Does this add-on somehow limit this?

Does the add-on have reciprocal link verification?

The option to instantly list verified links?

Lastly, How difficult would it be to transfer over 3000 links via excel, and could it be done if they were not reciprocal links?

Kind Regards,
Jeff
PCmediaHost

I didn't see a captcha feature. I have a link submission site (not related) that currently doesnt have captcha and I am getting so many link requests that it is to overwhelming to filter through them.
Does this add-on somehow limit this?
It doesn't have captcha incorporated, but there is a mod located in the downloads section that can be used.

Just be sure you run a file compare of tpl_links_submit.php (that file in the captcha mod is older than the one in the current version of Links Manager.

Does the add-on have reciprocal link verification?

This can be done in admin -> extras -> links
You will have to set the "links check phrase" in admin -> configuration -> links manager

The option to instantly list verified links?

submitted links must be approved admin -> extras -> links before they are listed.

Lastly, How difficult would it be to transfer over 3000 links via excel, and could it be done if they were not reciprocal links?

The links information is stored in three different tables: Links - Links description - links to links categories.
You'd have to break up to fit the table structure(s)

Alex Clarke:

Thanks, that fixed the sort order issue.

I'm currently running IIS 6.

When trying to submit a new link (not via the admin) the page simply refreshes.

Also, clicking on any category (on the links page) does not display any links. Again, the page seems to refresh.

I'm still looking into these issues, but not getting very far at the moment. :(

Just wanted to let everyone know that I've solved my second issue (clicking on any category (on the links page) does not display any links).

I made the following changes to lines 27-28 of includes/modules/pages/links/header_php.php:

From:

  if (isset($HTTP_GET_VARS['lPath'])) {
    $lPath = $HTTP_GET_VARS['lPath'];

To:

  if (isset($_GET['lPath'])) {
    $lPath = $_GET['lPath'];

I'm currently working on a fix for the other issue (trying to submit a new link (not via the admin) the page simply refreshes) and will post my findings here.

Hope this helps someone else running this contribution on IIS.

Alex Clarke:

Just wanted to let everyone know that I've solved my second issue (clicking on any category (on the links page) does not display any links).

I made the following changes to lines 27-28 of includes/modules/pages/links/header_php.php:

From:

if (isset($HTTP_GET_VARS['lPath'])) {
$lPath = $HTTP_GET_VARS['lPath'];

>  
> **To:**
> ```
  if (isset($_GET['lPath'])) {
    $lPath = $_GET['lPath'];

I'm currently working on a fix for the other issue (trying to submit a new link (not via the admin) the page simply refreshes) and will post my findings here.

Hope this helps someone else running this contribution on IIS.

Alex,

did you also make the same changes on lines 31-32

FROM:

 } elseif (isset($HTTP_GET_VARS['links_id'])) {
    $lPath = zen_get_link_path($HTTP_GET_VARS['links_id']);

TO:

} elseif (isset($_GET['links_id'])) {
   $lPath = zen_get_link_path($_GET['links_id']);

Just made those changes now. All is working fine (except the submit link form, but I'll worry about that next week).

Thanks for the help. :)

I've burned through every single page in the thread and I've only seen this mentioned 2 other times - I'm getting the 1064 errors. I've done the SQL patch, I've done the tinyint patch, no luck.

So, if anyone wants to take a crack, here's the URL - http://www.alarmmall.com/zen137/index.php?lPath=1&main_page=links

And here's the message (which, of course, you can see above):

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 zen_links_description ld, zen_links l, zen_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 = '1'order by ]

I did just recently update to 1.3.7 as we did a PHP update on the server that completely rendered our old shop useless. However, all the files are, for the most part, stock files. Very few changes other than the links manager and a few others. Everything in the Admin works great. I actually had several links transferred from the old shop listed in the box, however since they are not working, I took them down and stocked the link.

Any suggestions would be great. Short on time for now, but if you need any more info, let me know.

Thanks for the help.

safewatch:

I've burned through every single page in the thread and I've only seen this mentioned 2 other times - I'm getting the 1064 errors. I've done the SQL patch, I've done the tinyint patch, no luck.

So, if anyone wants to take a crack, here's the URL - http://www.alarmmall.com/zen137/index.php?lPath=1&main_page=links

And here's the message (which, of course, you can see above):

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 zen_links_description ld, zen_links l, zen_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 = '1'order by ]

> 
> I did just recently update to 1.3.7 as we did a PHP update on the server that completely rendered our old shop useless. However, all the files are, for the most part, stock files. Very few changes other than the links manager and a few others. Everything in the Admin works great. I actually had several links transferred from the old shop listed in the box, however since they are not working, I took them down and stocked the link.
> 
> Any suggestions would be great. Short on time for now, but if you need any more info, let me know.
> 
> Thanks for the help.

Try this: just unzip the file, rename the YOUR_TEMPLATE folder to match the name of your custom folder and then upload the entire includes folder to your server.

[Attachment no longer available]

Same message, same results. Looks like there's a space missing here:

l2lc.link_categories_id = '1'order by

Between the '1' and order by. Should read this:

l2lc.link_categories_id = '1' order by

Correct?

Edit:
Well, I was right, but that didn't completely fix it. Still getting an error on line 1.

safewatch:

Same message, same results. Looks like there's a space missing here:

l2lc.link_categories_id = '1'order by

> Between the '1' and order by. Should read this:
> ```
l2lc.link_categories_id = '1' order by

Correct?

You can try that and see if it helps.

I'm running this (as I gave you) on 4 different sites without problem.

Ok, so if you look at the new message, it seems that I'm missing the $sortorder variable in the query. I put in "ld.links_title" directly instead of $sortorder and everything works fine. But I see just above the query where the $sortorder is defined, so I don't know why it wouldn't work? Maybe I'll just leave it hard-coded for now.

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 'limit 0, 20' at line 1
in:
[select l.links_image_url, ld.links_title, ld.links_description, ld.links_title, l.links_id from zen_links_description ld, zen_links l, zen_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 = '1' order by limit 0, 20]

safewatch:

Ok, so if you look at the new message, it seems that I'm missing the $sortorder variable in the query. I put in "ld.links_title" directly instead of $sortorder and everything works fine. But I see just above the query where the $sortorder is defined, so I don't know why it wouldn't work? Maybe I'll just leave it hard-coded for now.

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 'limit 0, 20' at line 1
in:
[select l.links_image_url, ld.links_title, ld.links_description, ld.links_title, l.links_id from zen_links_description ld, zen_links l, zen_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 = '1' order by limit 0, 20]

Did you set the sort order in admin -> configuration -> links manager ???

Ok, so I've got that hard-coded and it's working fine, I'm happy with it anyway.

So, my next problem is that I backed up the 7 tables to another database temporarily from phpmyadmin, I just copied everything back and now none of the links are showing up.

I've checked the status - fine. I've checked the Admin, everything is showing there. I've got about 40 links - some approved, some pending, some disabled. None of them are showing in the links page.

Ideas?

How do I get the text hyper link to show above the description on my site:

http://www.cooltechcentral.com/index.php?main_page=links&lPath=8

similar to your test site:

http://mysticmountainnaturals.com/testsite/index.php?main_page=links&lPath=6

ctcentralinfo:

How do I get the text hyper link to show above the description on my site:

http://www.cooltechcentral.com/index.php?main_page=links&lPath=8

similar to your test site:

http://mysticmountainnaturals.com/testsite/index.php?main_page=links&lPath=6

Which version of Links manager are you using.

I am not sure it has been about a year since I upgraded your version.