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

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.

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

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.

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

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