Ultimate SEO v3 (and v2.200) [Support Thread]

[su35]

What URL (or chain of URLs) was the site redirected to after the product was added to the cart? What are your settings in Zen Cart for "Display after add to cart"? What was the 404 page URL?

What version of Ultimate URLs? What version of Zen Cart?

Hi lhungil, Thanks for you reply

The Zen Cart version is 1.5.1. The Ultimate SEO URLs version is V2.212

Display Cart After Adding Product is set to false.

The 404 page URL is domain/index.php?main_page=page_not_found

[su35]

One parameter (disp_order=x) was introduced into the link. Is this parameter that interrupts the rewrite rule?

[lhungil]

Probably not. I'm out of town at the moment. If you can send me a link to the example page (want to see all of the HTTP codes), I'll take a look when I get back. Feek free to send in a PM (so I do not forget).

[buildingblocks]

Hi

I have zen cart 1.5.1 installed on a subdomain. Ultimate seo urls Version: 2.212 is installed. All looks good except for in admin in the top navigation bar, the link to "Online Catalog" is not working correctly. It opens to

http://testsite.mywebsite.com/.html

As expected it opens to a 403 page. Any ideas what to do about this problem? The .htaccess is the one supplied with the module and only the RewriteBase changed from /shop/ to /. Nothing else has been altered in the file.

When I turn off the seo module the problem goes away and the link opens to the shop.

Other modules installed so far:

quick updates
stock by attributes
easy populate
backup mysql
theme forest exodus template

Just to rule out the template I switched to classic and it made no difference

thanks

[lhungil]

First comment out the line containing RewriteBase (add a # as the first character on that line). This line is not needed when Zen Cart is installed in the web server's root directory.

Second open up "/admin/includes/header.php" and edit the link for the "online catalog" to use "HTTP_CATALOG_SERVER . DIR_WS_CATALOG" for the href attribute.

There is a good chance this change will be present in v160 of Zen Cart.

[buildingblocks]

perfect! That fixed it. Thank you :-)

[mvmastrigt]

Hi,

I've been using your plugin with zencart 1.5.0 for some time now.
Somthing seems to be wrong though as loading times skyrocket with the plugin enabled.
After some digging I discovered it generates almost 30000 queries per page load.
Disabling the plugin reduces amount of queries to about 211.
I proceeded to try various combinations of caching settings, but nothing helped so far.
Do you have any idea as to why the plugin generates this many sql queries?

url: www dot coins-stamps-rotterdam dot nl

[lhungil]

Not sure why you are seeing so many queries. I've rarely seen a request with the latest stable release of Ultimate URLs exceed an average of 150 additional queries (with Ultimate URL enabled and the caches disabled).

One of the times I've seen a massive number of additional queries, a page existed with a massive number of internal links to different products, categories, ez-pages, and manufacturers. Usually in this case enabling the individual caches reduces these requests (unless the host does not allow PHP eval()).

Another time I've seen a massive number of additional queries, the root cause was a problem with the database. Once the database server was out of memory (poor server management) and in the other case the server was having issues with data corruption (server hardware replaced to fix). This case also required running a repair of the SQL tables after the hosting provider corrected the server issues.

Another time the problem, something was missed (or incorrectly merged) when installing the module. This caused Zen Cart to issue duplicate queries attempting to retrieve data.

I'd be very interested to know what is causing the enormous number of extra queries in your hosting environment. Is it every page? One specific page? Anything in the Zen Cart debug logs? Answers to the other questions in the "Posting Tips"? Can you provide more details on the server environment?

[lhungil]

The global USU cache
Saves "name" results in memory for the current web request.

1. Check if name is already in memory. Return the name if cached.
2. If not cached, issue one SQL query per name needed. Cache the name(s) in memory. Return the name.

The individual USU caches (products, categories, mfgs, ez-pages)
Saves "name" results in memory for the current web request.
Additionally saves "name" results using database storage.

On startup (once per page request).

1. If cached copy exists in the database and has expired, delete from the database.
2. If cached copy exists in the database and has not expired, load into memory.
3. If not cached in the database, run one SQL query to load all names, save into database and memory.

Zen Cart 1.5.1+ (data_diggers) memory query cache
Stores SELECT queries in a memory cache. Greatly reduces the number of queries run against the database by Zen Cart (in general). Will be used by this module if present (and most the caching done by USU internally is not needed when this is present / enabled).

The Zen Cart persistent SQL cache
Saves SQL queries according to configure settings. When enabled, this will be used by Ultimate URLs to cache all SQL queries for 43200 seconds (or 12 hours). This cache cannot be reset inside Ultimate URLs and is independent. If your hosting provider limits the number of SQL queries (or throttles them) and you cannot move to a better hosting provider, enabling this in Zen Cart 1.5+ w/ file based caching can help... But keep in mind a file lookup is usually more expensive than a database lookup (and will typically be slower).

[jeking]

I have a file in the store root (Zen Cart is in the 'store' directory, just to confirm) that needs to not be rewritten but is being rewritten. The file is: ShippingZZencart.php from stamps.com

I thought the last lines of the htaccess were to prevent rewriting real files but they don't seem to be. This is the htaccess file contents.

###############################################################################
# Common directives
###############################################################################
# NOTE: Replace /shop/ with the relative web path of your catalog in the "Rewrite Base" line below:

Options +FollowSymLinks
RewriteEngine on
RewriteBase /store/

###############################################################################
# Start Ultimate SEO URLs
###############################################################################

# Handles the new URL formats
RewriteRule ^(.*)-c-([0-9_]+)/(.*)-p-([0-9]+)(.*)$ index\.php?main_page=product_info&products_id=$4&cPath=$2&%{QUERY_STRING} [L]
RewriteRule ^(.*)-c-([0-9_]+)/(.*)-pi-([0-9]+)(.*)$ index\.php?main_page=popup_image&pID=$4&cPath=$2&%{QUERY_STRING} [L]
RewriteRule ^(.*)-c-([0-9_]+)/(.*)-pr-([0-9]+)(.*)$ index\.php?main_page=product_reviews&products_id=$4&cPath=$2&%{QUERY_STRING} [L]
RewriteRule ^(.*)-c-([0-9_]+)/(.*)-pri-([0-9]+)(.*)$ index\.php?main_page=product_reviews_info&products_id=$4&cPath=$2&%{QUERY_STRING } [L]

# Original (unchanged) URL formats
RewriteRule ^(.*)-p-([0-9]+)(.*)$ index\.php?main_page=product_info&products_id=$2&%{QUERY_STRING} [L]
RewriteRule ^(.*)-m-([0-9]+)(.*)$ index\.php?main_page=index&manufacturers_id=$2&%{QUERY_STRING} [L]
RewriteRule ^(.*)-pi-([0-9]+)(.*)$ index\.php?main_page=popup_image&pID=$2&%{QUERY_STRING} [L]
RewriteRule ^(.*)-pr-([0-9]+)(.*)$ index\.php?main_page=product_reviews&products_id=$2&%{QUERY_STRING} [L]
RewriteRule ^(.*)-pri-([0-9]+)(.*)$ index\.php?main_page=product_reviews_info&products_id=$2&%{QUERY_STRING} [L]
RewriteRule ^(.*)-ezp-([0-9]+)(.*)$ index\.php?main_page=page&id=$2&%{QUERY_STRING} [L]
RewriteRule ^(.*)-c-([0-9_]+)(.*)$ index\.php?main_page=index&cPath=$2&%{QUERY_STRING} [L]

# All other pages
# Don't rewrite real files or directories
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ index\.php?main_page=$1&%{QUERY_STRING} [L]