Ceon URI Mapping v4

[conor]

Hi,

I replied to your e-mail.. did you get my e-mail ok?

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''1' at line 10
in:
[ UPDATE ceon_uri_mappings SET uri = '' WHERE uri = '/' AND language_id = '1' AND current_uri = '1;]

Argh, I've tracked this and can see that you've found a bug.. the SQL is missing its closing quote.

This should affect very few people though as it is part of the _stripTrailingSlashesFromMappings() upgrade method.

This method runs whenever your previous set of 3.x mappings have any mappings that end with a slash.

In your case, you'd actually added an incorrect mapping, by manually adding a mapping for '/'.. a mapping was never required for the root of the site in version 3.8.0.

Still, it appears that one test I missed was for sites that had URIs with ending slashes.

I've fixed this and am re-releasing 4.0.0 without any notification about this and without creating a version 4.0.1.

I should really create a 4.0.1 but because only a small number of people have so far downloaded 4.0.0, the time saved in not doing so can help me get some better work done! :)

I'll also make tweak the method so it ignores this "unnecessary" root page mapping you had added.. didn't expect anyone to have added such a mapping! :)

Just an added bit of info for the upgrade. Section 9 of the instructions, the Installation check, it would not work for me until I had gone into "Tools" "Admin Settings" and entered a tick next to the new module "ceon uri mapping installation check"...

I understand why you needed to do that.. that's the "Admin Profiles" module. To be honest, that's really your responsibility to know how it works when you install it, but I guess it might be worth adding instructions for others who forget when they've got it installed to check its settings. :)

All the best...

Conor
ceon

[conor]

Hi,

I've fixed that upgrade method and re-released v4.0.0.. the version on the Ceon website has this fix in it.

There's a problem with the Zen Cart downloads area's upload page at the minute so until that's fixed please just use the link at the top of this thread (well, here it is again too).

All the best..

Conor
ceon

[kamelion0927]

This new version should run with the old version's .htaccess settings right?

I've uninstalled and reinstalled this mod three times in the last couple of days and my admin runs great but I can't access my site - it keeps giving me a 500 error with a file does not exist error in my cPanel.

I've tried modifying the

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

line in several different ways (including the way I had it before I upgraded) and it isn't working. I have also tried deleting the rest of the rewrites that I have set up in my .htaccess file to no avail.

And one other thing (though it's not a huge issue unless you're a total noob) when I ran the installation check, I was told that the line above needed to be

RewriteRule .* shindex.php [QSA,L]

which made me laugh because it just doesn't look right (and yes, I tried that line as well just to make sure). It also added a non-included line next to a rewrite rule

RewriteCond %{REQUEST_URI} ^/shop/ [NC]# Don't rewrite any URIs ending with a file extension (ending with .[xxxxx])

which also gave me an error (but google was kind enough to help me figure out what the problem was).

Any help would be extremely appreciated. Thanks in advance!

[kamelion0927]

...It also added a non-included line next to a rewrite rule

RewriteCond %{REQUEST_URI} ^/shop/ [NC]# Don't rewrite any URIs ending with a file extension (ending with .[xxxxx])

which also gave me an error (but google was kind enough to help me figure out what the problem was).

Any help would be extremely appreciated. Thanks in advance!

Sorry - I didn't add the fix to one of the issues in my last post and wanted to document it in case someone else needs it.

If you're getting a bad rewrite request error, make sure all not-included rewrite rules are on their own line. So to fix the problem above, make it look like this:

RewriteCond %{REQUEST_URI} ^/shop/ [NC]
# Don't rewrite any URIs ending with a file extension (ending with .[xxxxx])

[RobL]

Hi,
Getting the same error as kamelion0927.
I can access a product page via a direct link ok but cannot use the home button to get to the normal landing page
"/localhost/catalogue/" it just gives a blank page.
If i put in "/localhost/catalogue/index.php?main_page=index." note the "." it loads.
Don't know much about this sort of stuff but maybe it will help.

[conor]

Hi,

I can access a product page via a direct link ok but cannot use the home button to get to the normal landing page
"/localhost/catalogue/" it just gives a blank page.
If i put in "/localhost/catalogue/index.php?main_page=index." note the "." it loads.

I have never seen anything like that before. Maybe it's the same issue with the missing newline in the example rule.

Please re-download 4.0.0 and overwrite the files on your test site with the files from the "files" folder and that will let you produce the correct rewrite rule to put in your .htaccess file.

All the best...

Conor
ceon

[conor]

HI,

when I ran the installation check, I was told that the line above needed to be

RewriteRule .* shindex.php [QSA,L]

which made me laugh because it just doesn't look right (and yes, I tried that line as well just to make sure). It also added a non-included line next to a rewrite rule

RewriteCond %{REQUEST_URI} ^/shop/ [NC]# Don't rewrite any URIs ending with a file extension (ending with .[xxxxx])

I was able to replicate this problem. A "\n" was missing when the store used a subdirectory.

I've fixed this now.. the download archive's files include this fix. Again, not making this an official 4.0.1 update as so few people have this version.

Simply download the archive again and overwrite the files on your site with the files from the "files" folder and the example Rewrite Rule produced in the Installation Check will be the one you should use. I've tested this properly this time, sorry about earlier.

All the best..

Conor
ceon

[kamelion0927]

HI,



I was able to replicate this problem. A "\n" was missing when the store used a subdirectory.

I've fixed this now.. the download archive's files include this fix. Again, not making this an official 4.0.1 update as so few people have this version.

Simply download the archive again and overwrite the files on your site with the files from the "files" folder and the example Rewrite Rule produced in the Installation Check will be the one you should use. I've tested this properly this time, sorry about earlier.

All the best..

Conor
ceon

Thank you very much! I really appreciate your prompt response and help.

[conor]

Hi,

Thank you very much! I really appreciate your prompt response and help.

No problem! I've uploaded the updated archive now.

Good night!

All the best...

Conor
ceon

[kamelion0927]

Hi,



No problem! I've uploaded the updated archive now.

Good night!

All the best...

Conor
ceon

Night - you too.