Ceon URI Mapping (SEO)

[conor]

Hi,

1054 Unknown column 'pages_title' in 'order clause'

This isn't a problem with the module I'm afraid.

It's a problem with your database! The error is saying that your ezpages database table is missing the pages_title column!

You'll have to restore the table to a working version or add that column back in.

I'm afraid I've no idea how that could have happened but I can assure you it wasn't any software from Ceon that did this.. you must have installed some bad software or made a mistake in PHPMyAdmin and accidentally deleted that column or something.

Hope you get this fixed!

If you can't fix it, please start a new thread, unfortunately this is nothing to do with the URI mapping module so I can't help you on this thread!

All the best..

Conor
ceon

[mercurysoun.it]

Sorry, I thought there was a connection because if I use the existing version of ezpages.php have no error (but does not appear at the bottom the ceon's function) If I use ezpages.php included in the installation I have this error.

[conor]

Hi,

Sorry, I thought there was a connection because if I use the existing version of ezpages.php have no error (but does not appear at the bottom the ceon's function) If I use ezpages.php included in the installation I have this error.

That means that your old version was a custom version or else from before Zen Cart 1.3!

The modifications made to that file for URI Mapping don't include anything to do with the pages_title column.

The easiset course of action for you is probably to "compare" your old version with the URI Mapping version and merge the custom changes you have with the additions the URI Mapping module makes.

A tool like "Beyond Compare" or "WinMerge" would be useful for that.

All the best...

Conor
ceon

[mercurysoun.it]

ok I will follow your advice
Thanks again and congratulations for the add

[toboldlygo]

Hi,
I just installed the URI Mapping mod and it is a great mod that seems to work well. However, I am having a bit of problem.

I have the User Tracking mod installed. When I go to look at the User log, I now get warning boxes pop up. The first box has the ZenAdminId and the zenid listed. I then click that box off and another box appears that says this:
strats_sa_surl_xss.nasl
This box appears twice. I then click those off and a warning box appears that says this:
mod_perl_status_uri_xss.nasl

These boxes never appeared prior to installing the Mapping mod and going to the tracking logs for the days prior to installation does not produce the warning boxes. They only appear for the days after installation. I am also seeing that an XSS attack was attempted on my server after I installed the mod.

Does allowing the URI rewrites necessary to make this mod work make XSS attacks possible? Am I now open to these attacks because of installing this mod?

A while back, Zen Cart posted a security fix for XSS attacks, which I installed. I believe it involved the replacement of some of the files the Mapping mod uses. I made sure that I used those security fix files and then added the necessary code from the Mapping mod files. Do these security fixes no longer function due to the additions of the new code?

I would appreciate any help you could give me.

Thanks,

[conor]

Hi,

I just installed the URI Mapping mod and it is a great mod that seems to work well. However, I am having a bit of problem.

I'm glad you like our software! Unfortunately I'm not familiar with the module you have described so there's nothing specific I can say about what is happening to you.

These boxes never appeared prior to installing the Mapping mod and going to the tracking logs for the days prior to installation does not produce the warning boxes. They only appear for the days after installation. I am also seeing that an XSS attack was attempted on my server after I installed the mod.

Does allowing the URI rewrites necessary to make this mod work make XSS attacks possible? Am I now open to these attacks because of installing this mod?

I can say though that I think you are probably experiencing what is called a "correlation".. although you are attributing things happening because of the module being installed, which is a "causation", I think in fact the module has nothing to do whatsoever with these things happening but may just be showing them up, or the timing may just be a coincidence and you did something else at the same time as installing the module which is causing the behaviour you have described.

A while back, Zen Cart posted a security fix for XSS attacks, which I installed. I believe it involved the replacement of some of the files the Mapping mod uses.

The URI mapping module only modifies a single file on the catalog side, html_output.php. So unless the XSS fix involved that file, installing the URI mapping module can't possibly have any effect.

If the fix you installed does use that file then you should merge the files using software like Beyond Compare or WinMerge.

I would appreciate any help you could give me.

Well there's a completely comprehensive answer for you! It's not this module so you know you can look elsewhere (or carry out a merge if html_output.php is the culprit). :)

All the best..

Conor
ceon

[mamin]

Hi
Couple of days ago I installed Ceon URI module on latest Zen Cart and all my old URL are working fine, however, if I add any of the new products, it is not showing in the category it was added.

If I disable Ceon URI Module, I can see the product correctly. What could be the issue ?

ZenCart Version: 1.3.8A
New Installation
Module Installed: Ceon URI
Windows IIS 7
URL rewriting by: ISAPI Rewrite 3.0


Thanks

[conor]

Hi,

Windows IIS 7
URL rewriting by: ISAPI Rewrite 3.0

The example rules provided with the module are all for the Apache webserver.

I've no idea how to get them to work with IIS. Hopefully someone else here does or you can get this figured out!

If you get this working please post back here with your solution so that others using IIS and ISAPI Rewrite can get it working as well.

Thanks!

All the best..

Conor
ceon

[sfklaas]

I have downloaded and installed this mod, and it is great! Pretty easy install and easy to follow documentation.

My problem: On one of my sites, I use the AJAX Image swapper mod that also incorporates the fual slimbox lightbox and Image Handler. None of my product images seem to load.

While searching through previous threads, I came across this:

For the benefit of others out there.. these missing pages in the error log are part of a module called fual slimbox lightbox. It builds relative paths to its javascript files as it (wrongly) assumes it will only ever be used from the base shop folder (e.g. / or /shop/). (This clearly isn't the case when you have /shop/books/life-is-good as the current URI for a product!).

As far as a solution to this problem to get my images up, i'm not sure which files I would need to modify. I need to keep the image swapper, but would love to keep the URI mod. Can I make both work together?

[conor]

Hi,

Glad you like the module, thanks for the nice comments!

As far as a solution to this problem to get my images up, i'm not sure which files I would need to modify. I need to keep the image swapper, but would love to keep the URI mod. Can I make both work together?

The module can work with any other module.. it's just a matter of updating other modules to be able to work with static URIs instead of relative URIs.

It sounds like you may need to adjust either your template or the software you are integrating with to use full, static paths for your image swapper URIs. I think they must be using relative URIs at present.

So instead of "images/my_image.jpg" you want to use "/images/my_image.jpg" (note the path starts with a slash!).

Hope that helps you sort this out.

As this appears to be a problem with the other module not working with static URIs you'd best post in the Image Swapper module's thread if you need any further help with this. I'm afraid I don't provide support for integrating third party modules with the URI mapping module on this forum.

All the best...

Conor
ceon