Ceon URI Mapping (SEO)

I have tried going into phpMyAdmin and adding the mapping for each page into the database but I can't get it to work...the pages still show the same URL.

..does someone have a screen shot of their phpMyadmin so I can check I am inserting the right info?

I basically followed this: example

Then clicked 'Go'

Thanks

Hi,

pb4:

..does someone have a screen shot of their phpMyadmin so I can check I am inserting the right info?

That should have worked.

If it isn't for you then you may need to read up a bit on how to use PHPMyAdmin or get someone else in to help you as you may have messed up a previous database record creation attempt.

The example is perfect.

All the best...

Conor
ceon

Hi,

...I had about-us instead of about_us within the main_page field :blush:

Thanks again..working fine now :smile:

Great Mod...why is this not built into Zen Cart automatically? :dontgetit

Great support too and much appreciated :bigups:

Thank you!

Hi,

pb4:

...I had about-us instead of about_us within the main_page field :blush:

Thanks again..working fine now :smile:

That was a very easy mistake to make.. I've done similar while coding more times than I'd like to admit!

Glad things are sorted now.

All the best...

Conor
ceon

Hi,
I am using ZC 1.3.9h. In the modified core files list the following files are shown:

-includes/init_includes/overrides/init_add_crumbs.php (Zen Cart 1.3.5 - 1.3.9)
-includes/init_includes/overrides/init_canonical.php (Zen Cart 1.3.9 only)

But these files are not part of ZC 1.3.9. I don't have them in my init_includes/overrides directory. I also checked the 1.3.9h install pack and these files are not there.

Were these two files actually new, and not modified? Do I need to upload them? I just upgraded and don't want to add any files that could cause issues later. It took me two days to find the one little problem that made my upgrade go wrong, and I don't want to do any more trouble shooting this week :).

Thanks,
Lindsay

rusty79fj40:

Now when I try to access my products I get the following error :1146 Table 'my_database.TABLE_CEON_URI_MAPPINGS' doesn't exist
in:
[ SELECT language_id, uri FROM TABLE_CEON_URI_MAPPINGS WHERE main_page = 'product_info' AND associated_db_id = '265' AND current_uri = '1';]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I understand that I need the db table(s). I am just not sure what is preventing the db script from running?!

rusty79fj40:

Well folks.. thanks for the help! I wiped everything and got it to work on the third try. :smile:

What did you do to fix this????
I am on my second . I have the exact same problem. What did you so?

Thanks,
Lindsay

Hi,

lsullivan:

But these files are not part of ZC 1.3.9. I don't have them in my init_includes/overrides directory.

The clue is in the name.. "overrides".

The overrides directory is where files from the non-overrides directory are place to override the files.

lsullivan:

I am on my second . I have the exact same problem. What did you so?

Once you've uploaded all the files go to Modules - Ceon URI Mapping Config

That should create the database tables.

If it doesn't your permissions are messed up and you'll need someone to give you CREATE TABLE permissions.

All the best...

Conor
ceon

I'm a first-time user of 3.8.0 and have a basic question about the stylesheet.css link. I've googled and searched but this thread is a monster and I can't find any help yet.

The old style URLs were e.g. http://www.premierrange.co.uk/index.php?main_page=blah. So every file is fetched relative to /index.php. I have a bunch of links that just say "lib/foo" and "images/blah" and, relative to /, they work.

Now, Ceon SEO is using the URL e.g. http://www.premierrange.co.uk/category-one/subcat-two/product. This means every resource fetched is now relative to /category-one/subcat-two, and all my "lib/" and "images/" links don't work. Do I understand this correctly, or should these work somehow and I've missed something?

Moving on from this standpoint...

A basic product page doesn't render for me, because stylesheet.css isn't loaded. html_header.php contains a loop with this:

    echo '<link rel="stylesheet" type="text/css" href="' . $template->get_template_dir('.css',DIR_WS_TEMPLATE, $current_page_base,'css') . '/' . $value . '" />'."\n";

So, that generates output like:

<link rel="stylesheet" type="text/css" href="includes/templates/premierrange/css/stylesheet.css" /> 
<link rel="stylesheet" type="text/css" href="includes/templates/premierrange/css/stylesheet_css_buttons.css" /> 

These get 404 Not Found responses. This is because, as in the out-of-the-box zen cart, I have these in configure.php:

  define('DIR_WS_CATALOG', '/');
  define('DIR_WS_HTTPS_CATALOG', '/');

  define('DIR_WS_IMAGES', 'images/');
  define('DIR_WS_INCLUDES', 'includes/');
