Now when I try to access my products I get the following error :1146 Table 'my_database.TABLE_CEON_URI_MAPPINGS' doesn't exist
in:
[ SELECT language_id, uri FROM TABLE_CEON_URI_MAPPINGS WHERE main_page = 'product_info' AND associated_db_id = '265' AND current_uri = '1';]
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.

I understand that I need the db table(s). I am just not sure what is preventing the db script from running?!

Well folks.. thanks for the help! I wiped everything and got it to work on the third try. :smile:

buildingblocks:

Hi

I've had this mod installed and working for a while now, but I never did do anything with the define pages, all products pages or new products pages.

I've been reading the directions and at step 9 I want to do the first method.

For my first attempt I am trying to get the All Products page mapped.

In phpmyadmin > zen_ceon_uri_mappings

I used the existing rows as my example. I added a new row for products_all, but the store front url is still showing as index.php?main_page=products_all

I attached a screenshot of my settings. Am I missing something obvious?

Thank you

edit:

the screenshot is rather small. These are the settings

uri - /all-products

language_id - 1

current_uri - 1

main_page - products_all

query_string_parameters - null

associated_db_id - 1

alternate_uri - null

redirection_type_code - 301

date_added - 2011-03-01 00:00:00

You'll have to add records to the database for these pages. The
instructions are in the docs : "Specifying the current URI Mapping for any other Zen Cart page"
In your phpMyAdmin on the left click ceon_uri_mappings at the top click insert and fill in the information as showed. This will work with any define pages. Make sure the date added is NOW.
You can look at an example here.

uri: /all-products

main_page: products_all

current_uri: 1

language_id: 1

date_added: NOW()

Lets show Conor some love and support by giving a donation for his fine work. Donation help keep the project going forward. :yes:

Thanks for responding countrycharm. As far as I can tell I am following the directions in the documentation. I tried the settings you showed too.

Here are my settings for the all_products page

php settings

With these settings I am getting a page not found. In the store the url in the address bar shows the new static name I gave it, but the storefront shows a page not found. The breadcrumb reads, Home :: Page Not Found

page not found

Do my php settings look correct?

I just installed the URI Mapping Module and I'm loving it! I am currious if anyone knows what it takes to make the MAP Module (Minimum Advertised Price) work and keep the clean URI format.

I am guessing that is within the following files:

admin\includes\modules\update_product.php
admin\includes\modules\product\collect_info.php
admin\includes\modules\product\preview_info.php

I don't know enough php to fix this on my own.

Does anyone have a fix for this issue? If this has already been addressed please point me to a resource. :)

rusty79fj40 - I can't answer your question about the MAP module but if you get around to doing your define pages would you let me know how that goes for you and if you get it to work? I'm stuck in this part.

I haven't run in to that one yet but I'm sure I will. :frusty:

If I do figure anything out I will gladly pass it along.

-Jim

buildingblocks:

Thanks for responding countrycharm. As far as I can tell I am following the directions in the documentation. I tried the settings you showed too.

Here are my settings for the all_products page

php settings

With these settings I am getting a page not found. In the store the url in the address bar shows the new static name I gave it, but the storefront shows a page not found. The breadcrumb reads, Home :: Page Not Found

page not found

Do my php settings look correct?
Your PHP settings are correct. I'm not sure why you would get a page not found. ummm here's what it should look like all-products I will let you know when I find something out on your problem.

thank you for checking on that for me countrycharm. Could it have anything to do with .htaccess?

I used the example from the config instructions:

RewriteEngine On

# Don't rewrite any URIs ending with a file extension (ending with .[xxxxx])
RewriteCond %{REQUEST_URI} !\.[a-z]{2,5}$ [NC]
# Don't rewrite admin directory
RewriteCond %{REQUEST_URI} !^/415Rfg643aNf7Uk [NC]
# Don't rewrite editors directory
RewriteCond %{REQUEST_URI} !^/editors [NC]
# Don't rewrite cPanel directories
RewriteCond %{REQUEST_URI} !/cpanel [NC]
RewriteCond %{REQUEST_URI} !/frontend [NC]
# Handle all other URIs using Zen Cart (index.php)
RewriteRule .* index.php?%{QUERY_STRING} [L]

buildingblocks:

thank you for checking on that for me countrycharm. Could it have anything to do with .htaccess?

I used the example from the config instructions:

RewriteEngine On

Don't rewrite any URIs ending with a file extension (ending with .[xxxxx])

RewriteCond %{REQUEST_URI} !.[a-z]{2,5}$ [NC]

