ultimate seo url categories not working

[Guest]

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

[insomniac2]

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.

[modulate]

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.

[Guest]

Thanks for that worked like a treat

[aplein]

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

[Guest]

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.

[sitandspin]

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?

[Guest]

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?