Hi,

Mike_Dean:

Does this include the suggested changes that were discussed in "that" thread about the indexing and speed issues ? :wink:

The lack of an index is part of the speed issue! :)

Yes, I've tested Christian's suggestions (thanks again Christian) and they are included in 3.6.3.

I've decided to completely restructure the database into multiple tables for 4.0.0 though so this is a temporary measure to increase the speed for large sites.. 4.0.0 should hopefully see even greater efficiencies/speed increases! :)

I'll be posting a request for comments on my proposed changes for 4.0.0 soon as a new thread.. I hope all here will add their thoughts once I've done so! :)

As always both 3.6.3 and 4.0.0 will feature auto-upgrade functionality so upgrading will be simple!

All the best..

Conor
ceon

I got my web hosts to install the module as I know nothing about the backend of zencart, the module appears in the Zencart Admin in Configuration and Modules sections but the mapping fields sections are not there when I go to edit a product or category? My edit or add new category/product pages are the same as before the mod. I hope you can help. Many thanks.

Hi,

StueyJH:

I got my web hosts to install the module as I know nothing about the backend of zencart, the module appears in the Zencart Admin in Configuration and Modules sections but the mapping fields sections are not there when I go to edit a product or category? My edit or add new category/product pages are the same as before the mod. I hope you can help. Many thanks.

I'm afraid your hosts haven't installed the software properly then. It sounds like they've only uploaded the contents of the "files" folder and then haven't made the changes to the categories/products admin pages using the sample files in the "modified_core_files" folder.

Please ask then to complete the installation or to carry it out all over again!

All the best..

Conor
ceon

Hi,

It gives me great pleasure to release what is hopefully the last of the 3.x branch of Ceon URI Mapping!

Discussions are beginning for a significant change to the database structure for 4.0.0. Please contribute your thoughts here.

This is an essential upgrade for any large stores with lots of mappings as it brings some nice speed optimisations suggested by Christian Pinder.

All other stores should upgrade also as free support from Ceon will only be available for version 3.6.3 from now on.. Upgrading should only take a few minutes.

Version 3.6.3 also has improved auto-generation formatting of names with "special" characters in them.

From the Revision History:

[UPDATED] URI mapping lookup query updated to use a LIKE operator before the REGEXP operator. Limits the number of records that have to be examined by the REGEXP, resulting in vastly superior performance when the URI mappings table is large (especially if it is too large to be cached in memory by the SQL server software). Code update by Christian Pinder.

[INTERMED] Index added to the database table, for categories/products/EZ-pages, to speed up URI mapping. Gives a noticeable improvement with very large sites with tens of thousands of products. Thanks for suggestion for index format goes to Christian Pinder. Database structure shall be changing entirely in 4.0.0 for further optimisations (As always all changes are managed by the auto-upgrade functionality of the software).

[UPDATED] When URIs are being auto-generated, any forward slashes, pipe characters, plus symbols, colons, semicolons, brackets, square brackets or angle brackets in the name of a category/product/manufacturer/EZ-page will now be converted to a space, then replaced by the whitespace replacement character. This means that names with those characters in them will no longer have the words joined together.

[ADDED] Sample modified core files for Zen Cart 1.3.9d added to the distribution.

The distribution can be downloaded immediately here.

It has also been submitted to the Zen Carts downloads area and should be available there shortly.

Enjoy!

And please don't forget to make your voice heard on the Ceon URI Mapping Version 4.0.0 thread.

All the best..

Conor
ceon

improved auto-generation formatting , it will autogenerate the urls?

Hi,

rxalex:

improved auto-generation formatting , it will autogenerate the urls?

No, it simply results in better URIs with names like "CD/DVD" becoming "cd-dvd" instead of "cddvd".

All the best..

Conor
ceon

conor:

Hi,

No, it simply results in better URIs with names like "CD/DVD" becoming "cd-dvd" instead of "cddvd".

All the best..

Conor
ceon

So in other words Conor what you saying is that it will not autogenerate the urls like the simple seo add on does. I know what *DivaVocals said to do but that seems to take a while to do when I have a lot of products all ready. *

I intall a "ceon_uri_mapping_3.6.2_for_zc" the .htaccess files has been add on this follwing:

RewriteEngine On
# Don't rewrite any URIs ending with a file extension (ending with .[xxxx])
RewriteCond %{REQUEST_URI} !.[a-zA-Z]{2,4}$
# Don't rewrite admin directory
RewriteCond %{REQUEST_URI} !^/admin.* [NC]
# Don't rewrite editors directory
RewriteCond %{REQUEST_URI} !^/editors.* [NC]
# Don't rewrite cPanel directories
RewriteCond %{REQUEST_URI} !/cpanel.* [NC]
RewriteCond %{REQUEST_URI} !/frontend.* [NC]
# Handle all other URIs using Zen Cart (index.php)
RewriteRule (.*) index.php?%{QUERY_STRING} [L]

I find after .htaccess files changed, my Auto data feed script (.php) cannot read and doesn't work.
Do I done anything wrong or I have to do something extra?
Please help.many thanks

You'll need to change the order of the rules, as it is likely they are interacting with each other, or else add an exclusion to stop those requests being incorrectly processed.