Don't rewrite admin directory

RewriteCond %{REQUEST_URI} !^/415Rfg643aNf7Uk [NC]

Don't rewrite editors directory

RewriteCond %{REQUEST_URI} !^/editors [NC]

Don't rewrite cPanel directories

RewriteCond %{REQUEST_URI} !/cpanel [NC]
RewriteCond %{REQUEST_URI} !/frontend [NC]

Handle all other URIs using Zen Cart (index.php)

RewriteRule .* index.php?%{QUERY_STRING} [L]

Delete whats in your .htaccess file and put this in it. Fill in all the red highlights to what yours are. Upload it to your root and see if it will take care of your problem.

> RewriteEngine On
> 
> RewriteCond %{HTTP_HOST} ^your.com$ [NC]
> RewriteRule ^(.*)$ http://www.your.com/$1 [R=301,L]
> # Don't rewrite any URIs ending with a file extension (ending with .[xxxxx])
> RewriteCond %{REQUEST_URI} !\.[a-z]{2,5}$ [NC]
> # Don't rewrite admin directory
> RewriteCond %{REQUEST_URI} !^/admin_or_your_custom_folder_name [NC]
> # Don't rewrite editors directory
> RewriteCond %{REQUEST_URI} !^/editors [NC]
> # Don't rewrite cPanel directories
> RewriteCond %{REQUEST_URI} !/cpanel [NC]
> RewriteCond %{REQUEST_URI} !/frontend [NC]
> # Handle all other URIs using Zen Cart (index.php)
> RewriteRule .* index.php?%{QUERY_STRING} [L]

If that doesn't work try this one.

> RewriteEngine On
> 
> RewriteCond %{HTTP_HOST} ^your.com$ [NC]
> RewriteCond %{REQUEST_URI} !^/admin_or_your_custom_folder_name [NC]
> RewriteCond %{REQUEST_URI} !^/editors [NC]
> RewriteRule ^(.*)$ http://www.your.com/$1 [R=301,L]
> 
> # Don't rewrite any URIs ending with a file extension (ending with .[xxxxx])
> RewriteCond %{REQUEST_URI} !\.[a-z]{2,5}$ [NC]
> # Don't rewrite admin directory
> RewriteCond %{REQUEST_URI} !^/admin_or_your_custom_folder_name [NC]
> # Don't rewrite editors directory
> RewriteCond %{REQUEST_URI} !^/editors [NC]
> # Don't rewrite cPanel directories
> RewriteCond %{REQUEST_URI} !/cpanel [NC]
> RewriteCond %{REQUEST_URI} !/frontend [NC]
> # Handle all other URIs using Zen Cart (index.php)
> RewriteRule .* index.php?%{QUERY_STRING} [L]

Maybe this will solve your problem.

Thank you countrycharm!! The second one worked minus one line. I'm in business now :clap: Thanks so much for your help.

RewriteEngine On

RewriteCond %{HTTP_HOST} ^mysite.com$ [NC]
RewriteCond %{REQUEST_URI} !^/admin [NC]
RewriteCond %{REQUEST_URI} !^/editors [NC]

# Don't rewrite any URIs ending with a file extension (ending with .[xxxxx])
RewriteCond %{REQUEST_URI} !\.[a-z]{2,5}$ [NC]
# Don't rewrite admin directory
RewriteCond %{REQUEST_URI} !^/admin [NC]
# Don't rewrite editors directory
RewriteCond %{REQUEST_URI} !^/editors [NC]
# Don't rewrite cPanel directories
RewriteCond %{REQUEST_URI} !/cpanel [NC]
RewriteCond %{REQUEST_URI} !/frontend [NC]
# Handle all other URIs using Zen Cart (index.php)
RewriteRule .* index.php?%{QUERY_STRING} [L]

buildingblocks:

Thank you countrycharm!! The second one worked minus one line. I'm in business now :clap: Thanks so much for your help.

RewriteEngine On

RewriteCond %{HTTP_HOST} ^mysite.com$ [NC]
RewriteCond %{REQUEST_URI} !^/admin [NC]
RewriteCond %{REQUEST_URI} !^/editors [NC]

Don't rewrite any URIs ending with a file extension (ending with .[xxxxx])

RewriteCond %{REQUEST_URI} !.[a-z]{2,5}$ [NC]

Don't rewrite admin directory

RewriteCond %{REQUEST_URI} !^/admin [NC]

Don't rewrite editors directory

RewriteCond %{REQUEST_URI} !^/editors [NC]

