After re-reading what i wrote above i dont think i was too clear on what the problem is.

My current site is a 1.3.5 that is live is mysite.co.uk/shop and doesnt have this mod installed on it, over the past few weeks i have been building a 1.3.8a test site in mysite.co.uk/test i have just installed your mod and put my site live within the root so its simply at mysite.co.uk it will take a while for this to become within search engines as its literally just a few hours old of being live, but my main problem is that when i try to go to mysite.co.uk/shop it doesnt load and throws a 404 error as with mysite.co.uk/blog, i have scanned through this whole thread and i couldnt find another post by someone that has multiple databases within the one domain, im pretty sure i just need a rewite code but im stuck at locating what the code is i need.

I hope you can help me out, as im really stuck as i cant get into my /shop/admin page to access the sales.

Cheers
Ben

ben harry:

After re-reading what i wrote above i dont think i was too clear on what the problem is.

My current site is a 1.3.5 that is live is mysite.co.uk/shop and doesnt have this mod installed on it, over the past few weeks i have been building a 1.3.8a test site in mysite.co.uk/test i have just installed your mod and put my site live within the root so its simply at mysite.co.uk it will take a while for this to become within search engines as its literally just a few hours old of being live, but my main problem is that when i try to go to mysite.co.uk/shop it doesnt load and throws a 404 error as with mysite.co.uk/blog, i have scanned through this whole thread and i couldnt find another post by someone that has multiple databases within the one domain, im pretty sure i just need a rewite code but im stuck at locating what the code is i need.

I hope you can help me out, as im really stuck as i cant get into my /shop/admin page to access the sales.

Cheers
Ben

Quick update i have added the following code with success

Don't rewrite cPanel directories

RewriteCond %{REQUEST_URI} !/shop.* [NC]
RewriteCond %{REQUEST_URI} !/blog.* [NC]

I put this mod on a new site... After I had made a few test products. It worked great. Yesterday I added a bunch of products and used the auto generation "tick box" to create the mappings for those new products. Here's the problem: I can add the original test products to my shopping cart but not any of the products that were added after the mapping module. I tried removing the mapping and re-adding it but that didn't seem to work either. Any suggestions?

Thanks
Nancy

Before I bugger this up, could you clarify how to map from:

/index.php?manufacturers_id=22 (old blogged location)

to

/index.php?manufacturers_id=67 (actual new location)

Thanks much Conor, this mod is too cool!

Hi,

ben harry:

Hello conor hope all is well.

Really hectic but fine thanks! :)

ben harry:

Do you think this is down to a missing rewrite rule somewhere, or is it another error, and is there anything you could help me with.

Yes. The rewrite rule will block the addresses you described. You need to add exceptions to the rewrite rule.

Please read the section "Adding exceptions to the rule to prevent particular addresses (e.g. Control Panels etc.) being handled by Zen Cart" for more information!

You'll add conditions like:

RewriteCond %{REQUEST_URI} !/shop.* [NC]

Glad you like another of our modules! :)

All the best...

Conor

Hi,

ben harry:

Quick update i have added the following code with success

Off the internet for one day and so many support requests/posts!

Glad to hear you're sorted.. you can obviously disregard the post I just made!

All the best...

Conor
ceon

Hi,

Mrchristoh:

yep i just lost the enhancements i made to the front-end.

any ideas?

More than likely the "enhancements" aren't building their URIs correctly so when you go to a page like

/yourshop/mycategory/myproduct

the "enhancement" scripts are trying to access a file relatively instead of using the "base" URI of the site.

E.g.:

A script may be trying to access

/yourshop/this_file.js

But when you're in

/yourshop/mycategory/myproduct

it is trying to find:

/yourshop/mycategory/this_file.js

which obviously doesn't exist.

You need to contact the author of the enhancements (or if you can code, try yourself) to have them prefix the path to files with the shop's web directory (DIR_WS_CATALOG) instead of expecting only ever to be at the root URI of the store.

There's nothing I can do about this, it's simply that the author of the enhancement hasn't thought about the fact that people might want to use SEF/SEO URIs and introduced a problem in their code.

Mrchristoh:

well i guess its time to abandon all hope with this.......thanks anyway

No, you shouldn't abandon hope.. the problem should be easy to fix.. simply a matter of changing the incorrect paths in the "enhancements".

