Hi,

Gertzy:

I was a database programmer years ago so know a bit about databases. :)

lol it's wasn't the SQL I was referring to per say, but the fact that I was outputting the SQL without an end quote in the PHP code.. it was the PHP that was messed up. Anyway... :)

Gertzy:

Actually, I have not added any manual database entries into the 3.8.0 table. I have looked at it and see this... I have created 6 x categories in Zen that act as spacers.... the way I did it was to create a category with a blank name...

One thing I will say about that is, I dont know how those 6 blank categories got into your mappings table because I KNOW, that I have never edited those 6 categories to manually get them into the URI database like I did with the 400 or so other categories... So a little confused with that..!!

Ceon URI Mapping will have automatically generated a URI whenever you edited these categories in the admin. So although you didn't manually modiofy the Ceon URI Mapping database, these "rogue" mappings still got in. The software simply wasn't built to cope with nameless categories, which is how we found ourselves in the situation that we did. :)

Not a big deal, just delete those mappings manually from your database and stop using "fake categories" for layout! :)

If you want to add a space you should actually just reprogram the categories sidebox so that it modifies the output HTML.

Having a category with no name will break auto-generation of all categories below that level.

So...

Move all your categories back to the parent level, delete the six fake ones and adjust the categories sidebox to preceed the categories' names with   after the first five.

Gertzy:

I agree that it is a good idea to put a line in the instructions for those that forget they have admin tools..

I'll add this reminder into a future version.

All the best...

Conor
ceon

uninstalled 3.8 and installed version 4 on 1.39h and all worked first time

thanks
bryan

Hi,

bn17311:

uninstalled 3.8 and installed version 4 on 1.39h and all worked first time

Yes, apart from the two minor slipups mentioned above, I'd done extensive testing.. so I suppose its good they were found so quickly as I don't expect anyone else to have any trouble, just like you didn't!

Hope you like the new version! :)

All the best..

Conor
ceon

bn17311:

uninstalled 3.8 and installed version 4 on 1.39h and all worked first time

thanks
bryan

How did you uninstalled 3.8? from admin?
I'm going to install v4.0 on 1.39h.

Hi,

hara:

How did you uninstalled 3.8? from admin?
I'm going to install v4.0 on 1.39h.

"Uninstall" isn't quite what he meant.. "remove the old 3.8 files" is what he was talking about. You don't remove the old module altogether, you don't actually "uninstall" 3.8.0.

Just follow the "Upgrading" instructions in the 4.0.0 documentation and you'll be fine.

All the best..

Conor
ceon

conor:

Hi,

"Uninstall" isn't quite what he meant.. "remove the old 3.8 files" is what he was talking about. You don't remove the old module altogether, you don't actually "uninstall" 3.8.0.

Just follow the "Upgrading" instructions in the 4.0.0 documentation and you'll be fine.

All the best..

Conor
ceon

Thank you for explanation Conor.

One shot. Work like a charm. Thank you for the great mod!

The following I need to find out why:
All products that added CEON url mapping the CAPTCHA not showing on both tell a friend and product review. But shows for the products not defined with CEON.

Hi,

hara:

One shot. Work like a charm. Thank you for the great mod!

Glad you like it.

hara:

All products that added CEON url mapping the CAPTCHA not showing on both tell a friend and product review. But shows for the products not defined with CEON.

The Captcha module needs to have its code updated.

You can read more in the last part of this FAQ ("Check the module's code..."):

When Ceon URI Mapping is enabled a module on the site doesn't work properly!

There's more info about a particular CAPTCHA program, it could be your one, I don't know, here:

http://www.zen-cart.com/forum/showpost.php?p=1046744&postcount=2882

http://www.zen-cart.com/forum/showpost.php?p=1046791&postcount=2883

If you're having trouble with this then I'm afraid I can't help you further here.. all the information a programmer would need is covered by the above links and the free support here doesn't cover helping with third party module programming issues.

All the best..