Don't rewrite cPanel directories

RewriteCond %{REQUEST_URI} !/cpanel [NC]
RewriteCond %{REQUEST_URI} !/frontend [NC]

Handle all other URIs using Zen Cart (index.php)

RewriteRule .* index.php?%{QUERY_STRING} [L]

Your very welcome. I'm glad you got it sorted out.

I have installed your module on two websites and it works well on both. I used the .htaccess file as I don't understand how or where to enter the ReWrite rule.
I backed up both websites before I installed the module. I backup to a localhost using WAMP.

My problem arises when backing up the new websites with the module included. One website is fine and works on the localhost, but the other produces the 404 error when trying to access products. The two websites are set up almost the same, and both used the same .htaccess file which would seem to be the problem looking at other posts.

I have backed up the website again in case I had made an error there, but the esult is the same.

I have tried copying the .htaccess file onto the localhost in the same directory as the index file, but this stops the website working completely.

I also note that when I look at the files on my live working websites the .htaccess file seems to have disappeared. I assume this is correct as the module works on the live sites.

Have you any suggestions as to why the localhost version isn't working? I don't feel comfortable adding to a working site if I cannot take a backup.

Hi,

buildingblocks:

query_string_parameters - null

associated_db_id - 1

The problem in your case was that associated_db_id should be NULL.

All the best..

Conor
ceon

Hi,

Ousel:

I have tried copying the .htaccess file onto the localhost in the same directory as the index file, but this stops the website working completely.

You don't "back up a site to localhost".. your "localhost" site is another site.. it can be called a repplica [spelt wrong on purpose as forum considers proper spelling a banned word!!] or test version of your "live" site but to say it is a backup is wrong. A backup should require zero configuration changes to get it to work.. with localhost that's clearly not true.

Your problem appears to be that when trying to set up a test version of your "live" site your local, "test/replicaa version isn't working.

You may either need to install a different .htaccess file for this test site or the webserver configuration for this local site may not be loading in the .htaccess file.

I'm afraid this isn't a problem with the software but with your differences in configuration. It's not something I can support here.

I'd suggest trying to install the Ceon URI Mapping software (and a fresh .htaccess file and rewrite rule) to your localhost site, if you do that right, it should get it working okay.

All the best..

Conor
ceon

Hi Guys,
I am planning to use this tool for my Meta Data. Just wondering do I still need to insert the default zen cart meta data for each product or will this tool do all this for me?
Thanks in advance

Hi,

rebelman:

I am planning to use this tool for my Meta Data. Just wondering do I still need to insert the default zen cart meta data for each product or will this tool do all this for me?
Thanks in advance

This has nothing to do with the meta data. You'll still have to enter it for each product.

All the best..

Conor
ceon

Hi Conor,

Thanks for the quick reply.

conor:

You don't "back up a site to localhost".. your "localhost" site is another site.. i

Sorry for the incorrect terminology. I copy my zencart files from a live site onto the localhost, and I import the database from the livesite to the localhost, which should give an exact copy of my live site on my localhost.

I have tried to reinstall the CEON module on localhost, but still only the front page appears. When I look for a product I get the 404 error. If I include the .htaccess file localhost cannot even find the front page.

I appreciate that this is not an error with the CEON module, but it seems strange that I have 2 websites on localhost with the CEON module but only one works correctly.

I know very little about using WAMP. Is it possible to have 2 websites on it each with an .htaccess file, or are they conflicting?

Hi,

Ousel:

Sorry for the incorrect terminology. I copy my zencart files from a live site onto the localhost, and I import the database from the livesite to the localhost, which should give an exact copy of my live site on my localhost.

Yes, we do the same, it's how we rollout websites from our development machine to our live server. We actually use a shared subversion repository so it is the "backup" and both the local and live instances of the websites are working copies checked out from this repository. Very handy way to work!

There are always some differences though, like the paths in the configure.php files etc. so we don't consider one a backup of another, we have local config files which apply only for the server/site in question.

You have to be careful in such a situation that the server encvironment is similar enough that you don't need to customise any more files per site (the configure files should be the only files that need changing, along with the session write directory value in eh configuration table).

Ousel:

I know very little about using WAMP. Is it possible to have 2 websites on it each with an .htaccess file, or are they conflicting?

When you say WAMP, did you install Apache, PHP etc. yourself?

Check that the VirtualHost configs for the two local sites are the same.. you may have enabled overrides in one (AllowOverides) but not in the other, meaning the .htaccess file won't work in one.

Hope that helps.

All the best..

Conor
ceon