close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 or 2018 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Apostrophe in category name messing me up

Thread began 6/13/2010 10:48 pm by julie383376 | Last modified 6/24/2010 1:21 pm by Eric Mittman | 1466 views | 5 replies |

julie383376

Apostrophe in category name messing me up

To help save my client some money, I've had her entering products in the database. She has made a category named

Jus Groovin' Retro

In addition, within that category there is a subcategory name in which she accidentally put an apostrophe.

So now I'm trying to help clean things up because the Admin is really bogging down (timing out and giving 500 page not found errors [tho a refresh of the page will eventually pull it up]).

Within Admin, if you are on a page that has the accordion menu on the left side and you click on the Jus Groovin' Retro category, nothing happens. Within category maintenance, if you click on "Edit Category Name", nothing happens. I have even tried to delete the whole category - again, the button won't work. (Same goes for the subcategory that has the accidental apostrophe at the end.) I am able to edit/delete other categories / subcategories, tho.

I'm pretty sure the apostrophe is what's freaking everything out, but I can't get in there to edit it out. I know NOTHING about MySQL, so even if editing the database was acceptable in this situation, I wouldn't know how to do it.

Can you give me some tips or a solution to getting those dang apostrophes out of there? :)

Thanks!

~J

Sign in to reply to this post

Eric Mittman

If the records are in the db already like this then you will need to update them in the db. To do this you will need to search products and categories tables for the item or category and then update it when you find it.

Do you use phpMyAdmin for administering your MySQL db? This tool and most others have an option for you to browse or view the records in a table. You can do it this way and just find the product/category name and update it. For now you can just remove it then update it agagin in the admin area.

I'm also including updated copies of the categories_Results.php, Product_Update.php and Product_Insert.php pages for you. These pages belong in the Admin folder and can replace the default files in here. Make sure that you create a backup of your files first in case there are any problems.

Attached Files
allow ' and %22 in product and category names.zip
Sign in to reply to this post

julie383376

Thank you for your reply, Eric. I'm sorry I haven't responded before now, but I was pulled away on some other sites...

I replaced the pages on the site with the ones you provided, but I still can't delete that category or subcategory.

As for editing the DB, the server has MySQL Administrator and MySQL Query Browser. I'm really nervous about messing with the DB, and while I figured out how to look at ps3_productcategories contents (I think), I only see numbers, no category names... Beyond that, I don't know how to delete a category...

My husband and I own a small ISP, so we host all my sites. If you would like to open a ticket, I can give you my user name and password to remote desktop to the server and maybe you can delete that category for me?

~J

Sign in to reply to this post

Eric Mittman

If you have the query browser installed then you should be able to go into the PS3 db and find the table name ps3_categories. This is the table that holds the name and id of the category. You will need to edit the record here to remove the apostrophe. Once you do this and save your changes you should then be able to update it with the new pages I posted.

If you have any further trouble with this let me know and I will get you a ticket opened.

Sign in to reply to this post

julie383376

Woohoo! I figured out how to edit the field name, then I was able to go in and delete the category.

I have a new problem now :) - will start a separate post for it.

Thanks!

~J

Sign in to reply to this post

Eric Mittman

Glad to hear that, thanks for starting a new thread, it helps keep things organized.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...