Ultimate SEO URLs bug fix

	SEO osCommece Package XII
	Loaded Features: Spider Session Remover ( SID Killer ) Ultimate SEO URLs Header Tags Controller Google XML Sitemap SEO Assistant AJAX Attribute Manager Product Extra Fields X-Sell v2-MS2 - Cross Sell for MS2 Credit Class & Gift Voucher TinyMCE WYSIWYG HTML EDITOR Multi/extra images Purchase Without Account Newsletter & Subscribers

This is not for everybody.

But if you’re getting URL’s for your categories like this:
http;//www.yoursite.com/-c-2.html
instead of:
http://www.yoursite.com/categoryname_keyword-c-2.html
Then your version of mysql needs a new seo.class.php.
Just upload it to your (catalog)/includes/classes/ folder and your categories names will again appear!
This file contains only the seo.class.php file, and nothing else, so this is not the complete contribution — this fix only for those who had the problem mentioned above.

Find
$sql = "SELECT cd.categories_seo_url, c.categories_id, c.parent_id, cd.categories_name as cName, cd2.categories_name as pName FROM ".TABLE_CATEGORIES." c, ".TABLE_CATEGORIES_DESCRIPTION." cd LEFT JOIN ".TABLE_CATEGORIES_DESCRIPTION." cd2 ON c.parent_id=cd2.categories_id AND cd2.language_id='".(int)$this->languages_id."' WHERE c.categories_id='".(int)$single_cID."' AND cd.categories_id='".(int)$single_cID."' AND cd.language_id='".(int)$this->languages_id."' LIMIT 1";

Change it to:
$sql = "SELECT cd.categories_seo_url, c.categories_id, c.parent_id, cd.categories_name AS cName, cd2.categories_name AS pName FROM ".TABLE_CATEGORIES." c INNER JOIN ".TABLE_CATEGORIES_DESCRIPTION." cd ON cd.categories_id = '".(int)$single_cID."' AND cd.language_id='".(int)$this->languages_id."' LEFT JOIN ".TABLE_CATEGORIES_DESCRIPTION." cd2 ON c.parent_id = cd2.categories_id AND cd2.language_id = '".(int)$this->languages_id."' WHERE c.categories_id = '".(int)$single_cID."' LIMIT 1";

Admin

http://www.oscommerce-packages.com

Bookmark It