Ceon URI Mapping V5.0

At what point in time (and, more importantly, why) did the .htaccess addition for the Ceon URI Mappings become so complex?

I recently upgraded a site from zc155f and this is the only addition to that file ... and it works just fine:

<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule .* index.php [QSA,L]
</IfModule>

I don't remember it ever being any simpler than a huge list.

torvista:

I don't remember it ever being any simpler than a huge list.
Hmm, I'll note that all of the previous files were timestamped 2018-06-12 and class.CeonURIMappingVersion.php shows

$this->_version = '4.4.3';

lat9:

At what point in time (and, more importantly, why) did the .htaccess addition for the Ceon URI Mappings become so complex?

I recently upgraded a site from zc155f and this is the only addition to that file ... and it works just fine:

torvista:

I don't remember it ever being any simpler than a huge list.

Same, as far as I've always known it's been a copy and paste operation that works just fine as well.

Me personally? The above appears to involve more server effort than filtering down the content list. The above offered code compares each web request against the file system, if it is a file or a directory then it is directly accessed, if it is not then ZC processes the request.

Seems to me a further means to easily be malicious as there is no preset/expected structure and if somehow a file is maliciously written then creating a folder structure off of the root similar to a product's URL would allow "replacing" the page's content with an applicable file and barely notice the issue.

Besides as I recall, the on-screen instructions indicate that there are other ways or perhaps changes necessary to obtain the necessary results. For example, I usually have to modify the line of the generated RewriteRule on the server I use currently. Either it is because of the server or the way I use the program, I'm not sure, but the modification is simple (Either I have to remove or add a leading forward slash.)

Does it work on 2.0.1?

torvista:

Yes:
https://github.com/torvista/Zen-Cart_CEON-URI-Mapping

Doesn't seem to work with new installs. At a minimum, the responsive_classic customization for html_header.php would need to change because of changes to MobileDetect. But I still can't get it to rewrite URLs on a new install using responsive_classic.

But I still can't get it to rewrite URLs on a new install using responsive_classic.
Me neither!

I've always managed to avoid digging into the infernal internals, since it wasn't broken...on a cursory look last night I saw how the observer pulled static links out of the db for the various pages but didn't see the mechanism for generating a new link/storing it in the db when one did not exist, so that's a starting point.
No chance to do that today.

When I looked at it quickly, it appeared that the NOTIFY_SEFU_INTERCEPT observer wasn't being hit, which it consistent with your finding. Haven't had time to dig in yet.

The observer was working correctly to pull links from the db....which was empty...and I didn't see any code to handle "if empty")...because there isn't any!

As I've always used UMM, and never read the instructions, I'd not realised that:

This module DOES NOT automatically add mappings for EXISTING Categories/Products/Manufacturers/EZ-Pages!
If the site has existing Categories/Products/Manufacturers/EZ-Pages, they'll continue to use the standard Zen Cart dynamic URIs, until a URI has been entered or auto-generated for them, by editing the respective Category/Product/Manufacturer/EZ-Page in the admin.

This means going in and editing every Category/Product/Manufacturer/EZ-Page for which a static URI mapping is desired.
...
Our URI Mappings Manager software has the ability to auto-generate URI mappings for all/selected Categories/Products/Manufacturers/EZ-Pages/Other Zen Cart Pages at once.

So, once you edit a product and generate the static url...it works as advertised.

Back to work.

I did not realize that either - all the sites I manage that use this have used it forever so their list of URLs is fully populated. Thanks for tracking this down.

How do you fix an URL that redirect to the wrong EZ-Page?

The ez-page also a correct uri pointing to it ( the one displayed in ezpage admin) so changing the ez-page id would work.

For example:

url abc.com/flowers points to ez page id 1 ( correct as per admin options)

url abc.com/roost points to ez page id 1 ( wrong and no way to delete the url or change the ez page id)

I looked into phpmyadmin but i am not able to edit the associated_id in the ceon_uri_mappings table

It states:

Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available

Any way around this? how can i delete the url in question?

Thank you

