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

[brist]

Bugs in Ultimate SEO 2.212

I was profiling my website and found two bugs causing category names and manufacturer names to not cache in memory. This would cause additional database queries to the categories_description, categories, and manufacturers tables. It would not be noticeable to the user except for slower performance. The file and problem is listed below.

Version 2.212 in file: includes/classes/seo.url.php

1. ---- line 1021 --- function generate_manufacturers_cache()

$define = 'define(\'MANUFACTURER_NAME_' . $manufacturer->fields['id'] . '\', \'' . $this->filter($manufacturer->fields['name']) . '\');'; 

SHOULD BE:

$define = 'define(\'MANUFACTURER_NAME_' . $manufacturers->fields['id'] . '\', \'' . $this->filter($manufacturers->fields['name']) . '\');'; 

2. ---- line 1059 ---- function generate_categories_cache()

$cPath = $this->get_full_cPath($category->fields['categories_id'], $single_cID); 

SHOULD BE:

$cPath = $this->get_full_cPath($category->fields['id'], $single_cID); 

3. If anyone makes these changes, you need to flush the SEO_CACHE table from a MySQL shell:

DELETE FROM seo_cache;

It will regenerate on the next page load.

-------------------------------------------------

After making a cursory look at the other downloadable ZIP flies it appears versions 2.x have the manufacturers bug and versions between 2.212 and 2.210 have the categories bug; however, on different line numbers. I did not look at other versions.

FYI: I'm running versions: Ultimate SEO 2.212 and Zen-cart 1.5.1

-------------------------------------------------

OPTIONAL: If you want to verify if this bug is occurring, you can insert the following code at the bottom of your index page.
Please do not run on a publicly accessible live site.

Categories and manufacturers caches must be turned on:
Admin -> Configuration -> UltimateSEO: Enable categories cache? and Enable manufacturers cache?

<?php
echo "<pre>CONSTANTS\n";
$def = get_defined_constants();
while(list($key,$val) = each($def)) {
    if(is_string($val)) {
        if (strpos($key, 'CATEGORY_NAME_') === 0 || strpos($key, 'MANUFACTURER_NAME_') === 0) {
            echo "define ", $key, '=', $val, "\n";
        }
    }
}
echo "\n</pre>\n";
?>

Before fixing you should see only two malformed records like below:

CONSTANTS
define CATEGORY_NAME_=category-name-here
define MANUFACTURER_NAME_=

After fixing and wiping 'seo_cache' table you should see a lot of records similar to below:

CONSTANTS
define CATEGORY_NAME_101=category-name-here
define CATEGORY_NAME_102=category-name-here
define CATEGORY_NAME_103=category-name-here
define CATEGORY_NAME_104=category-name-here
define MANUFACTURER_NAME_102=manufacturer-name-here
define MANUFACTURER_NAME_103=manufacturer-name-here
define MANUFACTURER_NAME_104=manufacturer-name-here
define MANUFACTURER_NAME_105=manufacturer-name-here
...

[lhungil]

Affected Users
Any user with the manufacturer or category cache enabled.

Symptoms
Notices about CATEGORY_NAME_ and MANUFACTURER_NAME_ already defined (rare). No performance gain from enabling the manufacturer or category cache. A minor performance hit causing each cache entry (category or manufacturer) to be pulled twice (once for each in the database and once for each displayed on a page).

Cause and Bugfix
Code generating the manufacturer and category caches does not actually populate the caches. Please use the fix posted by brist.


A big Thank You to brist for uncovering, reporting, and posting a fix for the bug.

[BugGrub.com]

I am using a new build of Zencart 1.5.3 and after installing step 3 of the installation instructions of "ultimate_seo_urls_212" I got a 500 Internal Server Error when trying to load my admin login page to continue installation.

After doing some investigation and replacing the files copied in the install process, I found that the following file was causing this problem:-

..\admin\includes\functions\general.php

Replacing this file with my backup file instantly enabled me to log in again.

