Link Manager 3.0 Support Thread

[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/inde...ain_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.

[clydejones]

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/inde...ain_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 3013

[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?

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

[clydejones]

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.

[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]

[clydejones]

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 ???

[safewatch]

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?

[ctcentralinfo]

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

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

similar to your test site:

http://mysticmountainnaturals.com/te...=links&lPath=6

[clydejones]

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

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

similar to your test site:

http://mysticmountainnaturals.com/te...=links&lPath=6

Which version of Links manager are you using.

[ctcentralinfo]

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