Can you not search on uri like roost?

Or you could export-edit-import the table.

nicksab:

How do you fix an URL that redirect to the wrong EZ-Page?

The ez-page also a correct uri pointing to it ( the one displayed in ezpage admin) so changing the ez-page id would work.

For example:

url abc.com/flowers points to ez page id 1 ( correct as per admin options)

url abc.com/roost points to ez page id 1 ( wrong and no way to delete the url or change the ez page id)

I looked into phpmyadmin but i am not able to edit the associated_id in the ceon_uri_mappings table

It states:

Any way around this? how can i delete the url in question?

Thank you

I run SQL queries from within phpmyadmin whenever I want to edit the 'ceon_uri_mappings' table, backup your database and run this query:

UPDATE ceon_uri_mappings SET associated_db_id=REPLACE(associated_db_id,'1','???') WHERE uri='/roost' AND main_page='page';

(replace ??? with the new id for /roost)

or you could delete the whole line using an appropriate DELETE query (that's not Zen Cart related so you might need to do a bit of research)

thank you

zen version 2.01 fresh install everything was working

installed:
zen version 2.01
IH5
Ceon 5.11

Admin says it is up to date and coughed up the info to enter into the root .htaccess file.
I entered the info and now get the white page of nothingness

Log says

[20-Sep-2024 15:47:41 UTC] Request URI: /market/index.php?main_page=product_info&products_id=1, IP address: 172.103.65.146, Language id 1
#0 /home/fantasies/public_html/market/includes/classes/category_tree.php(127): zen_debug_error_handler()
#1 /home/fantasies/public_html/market/includes/modules/sideboxes/categories.php(18): category_tree->zen_category_tree()
#2 /home/fantasies/public_html/market/includes/modules/column_left.php(30): include('/home/fantasies...')
#3 /home/fantasies/public_html/market/includes/templates/responsive_classic/common/tpl_main_page.php(142): require('/home/fantasies...')
#4 /home/fantasies/public_html/market/index.php(94): require('/home/fantasies...')
--> PHP Warning: Undefined array key "categories_image" in /home/fantasies/public_html/market/includes/classes/category_tree.php on line 127.

[20-Sep-2024 15:47:41 UTC] Request URI: /market/index.php?main_page=product_info&products_id=1, IP address: 172.103.65.146, Language id 1
#0 /home/fantasies/public_html/market/includes/classes/category_tree.php(153): zen_debug_error_handler()
#1 /home/fantasies/public_html/market/includes/modules/sideboxes/categories.php(18): category_tree->zen_category_tree()
#2 /home/fantasies/public_html/market/includes/modules/column_left.php(30): include('/home/fantasies...')
#3 /home/fantasies/public_html/market/includes/templates/responsive_classic/common/tpl_main_page.php(142): require('/home/fantasies...')
#4 /home/fantasies/public_html/market/index.php(94): require('/home/fantasies...')
--> PHP Warning: Undefined variable $first_element in /home/fantasies/public_html/market/includes/classes/category_tree.php on line 153.

[20-Sep-2024 15:47:41 UTC] Request URI: /market/index.php?main_page=product_info&products_id=1, IP address: 172.103.65.146, Language id 1
#0 /home/fantasies/public_html/market/includes/classes/category_tree.php(161): zen_debug_error_handler()
#1 /home/fantasies/public_html/market/includes/classes/category_tree.php(153): category_tree->zen_show_category()
#2 /home/fantasies/public_html/market/includes/modules/sideboxes/categories.php(18): category_tree->zen_category_tree()
#3 /home/fantasies/public_html/market/includes/modules/column_left.php(30): include('/home/fantasies...')
#4 /home/fantasies/public_html/market/includes/templates/responsive_classic/common/tpl_main_page.php(142): require('/home/fantasies...')
#5 /home/fantasies/public_html/market/index.php(94): require('/home/fantasies...')
--> PHP Warning: Undefined array key "" in /home/fantasies/public_html/market/includes/classes/category_tree.php on line 161.

[20-Sep-2024 15:47:41 UTC] Request URI: /market/index.php?main_page=product_info&products_id=1, IP address: 172.103.65.146, Language id 1
#0 /home/fantasies/public_html/market/includes/classes/category_tree.php(161): zen_debug_error_handler()
#1 /home/fantasies/public_html/market/includes/classes/category_tree.php(153): category_tree->zen_show_category()
#2 /home/fantasies/public_html/market/includes/modules/sideboxes/categories.php(18): category_tree->zen_category_tree()
#3 /home/fantasies/public_html/market/includes/modules/column_left.php(30): include('/home/fantasies...')
#4 /home/fantasies/public_html/market/includes/templates/responsive_classic/common/tpl_main_page.php(142): require('/home/fantasies...')
#5 /home/fantasies/public_html/market/index.php(94): require('/home/fantasies...')
--> PHP Warning: Trying to access array offset on null in /home/fantasies/public_html/market/includes/classes/category_tree.php on line 161.

[20-Sep-2024 15:47:41 UTC] Request URI: /market/index.php?main_page=product_info&products_id=1, IP address: 172.103.65.146, Language id 1
#0 /home/fantasies/public_html/market/includes/classes/category_tree.php(168): zen_debug_error_handler()
#1 /home/fantasies/public_html/market/includes/classes/category_tree.php(153): category_tree->zen_show_category()
#2 /home/fantasies/public_html/market/includes/modules/sideboxes/categories.php(18): category_tree->zen_category_tree()
#3 /home/fantasies/public_html/market/includes/modules/column_left.php(30): include('/home/fantasies...')
#4 /home/fantasies/public_html/market/includes/templates/responsive_classic/common/tpl_main_page.php(142): require('/home/fantasies...')
#5 /home/fantasies/public_html/market/index.php(94): require('/home/fantasies...')
--> PHP Warning: Undefined array key "" in /home/fantasies/public_html/market/includes/classes/category_tree.php on line 168.

[20-Sep-2024 15:47:41 UTC] Request URI: /market/index.php?main_page=product_info&products_id=1, IP address: 172.103.65.146, Language id 1
#0 /home/fantasies/public_html/market/includes/classes/category_tree.php(168): zen_debug_error_handler()
#1 /home/fantasies/public_html/market/includes/classes/category_tree.php(153): category_tree->zen_show_category()
#2 /home/fantasies/public_html/market/includes/modules/sideboxes/categories.php(18): category_tree->zen_category_tree()
#3 /home/fantasies/public_html/market/includes/modules/column_left.php(30): include('/home/fantasies...')
#4 /home/fantasies/public_html/market/includes/templates/responsive_classic/common/tpl_main_page.php(142): require('/home/fantasies...')
#5 /home/fantasies/public_html/market/index.php(94): require('/home/fantasies...')
--> PHP Warning: Trying to access array offset on null in /home/fantasies/public_html/market/includes/classes/category_tree.php on line 168.

[20-Sep-2024 15:47:41 UTC] Request URI: /market/index.php?main_page=product_info&products_id=1, IP address: 172.103.65.146, Language id 1
#0 /home/fantasies/public_html/market/includes/classes/category_tree.php(173): zen_debug_error_handler()
#1 /home/fantasies/public_html/market/includes/classes/category_tree.php(153): category_tree->zen_show_category()
#2 /home/fantasies/public_html/market/includes/modules/sideboxes/categories.php(18): category_tree->zen_category_tree()
#3 /home/fantasies/public_html/market/includes/modules/column_left.php(30): include('/home/fantasies...')
#4 /home/fantasies/public_html/market/includes/templates/responsive_classic/common/tpl_main_page.php(142): require('/home/fantasies...')
#5 /home/fantasies/public_html/market/index.php(94): require('/home/fantasies...')
--> PHP Warning: Undefined array key "" in /home/fantasies/public_html/market/includes/classes/category_tree.php on line 173.

[20-Sep-2024 15:47:41 UTC] Request URI: /market/index.php?main_page=product_info&products_id=1, IP address: 172.103.65.146, Language id 1
#0 /home/fantasies/public_html/market/includes/classes/category_tree.php(173): zen_debug_error_handler()
#1 /home/fantasies/public_html/market/includes/classes/category_tree.php(153): category_tree->zen_show_category()
#2 /home/fantasies/public_html/market/includes/modules/sideboxes/categories.php(18): category_tree->zen_category_tree()
#3 /home/fantasies/public_html/market/includes/modules/column_left.php(30): include('/home/fantasies...')
#4 /home/fantasies/public_html/market/includes/templates/responsive_classic/common/tpl_main_page.php(142): require('/home/fantasies...')
#5 /home/fantasies/public_html/market/index.php(94): require('/home/fantasies...')
--> PHP Warning: Trying to access array offset on null in /home/fantasies/public_html/market/includes/classes/category_tree.php on line 173.

[20-Sep-2024 15:47:41 UTC] Request URI: /market/index.php?main_page=product_info&products_id=1, IP address: 172.103.65.146, Language id 1
#0 /home/fantasies/public_html/market/includes/classes/category_tree.php(185): zen_debug_error_handler()
#1 /home/fantasies/public_html/market/includes/classes/category_tree.php(153): category_tree->zen_show_category()
#2 /home/fantasies/public_html/market/includes/modules/sideboxes/categories.php(18): category_tree->zen_category_tree()
#3 /home/fantasies/public_html/market/includes/modules/column_left.php(30): include('/home/fantasies...')
#4 /home/fantasies/public_html/market/includes/templates/responsive_classic/common/tpl_main_page.php(142): require('/home/fantasies...')
#5 /home/fantasies/public_html/market/index.php(94): require('/home/fantasies...')
--> PHP Warning: Undefined array key "" in /home/fantasies/public_html/market/includes/classes/category_tree.php on line 185.

[20-Sep-2024 15:47:41 UTC] Request URI: /market/index.php?main_page=product_info&products_id=1, IP address: 172.103.65.146, Language id 1
#0 /home/fantasies/public_html/market/includes/classes/category_tree.php(185): zen_debug_error_handler()
#1 /home/fantasies/public_html/market/includes/classes/category_tree.php(153): category_tree->zen_show_category()
#2 /home/fantasies/public_html/market/includes/modules/sideboxes/categories.php(18): category_tree->zen_category_tree()
#3 /home/fantasies/public_html/market/includes/modules/column_left.php(30): include('/home/fantasies...')
#4 /home/fantasies/public_html/market/includes/templates/responsive_classic/common/tpl_main_page.php(142): require('/home/fantasies...')
#5 /home/fantasies/public_html/market/index.php(94): require('/home/fantasies...')
--> PHP Warning: Trying to access array offset on null in /home/fantasies/public_html/market/includes/classes/category_tree.php on line 185.

[20-Sep-2024 15:47:41 UTC] Request URI: /market/index.php?main_page=product_info&products_id=1, IP address: 172.103.65.146, Language id 1
#0 /home/fantasies/public_html/market/includes/classes/category_tree.php(188): zen_debug_error_handler()
#1 /home/fantasies/public_html/market/includes/classes/category_tree.php(153): category_tree->zen_show_category()
#2 /home/fantasies/public_html/market/includes/modules/sideboxes/categories.php(18): category_tree->zen_category_tree()
#3 /home/fantasies/public_html/market/includes/modules/column_left.php(30): include('/home/fantasies...')
#4 /home/fantasies/public_html/market/includes/templates/responsive_classic/common/tpl_main_page.php(142): require('/home/fantasies...')
#5 /home/fantasies/public_html/market/index.php(94): require('/home/fantasies...')
--> PHP Warning: Undefined array key "" in /home/fantasies/public_html/market/includes/classes/category_tree.php on line 188.

[20-Sep-2024 15:47:41 UTC] Request URI: /market/index.php?main_page=product_info&products_id=1, IP address: 172.103.65.146, Language id 1
#0 /home/fantasies/public_html/market/includes/classes/category_tree.php(188): zen_debug_error_handler()
#1 /home/fantasies/public_html/market/includes/classes/category_tree.php(153): category_tree->zen_show_category()
#2 /home/fantasies/public_html/market/includes/modules/sideboxes/categories.php(18): category_tree->zen_category_tree()
#3 /home/fantasies/public_html/market/includes/modules/column_left.php(30): include('/home/fantasies...')
#4 /home/fantasies/public_html/market/includes/templates/responsive_classic/common/tpl_main_page.php(142): require('/home/fantasies...')
#5 /home/fantasies/public_html/market/index.php(94): require('/home/fantasies...')
--> PHP Warning: Trying to access array offset on null in /home/fantasies/public_html/market/includes/classes/category_tree.php on line 188.

[20-Sep-2024 15:47:41 UTC] Request URI: /market/index.php?main_page=product_info&products_id=1, IP address: 172.103.65.146, Language id 1
#0 /home/fantasies/public_html/market/includes/classes/category_tree.php(205): zen_debug_error_handler()
#1 /home/fantasies/public_html/market/includes/classes/category_tree.php(153): category_tree->zen_show_category()
#2 /home/fantasies/public_html/market/includes/modules/sideboxes/categories.php(18): category_tree->zen_category_tree()
#3 /home/fantasies/public_html/market/includes/modules/column_left.php(30): include('/home/fantasies...')
#4 /home/fantasies/public_html/market/includes/templates/responsive_classic/common/tpl_main_page.php(142): require('/home/fantasies...')
#5 /home/fantasies/public_html/market/index.php(94): require('/home/fantasies...')
--> PHP Warning: Undefined array key "" in /home/fantasies/public_html/market/includes/classes/category_tree.php on line 205.

[20-Sep-2024 15:47:41 UTC] Request URI: /market/index.php?main_page=product_info&products_id=1, IP address: 172.103.65.146, Language id 1
#0 /home/fantasies/public_html/market/includes/classes/category_tree.php(205): zen_debug_error_handler()
#1 /home/fantasies/public_html/market/includes/classes/category_tree.php(153): category_tree->zen_show_category()
#2 /home/fantasies/public_html/market/includes/modules/sideboxes/categories.php(18): category_tree->zen_category_tree()
#3 /home/fantasies/public_html/market/includes/modules/column_left.php(30): include('/home/fantasies...')
#4 /home/fantasies/public_html/market/includes/templates/responsive_classic/common/tpl_main_page.php(142): require('/home/fantasies...')
#5 /home/fantasies/public_html/market/index.php(94): require('/home/fantasies...')
--> PHP Warning: Trying to access array offset on null in /home/fantasies/public_html/market/includes/classes/category_tree.php on line 205.

in the code for the htaccess page admin said everything was fine
The line above in red...should I remove that file or is there an edit it needs.

I suggest you use updated files for starters:

https://github.com/torvista/Zen-Cart_CEON-URI-Mapping

probably nothing to do with your error, but FYI.

I am upgrading from Zen Cart 1.5.5f to 2.1.0.
I used Ceon-URL-Mapping with 1.5.5f, I upgraded the database and i am using it with my testing 2.1.0,
I do not need to install the tables for Ceon-URL-Mapping, do i?
if not how do i skip the tables creation? Thanks.

If you upgraded, the tables should still be there. An upgrade does not wipe anything, a clean install does...but even so, it probably would not wipe tables that are not ZC core.

torvista:

If you upgraded, the tables should still be there. An upgrade does not wipe anything, a clean install does...but even so, it probably would not wipe tables that are not ZC core.

Thanks for the quick reply.

I am worried about installing Ceon URL Mapping will replace the tables i have already since all the URL for my pages in those tables.

The installer is automatic....if the tables are already installed, it's already done...why and how are you thinking of repeating the install?

torvista:

why and how are you thinking of repeating the install?

I am installing Ceon Url mapping on zen cart 2.1.0 which i am using a database upgraded from 1.5.5f and already has the tables for Ceon which was installed on it.