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

[lat9]

I've just submitted v3.0.3 of USU to the Zen Cart moderators for review; I'll post back here when it's available for download (https://www.zen-cart.com/downloads.php?do=file&id=132).

This release contains changes associated with the following GitHub issues:

#25: Remove hard-coded category indicator from categories URL.
#27: Correct issues with $_GET array parameters.
#28: Correct attributed-product-in-cart link back to product page (attribute restoration).
#29: Don't add 'manufacturers_id' parameter to any product-info type page.
#30: Update various queries, using integer values, for future-proofing.

[lat9]

Unfortunately , there's a potential for a mySQL fatal error using v3.0.3 if your store's setting for Format of alternate URLs is parent or the setting for Display categories as directories is short.

You'll see logs similar to

[08-Nov-2019 15:37:05 America/New_York] Request URI: /zc155fusu/beacH-vrb-exTra/configuration.php?gID=31&cID=585&action=save, IP address: ::1
#1  trigger_error() called at [C:\xampp\htdocs\zc155fusu\includes\classes\db\mysql\query_factory.php:171]
#2  queryFactory->show_error() called at [C:\xampp\htdocs\zc155fusu\includes\classes\db\mysql\query_factory.php:143]
#3  queryFactory->set_error() called at [C:\xampp\htdocs\zc155fusu\includes\classes\db\mysql\query_factory.php:218]
#4  queryFactory->Execute() called at [C:\xampp\htdocs\zc155fusu\includes\classes\usu.php:1256]
#5  usu->generate_categories_cache() called at [C:\xampp\htdocs\zc155fusu\includes\classes\usu.php:84]
#6  usu->__construct() called at [C:\xampp\htdocs\zc155fusu\beacH-vrb-exTra\includes\classes\observers\UsuAdminObserver.php:29]
#7  UsuAdminObserver->__construct() called at [C:\xampp\htdocs\zc155fusu\includes\autoload_func.php:79]
#8  require(C:\xampp\htdocs\zc155fusu\includes\autoload_func.php) called at [C:\xampp\htdocs\zc155fusu\beacH-vrb-exTra\includes\application_top.php:171]
#9  require(C:\xampp\htdocs\zc155fusu\beacH-vrb-exTra\includes\application_top.php) called at [C:\xampp\htdocs\zc155fusu\beacH-vrb-exTra\configuration.php:10]
--> PHP Fatal error: 1054:Unknown column 'c.parent_id' in 'on clause' :: SELECT c.categories_id AS id, c.parent_id, cd.categories_name AS cName, cd2.categories_name as pName
                       FROM categories AS c, categories_description AS cd
                            LEFT JOIN categories_description AS cd2
                                ON c.parent_id = cd2.categories_id 
                               AND cd2.language_id = 1
                      WHERE c.categories_id = cd.categories_id
                        AND cd.language_id = 1 ==> (as called by) C:\xampp\htdocs\zc155fusu\includes\classes\usu.php on line 1256 <== in C:\xampp\htdocs\zc155fusu\includes\classes\db\mysql\query_factory.php on line 171.

I've got the update staged on GitHub, changing /includes/classes/usu.php, starting at line 1241, from

            if (USU_FORMAT == 'parent' || USU_CATEGORY_DIR == 'short') {
                $sql = 
                    "SELECT c.categories_id AS id, c.parent_id, cd.categories_name AS cName, cd2.categories_name as pName
                       FROM " . TABLE_CATEGORIES . " AS c, " . TABLE_CATEGORIES_DESCRIPTION . " AS cd
                            LEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " AS cd2
                                ON c.parent_id = cd2.categories_id 
                               AND cd2.language_id = {$this->languages_id}
                      WHERE c.categories_id = cd.categories_id
                        AND cd.language_id = {$this->languages_id}";
            } else {
                $sql = 
                    "SELECT categories_id AS id, categories_name AS cName
                       FROM " . TABLE_CATEGORIES_DESCRIPTION . "
                      WHERE language_id = {$this->languages_id}";
            }

to

            if (USU_FORMAT == 'parent' || USU_CATEGORY_DIR == 'short') {
                $sql = 
                    "SELECT c.categories_id AS id, c.parent_id, cd.categories_name AS cName, cd2.categories_name as pName
                       FROM " . TABLE_CATEGORIES . " AS c
                            LEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " AS cd2
                                ON c.parent_id = cd2.categories_id 
                               AND cd2.language_id = {$this->languages_id}, " . TABLE_CATEGORIES_DESCRIPTION . " AS cd
                      WHERE c.categories_id = cd.categories_id
                        AND cd.language_id = {$this->languages_id}";
            } else {
                $sql = 
                    "SELECT categories_id AS id, categories_name AS cName
                       FROM " . TABLE_CATEGORIES_DESCRIPTION . "
                      WHERE language_id = {$this->languages_id}";
            }

[lat9]

I've just submitted v3.0.4 to correct the following issues introduced in v3.0.3 and will post back when it's available for download.

This release contains changes for the following issues, introduced in v3.0.3:


#31. (a) Faulty query results in fatal MySQL error.
#31. (b) Restore use of ENABLE_SSL_CATALOG when creating storefront links from the admin.

[lat9]

I've just submitted v3.0.3 of USU to the Zen Cart moderators for review; I'll post back here when it's available for download (https://www.zen-cart.com/downloads.php?do=file&id=132).

This release contains changes associated with the following GitHub issues:

#25: Remove hard-coded category indicator from categories URL.
#27: Correct issues with $_GET array parameters.
#28: Correct attributed-product-in-cart link back to product page (attribute restoration).
#29: Don't add 'manufacturers_id' parameter to any product-info type page.
#30: Update various queries, using integer values, for future-proofing.

I've just submitted v3.0.4 to correct the following issues introduced in v3.0.3 and will post back when it's available for download.

This release contains changes for the following issues, introduced in v3.0.3:


#31. (a) Faulty query results in fatal MySQL error.
#31. (b) Restore use of ENABLE_SSL_CATALOG when creating storefront links from the admin.

v3.0.4 is now available for download: https://www.zen-cart.com/downloads.php?do=file&id=132

As noted above, v3.0.3 should be bypassed due to the errors I introduced; all v3.0.3 updates are present (and corrected, if needed) in v3.0.4.

[swguy]

Trying to turn off Ultimate URLs for a specific subfolder (Google_Merchant) by updating .htaccess but it's not working. Is there something else needed?
(It redirects back to index.php)

[lat9]

Trying to turn off Ultimate URLs for a specific subfolder (Google_Merchant) by updating .htaccess but it's not working. Is there something else needed?
(It redirects back to index.php)

What changes did you try in the .htaccess and what's 'not working'?

I'm guessing that you might need to add a negative RewriteCond to indicate that the redirect to the main-page shouldn't be performed.

[swguy]

I would have thought one of

RewriteCond %{REQUEST_URI} !^/store/Google_Merchant [NC]
RewriteCond %{REQUEST_URI} !^/Google_Merchant [NC]

would do it - but no.