[cut]
  define('DIR_WS_TEMPLATES', DIR_WS_INCLUDES . 'templates/');

As before, a link of "includes/" doesn't work, relative to the seo friendly URI I'm using.

Is this wrong?

Should I prepend a "/" to the DIR_WS_TEMPLATES variable? And any others? I'm just approaching this problem and wondering how many tweaks I'll have to make, and what the best approach is.

Cheers!
Nick

Hi Nick,

I didn't reply to your e-mail yet as I've been working on the software all day but I see you couldn't wait. :)

neekfenwick:

I'm a first-time user of 3.8.0 and have a basic question about the stylesheet.css link.

You are missing the base href tag from your html_header.php file. Your custom template must have messed that up.

Put the tag back in, making sure it's as near to the top of the <head> as possible and all links will be relative to that base instead of teh static URI, letting CSS and JS files load.

All the best..

Conor
ceon

conor:

I didn't reply to your e-mail yet as I've been working on the software all day but I see you couldn't wait. :)
My boss can't wait. He drives me up the wall. He has this SEO expert breathing down our necks wanting payment and Boss won't pay him until all his recommendations are implemented, which means we need URI mappings like yesterday.

conor:

You are missing the base href tag from your html_header.php file. Your custom template must have messed that up.

Good call. I took the <base> tag out years ago, because IE6 simply failed with it in. Took me some annoying debugging to find that out.

It's fixed the problem :)

Now my custom zen_image thumbnailer solution has stopped working.. but that's another story.. ceon mods didn't affect zen_image() so let me dig around and see what's going on. Oh, for a decent PHP debugger :( XDebug doesn't want to connect for me so I'm reduced to error_log and echo. Pity the fool.

Nick

Hi Conor,
I can't see the module in my admin page. I read all the pages in this support forum and I totally understand that I missed something during installation. I have double checked my files many times, but I know that I need to go through again because there must be an issue somewhere.

Since many people have had this issue could I have some tips on the most important files to focus on?

Also, you mentioned create database table permissions. I have added other mods that created tables, such as free dangling carrot. I know that I have permission to create database tables. But I can't remember if I needed to make an adjustment to the permissions in myPHPadmin, or if the tables were created automatically. If you have any tips that would be great.

Thanks,
Lindsay

lsullivan:

Hi Conor,
I can't see the module in my admin page. I read all the pages in this support forum and I totally understand that I missed something during installation. I have double checked my files many times, but I know that I need to go through again because there must be an issue somewhere.

Since many people have had this issue could I have some tips on the most important files to focus on?

Also, you mentioned create database table permissions. I have added other mods that created tables, such as free dangling carrot. I know that I have permission to create database tables. But I can't remember if I needed to make an adjustment to the permissions in myPHPadmin, or if the tables were created automatically. If you have any tips that would be great.

Thanks,
Lindsay

I can't see the module in my admin page. I read all the pages in this support forum and I totally understand that I missed something during installation. I have double checked my files many times, but I know that I need to go through again because there must be an issue somewhere.Go back and make sure if you are using a custom folder name for admin and your template, that you rename Ceon URI Mapping admin, and the template_default to the same name that you are using. A lot of people miss these steps for some odd reason. Make sure you do the same for the modified_core_files also.

Ok, I am really stuck... I'm pretty sure i've put everthing in the correct folders, and executed the rewrite correctly, but my URL's aren't showing in the new format??

Does anyone have any ideas on what this can be, i've changed a couple to test but they are not showing correctly?

Thanks:unsure:

Hi,

lindsey80:

Ok, I am really stuck... I'm pretty sure i've put everthing in the correct folders, and executed the rewrite correctly, but my URL's aren't showing in the new format??

Does anyone have any ideas on what this can be, i've changed a couple to test but they are not showing correctly?

To be honest it only ever turns out to be user error when installing.

I can take a quick look for you, send me FTP and admin details at this address.

Yes, the baby picture has worked. ;)

All the best...

Conor
ceon

countrycharm:

Go back and make sure if you are using a custom folder name for admin and your template, that you rename Ceon URI Mapping admin, and the template_default to the same name that you are using. A lot of people miss these steps for some odd reason. Make sure you do the same for the modified_core_files also.

Thank you for the tip, but that is not a problem for me.

Thanks,
Lindsay

lindsey80:

Ok, I am really stuck... I'm pretty sure i've put everthing in the correct folders, and executed the rewrite correctly, but my URL's aren't showing in the new format??

