Quote Originally Posted by luckystu View Post
Our problem remains unsolved, was able to find the proper table in the database and deleted all URLs containing the category name we want to use again. Even took it a step further and deleted the original, previous URLs that we "recycled." After deleting, we attempted to start fresh and create the URL we want to use (again) but it continues to give an error message indicating a mapping conflict. Went over everything with a fine tooth comb and deleted each value necessary. Is there a time factor involved, meaning does it take a certain amount of time for deletions to clear out of the system? I assume they take effect immediately. Is there a location other than the database where the URLs in question are existing? Many thanks for any advice you have!
No, there is no timer involved. When the software is trying to create a new uri for a product it attempts to verify it's existence first. If it exists there is a conflict and that means that the occurrences have not been deleted. Don't forget about the "additional" uris such as those about reviews, etc...

A query to identify duplicate results would include a search of the uri field using the LIKE option, percent symbols at the front and back of the search term and the resulting term for the product. So the query for a product that was referenced as 'blue hat' in the original name my be found with the following query:
Code:
SELECT uri FROM ceon_uri_mappings WHERE uri like '%blue%';
Now this query will return every row that has the word blue in it, which could include a category name, manufacturer, etc... the records also would include those that are current and not, but the goal is to narrow down the query to be able to delete just the ones that are causing the mapping clash.