Link Manager 3.0 Support Thread

[Doodlebuckets]

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 !

[clydejones]

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

Glad to help

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

[clydejones]

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?

[clydejones]

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

[Doodlebuckets]

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.

[Doodlebuckets]

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

[Doodlebuckets]

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.

[clydejones]

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.

[Doodlebuckets]

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 :)