Link Manager 3.0 Support Thread

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

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]

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.