Conor
ceon

Gertzy - re: post 11, and post 21 - To alter the layout of the categories sidebox, I suggest you use Categories Dressing which supports many kinds of formatting and styling without fake category kludges.

gjh42:

Gertzy - re: post 11, and post 21 - To alter the layout of the categories sidebox, I suggest you use Categories Dressing which supports many kinds of formatting and styling without fake category kludges.

Okie dokies, I will have a look at that see if it cuts out what I am doing - cheers.

I found 2 categories out of control by CEON url mapping.
I can see correct path xxx.com/aaa-bbb from mouse touch, but click on the category the actual browser path showing "http://www.xxx.com/index.php?main_page=product_info&cPath=66&products_id=260"

All other categories are working fine with CEON, except for these two.

Hi,

hara:

I found 2 categories out of control by CEON url mapping.
I can see correct path xxx.com/aaa-bbb from mouse touch, but click on the category the actual browser path showing "http://www.xxx.com/index.php?main_page=product_info&cPath=66&products_id=260"

All other categories are working fine with CEON, except for these two.

That's a product URI.

So you must only have one product in each of those categories and Zen Cart is redirecting to the product page when you click on a category.

If you want a static URI for those pages, you need to generate a static URI for the products.

Whenever you add more products to those 2 categories, the category will no longer redirect to a product.

You like to ask lots of questions.. I hope that's you sorted now! :)

All the best..

Conor
ceon

conor:

Hi,

That's a product URI.

So you must only have one product in each of those categories and Zen Cart is redirecting to the product page when you click on a category.

If you want a static URI for those pages, you need to generate a static URI for the products.

Whenever you add more products to those 2 categories, the category will no longer redirect to a product.

You like to ask lots of questions.. I hope that's you sorted now! :)

All the best..

Conor
ceon
Yes, after adding url mapping for a product, the category working fine now. Thanks a lot!

Hello Conor, just having a small problem with historic URI's... Hope you can help....

I have gone and imported 2000+ records into the table... 'ceon_uri_mappings'.... they all went in OK on the import..

But, they are not working... I will try to explain best I can... The old site uses ultimate SEO...

The old link for the particular product that i am testing is similar to..... http://www.thedomain.co.uk/xxxxxx-xxxxxx-xxxxx-p-3333.html

so the entry into the 'ceon_uri_mappings' table has in the first field... '/xxxxxx-xxxxxx-xxxxx-p-3333.html' ...... and '0' for the current_uri...

So... When I do the test... http://www.testdomain.com//xxxxxx-xxxxxx-xxxxx-p-3333.html .... I get a 404 page not found...

So I tried a few changes.... I removed '.html' from the end of the data in the 'uri' field.... I tested the same again and got 404 error... But... I tried the hyperlink.... http://www.testdomain.com/xxxxxx-xxxxxx-xxxxx-p-3333 - So that works and brings up the actual proper page that was determined in the new CEON ..... But thats not going to work, because the people who click on links to the old naming method are going to have .html at the end of every link..?

Hope that all makes sense..!!

Cheers
Gertzy

Hi,

Gertzy:

But thats not going to work, because the people who click on links to the old naming method are going to have .html at the end of every link..

Please read the section of the FAQs/docs about modifying the rewrite rule to allow the rewriting of extensions like .html.

That should hopefully get you sorted.

v4.0.1 coming out later this evening.. small bugfix and two improvements.

All the best..

Conor
ceon

[QUOTE=conor;1048683]Hi,
Please read the section of the FAQs/docs about modifying the rewrite rule to allow the rewriting of extensions like .html.

QUOTE]

Ahhh, ok, never realised it was there. Found the FAQ, added the extra line to the .htaccess.. Works a treat now, thanks..

I will also look out for the 4.0.1 update...

Cheers
Gertzy

Just found myself a new question.

I see inside the SQL table for ceon_uri_mappings... That a colum called 'redirection_type_code'... Was previous occupied with '301' and since version 4.0.0 that particular field is now 'NULL'...

