Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

ultimate seo url categories not working


Guest

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

  • 4 weeks later...
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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...