I continued with step 4 of the installation instructions and got the confirmation message that it had been installed OK.

With SEO enabled, my site shows 404 errors for all of the updated URL's. Disabling SEO my site works as it originally did. I am guessing that not having the correct "general.php" file in place is causing this. Can someone please help me understand what is in this file that is causing my admin area not to work.

Thanks

[jeking]

This has not been updated for Zen Cart 1.5.3 yet. A new version is in the works.

[DivaVocals]

This plugin already works in 1.5.3. I also have an updated version close to release.

This has not been updated for Zen Cart 1.5.3 yet. A new version is in the works.

You are HALF right..

This module WORKS with v1.5.3, AND a new version is in the works..

[lhungil]

I am using a new build of Zencart 1.5.3 ... I found that the following file was causing this problem: "/admin/includes/functions/general.php" ...

Ultimate URLs 2.212 will work no problem under Zen Cart 1.5.3. The catch? With Ultimate URLs version 2.212, you will need to manually merge the changes into core files. No drag and drop overwrites of core files.

I'd suggest rolling back all files to before installation of Ultimate URLs, then re-install (and manually merge core files). You may want to take a look at the example modified files from Zen Cart 1.5.2 RC2 during the process (will be closer to the ones found in Zen Cart 1.5.3 versus the Zen Cart 1.5.1 files included in the plugin download).

Reverting the core files and manually merging in changes required for Ultimate URLs would be my first step.

... With SEO enabled, my site shows 404 errors for all of the updated URL's. Disabling SEO my site works as it originally did. ...

Once manual merging of the core files is completed, it would be very useful to see the "development" site where you are installing / testing this module. A full copy of your Zen Cart .htaccess (and any .htaccess file in a parent folder) will also be useful (use "CODE" tags - the # button in the editor on the Zen Cart forums). Or if you really do not want us to see the website at all... provide the URLs (old and new) and the Zen Cart page where the URLs are found.

[coucho]

I was sent here from the ecommerce browser forum because we cant figure out the issue. Apparently the ecommerce browser plug in has issues dealing with seo url rewriters such as this plug in which I have installed on my site. We tried modifying the ht access file without success. Does anyone here have both plug ins installed and if so how did you get around the problem of the facebook app pulling product images and descriptions from your website.

Any suggestions are appreciated.

[DivaVocals]

I was sent here from the ecommerce browser forum because we cant figure out the issue. Apparently the ecommerce browser plug in has issues dealing with seo url rewriters such as this plug in which I have installed on my site. We tried modifying the ht access file without success. Does anyone here have both plug ins installed and if so how did you get around the problem of the facebook app pulling product images and descriptions from your website.

Any suggestions are appreciated.

I suggested you come here, but you have not provided even a scintilla of the information needed for the author of this module to assist you..

• what "ecommerce browser" module (DON'T assume the author knows)
• What do you mean by "issues dealing with seo url rewriters"
• You ask "Does anyone here have both plug ins installed" except you really have said by BOTH what you mean..

[coucho]

I suggested you come here, but you have not provided even a scintilla of the information needed for the author of this module to assist you..

• what "ecommerce browser" module (DON'T assume the author knows)
• What do you mean by "issues dealing with seo url rewriters"
• You ask "Does anyone here have both plug ins installed" except you really have said by BOTH what you mean..

Don't worry Diva I found the issue but with an attitude like yours I am not going to share or come near this forum again.

[DivaVocals]

Don't worry Diva I found the issue but with an attitude like yours I am not going to share or come near this forum again.

Attitude?? REALLY???? I simply suggested that you provide the DETAILS of your issue so the author can help YOU.. he can't help if you don't provide details.. and BTW, he would ask for those SAME details.. but if that's what you consider "attitude", then okay.. **shrug**

not sharing your solution or coming back to this forum?? well you aren't really hurting ME persay.. SHARING your solution helps OTHERS.. but okay if you don't want to share or come back to the forum because YOU think I have an "attitude" (I don't)..