Ceon URI Mapping v4.x

The links are stored in the table DB_PREFIX. ceon_uri_mappings. Searching the uri field should identify the presence of the existing mappings.

As to the issue seen, yes, there is such a "memory" it is one of the strengths of this uri mapping. There is no need to populate an htaccess file with redirects to the items in the store as the software makes every previously existing link one hop to the current and all current links are directly used. The presence of the cPath information which is discussed in the instruction indicates that the product is located outside of its master category and is appended to maintain the canonical link.

Generally speaking a link should point to one location and one location only, which is why the "conflict" is being seen when trying to again add a "new" category/product with the same name as has been stored in the database. A site that has been in operation with that link for a period of time would want users to be able to get to that location again (rather than receiving a broken link notification). However, in this situation where it has been generated but not really existed for long, there is less of an issue as it is less likely to have been indexed or otherwise stored "yet".

mc12345678:

The links are stored in the table DB_PREFIX. ceon_uri_mappings. Searching the uri field should identify the presence of the existing mappings.

mc12345678, I truly appreciate your expertise and the helpful information you've provided. I've been looking for the table DB_PREFIX ceon_uri_mappings - I'm assuming this should be located in the database? Many thanks again!

luckystu:

mc12345678, I truly appreciate your expertise and the helpful information you've provided. I've been looking for the table DB_PREFIX ceon_uri_mappings - I'm assuming this should be located in the database? Many thanks again!
DB_PREFIX is a constant that is assigned in both the includes/configure.php and YOUR_ADMIN/includes/configure.php. It should be the same in both files.

Whatever the value is ('bob_', 'cart_', 'green_', or even ''), should be prepended to ceon_uri_mappings ('bob_ceon_uri_mappings', 'cart_ceon_uri_mappings', 'green_ceon_uri_mappings', or 'ceon_uri_mappings') to identify the database table that should contain the uris in question.

mc12345678:

Whatever the value is ('bob_', 'cart_', 'green_', or even ''), should be prepended to ceon_uri_mappings ('bob_ceon_uri_mappings', 'cart_ceon_uri_mappings', 'green_ceon_uri_mappings', or 'ceon_uri_mappings') to identify the database table that should contain the uris in question.

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!

luckystu:

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:

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.

mc12345678:

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.

Thanks, mc, ran the query and looked for the results in the database but they're not there so I assume we're not looking in the right place - where would the results be located? Many thanks.

luckystu:

Thanks, mc, ran the query and looked for the results in the database but they're not there so I assume we're not looking in the right place - where would the results be located? Many thanks.

I've obviously not doing something right in trying to help. So let's take this one step at a time with known information.

First of all to answer the above question, running the query in tools->install sql patches will not display the results for security reasons. The query needs to be executed in a tool such as phpmyadmin in the cPanel of your site. There are other similar tools.

So, to be sure to offer a query that is likely to target just the desired product uri, please identify the vaUe of DB_PREFIX identified in YOUR_ADMIN/includes/configure.php where YOUR_ADMIN is the renamed admin directory used to access the admin side.

Then what is the product uri that is being attempted and rejected as being a duplicate. Include the -, _ or other separator that is used when generating uris.

mc12345678:

The query needs to be executed in a tool such as phpmyadmin in the cPanel of your site. There are other similar tools.

So, to be sure to offer a query that is likely to target just the desired product uri, please identify the vaUe of DB_PREFIX identified in YOUR_ADMIN/includes/configure.php where YOUR_ADMIN is the renamed admin directory used to access the admin side.

We ran the query from phpmyadmin and it says it was successful, however we still can't find the results. Talked with our hosting tech support and they said the results should display right after the query is run but they do not. We used your code from above, mc, inserting the proper DB_PREFIX identified in both configure.php files. So as a hypothetical example, if we want to use "flowers" as a category name, which had been previously created and then deleted but is still not being "released" due to a mapping conflict, this is the query executed:

SELECT uri FROM (our DB_PREFIX)_ceon_uri_mappings WHERE uri like '%flowers%';

Is this correct and where would the query results be located? Sorry this is taking much longer than expected, really appreciate your help!

