Chemo's Ultimate URL's

[dreamscape]

Because support for this mod has been inconsistent

Inconsistent support? I have not once turned down support requests from anyone. There is a reason that I offer support as a service to all of my contributions.

The thread in the forums here is for community support, which I will address some questions when and if I can, but mainly it exists for users to support other users. If you truly were in so dire need of assistance, they you could have just sought my support, rather than relying on the community support.

[macson]

my install is ok.
but i got a errors when i visited the first page.

1054 Unknown column 'c.parent_id' in 'on clause'
in:
[SELECT c.categories_id as id, c.parent_id, cd.categories_name as cName, cd2.categories_name as pName FROM zh_categories c, zh_categories_description cd LEFT JOIN zh_categories_description cd2 ON c.parent_id=cd2.categories_id AND cd2.language_id='2' WHERE c.categories_id=cd.categories_id AND cd.language_id='2']

[macson]

my install is ok.
but i got a errors when i visited the first page.

1054 Unknown column 'c.parent_id' in 'on clause'
in:
[SELECT c.categories_id as id, c.parent_id, cd.categories_name as cName, cd2.categories_name as pName FROM zh_categories c, zh_categories_description cd LEFT JOIN zh_categories_description cd2 ON c.parent_id=cd2.categories_id AND cd2.language_id='2' WHERE c.categories_id=cd.categories_id AND cd.language_id='2']

and i find the code from includes\classes\seo.url.php

function generate_categories_cache(){
$this->is_cached($this->cache_file . 'categories', $is_cached, $is_expired);
if ( !$is_cached || $is_expired ) { // it's not cached so create it
switch(true){
case ($this->attributes['SEO_ADD_CAT_PARENT'] == 'true'):
$sql = "SELECT c.categories_id as 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=cd.categories_id
AND cd.language_id='".(int)$this->languages_id."'";
break;
default:
$sql = "SELECT categories_id as id, categories_name as cName
FROM ".TABLE_CATEGORIES_DESCRIPTION."
WHERE language_id='".(int)$this->languages_id."'";
break;
} # end switch

my environment is
apache 2.2 /php 4.4.2/mysql 5.0.20
ZEN 1.3.0.1
Ultimate_SEO_URLs_v2.101

[macson]

i have resolve the problem.
just modify the table sort for left join.

SELECT c.categories_id as 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=cd.categories_id
AND cd.language_id='".(int)$this->languages_id."'";

change to --->
"SELECT c.categories_id as id, c.parent_id, cd.categories_name as cName, cd2.categories_name as pName
FROM
".TABLE_CATEGORIES_DESCRIPTION." cd,
".TABLE_CATEGORIES." c
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."'";

[lhhgbh]

Im getting an error from my application_top.php file telling me to go to line 363.. When I go this is whats on thatline.. What did i do wrong? Im guessing this is preventing it from installing because I dont see the SEO URLs option in my configuration.. Thanks!

<p>// include the extra language translations<br>

[cmiller]

Macson,

Thanks for posting your fix for that issue......I was having the same problem, but couldn't figure out where it was coming from. Good work and thanks again

[yeemn]

When we have this enabled everything works great until the customer gets to the checkout or Add to Cart or login. After entering the info the next page gives a error with 404 not page found.

[I Brian]

It's great to see this MOD around, but I noticed on the Zen Cart Wiki it mentions that this MOD doesn't include a "Paypal Fix":

http://www.zen-cart.com/wiki/index.p...n:Ultimate_SEO

Any suggestions on what this fix is, and where to find it, would be very much appreciated.

[maxus]

Im setup Ultimate_SEO_URLs_v2.101 for 1.3

But something wrong...

Fatal error: Call to undefined function gzdeflate() in /....

any idea ?

[maxus]

Im setup Ultimate_SEO_URLs_v2.101 for 1.3

But something wrong...

Fatal error: Call to undefined function gzdeflate() in /....

any idea ?

after turn on on gzdeflate() - no erro
all OK now