Ceon URI Mapping v4.x

[luckystu]

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!

[mc12345678]

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.

[luckystu]

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!

[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?

[mc12345678]

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] tags.

[Nick1973]

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

[Nick1973]

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