Guest Posted October 10, 2006 Posted October 10, 2006 installed the latest verion of Chemo's ultimate seo urls contribution, also installed the additional install instructions which has changed the product urls but not the category urls to see what i mean have a look at the following url http://www.office2me.co.uk/-c-29_134.html the product urls look like the following http://www.office2me.co.uk/art-attack-pva-...961-p-6510.html just wondered if anyne else had come across this problem and had found a fix for it thanks Quote
insomniac2 Posted October 10, 2006 Posted October 10, 2006 Yes there seemed to be a missing LEFT JOIN in 2 of the queries. Find the first: case ($this->attributes['SEO_ADD_CAT_PARENT'] == 'true'): Change the sql query after it to: $sql = "SELECT c.categories_id, c.parent_id, cd.categories_name as cName, cd2.categories_name as pName FROM " . TABLE_CATEGORIES . " c LEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd ON c.categories_id = cd.categories_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 . "' AND cd.categories_id = '" . (int)$single_cID . "' AND cd.language_id = '" . (int)$this->languages_id . "' LIMIT 1"; Than Find the second: case ($this->attributes['SEO_ADD_CAT_PARENT'] == 'true'): Change the sql query after it to: $sql = "SELECT c.categories_id as id, c.parent_id, cd.categories_name as cName, cd2.categories_name as pName FROM " . TABLE_CATEGORIES . " c LEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd ON c.categories_id = cd.categories_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 = cd.categories_id AND cd.language_id = '" . (int)$this->languages_id . "'"; Worked for me anyway. Quote
modulate Posted October 10, 2006 Posted October 10, 2006 There is a seperate seo_class file in the contributions area, that fixes that problem, just overwrite the old one. Check the contributions for the mod, and its in there listing something alike in the description. Quote
aplein Posted November 6, 2006 Posted November 6, 2006 Yes there seemed to be a missing LEFT JOIN in 2 of the queries. Find the first: case ($this->attributes['SEO_ADD_CAT_PARENT'] == 'true'): Change the sql query after it to: $sql = "SELECT c.categories_id, c.parent_id, cd.categories_name as cName, cd2.categories_name as pName FROM " . TABLE_CATEGORIES . " c LEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd ON c.categories_id = cd.categories_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 . "' AND cd.categories_id = '" . (int)$single_cID . "' AND cd.language_id = '" . (int)$this->languages_id . "' LIMIT 1"; Than Find the second: case ($this->attributes['SEO_ADD_CAT_PARENT'] == 'true'): Change the sql query after it to: $sql = "SELECT c.categories_id as id, c.parent_id, cd.categories_name as cName, cd2.categories_name as pName FROM " . TABLE_CATEGORIES . " c LEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd ON c.categories_id = cd.categories_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 = cd.categories_id AND cd.language_id = '" . (int)$this->languages_id . "'"; Worked for me anyway. Many, thank you Alfred from Germany Quote
Guest Posted November 8, 2006 Posted November 8, 2006 Thanks for that worked like a treat Hi, I am having a problem with the URL's as stated above. I have updated the seo.class file but the urls are showing like this and i'm getting a 404 page cannot be found. products show like this: https://www.british-warrior.co.uk/shop/wall...cket-p-123.html categories show like this: https://www.british-warrior.co.uk/shop/uniforms-c-21.html Also when i turn off the SEO URL's in admin, the pages don't load. Also, in product admin, i don't get the option to manually add an SEO URL. any help appreciated. Quote
sitandspin Posted November 9, 2006 Posted November 9, 2006 I just setup and edited all these files as they are described in the contribution, but I don't have the SEO menu in my admin menu. Any ideas why that might be happening? Quote
Guest Posted November 9, 2006 Posted November 9, 2006 I just setup and edited all these files as they are described in the contribution, but I don't have the SEO menu in my admin menu. Any ideas why that might be happening? Hi, can someone please take a look at my site, the pages aren't loading since i added the ultimate seo urls. http://british-warrior.co.uk/shop/index.php I also added the meta tags contribution with sql update. could this be the problem? Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.