I can't rename or delete certain Categories

Hi guys,

I've run into a problem as mentioned in the title... My client is a pet food distributor, and one of the vendors is called Dr. Harvey's. We will have three categories for most of the vendors, in this case they are... Dr. Harvey's Pet Food, Dr. Harvey's Treats and Dr. Harvey's Supplements.

The president was over here yesterday and I hadn't set up the categories in this way so I'm rearranging the products from the way I had them.

In renaming the categories for all of them I've had no problem... except for Dr. Harvey's. Both the Rename and Delete buttons move but no action results. No renaming popup. Nada.

I believe this is because of the apostrophe in Harvey's. That's because I tried making a new one without the period in Dr first and got the same result.

Is there a workaround? Will I need to find and then go into the database manually to get rid of the categories that will be rendered "bad" 'cause they'll still be showing up on the left menu list? (See below)

Ah! Wait! I do see in another thread that I can delete categories through the productcategories_Results.php page, so apologies for that. Oh, but that page is the page I'm already using with no result for this specific instance... back to the above question about the database. Actually, on further research, I think I'm going to have to delete and reinstall Wamp after saving the www folder and redo the database/table/categories/products...

But I would still like to ask... Is there a way to make it display the apostrophe in the name when it displays in the browser? Maybe by using ´ or ??

Thanks!

Iggy

UPDATE! I went into the database from PHPmyAdmin and put in the ´ that way instead of the apostrophe... and it worked! Woot!

So folks... -never- put an apostrophe in a Category name, it'll stop the code from finishing!

Thanks...

Iggy

Wow, well, now I know! I just had the same problem as you and could not figure out for the life of me what was occuring! You would think that WebAssist would make something like this way more obvious or find a fix for this fast, especially since they advertise the program as being easy for a developer to just set up and pass on to their clients! I can just imagine my client being more than frustrated if I had sent this to him and let him fill out all his categories and add products himself!

We are working on a fix for this problem and will have one available soon.

I am very pleased with you guys.

I should just note though for general help that having an apostrophe of any sort in a product name will prevent the Authorize.net processing from getting past line one.

Don't know if there's a similar issue with PayPal.

Of course that's not a WebAssist issue at all, just thought I should mention it as we discovered it through an order.

The post fix above works great with category names.

Be well,
Iggy

Yeah, authorize.net will only allow alpha numeric characters for the product name.

One way to get around that would be to use the str_replace function to convert the apostrophe to "´".

find the following code on the confirm page:

$AuthNet_itemized[0][$nextIndex] = "Name";

  $AuthNet_itemized[1][$nextIndex] = "".$WA_Store_Cart->DisplayInfo("Name")  ."";

and change it to:

$AuthNet_itemized[0][$nextIndex] = "Name";

  $AuthNet_itemized[1][$nextIndex] = "".str_replace("'", "´", $WA_Store_Cart->DisplayInfo("Name"))  ."";

Thanks Jason!

Actually, though, I should mention that as I worked out in this thread showthread.php?t=9690 I had originally replaced the ' in the category name with ´ already, (and later to &# 8217; ) because using just an ' stopped the PHP from working and I was unable to edit or even delete the category from the Admin and had to rename it through phpMyAdmin.

And then, shortly afterwards I made the same change to ´ in the product names as a precaution...

and when I placed an order I then discovered the Authorize issue... so I OMG and "fixed" it by changing all the product names to "xxx by Dr. Harvey" as opposed to "Dr. Harvey´s xxx".

I wonder how that would affect your new code, though... as the str_replace would be telling it to see the acute code, but Authorize apparently doesn't like the acute code as that's what was in there...

I should have been more detailed in what I'd said in the above post... apologies for that.

Strangeness!

OK, if converting it to the html entity doesn't work, you can still use the str_replace command to strip it out:

$AuthNet_itemized[0][$nextIndex] = "Name";

  $AuthNet_itemized[1][$nextIndex] = "".str_replace("'", "", $WA_Store_Cart->DisplayInfo("Name"))  ."";

That should do it! Thank you much, Jason.

Originally Said By: kari402386

  Wow, well, now I know! I just had the same problem as you and could not figure out for the life of me what was occuring! You would think that WebAssist would make something like this way more obvious or find a fix for this fast, especially since they advertise the program as being easy for a developer to just set up and pass on to their clients! I can just imagine my client being more than frustrated if I had sent this to him and let him fill out all his categories and add products himself!  

I don't think it's possible to see every potential problem that may occur with any product. I was once a factory auto tech and we were always fixing something that was unforeseen. I've found WA products to work very well right out of the box, and they've always helped post haste with quirks, once at 10:21pm on a Sunday.

And PHP is, well, PHP. Trying to remember the humorous quip about it that my engineering friend who was at Google said but I just can't find it in the nooks and crannies... I really should learn the language so I can stop harassing these guys.

Be well...

Btw, WA dudes, my CMS install went great! Used this thread's subject once, too... rad!