Link Manager 3.0 Support Thread

Quote:

---

Originally Posted by clydejones

This should fix the spacing problem.

Just unzip the file, rename the YOUR_TEMPLATE folder to match the name of your custom template and upload the entire includes folder to your server.

Attachment 3403

---

Splendid! It's lovely now :) Thanks Clyde ! :clap:

Quote:

---

Originally Posted by Doodlebuckets

Splendid! It's lovely now :) Thanks Clyde ! :clap:

---

Glad to help

I just got an email that said they could not add their link to my site. I tested and got this error when the link is submitted:

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 's Gifts' and language_id = '1'' at line 1
in:
[select link_categories_id from link_categories_description where link_categories_name = 'Baby & Children's Gifts' and language_id = '1' ]

I got no SQL errors at install. Am running 1.3.8a on sql is version 5. Do you have a fix that will not wipe out my categories and current links?

Quote:

---

Originally Posted by Doodlebuckets

I just got an email that said they could not add their link to my site. I tested and got this error when the link is submitted:

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 's Gifts' and language_id = '1'' at line 1
in:
[select link_categories_id from link_categories_description where link_categories_name = 'Baby & Children's Gifts' and language_id = '1' ]

I got no SQL errors at install. Am running 1.3.8a on sql is version 5. Do you have a fix that will not wipe out my categories and current links?

---

Didn't you say that you disabled that particular category?

Quote:

---

Originally Posted by Doodlebuckets

I just got an email that said they could not add their link to my site. I tested and got this error when the link is submitted:

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 's Gifts' and language_id = '1'' at line 1
in:
[select link_categories_id from link_categories_description where link_categories_name = 'Baby & Children's Gifts' and language_id = '1' ]

I got no SQL errors at install. Am running 1.3.8a on sql is version 5. Do you have a fix that will not wipe out my categories and current links?

---

You have an extra apostrophe in the category name:

'Baby & Children's Gifts'

To correct this, edit the category name so it appears as follows:

'Baby & Children\'s Gifts'

You may want to make this correction to any other similar category names

Quote:

---

Originally Posted by clydejones

Didn't you say that you disabled that particular category?

---

I did disable a category on my www.giftsofcharacter.com site but they was just because that category was aligning funny. On www.doodlebuckets.com is where I am getting this error both when someone tries to submit on the links page and when I try to add in the admin.

Quote:

---

Originally Posted by clydejones

You have an extra apostrophe in the category name:

'Baby & Children's Gifts'

To correct this, edit the category name so it appears as follows:

'Baby & Children\'s Gifts'

You may want to make this correction to any other similar category names

---

OK! I'll give it a go...

Quote:

---

Originally Posted by clydejones

You have an extra apostrophe in the category name:

'Baby & Children's Gifts'

To correct this, edit the category name so it appears as follows:

'Baby & Children\'s Gifts'

You may want to make this correction to any other similar category names

---

When I put in the '\ in for the ', it shows up as '\ in the category name.

Quote:

---

Originally Posted by Doodlebuckets

When I put in the '\ in for the ', it shows up as '\ in the category name.

---

It should look like this when you do the edit

Baby & Children\'s Gifts

This tells the sql statement to keep the ' before the s and not to end the statement at that point.

You may see it on the editing screen but it should show up as

Baby & Children's Gifts on the submission screen.

Quote:

---

Originally Posted by clydejones

With just a quick look, it appears that the image for "gifts for Children" is NOT the same size (height) as the rest of the images.

That means that whatever follows that image is going to be bumped up a little and won't clear to the next line.

Make sure your images are all the same height and I think that should solve the problem.

---

Just wanted to let ya'll know that the category images will line up perfectly if you size your pics to 80px x 80px up front. I think my problem was that some pics were rectangular and some were square. When I cropped them all and resized them to 80 x 80, everything lined up great and I don't have to disable the category that was out of whack any more :)