luckystu:

We ran the query from phpmyadmin and it says it was successful, however we still can't find the results. Talked with our hosting tech support and they said the results should display right after the query is run but they do not. We used your code from above, mc, inserting the proper DB_PREFIX identified in both configure.php files. So as a hypothetical example, if we want to use "flowers" as a category name, which had been previously created and then deleted but is still not being "released" due to a mapping conflict, this is the query executed:

SELECT uri FROM (our DB_PREFIX)_ceon_uri_mappings WHERE uri like '%flowers%';

Is this correct and where would the query results be located? Sorry this is taking much longer than expected, really appreciate your help!

If you have accessed phpmyadmin, on the left side have selected not only the database associated with this site, but also the table (DB_PREFIX)ceon_uri_mappings and then on the right side selected the button/option along the top to run a sql query and entered into the query (let's assume the prefix is 'fun'):

SELECT uri FROM funceon_uri_mappings WHERE uri LIKE '%flowers%';

and then executed the query.

Then I too would expect the results to be provided below the representation of the query. Those results may be a statement of 0 results returned (or something similar) or 1 or more results in a column with the heading of the column being uri and each row showing the full content of the field returned.

If, in this case, the database being viewed is the active database that is reporting the attempt to duplicate mapping, then there should be at least one result that comes back.

Note the minor difference in how I represented the DB_PREFIX being used compared to how it was previously represented. ((DB_PREFIX)ceon_uri_mappings as compared to (DB_PREFIX)ceon_uri_mappings) While this may not seem to make a difference between you and me, it is important for others that may try to follow this. ZC does not add the underscore between the prefix and the table name. If one is to use a prefix, adding the underscore () at the end makes it easier for other database manipulations at some point in the future, but there is no requirement for there to be one. Nor is there a requirement to have/use a value in the DB_PREFIX.

mc12345678:

If you have accessed phpmyadmin, on the left side have selected not only the database associated with this site, but also the table (DB_PREFIX)ceon_uri_mappings and then on the right side selected the button/option along the top to run a sql query and entered into the query (let's assume the prefix is 'fun'):

SELECT uri FROM funceon_uri_mappings WHERE uri LIKE '%flowers%';

> and then executed the query.

Hi mc, cannot thank you enough for your help and patience, our problem is resolved! Followed your last instructions - of note, upon arriving at the SQL query window, a select command was already there and formatted, so I simply customized it to fit what we were looking for. The query produced multiple results, we deleted possible conflicting values, which finally released the category name we originally wanted to use.

May I just say, having the chance to look around the Ceon uri mapping structure at its core, I have a greater appreciation for the function of this program. Hope you'll enjoy a few cups of coffee on us and truly many thanks!

I've installed the latest version of CEON SEO URL's and when I go to the installation check page through the admin it goes to a blank white page. I am running Zen Cart 1.5.5f

Also my domain name is not live, its under the server IP temp url

Any ideas?

Nick1973:

I've installed the latest version of CEON SEO URL's and when I go to the installation check page through the admin it goes to a blank white page. I am running Zen Cart 1.5.5f

Also my domain name is not live, its under the server IP temp url

Any ideas?
What php version is being used?
What mydebug log information is available? (please obscure the admin directory name if/when posting here, and press the # button in the toolbar to capture the content in ```
[CODE][/CODE]

PHP 5.6. I'm aware that Zen Cart is supposed to now wok up to 7.1 but when I tried upgrading PHP it broke the site and the homepage wouldn't load. All I got was a 404 error. So I downgraded it back to 5.6

This is the error in the debug files.

PHP Parse error:  syntax error, unexpected '?' in /home/MYWEBSITEDIRECTORY/public_html/MYADMIN/includes/classes/class.CeonURIMappingInstallationCheck.php on line 2173

Just following up on my post above. I've just noticed that it appears that the homepage not loading and producing a 404 appears to be when SEO URL's is installed and nothing to do with PHP 5.6 or 7.1

This is what I found in the debug files. I have three duplicate sites with exactly the same template set, the only difference is that CEON SEO URL's is not installed and they are the same colour with different content.

[04-Sep-2018 16:53:54 UTC] Request URI: /~MYWEBSITEDIRECTORY/, IP address: 00.00.00.000
#1  preg_match() called at [/home/MYWEBSITEDIRECTORY/public_html/includes/functions/functions_general.php:1031]
#2  zen_back_link() called at [/home/MYWEBSITEDIRECTORY/public_html/includes/templates/template_default/templates/tpl_page_not_found_default.php:54]
#3  require(/home/MYWEBSITEDIRECTORY/public_html/includes/templates/template_default/templates/tpl_page_not_found_default.php) called at [/home/MYWEBSITEDIRECTORY/public_html/includes/templates/venturezen/common/tpl_main_page.php:179]
#4  require(/home/MYWEBSITEDIRECTORY/public_html/includes/templates/venturezen/common/tpl_main_page.php) called at [/home/vgd/public_html/index.php:97]

[04-Sep-2018 16:53:54 UTC] PHP Warning:  preg_match(): Unknown modifier 'v' in /home/MYWEBSITEDIRECTORY/public_html/includes/functions/functions_general.php on line 1031

what's on /includes/functions/functions_general.php on line 1031?

I have a couple of issues.

1. When I edit a product and/or add a product I got half of the page.

2. All my links didn't change even the module is in Enable.

Ok, I am getting this error:

[04-Sep-2018 17:27:34 America/Chicago] PHP Fatal error:  Uncaught Error: Call to undefined function zen_get_products_merkmale() in /home1/xxxxxx/public_html/galaxyhomedecor.com/manager/includes/modules/product/collect_info.php:329
Stack trace:
#0 /home1/xxxxxx/public_html/galaxyhomedecor.com/manager/product.php(137): require()
#1 {main}
  thrown in /home1/xxxxxx/public_html/galaxyhomedecor.com/manager/includes/modules/product/collect_info.php on line 329

wmorris:

Ok, I am getting this error:

[04-Sep-2018 17:27:34 America/Chicago] PHP Fatal error: Uncaught Error: Call to undefined function zen_get_products_merkmale() in /home1/xxxxxx/public_html/galaxyhomedecor.com/manager/includes/modules/product/collect_info.php:329
Stack trace:
#0 /home1/xxxxxx/public_html/galaxyhomedecor.com/manager/product.php(137): require()
#1 {main}
thrown in /home1/xxxxxx/public_html/galaxyhomedecor.com/manager/includes/modules/product/collect_info.php on line 329

Now I got it working, but now when I mouse over my subcategories on the main store I don't see my products. I get Error: 404 Page Not Found.

lankeeyankee:

what's on /includes/functions/functions_general.php on line 1031?

1031 to 1038

if (isset($_SERVER['HTTP_REFERER']) && preg_match("~^".HTTP_SERVER."~i", $_SERVER['HTTP_REFERER']) ) {
      //if (isset($_SERVER['HTTP_REFERER']) && strstr($_SERVER['HTTP_REFERER'], str_replace(array('http://', 'https://'), '', HTTP_SERVER) ) ) {
        $link= $_SERVER['HTTP_REFERER'];
      } else {
        $link = zen_href_link(FILENAME_DEFAULT);
      }
      $_SESSION['navigation'] = new navigationHistory;
    }

wmorris:

Now I got it working, but now when I mouse over my subcategories on the main store I don't see my products. I get Error: 404 Page Not Found.
One reason to get a 404 error relates to the either newly added or otherwise modified .htaccess file. ZC does not ship (because it does not need) with an htaccess file in the root of the store. This plugin (like other URI Rewriters that have been seen to work properly) requires a properly formatted/sequenced htaccess file. As has been done times before, the entire .htaccess file may need to be provided (though please obscure the admin directory name as it is provided in the template generated by the plugin.)

Also besides reviewing the instructions about the file and 404 issues, it is important to understand how this store is incorporated into the server with consideration of other stores on the server and any htaccess files in the directories above (before) the current store's root.

Now, all that said, you mentioned that there is a 404 issue when hovering over the images, does that mean you have been able to navigate the site with the rewritten uris, but only the images have an issue?