Chemo's Ultimate URL's

BlessIsaacola:

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.

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

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."'";

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!

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 :D

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.

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.php/Contribution:Ultimate_SEO

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

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

hello

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.

heres the paypal fix

http://www.zen-cart.com/forum/showthread.php?p=152157&highlight=paypal#post152157

hth :thumbsup:

abou character conversion in this mode
I have this URL
....cz/epson-v%C3%BDhodn%C3%A9-balen%C3%AD-c-6_7_11.html

czech language have additionl symbols up letters...

It is not looked good but what berret - use character converter for make
/epson-vyhodne-baleni-c-6_7_11.html

or let it be (meibe czech search engines can read this better) ?

and I dont know how to use conversion tools...what chart converter must be used ?
UTF ? or another ?

Im try to make conversion but %C3%BD=>y dosnt work

Look at https://www.zencart.cz to post from Dědek.
http://www.zencart.cz/modules/newbb/viewtopic.php?topic_id=301&viewmode=flat&order=ASC&type=&mode=0&start=0

Wow.. thank you

(dik, ted tam budu cist vice clanku )

ok no fair
I can read English, Japanese, am pretty good at German and have crappy french but czech?:cry:
Would one of you gentlemen be kind enough to translate that post for me please and post it in here?
http://www.zencart.cz/modules/newbb/viewtopic.php?post_id=2446#forumpost2446

Sory Reesy 8)
Im try translate this post

for convert non-english letter Dedek offer this solution

Edit file seo.url.php

After line

this->languages_id = (int)$languages_id;

add this code (I mean you can change this arrea like you need . this is maked for czech and slovak and another languages)

$this->trans = array('ä'=>'ae','ë'=>'ie','ö'=>'oe','ü'=>'ue','Ä'=>'AE','Ë'=>'IE','Ö'=>'OE','Ü'=>'UE',
'á'=>'a','č'=>'c','ď'=>'d','é'=>'e','ě'=>'e','í'=>'i','ľ'=>'l','ň'=>'n','ó'=>'o','ô'=>'o',
'ŕ'=>'r','ř'=>'r','š'=>'s','ť'=>'t','ú'=>'u','ů'=>'u','ý'=>'y','ž'=>'z','Á'=>'A','Č'=>'C',
'Ď'=>'D','É'=>'E','Ě'=>'E','Í'=>'I','Ľ'=>'L','Ň'=>'N','Ó'=>'O','Ô'=>'O','Ŕ'=>'R',
'Ř'=>'R','Š'=>'S','Ť'=>'T','Ú'=>'U','Ů'=>'U','Ý'=>'Y','Ž'=>'Z');

befor this line

switch($this->attributes['SEO_URLS_USE_W3C_VALID']){

add this code

if (is_array($this->trans)) {
  $link = strtr($link, $this->trans);
}

Thats great, thank you very much! :smile:

But you have this URL on your web server...
mod rewrite just change this URL to looked like standart .thml file

I dont know it is good for google or not... I just wait when google bot visit my page for look error statistics on my google sitemaps account.

I'm so glad that I finally found this thread. I had just installed the version for 1.31 when the Zen-Cart forum changed, so I've literally been everywhere looking for an answer.

I have successfully installed this contribution. It works perfectly... except Google hates it. Now since I saw the post where another user has over 2000 pages indexed with Google, I'm thinking I've done something wrong.

Here's the issue. When Google tries to verify the site to upload the Google site map I've installed - I get the following error - 404 error returns a 200OK - cannot verify site. In doing more testing I found that what is happening is that if a non-existent page is requested in the browser instead of "page_not_found.html or .php being returned - the user is just returned to the index.php. It has literally put the brakes on Google indexing beyond the home page.

Here's the link - http://www.bestdiamondwatch.com
Could someone take a look and let me know what I've done incorrectly or if there is somewhere in the code that it can be changed to not do this. I'm desparate on this. I've been trying to get this site indexed for nearly 6 weeks with absolutely zero luck.

Wowie. i got this contribution working now!
Then i saw another one: ImageHandler 2! Functions look great and look fine!!! :)

BUT..i could not find a doc or readme to do some manual changing in html_output.php.... for that is as far as i can see the only crucial core file that comes from the Imagehandler contri and then one of the 2 contri's do not work anymore.

Is there a manual how to do a merging of the SEF url & Image handler in html_output.php?