Guest Posted October 10, 2006 Share 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 Link to comment Share on other sites More sharing options...
insomniac2 Posted October 10, 2006 Share 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 Link to comment Share on other sites More sharing options...
modulate Posted October 10, 2006 Share 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 Link to comment Share on other sites More sharing options...
Guest Posted October 12, 2006 Share Posted October 12, 2006 Thanks for that worked like a treat Quote Link to comment Share on other sites More sharing options...
aplein Posted November 6, 2006 Share 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 Link to comment Share on other sites More sharing options...
Guest Posted November 8, 2006 Share 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 Link to comment Share on other sites More sharing options...
sitandspin Posted November 9, 2006 Share 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 Link to comment Share on other sites More sharing options...
Guest Posted November 9, 2006 Share 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 Link to comment Share on other sites More sharing options...
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.