Additionally, delete the trailing .* characters from every RewriteCond line. They are not required.

Thanks for your reply, I has been remove the .* characters

RewriteEngine On
# Don't rewrite any URIs ending with a file extension (ending with .[xxxx])
RewriteCond %{REQUEST_URI} !.[a-zA-Z]{2,4}$

Don't rewrite admin directory

RewriteCond %{REQUEST_URI} !^/admin [NC]

Don't rewrite editors directory

RewriteCond %{REQUEST_URI} !^/editors [NC]

Don't rewrite cPanel directories

RewriteCond %{REQUEST_URI} !/cpanel [NC]
RewriteCond %{REQUEST_URI} !/frontend [NC]

Handle all other URIs using Zen Cart (index.php)

RewriteRule .* index.php?%{QUERY_STRING} [L]

The Auto data feed script (.php) still been block.
I thing need to add something exclusion to allow the script (.php) can be access, but I don't know how?:blink:

als88:

Thanks for your reply, I has been remove the .* characters

RewriteEngine On
# Don't rewrite any URIs ending with a file extension (ending with .[xxxx])
RewriteCond %{REQUEST_URI} !.[a-zA-Z]{2,4}$
# Don't rewrite admin directory
RewriteCond %{REQUEST_URI} !^/admin [NC]
# Don't rewrite editors directory
RewriteCond %{REQUEST_URI} !^/editors [NC]
# Don't rewrite cPanel directories
RewriteCond %{REQUEST_URI} !/cpanel [NC]
RewriteCond %{REQUEST_URI} !/frontend [NC]
# Handle all other URIs using Zen Cart (index.php)
RewriteRule .* index.php?%{QUERY_STRING} [L]

The Auto data feed script (.php) still been block.
I thing need to add something exclusion to allow the script (.php) can be access, but I don't know how?:blink:

Problem has been fixed in the end, this is a great module, thanks

Hi Conor,
I really want to get FEC 1.8.1 working with this mod.
I've got a clean install of 1.3.9D, running on php5.3.0.
Only mods installed at this time are: FEC 1.8.1 and Ceon URI 3.6.3

On the checkout page, when clicking the "Change Address" button, FEC pops up a box for you to do that like so:

When URI is turned on, the box just keeps loading:

I've tried adding to the the exclude files:
/fec/fec_change_new_address.php?type=change_shipping_address,
/fec/fec_change_new_address.php?type=change_payment_address

Also added to .htaccess file:

RewriteCond %{REQUEST_URI} !^/facebox.* [NC]
RewriteCond %{REQUEST_URI} !^/fec.* [NC]

Is there anything else I could try to get these two fab mods to work together?

Thanks :)

Hi,

nsanford:

I really want to get FEC 1.8.1 working with this mod.
I've got a clean install of 1.3.9D, running on php5.3.0.
Only mods installed at this time are: FEC 1.8.1 and Ceon URI 3.6.3

I'm guessing that this new version of FEC has scripts which call the Zen Cart system directly. Rewrite conditions won't affect anything.

All the information you need is in the documentation, in the section "Ensuring 100% Compatibility with Third Party Zen Cart Modules - Specifying Individual Files to be Excluded from URI Mapping".

(More that likely from what you've posted the excluded file's path should be:

/fec/fec_change_new_address.php

I'm sure that'll get you sorted.

All the best..

Conor
ceon

Fixed! I had an incorrect exclude file path :wacko: and now it all works brilliantly. I should've read more carefully, sorry about that.

Hi,

nsanford:

Fixed! I had an incorrect exclude file path :wacko: and now it all works brilliantly. I should've read more carefully, sorry about that.

No problem, just glad to hear you got things working.

All the best..

Conor
ceon

Conor,
I am back once again.
After fixing the issue I had before, I updated your product to 3.6.3.
I have gone through the site and redid all the mappings but it doesn't seem to do it. Could you please help.

Thanks

Hi,

Burnin Carbon:

I have gone through the site and redid all the mappings but it doesn't seem to do it. Could you please help.

I don't what "it" is. You should describe your problems better in future!

Please get in contact at this address with FTP and admin details for your site and a description of the problem you are having and I'l take a quick look to see if I can see what's wrong.

All the best..

Conor
ceon

conor

just testing this on a local host running wamp php 5.2.8 apache 2.2.11 zen cart is 1.3.7 - the back end seems to do its bit but when I click on a product or category which has had its URL updated although the URL changes the page is the front home page of the site.

I have gone through everything again carefully to make sure all files are copied but cannot see the error. Any pointers

Let me know what other infor you need

Hi Mikey,

MikeyG:

I have gone through everything again carefully to make sure all files are copied but cannot see the error. Any pointers

Let me know what other infor you need

The home page shows when a 404 should be displayed but the Zen Cart setting for 404 is set to display the home page, so that could possibly be what's happening. If it is I'm not sure why you'd be having that problem.

As it's on your local computer I'm afraid I can't check it out obviously.. maybe try sending me your htaccess file via this address.

All the best..

Conor
ceon

Displaying the home page for any 404 error is nowadays going to land up being reported as a "Soft 404 Error" in Google WebmasterTools reports, and is flagged as a negative factor in site quality. I'd highly caution against that.