Is that right..?
Does it matter which?
Should I change the whole field records to NULL now?

Cheers
Gertzy

Hi Gertzy,

Gertzy:

Just found myself a new question.

Hopefully it's the last! :)

Gertzy:

Does it matter which?
Should I change the whole field records to NULL now?

That field is only used for alternate URIs.. it's not used at all for normal mappings. All normal redirections use 301.

All the best..

Conor
ceon

Hi,

Ceon URI Mapping v4.0.1 has now been released.

It fixes a bug and has some small improvements.

Upgrading from 4.0.0 to 4.0.1 should take around 10 seconds so be sure to upgrade now!

(Follow the short upgrading instructions in the documentation).

You can download the archive now from the Ceon website.

It should be available from the Zen Cart downloads area shortly.

From the Revision History:

[UPDATED] If auto-generation fails to generate a URI mapping (because a category/product/manufacturer/EZ-Page has no name), an informative error message is now displayed, instead of simply stating that no URI mapping was generated.

[UPDATED] The example rewrite rule generated by the software included a slash at the end of the admin exclusion. It has now been adjusted to remove this slash, so that the admin URI can be accessed without having to end it with a slash (http://store.com/admin can be used to access the admin, instead of insisting upon http://store.com/admin/ or http://store.com/admin/index.php etc.).

[BUGFIX] Existing URI mappings for auto-managed product pages weren't being converted to historical URI mappings whenever a new URI mapping was entered/generated for a product.

[REMOVED] Sample modified core files, and template override files, for Zen Cart versions 1.3.0 to 1.3.7 removed from the distribution. Every store should really upgrade to Zen Cart 1.3.9h as previous versions are bug-ridden!

Enjoy!

All the best...

Conor
ceon

Alright, this is kind of a strange problem.

I have two sites - bestcatholicposters.com and bestscientists.com, both built with the latest version of Zencart 1.39h.

Since bestscientists is the least trafficked, I installed ceon 4.0.1 on it.
Worked like a charm.
LOVED it.

So, I went to bestcatholicposters.com and installed it there.
Everything exactly the same, as far as I can tell.

Whenever I cut-and-paste the code into the .htaccess, the site responds with 500 Internal Server Error.

BEGIN CEON URI MAPPING REWRITE RULE

RewriteEngine On

ONLY rewrite URIs beginning with /zencart/

RewriteCond %{REQUEST_URI} ^/zencart/ [NC]

Don't rewrite any URIs ending with a file extension (ending with .[xxxxx])

RewriteCond %{REQUEST_URI} !.[a-z]{2,5}$ [NC]

Don't rewrite any URIs for some, popular specific file format extensions,

which are not covered by main file extension condition above

RewriteCond %{REQUEST_URI} !.(mp3|mp4|h264)$ [NC]

Don't rewrite any URIs for some specific file format extensions,

which are not covered by main file extension condition above

Uncomment the following line to apply this condition! (Remove the # at the start of the next line)

#RewriteCond %{REQUEST_URI} !.(3gp|3g2|h261|h263|mj2|mjp2|mp4v|mpg4|m1v|m2v|m4u|f4v|m4v|3dml)$ [NC]

Don't rewrite cPanel directories

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

Don't rewrite admin directory

RewriteCond %{REQUEST_URI} !^/zencart/zcadmin [NC]

Don't rewrite editors directory

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

Don't rewrite image files directory

RewriteCond %{REQUEST_URI} !^/zencart/image files/ [NC]

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

RewriteRule .* zencart/index.php [QSA,L]
#RewriteRule .* index.php?%{QUERY_STRING} [L]

END CEON URI MAPPING REWRITE RULE

I've eyeballed comparisoned everything I can think of - configuration and configuration_group, both .htaccess files, but I can't see why one works and the other doesn't.
I may have screwed up the second installation, but since it worked on the first one, I gotta believe it was something subtle.

Thoughts?