As I said in the private message to you, I don't know what enhancements you are actually talking about, it's obvious to you since you built the site but not to me as a visitor!

Hope that helps! Thanks for the nice comments about the module! :)

All the best...

Conor
ceon

Hi,

kiddo:

Before I bugger this up, could you clarify how to map from:

/index.php?manufacturers_id=22 (old blogged location)

to

/index.php?manufacturers_id=67 (actual new location)

Thanks much Conor, this mod is too cool!

Okay, one last example then.. got my own life to lead! ;)

uri

/index.php?manufacturers_id=67

language_id

1

current_uri

1

main_page

index

query_string_parameters

manufacturers_id=22

associated_db_id

NULL

alternate_uri

NULL

redirection_type_code

301

date_added

NOW()

Glad you like the module!

All the best...

Conor
ceon

Hi Nancy,

ladyink:

Any suggestions?

I'm afraid I've no idea what could be going wrong. I can't see how it would have anything to do with the module though. This must be a coincidence and it must be something else you did to the products which is creating the problem (maybe their stock level is zero or something?).

Sorry I can't be of more help but at least you know it's not this module and you can start looking elsewhere to see what the problem is!

All the best...

Conor
ceon

Thanks again Conor, now I'll stop pestering you. Problem was I kept putting something in the associated_db field. Just seemed right. I get it now!

conor:

Hi Nancy,

I'm afraid I've no idea what could be going wrong. I can't see how it would have anything to do with the module though. This must be a coincidence and it must be something else you did to the products which is creating the problem (maybe their stock level is zero or something?).

Sorry I can't be of more help but at least you know it's not this module and you can start looking elsewhere to see what the problem is!

All the best...

Conor
ceon

Thanks for taking a look. I went into the database and removed the mappings and the products work fine that way. I'll just leave the mapping on my "other pages" and leave them off my products.
Knowing me, I'll work on it for awhile longer- if I figure it out, I'll let you know!

Nancy

ladyink:

Knowing me, I'll work on it for awhile longer- if I figure it out, I'll let you know!

Nancy

Well, I figured this much out...

The products that are only in a main category work fine (ex mywebsite.com/maincategory/product-name). If there is a sub category (ex mywebsite.com/maincategory/products/product-name) the automatic mapping is not working. It maps it but when you push "add to cart" it goes to a page with this at the end of the mapping: "?&action=add_product" instead of putting this at the "&number_of_uploads=1" and actually adding it to the cart. If I manually put the mapping in to avoid that other category- everything is fine.

Hope this helps someone... If you know what would fix this, please let me know!!

Nancy

Hi,

kiddo:

Thanks again Conor, now I'll stop pestering you. Problem was I kept putting something in the associated_db field. Just seemed right. I get it now!

Easy mistake to make.. glad you're up and running.

Enjoy the rest of the weekend! :)

All the best...

Conor
ceon

Conor,

I'm going to ask this question, but I'm afraid I already know the answer. Anyway, worth asking...

I did not have the ceon_uri_mapping.php language definition file placed into the proper language section under my admin file structure at the time I created products. I originally put that file in the English admin file structure because my site is in Italian, but I want to manage it through the admin in English. Didn't think I'd need anything operationally from the admin side... :ohmy:

What appears to have happened for me is that my Product Review and Tell a Friend URIs are now their respective variable names in their database records. :(

(I just wanted to get the module working first and then go check out the Reviews/Tell a Friend detail stuff later on. Looks like that may have been an oversight here on my end...

Anyway, now that I've placed that file in the proper place and appropriately translated the reviews/tell-a-friend values from English to Italian, is there any chance those database records will magically change or can they be forced to update sistematically? Do I have to go in and change them all one by one for each product?

If it helps, here's my site:

http://www.edizioninautilus.it

Thanks,

Jeremy

PS, by the way, I got this mod working with the Product Type Book mod recently and really like how that's working out if anyone wants to have a look....

simon1066:

Sorted!!!!!!

Ok, thanks for this Conor, looked at the dbase carefully and the problem was not to do with the dbase entry, as such, but more to do with the EZpage and subsequent internal link to the Define Pages page.

So, for any like minded people here's how:

1. When mapping Ezpages ('Specifying the current URI Mapping for an EZ-Page') only map those with content - not those with an internal link url to a Define Pages page.

2. Add mapping in the dbase ('Specifying a Static URI for any other Zen Cart page - option 1') for the Define Pages in question.

3. Change the internal link url within the relevant EZpage to match the new mapped path of that Define Page (does not need a slash prefix).

My mistake was mapping the EZpage and it's linked Define Page and not then changing the internal url.

A combination of mishaps, trouble is I don't know what I'm meant to be doing half the time!

Cheers

Simon,

Thanks for posting these instructions. It cleared up a bit of confusion for me with respect to the EZ-Page / Ceon URI functionality and interaction. However...

Conor, I'm still having some problems that I can't wrap my head around...

Here's a CSV dump from my database for the record "contatti" which is Italian for "Contact Us":

"/contatti","2","1","contact_us",NULL,"0",NULL,"301","2009-05-25 08:32:42"

Looks pretty good to me. The right name, language ID = 2 for Italian, 1 for active, main page= contact_us, etc, etc. Anything obviously wrong?

When you go to this page on my site, this URI http://www.edizioninautilus.it/contatti delivers the following link to the browser:

http://www.edizioninautilus.it/index.php?main_page=product_info&products_id=0

Any idea why?

I'm really starting to think this mod (when used in combination with the EZ-Pages multilanguage addon) doesn't like NOT having English active as a primary language with others as mere add ons. However, I can't put my finger on why. My install looks exactly like Simon's application and I've followed those instructions to a T, but I'm still having EZ-Pages add the &chapter= bit to the other non-DB added pages, and it's not because there is any chapter data in a stray record somewhere...

The mod is working great with all products, even the new ones I added using the Product Book Type...

Aggghhhh.

Jeremy

BTW, I've modified the existing live link on the "Contatti" EZ-Page to just go to the Zen-cart generated one so our customers don't see these machinations going on in real-time...

Anyone have any suggestions?

Hi Jeremy,

I've looked at my dbase entry for the 'contact us' define pages page, and instead of NULL,"0",NULL , I've used NULL,NULL,NULL. Not sure why you have the '0' in there.

Try using these 3 nulls, make sure your internal link in your Contact EZpage is "contatti" without the foward slash at the beginning, and ensure that the URI mapping field is empty with the tick box unchecked.

This replicates what I have in my setup so hopefully should work.

Good luck

Simon

simon1066:

Hi Jeremy,

I've looked at my dbase entry for the 'contact us' define pages page, and instead of NULL,"0",NULL , I've used NULL,NULL,NULL. Not sure why you have the '0' in there.

Try using these 3 nulls, make sure your internal link in your Contact EZpage is "contatti" without the foward slash at the beginning, and ensure that the URI mapping field is empty with the tick box unchecked.

This replicates what I have in my setup so hopefully should work.

Good luck

Simon

Simon,

Thanks! That did the trick. I was able to plug NULL in there instead of zero and it worked great. Also followed through by putting the "contatti" in the internal link section without the slash and all is well.

Thanks for taking the time to check your database records for me. I really appreciate it.

I think the record got set to 0 instead of its intended default of NULL when I tried to update this EZ Link page from the URI mapping section at the bottom of the EZ link page rather than doing the suggested access directly into the database. Was a bit fearful of phpadmin!

Now I can set up the other links appropriately. Still having problems with that chapter issue, but this solution gets me 5 out of the 6 EZ link pages I need anyway.

:clap:

Jeremy

simon1066:

Hi Jeremy,

I've looked at my dbase entry for the 'contact us' define pages page, and instead of NULL,"0",NULL , I've used NULL,NULL,NULL. Not sure why you have the '0' in there.

Try using these 3 nulls, make sure your internal link in your Contact EZpage is "contatti" without the foward slash at the beginning, and ensure that the URI mapping field is empty with the tick box unchecked.

This replicates what I have in my setup so hopefully should work.

Good luck

Simon

Simon,

Sorry to bother, but would you mind telling me what your database record looks like for an EZ Page with content in it, rather than the ones that just refer over to the Extra Pages?

Here's what mine looks like that's currently having some troubles:

"/chi-siamo","2","1","page",NULL,"7",NULL,"301","2009-05-25 14:55:39"

If I replace the 7 with NULL like the earlier solution, it breaks. My problem is that the resulting URI looks like this:

http://www.edizioninautilus.it/chi-siamo?&chapter=

I'm trying to get that ?&chapter= outta there...

Thanks. All of the rest of my pages are looking great now!

Jeremy

Jeremy,

No bother.

Your ez-page with content dbase record looks fine - same as mine.

Although I haven't looked into this deeply, you might want to make sure that there aren't duplicate entries in the dbase for '/chi-siamo'. I've noticed that this can happen sometimes when 'playing around' with uri's/dbase/internal links. Usually the duplicate entry has a 'current_uri' of zero, but not always.

Just to clarify my setup for an ez-page with content:

dbase entry agrees with yours:
"/chi-siamo","2","1","page",NULL,"7",NULL,"301","2009-05-25 14:55:39"

ez-pages admin:
Internal Link URL - blank
External Link URL - blank
URI Mapping would be - /chi-siamo
tick-box - unchecked

You problem might also be connected with the chapter setting for that page (http://www.edizioninautilus.it/chi-siamo?&chapter=) I haven't used these yet but if you are not using it, disable in the fields at the top of the admin page (chapter = 0 / TOC = No)

Can't think of anything else that might help you.

Cheers

Simon

Hello,

I installed the add-on today on a site I've been playing with, and I'm having a few problems, so I'm wondering if I missed a step somewhere. The site is http://www.wholesale4realtors.com and zc is installed in /cart.

I had initially gotten a few admin errors due to a few php files having additional blank lines at the end, so I removed those, no biggie... Then followed the instructions Modules>Ceon URI...

Now the frontend site opens with a 404: page not found error, for the define_main_page.php If I add /cart to the end of the url it does not have this error, so I'm assuming it is an issue with the .htaccess file, but don't see anything wrong.

Below is the htaccess file:

RewriteEngine On

# Don't rewrite any URIs ending with a file extension (ending with .[xxxx])
RewriteCond %{REQUEST_URI} !\.[a-zA-Z]{2,4}$
# Don't rewrite admin directory
RewriteCond %{REQUEST_URI} !^/cart/admin.* [NC]
# Don't rewrite editors directory
RewriteCond %{REQUEST_URI} !^/cart/editors.* [NC]
# Don't rewrite payment pages/callback handlers
# (Won't be rewritten by rules above but included here in case rewriting of URIs ending in .php is added)
RewriteCond %{REQUEST_URI} !^/cart/ipn_main_handler.php.* [NC]
RewriteCond %{REQUEST_URI} !^/cart/iridium_3d_secure_iframe.php.* [NC]
RewriteCond %{REQUEST_URI} !^/cart/localities_remote_loader.php.* [NC]
RewriteCond %{REQUEST_URI} !^/cart/nochex_apc_handler.php.* [NC]
RewriteCond %{REQUEST_URI} !^/cart/protx_direct_3d_secure_iframe.php.* [NC]
RewriteCond %{REQUEST_URI} !^/cart/realex_remote_3d_secure_iframe.php.* [NC]
# Don't rewrite cPanel directories
RewriteCond %{REQUEST_URI} !/cpanel.* [NC]
RewriteCond %{REQUEST_URI} !/frontend.* [NC]
RewriteCond %{REQUEST_URI} !/cart.* [NC]
# Handle all other URIs using Zen Cart (index.php)
RewriteRule (.*) /cart/index.php?%{QUERY_STRING} [L]
RewriteCond %{HTTP_USER_AGENT} Wget [OR] 
RewriteCond %{HTTP_USER_AGENT} CherryPickerSE [OR] 
RewriteCond %{HTTP_USER_AGENT} CherryPickerElite [OR] 
RewriteCond %{HTTP_USER_AGENT} EmailCollector [OR] 
RewriteCond %{HTTP_USER_AGENT} EmailSiphon [OR] 
RewriteCond %{HTTP_USER_AGENT} EmailWolf [OR] 
RewriteCond %{HTTP_USER_AGENT} ExtractorPro 
RewriteRule ^.*$ deny.html [L]
RewriteCond %{HTTP_HOST} ^4realtors.us$ [OR]
RewriteCond %{HTTP_HOST} ^www.4realtors.us$
RewriteRule ^/?$ "http\:\/\/www\.wholesale4realtors\.com" [R=301,L]
DirectoryIndex cart/index.php index.html index.php

Note: I have a few sites referring to this same htaccess file.

Any thoughts? ...and Thanks.