URL Alias

[Beachgirl]

I have set up the URL Alias and used the Automatic URL Alias Generator (very nice feature) but it appears that it generated SEO for my child categories and those links are now broken.

When reading up on this topic in the knowledge base ( viewtopic.php?f=22&t=25 ) it states that "It does not regenerate SEO for child categories or products." .... do I need to manually go through and change those all back or did I set it up wrong?

[Brent]

The automatic SEO Generator works fine for adding new products, manufacturers or categories.
It works in products for changing name or deleting.
The problem with categories occurs when you change the names of categories.
To amount of code required to handle this and the processing is about the same as complete regeneration if not more.
Just make your changes, go to url alias, and regenerate all SEO.
It's one step and deletes all SEO and recreates it again.

[Beachgirl]

I having a hard time understanding this one. Where do I make the changes? Do I need to rename "categories" in some code or file somewhere? Thanks

[Brent]

Give me an idea what you are doing and what results you are getting.

[Beachgirl]

I basically ran the "Generate SEO in URL Alias" (products and categories included) and now the child categories and search say "The page you requested cannot be found."

I don't understand the Regenerate part. When the instructions say: "you should regenerate the complete SEO in URL Alias." what exactly does this mean? Do I need to go and delete the child category in admin/catalog/category (which means I also need to remove from products that are linked to that category) then Insert the child category again (as new) ... then go back to to URL Alias and hit Generate again?

I also noticed that search will not work. I tried to replace the url alias with the original query "controller=search" but its still not finding the page. Sorry about all the questions, I really appreciate your help.

[Brent]

In admin/configuration/url alias, all you do is click the Generate SEO button at the top of the page.
It will generate SEO for categories/ products, and manufacturer
You will see all the urls generated.
If you are getting an error not found, it is probably your browser is caching the URLs.
Clear your browser cache.
When you regenerate the SEO, the cart cache is deleted and recreated the first time it is requested.

I think you are doing everything right. It is a simple process, one click and your done.

[Beachgirl]

I think I'm doing everything right too, but its just not working for my child categories and search. I cleared my browser cache and the cart cache but those pages still wont load. I also deleted all the url_aliases through phpMyAdmin and then regenerated and got the same result.

While I was in phpMyAdmin I did notice a few things that are different and wonder if these could be causing the conflict?

1. Under "product" it says "The following indexes appear to be equal and one of them should be removed: PRIMARY, product_id"

2. Collation was always set at utf8_unicode_ci on my local server but after I uploaded the database it changed to latin1_swedish_ci

[Brent]

It does appear your database is corrupt. Never had that one before.
On you local server, do a backup.
on the production server, change collation to utf8_unicode_ci .
Then copy the backup.sql into the SQL box in phpmyadmin and run.
That should restore the database on the production server to what is on you local server.
Then check the product table for duplicate primary.

Let me know what you find.

[leo]

Are the other links working? E.g. login or sitemap?

[Beachgirl]

All the other links are working fine, its only when trying to do a search and clicking on a child category do the I get the page not found error. The only other odd thing I've noticed is a few of my products will not show the cart module in the column (I've checked that quantity and status are correct) I've been adding a new product to replace it and it seems ok.

I will be gone all day but tonight or tomorrow I will do a restore on the database and let you know what happens. Thanks guys!