Ceon URI Mapping v4.x

[conor]

Hi,

always? i'm given a directory of "D:/webpages/apo/.htaccess" to place the .htaccess file. according to my webhost, my website is in "D:/webpages/apogee-new" and he had to create an apo directory to install it

Oh dear. Maybe not always then. Unless... are you using the latest 4.0.7? Creating a new directory is definitely the wrong way to go, the .htaccess file should be in the Zen Cart directory.. the "newly created" directory won't ever be used!

Anyway, just get in contact with FTP and admin details and I'll see if I can get things sorted, would be quicker than having a conversation here.

All the best...

Conor
ceon

[badmonkeybotanicals]

Conor, the / worked. Thanks again for your time I should have tried it like your installation check said before but I was being very cautious to follow the directions.

I'm sure I will be making a purchase of the URI manager software soon, this is an invaluable software for zen cart users who are interested in getting the most out of the search engines.

Thanks again!!!!!!!

[conor]

Hi,

Conor, the / worked. Thanks again for your time I should have tried it like your installation check said before but I was being very cautious to follow the directions.

I'm sure I will be making a purchase of the URI manager software soon, this is an invaluable software for zen cart users who are interested in getting the most out of the search engines.

Thanks again!!!!!!!

Really glad to hear that you that was all that was needed.. I like simple "fixes"! :)

Also glad to hear you really like the software, thanks for the nice feedback, it makes the time spent coding it feel that more worthwhile.

I hope it does indeed help your site do better!

All the best...

Conor
ceon

[stecrox]

Hi Ceon
I am attempting to install the module and after following your instructions I have attempted to run the install in Modules Ceon URI Mapping (SEO) Config and I get this error
"Database table can not be created! The database user does not have CREATE TABLE privileges!"

I am using Zen Cart version 1.3.9h
This is a new install and this is the first module I am attempting to install. I have since Installed two other modules without any problems
The site is hosted with IINET as I am based in Australia and they use Apache with the rewrite module.
Your help would be appreciated.

Stephen

[conor]

Hi Stephen,

I get this error
"Database table can not be created! The database user does not have CREATE TABLE privileges!"

Quite simply this error message is telling you that your Zen Cart database user appears to only have USAGE privileges for the database.

When this happens it often means that your MySQL server is broken. You should probably get it fixed.

Ceon URI Mapping has code built into it to get round a broken server such as yours.

Go back to the Ceon URI Mapping (SEO) Config page in admin - modules and append

?override-db-privileges-check=1

to the end of the address in the browser's URI bar and press return.

The database tables should then be created.

If not, then you'll need to adjust the privileges of your database user appropriately.

Hope you like the software, it took a huge amount of time to write.

All the best...

Conor
ceon

[stecrox]

Conor

Thank you.
It appears to have resolved the issue.
I have just spoken to the Host Company who were also monitoring the forum.
They advised the issue is that they don't give admin rights but only Create / amend writes etc. As a result the check that was carried out in the code threw up the error.
Brilliant override and they say well done for answering so quickly.

Stephen

[conor]

Hi Stephen

Glad you're sorted now.

Could you run the following SQL command and send me the results please:

SHOW GRANTS;

In 4.0.8 I may rewrite things to try and create the tables without checking the permissions first, for servers such as your which aren't configured "quite right".

Thanks,

Conor
ceon

[damiantaylor]

I finally got round to upgrading to the latest version of uri mapping and everything works perfectly...even better than the previous version with the canonical support thrown in, so thanks Conor!

I use a variable in one of my other mods called $request_uri which contained the mapped path of the current page, for example 'Clothing/Jackets'.

This variable doesn't seem to be populated any more in the latest version.

Can you tell me where I can get the current mapped path name from?

Thanks!

[conor]

Hi Damian,

I finally got round to upgrading to the latest version of uri mapping and everything works perfectly...even better than the previous version with the canonical support thrown in, so thanks Conor!

No problem, glad you like it! And glad you're back on a supported version, 4.x is indeed much better as you've seen!

I use a variable in one of my other mods called $request_uri which contained the mapped path of the current page, for example 'Clothing/Jackets'.

This variable doesn't seem to be populated any more in the latest version.

It is now an internal class property.

You don't need to use it though, you can just pull the information you want from $_SERVER['REQUEST_URI'].

Hope that helps!

All the best...

Conor
ceon

[damiantaylor]

Thanks Conor,
I ended up using preg_replace('/\?.*$/', '', $_SERVER['REQUEST_URI']) to get rid of the zenid from the querystring but it seems to work fine now