Ceon URI Mapping (SEO)

[dajiaoyazi]

After installation, why always appear 404 error.
http://k3miao.com/Ying-Jian

[alan145]

[QUOTE=conor;883880]Hi Alan,
I'm glad you like the module but why are you posting asking what the new features "will be like"?

Why don't you just install the module?
QUOTE]

Hello Conor,
today, I installed 3.4.1, I just upload the files to overwrite the currently module 3.2.4 I use, Also I use the compare tool like beyond compare to keep my important content,
all are well, when visit the website, and it didn't appear problem,
but when I log in the admin, I found it display

1060 Duplicate column name 'excluded_files'
in:
[ ALTER TABLE ceon_uri_mapping_configs ADD `excluded_files` TEXT DEFAULT NULL AFTER `char_str_replacements`;]
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.

PS: I don't change admin file name, what can I do now. Thank you.
Alan

[conor]

Hi Alan,

Oh dear. That's a bug in the auto-upgrade script. It is running the auto-upgrade code for versions 3.2.0-3.2.2 when you are upgrading from 3.2.4!

Sorry about that!

I've released a new version of the module with the bugfix for this.

You can download it now:

Download version 3.4.2

The only files that have changed are

admin/ceon_uri_mapping_auto_upgrade.php
admin/ceon_uri_mapping_config.php

Copy those two files into your store's admin folder and then go to the Ceon URI Mapping Config and this time it will upgrade properly!

All the best...

Conor
ceon

[MikeyG]

Conor,

Just testing this on a local host on WAMP PHP5.2, ZenCart 1.3.9b with your sage pay form and if I cancel out of the sagepay form from the test server I am not getting back to the site/check out page.

I have just tried it with the URL mapping turned off and still the same problem - this might be a Sagepay form issue rather than the URL Mapping so sorry if I have posted in the wrong section

MikeyG

[piker]

I need urgent help with this one...
(This problem definitely has something to do with the URI mapping as everything works when its disabled.)
It relates to my product listing pages.
I look at page1 and thats ok. I hover the mouse over the link for page2 and it shows: ?sort=2a&page=2. I click it and it goes to page2 but the link says: ?sort=2apage=2. At this stage I can view page2 ok.
I click on the page3 products page and the link shows: ?sort=2appage=3. It breaks and goes to page1, although it shows the page 3 link at the top of the page.
I haven't made any spelling mistakes here...it changes from "2a&page" to "2apage" to "2appage" .
I am running the latest version 3.4.2

[piker]

Just looking at my Google Webmaster Tools reports and I also have a long string of 406 errors occurring just after I upgraded to 3.4.0 from 3.2.4.
They all go along the lines of....?alpha_filter_id=76page%3D1page%3D1page%3D1page%3D1page%3D1page%3D1page=1& sort=4d
Would these also be related to the Produst Page problem?
I currently have URI disabled, so as to allow people to keep using the site, but of course this will throw up a lot of errors to the Google search bots. Would it be a good idea to temporarily write redirects to all of my 215 products (and categories) until I sort this? I don't want my ranking to suffer..

[conor]

Hi,

I click on the page3 products page and the link shows: ?sort=2appage=3.

This really is complicated software! :)

I was just looking at the code and noticed that changes in 3.4.0 to make cleaner URIs would remove an extra ampersand if the main query string parameter for a mapped URI wasn't at the start of a URI.. this can happen if the likes of sort parameters are used but precede the main query string parameter (which only happens in some places and not in others). When I saw your post I knew exactly what could be causing it and upon testing it on our test server found the same thing.

I've released a new version. 3.4.3 with a bug fix for this.

From the revision history:

[BUGFIX] Code introduced in 3.4.0 to remove extra ampersands from the URI was being overzealous and removing an extra ampersand whenever the primary query string parameter for a mapped URI was not at the start of the query string, but was instead preceded by other query parameters. This broke the preceding and following query string parameters as the name of the following parameter was being appended to the preceding parameter's value.


ALL USERS MUST UPGRADE!

Versions 1.0.0 - 3.4.2 are NO LONGER SUPPORTED BY CEON.


The only files that have changed between 3.4.3 and 3.4.2/3.4.1 are

files/admin/ceon_uri_mapping_config.php

modified_core_files/YOUR_ZC_VERSION/includes/functions/html_output.php

(Once you've copied over these files don't forget to go to the configuration in the admin to have the database updated to the latest version).


To upgrade from versions 1.0.0-3.4.0 you will need to follow the upgrade instructions in the documentation.


Sorry about the bug but as I said., these things can be complex sometimes and hard to spot! Glad I did though (and good timing for your bug report too! :) ).


Download version 3.4.3 now!

All the best..

Conor
ceon

[Scott_C]

Hi Conor, this looks like a great module and Im keen to get it working.

Just seem to be having an issue. I have a test version of our live store running in a subdirectory (1.3.9b) and Ive tried to install the Ceon URI Mapping (SEO) add-on.

ive carefully gone through and copied all files - including core files from the 1.3.9b folder in your download (3.4.3)

But when i get to step 3 of your instructions about creating the database tables, I click through to; Admin>Modules>Ceon URI Mapping (SEO) - and I simply get a blank page.

If I go to EZ Pages to open a file I get an error about the table not existing.

It appears that the tables are not being created in the database? Is there perhaps a seperate SQL query I can run in phpMyAdmin?

Sorry if im missing something obvious here, but im fairly certain ive followed the instructions properly.

Cheers,

Scott.

[conor]

Hi Scott,

Glad you like the software!

But when i get to step 3 of your instructions about creating the database tables, I click through to; Admin>Modules>Ceon URI Mapping (SEO) - and I simply get a blank page.

A blank page means a PHP error. You'll have to enable error reporting/display errors in admin/includes/configure.php to see what you've done wrong.

It sounds like you haven't in fact uploaded all the files. You should reupload them all again.. the most likely cause of the error would be an attempt to load a required file failing (like includes/extra_datafiles/ceon_uri_mapping_config.php) or a function being missing because the functions files haven't been loaded.

Hope that helps!

All the best..

Conor
ceon

[Scott_C]

Hi Conor, thanks Ill have another look. Im downloading the error logs in the cache folder to see if I can shed some light.

Cheers,

Scott.