Just installing and configuring the add-on doesn't set up any new URI's. At least with 3.8.0, you then have to visit the configuration page at least once (Modules->CEON URI Mapping), see that it has "Offer Auto-generation of URIs for Categories, Products, Manufacturers and EZ-Pages" checked, then just Edit a Category or Product as normal and click Update.

When editing, you should see a blank URI Mapping textbox at the bottom of the page, and when you Preview you should see the auto-generated URI Mapping at the bottom. After that the mapping is stored in the database and your store should start using it.

This is mentioned in the docs "configuration" page as the first point: "This module DOES NOT automatically add mappings for EXISTING Categories/Products/Manufacturers/EZ-Pages!". I suggest you re-read that :)

Hi,

lsullivan:

Thank you for the tip, but that is not a problem for me.

Lindsay's problem was that she had Admin Profiles installed but forgot to enable the Ceon URI Mapping files whenever she installed the module, so it didn't show up in the admin.

ANYONE WHO HAS ADMIN PROFILES INSTALLED:

Don't forget that you need to change its settings anytime you install **any **module that has an admin part to it!

If you cannot see Ceon URI Mapping in the admin, follow the above instructions!

All the best...

Conor
ceon

My installation has gone well until I ran into a Flash video player that refused to work. I discovered that my .ogv and .webm files in html5 <video> tags played fine, but mp4 files did not. They were returned with a Content-Type of "text/html" and a size of 41K. After some messing around with mime.types and AddType, I figured out this was the same size as my index.php serves, and the .mp4 file request was being rewritten and hitting the index page instead of trying to serve the .mp4 file at all.

I think the rewrite rule for "files with an extension" don't work for extensions with a number in them. i.e.:

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

This matches ogv and webm, but not mp4.

As a proof-of-concept, adding my own rule to specifically ignore .mp4 files fixed the problem:

RewriteCond %{REQUEST_URI} !\.mp4$ [NC]

Could this "file extensions" rule be enhanced somehow? Perhaps:

RewriteCond %{REQUEST_URI} !\.[a-zA-Z0-9]{2,5}$ [NC]

I don't know what specific cases you might know of that you're trying to handle or avoid with your very restrictive [a-z].

Hi Nick,

neekfenwick:

I think the rewrite rule for "files with an extension" don't work for extensions with a number in them. i.e.:

No, they don't.. by default the "example" rule just excludes files with a textual extension: .jpg, jpeg, .html, .shtml, .png, .pdf etc.

This is because most people don't have numbers in their file extensions, whereas some people might have a dot and a combination of numbers and letters in their URI, e.g.

/widgets/large-widget-10.3mm

So the example rule lets that URI work.

As every site is different I had to choose an "Example" rule that best fits the *majority *of sites.. and the majority of Zen Cart sites use neither .mp3 nor .mp4.

Sorry that you got affected by this but obviously you saw that the solution is simple for you.

If I ever get time I might update the docs with more info on this.. but I'm spending 10 hours a day coding v4 as it is and I might leave adding extra info to the docs for a few months (the documentation already has a section on how to add support for extra file extensions).

Glad you're sorted now anyway.

All the best...

Conor
ceon

Goodness folks, these free mods are supported by folks on their time and their dime.. NO ONE is gonna write a free mod that covers EVERY SINGLE Zen Cart configuration out there..

That said Conor's instructions are detailed and that is more than I can say for a LOT of mods where the readme files are sketchy at best.. The .httaccess file EXAMPLES in the Ceon URI Mapping add-on readme are just that -- EXAMPLES. Meaning they cover the most COMMON server/store configurations and they MAY NOT work for your particular server/store configurations..

conor:

Hi Nick,

No, they don't.. by default the "example" rule just excludes files with a textual extension: .jpg, jpeg, .html, .shtml, .png, .pdf etc.

This is because most people don't have numbers in their file extensions, whereas some people might have a dot and a combination of numbers and letters in their URI, e.g.

/widgets/large-widget-10.3mm

So the example rule lets that URI work.

As every site is different I had to choose an "Example" rule that best fits the *majority *of sites.. and the majority of Zen Cart sites use neither .mp3 nor .mp4.

Sorry that you got affected by this but obviously you saw that the solution is simple for you.

If I ever get time I might update the docs with more info on this.. but I'm spending 10 hours a day coding v4 as it is and I might leave adding extra info to the docs for a few months (the documentation already has a section on how to add support for extra file extensions).

Glad you're sorted now anyway.

All the best...

Conor
ceon