vB Global Translator - Multiply your indexed pages & put search traffic on autopilot

[45wheelgun]

I wrote my own spider and translated all my pages in 40 languages. According to vbSEO sitemap generator - somesthing between 50-60K pages (don't remember exactlly) including oryginal not translated pages. DB stats:
TABLE ROWS SIZE
wt_cache 168 930 166,0 MB
wt_cache_medium 490 901 144,7 MB
wt_cache_short 812 496 66,0 MB

Would you care to share that spider? I would be interested in using it. My server has the horsepower and bandwidth and with 320,000 posts, I would like to get a leg up! Feel free to PM me.

On a related note, can you give me a short explanation of the three databases? How do they correlate with the 50-60k that the sitemap reports?

Great Mod guys, as I said before I am loving it.

[Dave Hybrid]

Would you care to share that spider? I would be interested in using it. My server has the horsepower and bandwidth and with 320,000 posts, I would like to get a leg up! Feel free to PM me.

On a related note, can you give me a short explanation of the three databases? How do they correlate with the 50-60k that the sitemap reports?

Great Mod guys, as I said before I am loving it.

You can just turn the crawl rate up in Google Webmaster Tools, that works.

[pharmacist]

Fantastic Mod
always wait for it

[NLP-er]

Would you care to share that spider? I would be interested in using it. My server has the horsepower and bandwidth and with 320,000 posts, I would like to get a leg up! Feel free to PM me.

On a related note, can you give me a short explanation of the three databases? How do they correlate with the 50-60k that the sitemap reports?

Great Mod guys, as I said before I am loving it.

Some people was already asking me - it is written in Java and uses its testing engine - without IDE you will not be able to even run it. If someone feel good in Java, is able to run tests and edit code to change some hardcoded things, then PM me :)

About cache tables - those split short, medium and long translations. Thanks that it works much faster, because short and medium data have full indexes and unique constraints which preserves data duplication. How those tables correlates with 50-60k of pages in sitemap - they have something about 50k translated pages from my forum :)

[Manoel J?nior]

I did the whole procedure, but does not appear in my navbar

[Dave Hybrid]

I did the whole procedure, but does not appear in my navbar

Then you did something wrong, i suggest you double check everything. :up:

[1Unreal]

Some people was already asking me - it is written in Java and uses its testing engine - without IDE you will not be able to even run it. If someone feel good in Java, is able to run tests and edit code to change some hardcoded things, then PM me :)

About cache tables - those split short, medium and long translations. Thanks that it works much faster, because short and medium data have full indexes and unique constraints which preserves data duplication. How those tables correlates with 50-60k of pages in sitemap - they have something about 50k translated pages from my forum :)

I made a really basic spider in PHP. Heres an element of it. If you build on it you could make it work nicely :)

$html = file_get_contents('http://www.example.com');

$dom = new DOMDocument();
@$dom->loadHTML($html);

// grab all the on the page
$xpath = new DOMXPath($dom);
$hrefs = $xpath->evaluate("/html/body//a");



for ($i = 0; $i < $hrefs->length; $i++) {
$href = $hrefs->item($i);
$url = $href->getAttribute('href');

echo $url.'<br />';
}

[silentcontrol]

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/climarso/public_html/forum/translate.php on line 41
Could not connect: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

why? :(

[tpearl5]

Sounds like you didn't put in the correct database name / username / password in translate.php

[turbosatan]

i havnt asked for a while now so thought i would ask again.

Can you make this work with zoints SEO please.

Some of us dont want to spend $150 on VBSEO when there are equivalents available for free.

I would love to use this mod for several of my forums but they all run zoints for SEO urls.

I will happily make a donation if it means this gets looked t.

T

[Triky]

I have installed it, configured, I have cURL installed, plugins activated, file mods finished, uploaded correcly, edited the navbar template.. but nothing is showing under my navbar. What can I try to do?

[Dave Hybrid]

I have installed it, configured, I have cURL installed, plugins activated, file mods finished, uploaded correcly, edited the navbar template.. but nothing is showing under my navbar. What can I try to do?

If you send me url and login i will have a look.

[Dave Hybrid]

I did the whole procedure, but does not appear in my navbar

If you pm me a url and login i will check it all.

[smnoel]

Small critique. I would put relative paths in the flag php file for the images. Makes your code more portable. ;)

ex:
flags/someimage.gif
instead of
/flag/someimage.gif

[Dave Hybrid]

Small critique. I would put relative paths in the flag php file for the images. Makes your code more portable. ;)

ex:
flags/someimage.gif
instead of
/flag/someimage.gif

More portable? :confused:

[smnoel]

Example:
My forum is not in my root www it is in a sub directory and so is this mod.
http://www.somesite.com/forums/
When you put the slash in front of the image tag it creates a link to:
somesiite.com/flags but it should put a link to where i'm uploading the files.

Hence..you lose some flexibility you either move the files to the webroot flag directory....or you change the tag to point relatively to where the flags are.

If some folks are not seeing the flags...that might be the issue.

P.S. I'm using a unix system. Looks like you might have a windows server.

[Manoel J?nior]

Hello,

You are showing the following error when I ask to do the translation:

102411

Database error in vBulletin 3.8.3:

Invalid SQL:

UPDATE session
SET lastactivity = 1248389420, location = '/forum/?hl=ro', inforum = 0, inthread = 0, incalendar = 0, badlocation = 0, useragent = 'Mozilla/5.0 (Windows; U; Windows NT 6.1; pt-BR; rv:1.9.1.1) Gecko/20090715 Firefox/3.5.1 (.NET CLR 3.5.30729)'
WHERE sessionhash = '07ce83e8f3b7a0e3189f05ebad6d95e7';

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Thursday, July 23rd 2009 @ 05:50:20 PM
Error Date : Thursday, July 23rd 2009 @ 05:51:10 PM
Script : http://www.myforum.com/forum/?hl=ro
Referrer : http://www.myforum.com/forum/private.php
IP Address : 200.161.104.118
Username : myusername
Classname : vB_Database
MySQL Version :

[cyc]

Hello,

You are showing the following error when I ask to do the translation:

102411

Database error in vBulletin 3.8.3:

Invalid SQL:

UPDATE session
SET lastactivity = 1248389420, location = '/forum/?hl=ro', inforum = 0, inthread = 0, incalendar = 0, badlocation = 0, useragent = 'Mozilla/5.0 (Windows; U; Windows NT 6.1; pt-BR; rv:1.9.1.1) Gecko/20090715 Firefox/3.5.1 (.NET CLR 3.5.30729)'
WHERE sessionhash = '07ce83e8f3b7a0e3189f05ebad6d95e7';

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Thursday, July 23rd 2009 @ 05:50:20 PM
Error Date : Thursday, July 23rd 2009 @ 05:51:10 PM
Script : http://www.myforum.com/forum/?hl=ro
Referrer : http://www.myforum.com/forum/private.php
IP Address : 200.161.104.118
Username : myusername
Classname : vB_Database
MySQL Version :


Hi

you might have the wait_timeout variable set to low. Check your mysql config ( /etc/my.cnf ) and increase the value.

regards

[pharmacist]

Please , any configuration to inhibit some categories from translation !
waiting your reply

[Dave Hybrid]

Please , any configuration to inhibit some categories from translation !
waiting your reply

Just show the flags on pages you want to translate using if conditions.

[Saviour]

Please , any configuration to inhibit some categories from translation !
waiting your reply

It would help if you would specify what categories you're referring to, so those supporting this mod can supply you with the proper coding for your conditional.

[azn_romeo_4u]

Say I got a post with 20k replies, is it gonna cache the entire thread or the pages that get visited by the bots and users? Also you can delete which languages you don't want supported right?

[AdamBryner]

Is there anyway this would/could work on a non-vbulletin website? ;)

[jaryx]

I must say: Translator not work on 100% correctly with vBseo. Mod don't translate vbseo Relevant Replacement

Topic in Polish:
http://fifa.pes.com.pl/gry-komputerowe-f1924/najlepsza-gra-multiplayer-18157.html

Najlepsza gra multiplayer?
Dyskusja w temacie Najlepsza gra multiplayer? na forum Inne gry -> Gry komputerowe;
Witam! Panowie jakie możecie polecić najlepsze (najbardziej grywalne i wciągające) gry multiplayer? Ostatnio odświeżyłem CS 1.6 i fajnie było sobie przypomnieć stary klimat! Dzisiaj przetestuję z kumplem Diablo II i ...

Topic translated to English:
http://fifa.pes.com.pl/gry-komputerowe-f1924/najlepsza-gra-multiplayer-18157.html?hl=en


The best multiplayer game?

Dyskusja w temacie Najlepsza gra multiplayer? na forum Inne gry -> Gry komputerowe;
Witam! Panowie jakie mo�ecie poleci� najlepsze (najbardziej grywalne i wci�gaj�ce) gry multiplayer? Ostatnio od�wie�y�em CS 1.6 i fajnie by�o sobie przypomnie� stary klimat! Dzisiaj przetestuj� z kumplem Diablo II i ..

The problem does not deal with Relevant Replacement or Google Translator, because if I paste the address directly into the translator window, everything is translated, including RR.
http://translate.google.pl/translate?hl=pl&sl=pl&tl=en&u=http%3A%2F%2Ffifa.pes.com.pl%2Fgry-komputerowe-f1924%2Fnajlepsza-gra-multiplayer-18157.html

Any solution?
You can somehow resolve this problem?

[Dave Hybrid]

Mr RR's translate fine so not sure what the problem would be...

[ZiG]

what would be a good edition to this, is to enable a feature to add the translation to the posbit for individual posts, that way if you have members from diferent regions in the world they can easily translate individual posts to their native language so that people all around the world can easily communicate

[NLP-er]

I must say: Translator not work on 100% correctly with vBseo. Mod don't translate vbseo Relevant Replacement

Topic in Polish:
http://fifa.pes.com.pl/gry-komputerowe-f1924/najlepsza-gra-multiplayer-18157.html

Najlepsza gra multiplayer?
Dyskusja w temacie Najlepsza gra multiplayer? na forum Inne gry -> Gry komputerowe;
Witam! Panowie jakie możecie polecić najlepsze (najbardziej grywalne i wciągające) gry multiplayer? Ostatnio odświeżyłem CS 1.6 i fajnie było sobie przypomnieć stary klimat! Dzisiaj przetestuję z kumplem Diablo II i ...

Topic translated to English:
http://fifa.pes.com.pl/gry-komputerowe-f1924/najlepsza-gra-multiplayer-18157.html?hl=en


The best multiplayer game?

Dyskusja w temacie Najlepsza gra multiplayer? na forum Inne gry -> Gry komputerowe;
Witam! Panowie jakie mo�ecie poleci� najlepsze (najbardziej grywalne i wci�gaj�ce) gry multiplayer? Ostatnio od�wie�y�em CS 1.6 i fajnie by�o sobie przypomnie� stary klimat! Dzisiaj przetestuj� z kumplem Diablo II i ..

The problem does not deal with Relevant Replacement or Google Translator, because if I paste the address directly into the translator window, everything is translated, including RR.
http://translate.google.pl/translate?hl=pl&sl=pl&tl=en&u=http%3A%2F%2Ffifa.pes.com.pl%2Fgry-komputerowe-f1924%2Fnajlepsza-gra-multiplayer-18157.html

Any solution?
You can somehow resolve this problem?

As I already PM to you - I suspect that this not translated content is added by some mod (I suspect this because of comments around this text in page code) - it this is correct then it is normal that this text is not translated - it is probably added after translation :) Solution - change the order

[Manoel J?nior]

I must say: Translator not work on 100% correctly with vBseo. Mod don't translate vbseo Relevant Replacement

Topic in Polish:
http://fifa.pes.com.pl/gry-komputerowe-f1924/najlepsza-gra-multiplayer-18157.html

Najlepsza gra multiplayer?
Dyskusja w temacie Najlepsza gra multiplayer? na forum Inne gry -> Gry komputerowe;
Witam! Panowie jakie możecie polecić najlepsze (najbardziej grywalne i wciągające) gry multiplayer? Ostatnio odświeżyłem CS 1.6 i fajnie było sobie przypomnieć stary klimat! Dzisiaj przetestuję z kumplem Diablo II i ...

Topic translated to English:
http://fifa.pes.com.pl/gry-komputerowe-f1924/najlepsza-gra-multiplayer-18157.html?hl=en


The best multiplayer game?

Dyskusja w temacie Najlepsza gra multiplayer? na forum Inne gry -> Gry komputerowe;
Witam! Panowie jakie mo�ecie poleci� najlepsze (najbardziej grywalne i wci�gaj�ce) gry multiplayer? Ostatnio od�wie�y�em CS 1.6 i fajnie by�o sobie przypomnie� stary klimat! Dzisiaj przetestuj� z kumplem Diablo II i ..

The problem does not deal with Relevant Replacement or Google Translator, because if I paste the address directly into the translator window, everything is translated, including RR.
http://translate.google.pl/translate?hl=pl&sl=pl&tl=en&u=http%3A%2F%2Ffifa.pes.com.pl%2Fgry-komputerowe-f1924%2Fnajlepsza-gra-multiplayer-18157.html

Any solution?
You can somehow resolve this problem?
That solved by changing the coding of your browser.

Change to Universal

[jaryx]

That solved by changing the coding of your browser.

Change to Universal

I know that coding is wrong. But wrong only on Relevant Replacements,
the remaining page content is converted to UTF and displays correctly.
It is because vbseo RR is loaded after page is translated.
And that is the essence of the problem. I think, something is wrong in mod, because when I paste link to translate.google.com whole site is translated correctly.

[jaryx]

Mr RR's translate fine so not sure what the problem would be...

Michael Biddle vBSEO Staff says:
Maybe its the hook execution order? Have you tried changing the execution order on the other?
That is something you need to change on the translator mod. I have never used it, so I do not know what hooks they use. Again, this is just a guess, but it is worth a try. In your plugin manager, click the plugin and it should have a box for execution order.

http://www.vbseo.com/f77/relevant-replacment-vb-global-translator-35825/

How I can change execution order? :)

[CThiessen]

Hi,
it ist working on my site.
http://brasil-web.de/forum/28018-unterkuenfte-belem-waehrend-des-cirio-de-nazare.html?hl=pl

I do have:
(Hook) : global_complete
execution order
vBSEO Global Hook : 15
vB Global Translator: 50

Greetings
Christian

[Sweeks]

I have been following this mod right from the start and I must say, yes it is great!!!

I have a small problem, I would like the mod to ignore a section of code so it is untranslated. I am sure I have seen how to do it at some point in this thread, is there any chance if this is possible you could add it to the first post so it is easy to find :)

[imported_silkroad]

Hi Dave!

We are definately seeking results (sooner than expected, BTW), so I will be sending some PayPal coin your way.

I have a question on overloadcache.txt in translate.php:

Our load average on linux is above 1.5 most of the weekday(s) but I have never seen translate.php create overloadcache.txt (GoogleBot is pulling 150 pages per second much of the time these days).

Does that mean there is a bug in translate.php ?

[NLP-er]

Hi Dave!

We are definately seeking results (sooner than expected, BTW), so I will be sending some PayPal coin your way.

I have a question on overloadcache.txt in translate.php:

Our load average on linux is above 1.5 most of the weekday(s) but I have never seen translate.php create overloadcache.txt (GoogleBot is pulling 150 pages per second much of the time these days).

Does that mean there is a bug in translate.php ?

No it was disabled. In translate.php You can find:

//MY CODE TO DISABLE SERVER LOAD CHEcKING
return 1;
//END


Just remove it to enable load checking. I disabled it when working on cache, I don't know does it goes to release by mistake or it was Dave decision - ask Dave :)

[vividbreeze]

Can you install this mod for me?

[Manoel J?nior]

Can you install this mod for me?
paid service?

[imported_silkroad]

No it was disabled. In translate.php You can find:

//MY CODE TO DISABLE SERVER LOAD CHEcKING
return 1;
//END


Just remove it to enable load checking. I disabled it when working on cache, I don't know does it goes to release by mistake or it was Dave decision - ask Dave :)

OK, thanks :o (Should have noticed that!)

I commented out your return 1 and changed the loadavg amount from 1.5 to 5.5 in the condition check, if(floatval(getServerLoad()) >= 5.5)

I think I will also change the function getServerLoad() to return $load[1] instead of $load[0], to smooth things (remove noise) a bit.

Cheers and thanks for the reply.

[NLP-er]

Can you install this mod for me?

PM Dave or me

[Dave Hybrid]

Hi Dave!

We are definately seeking results (sooner than expected, BTW), so I will be sending some PayPal coin your way.

I have a question on overloadcache.txt in translate.php:

Our load average on linux is above 1.5 most of the weekday(s) but I have never seen translate.php create overloadcache.txt (GoogleBot is pulling 150 pages per second much of the time these days).

Does that mean there is a bug in translate.php ?

It is old code, ignore it.

[imported_silkroad]

It is old code, ignore it.

I assume it does not work, right?

So, we should comment it out and not use it?

[vividbreeze]

yea ill pay ;)

[Dave Hybrid]

NLP-er will install for cash, PM him, his username is at the top of the MOD post.

[imported_silkroad]

I have a small problem, I would like the mod to ignore a section of code so it is untranslated.

We have the same issue.

We need to omit certain parts of the posts, especially the text within code tags. Currently, this is not supported and we have not found any way to omit parts of posts from translation.

[imported_silkroad]

Dear Dave and NLP-er,

I note that when I add the translation flags to /archive/index.php (part of vbSEO), the translation does not work for us, perhaps because we renamed the archive directory in vBSEO?

[Sweeks]

Here is a slight problem in Google Webmaster Tools I have noticed since adding the showthread URLS to the sitemaps:

Errors -
Duplicate URL
This URL is a duplicate of another URL in the sitemap. Please remove it and resubmit.
URL: http://www.teenforumz.com/sex-sexuality/4746-who-loves-sex-3.html?hl=hr
Problem detected on: Jul 30, 2009
Errors -
Duplicate URL
This URL is a duplicate of another URL in the sitemap. Please remove it and resubmit.
URL: http://www.teenforumz.com/sex-sexuality/4746-who-loves-sex.html?hl=hr
Problem detected on: Jul 30, 2009
Errors -
Duplicate URL
This URL is a duplicate of another URL in the sitemap. Please remove it and resubmit.
URL: http://www.teenforumz.com/sex-sexuality/4835-blowjob-2.html?hl=hr
Problem detected on: Jul 30, 2009
Errors -
Duplicate URL
This URL is a duplicate of another URL in the sitemap. Please remove it and resubmit.
URL: http://www.teenforumz.com/sex-sexuality/4835-blowjob.html?hl=hr
Problem detected on: Jul 30, 2009

Hope there is a way to fix these easy as it is on every sitemap created.

[imported_silkroad]

We donated using PayPal :-)

More to come ..... as we see results!

Thanks again for this mod!

[NLP-er]

Here is a slight problem in Google Webmaster Tools I have noticed since adding the showthread URLS to the sitemaps:

Errors -
Duplicate URL
This URL is a duplicate of another URL in the sitemap. Please remove it and resubmit.
URL: http://www.teenforumz.com/sex-sexuality/4746-who-loves-sex-3.html?hl=hr
Problem detected on: Jul 30, 2009
Errors -
Duplicate URL
This URL is a duplicate of another URL in the sitemap. Please remove it and resubmit.
URL: http://www.teenforumz.com/sex-sexuality/4746-who-loves-sex.html?hl=hr
Problem detected on: Jul 30, 2009
Errors -
Duplicate URL
This URL is a duplicate of another URL in the sitemap. Please remove it and resubmit.
URL: http://www.teenforumz.com/sex-sexuality/4835-blowjob-2.html?hl=hr
Problem detected on: Jul 30, 2009
Errors -
Duplicate URL
This URL is a duplicate of another URL in the sitemap. Please remove it and resubmit.
URL: http://www.teenforumz.com/sex-sexuality/4835-blowjob.html?hl=hr
Problem detected on: Jul 30, 2009

Hope there is a way to fix these easy as it is on every sitemap created.

I saw this yesterday in my webmaster tools. Right now have no idea why it happens. Changes in vbSEO Sitemap generator was suggested by vbSEO staff - they should know what happens. I'm not vbSEO Sitemap Generator developer and have no idea what happens inside...

[NLP-er]

We have the same issue.

We need to omit certain parts of the posts, especially the text within code tags. Currently, this is not supported and we have not found any way to omit parts of posts from translation.

Great idea :) My part in this mod is only cache issues - this is Dave's mod and he is planning new releases and functionalities. I add my voice for this functionality :)

[NLP-er]

Dear Dave and NLP-er,

I note that when I add the translation flags to /archive/index.php (part of vbSEO), the translation does not work for us, perhaps because we renamed the archive directory in vBSEO?

No it's because there is no plugin which reacts for archive :)

All you have to do is copy plugin for this mod in global_complete hook, and set in copy archive_complete hook :)

Here you have working archive translation on my forum:
http://www.forum.simple-nlp.pl/archive/t-677.html?hl=ar

(I didn't add flags, because I don't want my archive be translated - made it available only that you can see it)

[NLP-er]

We donated using PayPal :-)

More to come ..... as we see results!

Thanks again for this mod!

Great thanks :-)

Donation received!

Wish you lot of results ;)

[Verionia]

Yes, users aren't able to view the site in the change language, just one page then it switches to native language...

[CThiessen]

I saw this yesterday in my webmaster tools. Right now have no idea why it happens. Changes in vbSEO Sitemap generator was suggested by vbSEO staff - they should know what happens. I'm not vbSEO Sitemap Generator developer and have no idea what happens inside...
HI,
until now I do not have that in my Webmaster tools.
I do ad 2 Languages, so fare.

Maybe it is a mistake form Google because the content is different.

But:
My Glossary Pages:
http://brasil-web.de/forum/wiki/1-brasilien/1134-transamazonica.html?hl=pt
if I see them with the IE7 at my work I do not see any Content on translated pages, only the empty frames. If I turn of the AdSense code it is working.
It?s also working with Firefox and IE8.
So there might be some other code that make Google see the same that I see with IE7 (nothing) in that case the rest oft the Page is duplicate.
So we have to find out how Google see the Website.

Christian

[imported_silkroad]

FWIW, we are running the vBSEO sitemap generator mod suggested for this mod (by the vBSEO team in reply to Dave's query); and we do not get any (related) errors in our site map (fingers crossed :up: )

[NLP-er]

FWIW, we are running the vBSEO sitemap generator mod suggested for this mod (by the vBSEO team in reply to Dave's query); and we do not get any (related) errors in our site map (fingers crossed :up: )

I'm using the same and I have :( It didn't happen before - as I wrote - I saw this yesterday...

Also those errors appears only for few translated links for 1000 links in each sitemap (this is size which I set in my vbSEO Sitemap Generator) - have no idea what makes those different than other translated links...

[NLP-er]

Yes, users aren't able to view the site in the change language, just one page then it switches to native language...

???

[NLP-er]

HI,
until now I do not have that in my Webmaster tools.
I do ad 2 Languages, so fare.

Maybe it is a mistake form Google because the content is different.

But:
My Glossary Pages:
http://brasil-web.de/forum/wiki/1-brasilien/1134-transamazonica.html?hl=pt
if I see them with the IE7 at my work I do not see any Content on translated pages, only the empty frames. If I turn of the AdSense code it is working.
It?s also working with Firefox and IE8.
So there might be some other code that make Google see the same that I see with IE7 (nothing) in that case the rest oft the Page is duplicate.
So we have to find out how Google see the Website.

Christian

Probably your employer cut off your access to some Internet areas. I don't think that google spider have this problem with his employer ;)

Seriously - on my net I also have problems with getting some addresses (have no idea why), but those addresses works fine what I was checking from other locations.
For me Google is too good/big/serious to allow themselves to have such problems. In such case no matter what content you have there would be risk that Google will never see it, because of some Internet problems.

It just don't fill in my head ;)

[wolfstream]

Nice mod!

One feature request would be to make it that if the user clicks on a language that the site somehow (maybe via cookie?) remembers this, and delivers all their content from that point on in that language. Too hard to do? I wouldn't think so.

[imported_silkroad]

Nice mod!

One feature request would be to make it that if the user clicks on a language that the site somehow (maybe via cookie?) remembers this, and delivers all their content from that point on in that language. Too hard to do? I wouldn't think so.

Well, the mod is mostly designed for search engine referrals, not quality translations. In fact, Google Translate translations are known to be of poor quality for many languages. For our site, even basic English-Japanese translations are mostly humor for Japanese native speakers.

What would be more useful, based on user experience with this great mod, would be to support other translation services in the future because Google Translate is quite bad, frankly speaking.

In addition, there must be a way to tell the mod which text *not* to translate because translating source code, etc. is not good.......

In other words, this is a great mod, for what is was designed to do, improved SE referrals. It is not yet a high quality translation service because that was not the design goal.


Cheers.

[NLP-er]

What would be more useful, based on user experience with this great mod, would be to support other translation services in the future because Google Translate is quite bad, frankly speaking.

Do you know some automatic translation service which gives good translations?

[bollie]

I have eror

Parse error: syntax error, unexpected $end in /home/xxxxxxxx/public_html/includes/functions.php(5721) : eval()'d code on line 59

[wolfstream]

WAYYYY too many slow SQL queries, killing SQL server.

uninstalled

[NLP-er]

I have eror

Parse error: syntax error, unexpected $end in /home/xxxxxxxx/public_html/includes/functions.php(5721) : eval()'d code on line 59

When this error happens?

[cyc]

WAYYYY too many slow SQL queries, killing SQL server.

uninstalled

Once pages are cached, users shouldn't notice much difference in load times.

Was your mysql server getting killed once you installed this on the forum linked to in your sig?

[wolfstream]

It doesn't matter at this point, I have no intention of reinstalling this mod.
Your mod caused hundreds of slow sql queries, which, of course, caused massive problems with the server.

[matthewhotdude]

So the SQL am i adding that to the current database that my forum uses?

[cyc]

It doesn't matter at this point, I have no intention of reinstalling this mod.
Your mod caused hundreds of slow sql queries, which, of course, caused massive problems with the server.

the initial caching of a page is slow, we found 3 - 10 seconds. After that we found pages were generated almost as fast as standard pages eg; not noticeable when browsing.

You only have a hand full of posts. If it caused, as you put it "massive problems" i'd say you need to find a decent host or get a more powerful server. Maybe you could post some detail about the "massive problems" so dave or his off sider could comment?

[wolfstream]

It's not the host, or the server that is causing the problem, the mod is.
Stop trying to make assumptions about that which you know nothing of.

Prior to installing this mod, the forum used 1-5 mysql processes constantly. SINCE using the mod (before removing it), the forum jumped from 1-5 mysql processes constantly to 50-70. There is no reason for this except the mod. Once the mod was disabled and removed? Back to 1-5 mysql processes.

This mod handles sql VERY poorly and causes issues. It's not the server's fault the mod is slow, it's the mod's fault. It's not the server's fault the mod handles queries slowly, it's the mod's fault. It's not the server's fault the mod takes forever to work, it's the mod's fault.

Stop trying to blame things which you know nothing of. The server wasn't under load at all, in fact, it was just fine. The mod makes entirely too many slow queries, end of story.

[cyc]

It's not the host, or the server that is causing the problem, the mod is.
Stop trying to make assumptions about that which you know nothing of.


I've installed this on 3 forums so far, one has 7 million+ posts, the other 3.5million and the smallest 1.1 million. 1,500+ active user sessions are common on all of them.

MySQL usage obversely increased, there were no noticeable effects on server performance from a users POV. Average load floats between 1 and 2 on all of our servers, none of them have "massive problems".

You have 2,300 posts in the forum linked in your sig. You must be able to see why I suggested server or host maybe not up to scratch. You inital post was vauge so I went for the low fruit ;)

The mod isn't perfect, but it does a reasonable job. It's very easy to install and once translated pages are cached, they load fast enough for a user not to notice a speed difference between translated and non-translated pages.

regards

[imported_silkroad]

Do you know some automatic translation service which gives good translations?

One of our forum members has a lot of experience in this area. I will ask for his suggestions and get back to you on this.

As for Japanese, so far we have found the Yahoo translation service much better than Google's service. However, I have no idea about the API service.

[bollie]

I have eror

Parse error: syntax error, unexpected $end in /home/xxxxxxxx/public_html/includes/functions.php(5721) : eval()'d code on line 59

Wen i use Save the plugin and activate.

[imported_silkroad]

Wen i use Save the plugin and activate.

When you post lines of code errors, it is a bit "meaningless" if you don't also post the exact version of vB you are running, etc.

You are posting an "error" from a function outside of this mod. What is the calling function?

[matthewhotdude]

I'm at this part now

You need to comment out the flag for your base language otherwise you can cause duplicate URLs for those pages and this can be bad for SEO.

All the flags are on separate lines in alpha order, find your language and add <!-- to the start and --> to the end of the line.

eg; <!-- language flag code -->



Could someone past what this line is supposed too look like after the edit

. 'hl=en' : str_replace($xbit.'hl='.@$_GET['hl'], '', $_SERVER["REQUEST_URI"]) . $xbit . "hl=en"; ?>"><img src="/flags/United States.gif" alt="English" border="0" /></a>

[imported_silkroad]

(Deleted by imported_silkroad)

[imported_silkroad]

OBTW: Is the duplicate entry in the sitemap error by Google still unresolved?

[NLP-er]

It doesn't matter at this point, I have no intention of reinstalling this mod.
Your mod caused hundreds of slow sql queries, which, of course, caused massive problems with the server.

There is no any slow query :) There is no any joins. Each query takes data only from 1 table. Each select takes indexed data, so answer is immediate :) Learn more about DB :)

[NLP-er]

rly and causes issues. It's not the server's fault the mod is slow, it's the mod's fault. It's not the server's fault the mod handles queries slowly, it's the mod's fault. It's not the server's fault the mod takes forever to work, it's the mod's fault.

Stop trying to blame things which you know nothing of. The server wasn't under load at all, in fact, it was just fine. The mod makes entirely too many slow queries, end of story.

You now such word as: hypocrite? Did you even look ad this mod DB structure? Did you even look at this mod SQL queries?

As I wrote - there is no any slow query. Queries are instant, cause each data in where cause is indexed and data is taken without any joins. This is fastest kind of queries in any DB engine :)

So take advice of your own and:
Stop trying to blame things which you know nothing of

:D

[NLP-er]

Wen i use Save the plugin and activate.

Make sure you copied all plugin content and you set appropriate hook.

[NLP-er]

I'm at this part now

You need to comment out the flag for your base language otherwise you can cause duplicate URLs for those pages and this can be bad for SEO.

All the flags are on separate lines in alpha order, find your language and add <!-- to the start and --> to the end of the line.

eg; <!-- language flag code -->



Could someone past what this line is supposed too look like after the edit

. 'hl=en' : str_replace($xbit.'hl='.@$_GET['hl'], '', $_SERVER["REQUEST_URI"]) . $xbit . "hl=en"; ?>"><img src="/flags/United States.gif" alt="English" border="0" /></a>

Coment the line:

<!--
EVERYTHING BETWEEN THOSE IS COMMENTED
-->


:)

[NLP-er]

OBTW: Is the duplicate entry in the sitemap error by Google still unresolved?

Still have no idea :) As I wrote sitemap is not generated by this mod, but by vbSEO Sitemap Generator, so question should be for their staff. I don't care enough to ask them ;)

[wolfstream]

Wow, you really are clueless, aren't you?
Debugging PROVES that this mod caused the slow queries.

Previous to your mod:
Forum has 1-5 queries constantly running through mysql. Yeah, that's all, just 1-5, and that's normal and natural

Your mod installed:
Within 24 hours of having your mod installed, that 1-5 queries ran up to 50+, ALL with excessive time .

AFTER your mod removed
Forum has 1-5 queries constantly running through mysql. Yeah, that's all, just 1-5, and that's normal and natural


Don't even start with me and "that which you do not know". I develop and debug php/sql software for a living, it's what I do. I know full well how to develop, test, and work with software. In this case, the cause of the slow queries is quite evident. Just because you don't want to admit your product has this problem doesn't mean it's not so.

This product has nothing but slow queries. 10s response times? Yeah right, try 10 minutes, IF you're lucky.

[basilrath]

Are we saying the mod is not workable in any shape or form?

[cyc]

Are we saying the mod is not workable in any shape or form?

Nope, some guy with a tiny little forum posts vague replies. Which frankly, are no help to anyone. If I had a 3,000 post forum that suffered "massive problems" after installing this mod, I to would be extremely angry at my host or server administator. His attitude is perfectlly understandable ;)

If your website has appeal to people who's primary language isn't English, I reckon you'd be mad not to give it a go. Most of the people how have posted in this thread seem to be happy to share information or help each other.

[imported_silkroad]

Still have no idea :) As I wrote sitemap is not generated by this mod, but by vbSEO Sitemap Generator, so question should be for their staff. I don't care enough to ask them ;)

Oh! You should care ;)

Here is the reason why:

Google Sitemap Update Frequency and Sitemap Stats (http://www.thecepblog.com/2009/02/03/google-sitemap-update-frequency-and-sitemap-stats/)

Proper site maps make a huge difference when indexing :D

[NLP-er]

Wow, you really are clueless, aren't you?
Debugging PROVES that this mod caused the slow queries.

Previous to your mod:
Forum has 1-5 queries constantly running through mysql. Yeah, that's all, just 1-5, and that's normal and natural

Your mod installed:
Within 24 hours of having your mod installed, that 1-5 queries ran up to 50+, ALL with excessive time .

AFTER your mod removed
Forum has 1-5 queries constantly running through mysql. Yeah, that's all, just 1-5, and that's normal and natural


Don't even start with me and "that which you do not know". I develop and debug php/sql software for a living, it's what I do. I know full well how to develop, test, and work with software. In this case, the cause of the slow queries is quite evident. Just because you don't want to admit your product has this problem doesn't mean it's not so.

This product has nothing but slow queries. 10s response times? Yeah right, try 10 minutes, IF you're lucky.

LOL :D You are funny guy :) Especially with this "Don't even start with me". You have very huuuuuuuuuuge ego.

I was never discuss number of queries with you :) Keep focused! Or you don't have to because you are debug php/sql software for a living :D

You still didn't tell do you even know what kind of queries are in this mod. Can you show me which query is such slow for you and what is the time of that query? Or just debugging php/sql software for a living you don't have to identify the problem? :D

Are you able to point at least 1 slow query o master of masters who debug php/sql for a living?

Thanks for laugh which you gave me :D :up:

[NLP-er]

Oh! You should care ;)

Here is the reason why:

Google Sitemap Update Frequency and Sitemap Stats (http://www.thecepblog.com/2009/02/03/google-sitemap-update-frequency-and-sitemap-stats/)

Proper site maps make a huge difference when indexing :D

Good point - thanks :up: :)

[imported_silkroad]

Good point - thanks :up: :)

Thanks. Yea, the problem is that there is no other way (that we know of) to inform GoogleBot of the update frequencies, it is really inefficient to have Google just crawling for the sake of it without any "brains", especially for large forums.

Here is my other suggestions / recommendation for the future:


Using mod_rewrite, rewrite /forum/....html?hl=foo to be either /forum/foo/...html or /forum/....-foo.html


Modify vBSEO sitemap to change the way they have suggested indexing the flags:


Do not sitemap index like this:


index.html
index.html?hl=ja
index.html?hl=foo

Index like this (keep original content in tact):

index.html
forum/thread1.html
forum/thread2.html
forum/thread-etc.html

and then do an entire language as a group:

index.html
forum/thread1-ja.html
forum/thread2-ja.html
forum/thread-etc-ja.html

Repeat.

The reason for this is that it is easier to manage the (long term) indexing process if the language links are all nice and neat in a few sequencial sitemap files v. interwoven around each link. (The "interwoven process" in a nightmare, quite frankly).

Sorry, but the solution offered by the vBSEO team, while better than nothing, is not very manageable for large boards if you care about the convergence of Googles index with your sitemap. (Everyone should care if they care about SEO).

We track this on a weekly basis and have currently have nearly 92% convergence. Google does not keep dumping and recrawling, etc. (as it currently happening with the translated links) because there is no update frequency associated with the hl=foo links :erm:

Cheers.

[imported_silkroad]

This product has nothing but slow queries. 10s response times? Yeah right, try 10 minutes, IF you're lucky.

Actually, that is not true. We run this mod on a large board and have benchmarked it.

Yes, it adds a lot of time (slow queries) when a page is first translated; but after it is translated (and snug-as-a-bug-in-a-rug in the dB), it adds less than 100ms to a showthread query.

Naturally, since it must go across the network to sing the Google translation API song, that query will be very slow.

It's OK to beat up on these guys, since the code is free and you don't seem to understand it yet. ;-) They are used to it, but don't expect flowery replies when you beat them up ;)

I think they have done an outstanding job, and have donated one, of perhaps many, donations to these unsung heros of increased web traffic :-) In addition, I nominated this the "MOTM"! It is an amazing mod, and hopefully, will get better over time, if folks don't beat up the coders and chase them away!

[cyc]

Actually, that is not true. We run this mod on a large board and have benchmarked it.

Yes, it adds a lot of time (slow queries) when a page is first translated; but after it is translated (and snug-as-a-bug-in-a-rug in the dB), it adds less than 100ms to a showthread query.

Naturally, since it must go across the network to sing the Google translation API song, that query will be very slow.

That is also our experience with it :)

[NLP-er]

Yes, it adds a lot of time (slow queries) when a page is first translated; but after it is translated (and snug-as-a-bug-in-a-rug in the dB), it adds less than 100ms to a showthread query.

Naturally, since it must go across the network to sing the Google translation API song, that query will be very slow.

As I understood wolfstream, he was talking about DB SQL queries.

As you just wrote when page is first time translated long translation time is caused by http queries (requests) to Google for translation, not by SQL queries to DB (which are instant) :)

We are not able to make Google faster ;)

[NLP-er]

Also - thanks again for donation ;) :up:

[imported_silkroad]

After working with this mod for three weeks, I have dropped the Google Sitemap method suggested by the vBSEO team. That method, well intended, was a quick "kludge" which was not optimal for this type of application.

What I have done is easy and requires a small bit of manual labor and goes something like this:


Copy the *xml.gz files from ./vbseo_sitemap/data to another directory, for example FORUMROOT/es for Spanish, FORUMROOT/ja for Japanese, FORUMROOT/zh-CN for Chinese etc.

Unzip the files and use sed to add the ?hl=ja (or whatever flag you want to do) to each URL in the Sitemap. This takes about 10 seconds.

Update sitemap_index.xml.gz the same way, or use VI, etc.

Submit this Sitemap to Google.

Copy the first one you did and repeat for as many languages as you wish.


This method has many advantages.

First of all you have a completely different sitemap of your entire site for each language. So easy to submit to language specific search engines. Also, you can easily track the indexing progress for each Sitemap. This is much easier to manage and much cleaner, IMHO.

Of course, this method takes a bit of work when your need to update your language Sitemaps, but if you have a large board, this will get you indexed nicely in a well organized way. You can add the newer links after a high percentage of the legacy links are archived (in a few months).

We added the top 10 languages to Google Webmaster Tools, each with its own Sitemap, so where we originally had one big sitemap with nearly 396K URLs, we now have a total of around 4,750K URLs total in 11 Sitemaps. So far, Google is happy :-)

With this simple method, you can see the index progress on each language. You can submit your Sitemaps to language specific search engines. You can manage the update frequency on the translated URLs differently than your main site. You can also avoid any potential problems with your main sitemap.

(See attachment)

Enjoy and Good Luck!

[imported_silkroad]

I forgot to add, for the next "trick" I will write the URLs in the new Sitemaps as

FORUMROOT/flag/url.html

versus

FORUMROOT/url.html?hl=flag

etc....

and then add a very simple mod_rewrite rule to rewrite FORUMROOT/flags/blahblah.... to FORUMROOT/blahblah?hl=flag

:-)

[cyc]

I forgot to add, for the next "trick" I will write the URLs in the new Sitemaps as

FORUMROOT/flag/url.html

versus

FORUMROOT/url.html?hl=flag

etc....

and then add a very simple mod_rewrite rule to rewrite FORUMROOT/flags/blahblah.... to FORUMROOT/blahblah?hl=flag

:-)

Great idea! keep in mind this will effect paths to css and images on some forums.

[imported_silkroad]

Note:

We are definately seeing a sort of "Google penalty" for using ?hl=flag (duplicate content, it seems -- at least in the Sitemaps)

As Google indexes the various language sitemaps, it is subtracting indexed links from the main sitemap ... so I will need to rewrite the URLs sooner-than-later !

[NLP-er]

Note:

We are definately seeing a sort of "Google penalty" for using ?hl=flag (duplicate content, it seems -- at least in the Sitemaps)

As Google indexes the various language sitemaps, it is subtracting indexed links from the main sitemap ... so I will need to rewrite the URLs sooner-than-later !

I think it was temporary Google problem - I change nothing and right now my sitemap is clear of duplicate content errors :) Just checked.

[imported_silkroad]

<font color="Red">EDIT: DOES NOT WORK YET. DO NOT USE THE 'BRAINSTORMING' IDEA HERE</font>. - imported_silkroad

Cheers NLP-er and Thanks.

I think we will vBSEO rewrite, something like:

'^(.+?)\.html\?hl=(.+?)$' => '$2/$1.html'

Do you think it this work?

Or maybe just manually change the sitmaps (as above #591) and try:

'^ja/(.+?)\.html$' => '$1.html?hl=ja'
'^ru/(.+?)\.html$' => '$1.html?hl=ru'
'^ko/(.+?)\.html$' => '$1.html?hl=ko'

yadda, yadda, yadda ..

Maybe?

[swerdlow]

just installed this...works great and easy setup too

thanks ;)

[tpearl5]

Cheers NLP-er and Thanks.

I think we will vBSEO rewrite, something like:

'^(.+?)\.html\?hl=(.+?)$' => '$2/$1.html'

Do you think it this work?

Or maybe just manually change the sitmaps (as above #591) and try:

'^ja/(.+?)\.html$' => '$1.html?hl=ja'
'^ru/(.+?)\.html$' => '$1.html?hl=ru'
'^ko/(.+?)\.html$' => '$1.html?hl=ko'

yadda, yadda, yadda ..

Maybe?

Did you add this to your custom rewrite rules and custom redirects?

[NLP-er]

Cheers NLP-er and Thanks.

I think we will vBSEO rewrite, something like:

'^(.+?)\.html\?hl=(.+?)$' => '$2/$1.html'

Do you think it this work?

Or maybe just manually change the sitmaps (as above #591) and try:

'^ja/(.+?)\.html$' => '$1.html?hl=ja'
'^ru/(.+?)\.html$' => '$1.html?hl=ru'
'^ko/(.+?)\.html$' => '$1.html?hl=ko'

yadda, yadda, yadda ..

Maybe?

I checked first one '^(.+?)\.html\?hl=(.+?)$' => '$2/$1.html' and it crashed my forum :D So I commented it.

The best way would be to redirect internally URLs like country/rest to rest?hl=country.
Internally I mean without changing URL in browser (without sending header).
And redirect URLs like rest?hl=country to country/rest with 301 header.

It would be best because old, already indexed addresses will work. Redirect will made reindexing faster (I think :)) and you avoid possibility of duplicate content penalty if same content is available in booth URL's. In same time it would be good for this mod because no changes would be required at all. Unfortunately I'm not expert in .htaccess file or vbSEO custom rewrite rules, so I don't know does it is possible. For sure it is possible to redirect one address to other, but can it be done internally?...

[imported_silkroad]

I checked first one '^(.+?)\.html\?hl=(.+?)$' => '$2/$1.html' and it crashed my forum :D So I commented it.

Sorry about that!

I tried something similar in .htaccess after posting above and it crashed here too.... driving the load average of the server to outer space :o

More later ..... :confused:

[imported_silkroad]

Hey!

I nominated the mod for MOTM, and sure enough, there it is and currently running in second place !!!

https://vborg.vbsupport.ru/showthread.php?t=219942

Go Man Go!

[imported_silkroad]

Did you add this to your custom rewrite rules and custom redirects?

No, not yet.... just brainstorming.... please do not install the CRRs mentioned !

I was only brainstorming with NLP-er !! (and it did not work yet!)

Still under development!!

Ideas welcome!

PS: Maybe I should not brainstorm CRRs here? We don't want anyone to crash their board on an untested idea....

[CThiessen]

Ideas welcome!

Hi.
Maybe it is necessary to change the general rewrite settings.


Instead of : link.html use link.html&hl=en (own language) by editing the core files.

So than the standard is equal.
In the next step using the CRR to change:

link.html&hl=en to link.html (own language)
and
link.html&hl=ja to /ja/link.html (for every other language)

I am not a coder it is only a Idea.
Christian

[imported_silkroad]

I like this idea as well. We need to consider how this all plays with the vBSEO Sitemap Generator as well.

Unfortunately, I am not an expert on CRRs, but I think we can get there with a little time and help from our friends at vBSEO.

I think the overall requirement should be to rewrite all "/link.html?hl=flag" links to "flag/link.html" and to also make sure the "flag/link.html" links in the sitemaps, as well as the original "/link.html?hl=flag" work.

Also, I have been using distinct Google Sitemap for each flag and it works much better than combining all the flags in one huge, unmanageable process.

See attached update, as a FYI. (Note, in my image below, I changed es to sp (directory) ... the directory for the sitemaps only, because I had another es directory... you can use any method you like, but I like to have all lang sitemaps in a single directory for each lang.... much easier to manage!)

[cyc]

I think the overall requirement should be to rewrite all "/link.html?hl=flag" links to "flag/link.html" and to also make sure the "flag/link.html" links in the sitemaps, as well as the original "/link.html?hl=flag" work.


I also think this is the way to go!

[imported_silkroad]

I also think this is the way to go!

OK, thanks to Oleg at vBSEO, (http://www.vbseo.com/f23/simple-rewrite-rules-new-translation-sitemaps-36072/) we have the first part working with:

RewriteEngine on
RewriteRule (.*) http://www.site.com/$1?hl=ja [L,R=301]

Using Japanese as an example (ja), we use SED to create a new sitemap, changing

http://www.yoursite.com/link.html?hl=ja

to

http://www.yoursite.com/japan/link.html


Tested and working thanks to the vBSEO team's great support. Thanks again VBSEO team.

[imported_silkroad]

[QUOTE=imported_silkroad;1861799]

RewriteEngine on
RewriteRule (.*) http://www.site.com/$1?hl=ja [L,R=301]

OBTW, I forgot to ask....

Is there any SEO issue related to returning a 301 permanent redirect code?

[Saviour]

Just got the following database errors after Google and AdSense spidered the site:

Database error in vBulletin 3.8.3:

Invalid SQL:

UPDATE vb_session
SET lastactivity = 1249514101, location = '/forums/showthread.php?t=845&hl=tr', inforum = 58, inthread = 845, incalendar = 0, badlocation = 0
WHERE sessionhash = '122a4492f1ad4d9b896966deb0020880';

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Wednesday, August 5th 2009 @ 07:15:01 PM
Error Date : Wednesday, August 5th 2009 @ 07:16:22 PM
Script : http://glitchpc.com/forums/showthread.php?t=845&hl=tr
Referrer :
IP Address : 66.249.71.172
Username : Unregistered
Classname : vB_Database
MySQL Version :


Also...

Database error in vBulletin 3.8.3:

Invalid SQL:

UPDATE vb_session
SET lastactivity = 1249514535, location = '/forums/showthread.php?t=845&hl=th', inforum = 58, inthread = 845, incalendar = 0, badlocation = 0
WHERE sessionhash = '122a4492f1ad4d9b896966deb0020880';

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Wednesday, August 5th 2009 @ 07:22:15 PM
Error Date : Wednesday, August 5th 2009 @ 07:23:36 PM
Script : http://glitchpc.com/forums/showthread.php?t=845&hl=th
Referrer :
IP Address : 66.249.71.172
Username : Unregistered
Classname : vB_Database
MySQL Version :


And again...

Database error in vBulletin 3.8.3:

Invalid SQL:

UPDATE vb_session
SET lastactivity = 1249514972, location = '/forums/showthread.php?t=845&hl=nl', inforum = 58, inthread = 845, incalendar = 0, badlocation = 0
WHERE sessionhash = '122a4492f1ad4d9b896966deb0020880';

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Wednesday, August 5th 2009 @ 07:29:32 PM
Error Date : Wednesday, August 5th 2009 @ 07:30:41 PM
Script : http://glitchpc.com/forums/showthread.php?t=845&hl=nl
Referrer :
IP Address : 66.249.71.172
Username : Unregistered
Classname : vB_Database
MySQL Version :


Any ideas what's causing this?

[cyc]

Just got the following database errors after Google and AdSense spidered the site:

Hi there

The first time a page is cached, it can take 5 or 10 seconds, your mysql connection is probably timing out.

open your /etc/my.cnf file with vi or similar editor.

There should be a setting called "wait_timeout" i'd increase it a little until the errors stop, ours is;

wait_timeout = 30

regards

[Saviour]

cyc...

Thanks for replying. I don't see the /etc/ directory you're referring to on my server.

I'm on a shared server...not sure if this makes a difference.

[matthewhotdude]

/etc/my.cnf

where the hell is that?

lol saviour me neither

[cyc]

cyc...

Thanks for replying. I don't see the /etc/ directory you're referring to on my server.

I'm on a shared server...not sure if this makes a difference.

If you're have a shared hosting account you wont be able to edit that file.

/etc/my.cnf

where the hell is that?

lol saviour me neither

Its the configuration file for MySQL :)

[Saviour]

Which database though...

The forum database or the database for this mod?

[Saviour]

Nevermind...

It doesn't make any difference, since my host states this setting cannot be changed on a shared server. It's set by the host admin. Which means this mod is useless on a shared server.

Thanks for the help though, cyc...much appreciated.

Guess I'll have to uninstall this...

What a waste...

[cyc]

Which database though...

The forum database or the database for this mod?

Hey

not a specific database, the MySQL server itself.

How many errors are you getting?

regards

[Saviour]

I've received 15 database errors within the last hour or so...

Needless to say...I've just uninstalled the whole thing...including the database.

I contacted the host...and they said there is no issue with either the forum or the translator database.

Since I cannot modify the file you're referring to...to me...there's no need to further waste your time trying to correct it. Since it's timing out...and I cannot make any changes to the file in question...I can't use this mod.

Thanks, anyway, for the help...

[cyc]

I've received 15 database errors within the last hour or so...

Needless to say...I've just uninstalled the whole thing...including the database.

I contacted the host...and they said there is no issue with either the forum or the translator database.

Since I cannot modify the file you're referring to...to me...there's no need to further waste your time trying to correct it. Since it's timing out...and I cannot make any changes to the file in question...I can't use this mod.

Thanks, anyway, for the help...

no problem mate, someone else might have a different solution, stay subscribed to the thread. I was just sharing what I did to get around the same problem.

cheers

[imported_silkroad]

Which database though...

The forum database or the database for this mod?

The problem on your end seems to be the overall MySQL database configuration (my.cnf is for the entire MySQL configuration).

Most shared hosting sites are not going to permit you to override these settings, so it will be difficult for you to get this mod to work on a shared hosting site if the settings are not correct.

This is not a problem with the mod because the mod must make a request to the Google translate API when a page is first translated, and this is slow because of the network and Google's process, not the mod. Plus, things are always slower on (most) shared hosting environments.

I don't recommend people on shared hosting run this mod, BTW. If you want to run something like this, move to a solution where you control the MySQL configuration, either dedicated hosting or a robust VPS.

Don't be frustrated, just upgrade :-)

[Dave Hybrid]

Hey!

I nominated the mod for MOTM, and sure enough, there it is and currently running in second place !!!

https://vborg.vbsupport.ru/showthread.php?t=219942

Go Man Go!

Nice one, thanks.:up:

[Dave Hybrid]

Nevermind...

It doesn't make any difference, since my host states this setting cannot be changed on a shared server. It's set by the host admin. Which means this mod is useless on a shared server.

Thanks for the help though, cyc...much appreciated.

Guess I'll have to uninstall this...

What a waste...

Get a better host. :rolleyes:

[Dave Hybrid]

I've received 15 database errors within the last hour or so...

Needless to say...I've just uninstalled the whole thing...including the database.

I contacted the host...and they said there is no issue with either the forum or the translator database.

Since I cannot modify the file you're referring to...to me...there's no need to further waste your time trying to correct it. Since it's timing out...and I cannot make any changes to the file in question...I can't use this mod.

Thanks, anyway, for the help...

You only get those emails as the first time you translate a BIG page it times mysql out, no error actually occurs, mysql just sends an email warning.

Your forum users notice nothing, at all, it's just an email and once your site is fully translated they go away to a point.

I put up with a few emails in trade of 10k daily uniques. :up:

[imported_silkroad]

I put up with a few emails in trade of 10k daily uniques. :up:

Only 10K uniques/day :confused:

We are already getting 20K (more, hl=lang traffic) uniques per weekday after installing on July 14th :D

[Dave Hybrid]

Only 10K uniques/day :confused:

We are already getting 20K (more, hl=lang traffic) uniques per weekday after installing on July 14th :D

You have a load more threads than I do, I'd imagine you have more translated pages indexed.

[imported_silkroad]

Hi Dave,

Yes, things should get interesting in a few more weeks.

I hope you win MOTM. You deserve it. The other nominations are good, but this mod give real results.

Thanks for the great work.

Please add the capability to process Google Translate tags for notranslate in the next release. Thanks so much! We need to add this to our code tags. Cheers.

[Dave Hybrid]

I've been on holiday and am going here and there again over the next few months, but will work on a new release asap. If anyone has any suggestions leave them here please.

[ThePixel]

Hey :S is it sombody som can help me whit this :S ?

[NLP-er]

Nevermind...

It doesn't make any difference, since my host states this setting cannot be changed on a shared server. It's set by the host admin. Which means this mod is useless on a shared server.

Thanks for the help though, cyc...much appreciated.

Guess I'll have to uninstall this...

What a waste...

Stop! It's working fine. This error is harmless! You can use this mod and it will work fine. After most pages will translate those errors will stop occures.

This error is not of this mod, but vbulettin. At the very end of request vbulletin just want to update date of last session activity - and it cannot because session is timeout. It doesn't affect in any way vbulletin or this mod. So you can just ignore it. Dave was working on this, but it looks that he abandon this issue since it is harmless - still annoying of course ;)

[Dave Hybrid]

Stop! It's working fine. This error is harmless! You can use this mod and it will work fine. After most pages will translate you those errors will stop occures.

This error is not of this mod, but vbulettin. At the very end of request vbulletin just want to update date of last session activity - and it cannot because session is timeout. It doesn't affect in any way vbulletin or this mod. So you can just ignore it. Dave was working on this, but it looks that he abandon this issue since it is harmless - still annoying of course ;)

I didnt abandon it, it cannot be fixed, BIG fresh pages take time to translate the first time round and mysql gets bored waiting, unless you set the php wait timeout to minutes it cannot be avoided (wgich is bad for security). I dont cmind anyway, it is just a stupid email warning, no error coccus at all and it does not effect the running of the site at all. I just send them to mysql@domain.com and forward them to their own folder in outlook. They can be ignored. As i said i can put up with them for 10k uniques a day, others reported 20k new uniques a day, so i guess they can put up with them also.;)

[NLP-er]

Hey :S is it sombody som can help me whit this :S ?

What's the issue?

[NLP-er]

I didnt abandon it, it cannot be fixed, BIG fresh pages take time to translate the first time round and mysql gets bored waiting, unless you set the php wait timeout to minutes it cannot be avoided (wgich is bad for security). I dont cmind anyway, it is just a stupid email warning, no error coccus at all and it does not effect the running of the site at all. I just send them to mysql@domain.com and forward them to their own folder in outlook. They can be ignored. As i said i can put up with them for 10k uniques a day, others reported 20k new uniques a day, so i guess they can put up with them also.;)

I'm not so sure does it cannot be avoided. Just speculate. But if look into vBulletin source code you can find where exactly session is updated and check does there is a hook which can work after it.
Another possible solution (potentially easier) you already have in your mod - I was working on cache in this mod and have to fight with same problem. If translation takes too long then also connection to vBGT DB was lost. So I just reconnect. Did you try to reestablish connection to vBulletin database at the end of translation?...

[Dave Hybrid]

I'm not so sure does it cannot be avoided. Just speculate. But if look into vBulletin source code you can find where exactly session is updated and check does there is a hook which can work after it.
Another possible solution (potentially easier) you already have in your mod - I was working on cache in this mod and have to fight with same problem. If translation takes too long then also connection to vBGT DB was lost. So I just reconnect. Did you try to reestablish connection to vBulletin database at the end of translation?...

Everything i tried didnt work, if you have a code suggestion that works i'd be glad to add/test it.

[NLP-er]

Everything i tried didnt work, if you have a code suggestion that works i'd be glad to add/test it.

It's not related with cache and I have lot of other work right now :) I gave you direction - go for it :)

In maintime I think it would be good to describe it as Known Issues - people would be prepared for this and didn't panic ;)

[yahoooh]

hello

i installed this in my site which use utf-8 encoding
and i use vbseo that make threads url using arabic font

i see that the translate not working in thread url that have arabic words in its address
but only translate any english url address

also i use vba links which using its seo and vba dynamic which also use its seo
now how to make this addon at least translate pages that have url arabic

this occur only in threads but in groups and other thing works perfect



also i found another issue in NLP site :
http://www.forum.simple-nlp.pl/tags/pod%C5%9Bwiadomo%C5%9B%C4%87.html?hl=ar

[NLP-er]

also i found another issue in NLP site :
http://www.forum.simple-nlp.pl/tags/pod%C5%9Bwiadomo%C5%9B%C4%87.html?hl=ar

This is not issue of this mod but of vbSEO (you can see that it will be same for URL without hl param - also error message). vbSEO doesn't change special letters in URL's for tags, i.e. 'ś' to 's' (I wrote to them about this - no result).

[yahoooh]

i already fix this by change my forum and db to utf-8
it works perfect but the issue is :
i see that the translate not working in thread url that have arabic words in its address
but only translate any english url address

this issue only affect the threads of forum

[yaku]

One problem for me: I'm getting this error message when I try to run this. Any ideas?

Parse error: syntax error, unexpected '<' in /translateflags.php on line 10

[NLP-er]

One problem for me: I'm getting this error message when I try to run this. Any ideas?



Parse error: syntax error, unexpected '<' in /translateflags.php on line 10

My idea is you was editing this file and made somesthing wrong :) Download oryginal file - made copy before changes and then change :)

[NLP-er]

i already fix this by change my forum and db to utf-8
it works perfect but the issue is :
i see that the translate not working in thread url that have arabic words in its address
but only translate any english url address


this issue only affect the threads of forum

Can you show me this behaviour? I'm not sure what you mean by "thread url that have arabic words in its address". Could you copy here good and bad link?

[Dave Hybrid]

All URLs on the Internet anywhere in the world only allow English characters.

[imported_silkroad]

Can you show me this behaviour? I'm not sure what you mean by "thread url that have arabic words in its address". Could you copy here good and bad link?

vBSEO has an option to replace/remove/keep non-English chars in the URL:

Replace Non-English Characters in URLs?

Select 'Yes' to replace non-English characters with their English equivalent. Enable this option if your forums are not in English or if any non-English characters occur in your forums (E.g. Caf?)

[ThePixel]

What's the issue?

Yes I did everything that was there. Probably something wrong. but as I get it not to work and then I was wondering if someone could do it for me or something? : S

sorry i use google translate :P

[exploitersteam]

Hello Dave,

The MOD was working for 2 days and now i'm receiving this error:

Query to short cache failed: MySQL server has gone away

Do you have any idea what is this error?

Thank You,

Marcelo

[yahoooh]

Can you show me this behaviour? I'm not sure what you mean by "thread url that have arabic words in its address". Could you copy here good and bad link?

this thread with vbseo url english font:
http://www.alwatanyh.com/forum/f6/just-test-38040/

it works in translate

but for example this :
http://www.alwatanyh.com/forum/f6/%D9%84%D9%85%D9%86-%D9%84%D8%A7-%D9%8A%D8%B9%D8%B1%D9%81-%D8%A7%D9%84%D8%AC%D8%B2%D8%A7%D8%A6%D8%B1-36699/

it will not work , this is occur only for threads
but for groups ,blogs and other which use vbseo and arabic font in url , it will works with them

so this issue related to showthread links

[tpearl5]

It looks like google has been indexing my translated pages. I noticed a strange thing though; google is starting with non-thread pages. Does this mean googlebot isn't sticking around long enough to index the thread pages?

[NLP-er]

All URLs on the Internet anywhere in the world only allow English characters.

Not exactly... For example - this not working url from my forum which was copied by yahoooh has polish letters (like ść).

Just check yourself :)
http://www.forum.simple-nlp.pl/tags/podświadomość.html

[NLP-er]

vBSEO has an option to replace/remove/keep non-English chars in the URL:

Yes :) And it's working great on my forum for a long time - for threads links.

I wass discussing this with vbSEO stuff year ago. I found the topic - Here it is:
http://www.vbseo.com/f3/wrong-tag-links-26223/

They don't remove special characters from tags links. But tags links are coded fine with % notation. I wrote wrong before, confused by included link, but as I see on my forum links are ok in tags cloud.

Where did you get this wrong link yahoooh?

[NLP-er]

Yes I did everything that was there. Probably something wrong. but as I get it not to work and then I was wondering if someone could do it for me or something? : S

sorry i use google translate :P

PM me

[NLP-er]

Hello Dave,

The MOD was working for 2 days and now i'm receiving this error:

Query to short cache failed: MySQL server has gone away


Do you have any idea what is this error?

Thank You,

Marcelo

Hello :) Cahe issues are my part here :) Just please find in translate.php:

/*
if (!mysql_ping()) {
mysql_close();
establishConnection();
}
*/


And uncomment it (remove /* and */). Error will disspear :)

Dave - please correct it in next release :) - DON'T - see post below

[NLP-er]

After consideration - Dave don't change it. I remember now - I commented it with a reason. I didn't expect this error in this place, so I commented reestablish code for performance reasons (shouldn't have big impact, but if not necessary...).

So right now who doesn't have this problem just have good working mod, ant who has - can just uncomment mentioned code. Maybe when more people will note same issue there will be good moment to include it in release. Right now it's first complain since I made reestablish functionality, so it is rare and I would stay with commented code in official release.

Reestablis is neded after google translation (before inserting to cache) and there it is uncommented by default :)

[NLP-er]

this thread with vbseo url english font:
http://www.alwatanyh.com/forum/f6/just-test-38040/

it works in translate

but for example this :
http://www.alwatanyh.com/forum/f6/%D9%84%D9%85%D9%86-%D9%84%D8%A7-%D9%8A%D8%B9%D8%B1%D9%81-%D8%A7%D9%84%D8%AC%D8%B2%D8%A7%D8%A6%D8%B1-36699/

it will not work , this is occur only for threads
but for groups ,blogs and other which use vbseo and arabic font in url , it will works with them

so this issue related to showthread links

Hi :) As I see mod creates appropriate lins, but clicking clicking vbSEO is rediredting to url without hl param. You can see it by copying adress from flag image - there is hl param. But when you paste it to broswer and send, then hl pram dissapears.
I think that vbSEO makes 301 redirect. Talk with vbSEO stuff.

[NLP-er]

It looks like google has been indexing my translated pages. I noticed a strange thing though; google is starting with non-thread pages. Does this mean googlebot isn't sticking around long enough to index the thread pages?

Google is a mystery ;)

[exploitersteam]

Hello :) Cahe issues are my part here :) Just please find in translate.php:

/*
if (!mysql_ping()) {
mysql_close();
establishConnection();
}
*/


And uncomment it (remove /* and */). Error will disspear :)

Dave - please correct it in next release :) - DON'T - see post below

Thank You NLP-er,

Actually what happened was that in the hosting for some reason they were blocking the url http://ajax.googleapis.com* and consequently i was receiving that error. See below the example:

[forum]$ curl http://ajax.googleapis.com
curl: (7) couldn't connect

Now they fixed that blocking page i can connect to the specific url

But, thank you anyway and i hope this tip be useful for anyone that could face the same problem.

Thank You very much.

[imported_silkroad]

It looks like google has been indexing my translated pages. I noticed a strange thing though; google is starting with non-thread pages. Does this mean googlebot isn't sticking around long enough to index the thread pages?

You can help manage this by setting your both priority and update frequencies in your Google Sitemaps. You can set your threads a higher priority than posts, etc.

Our experience is that Google does tend to follow their own Sitemap standards, but you have to use them and use them wisely :-)

[Dave Hybrid]

Hello Dave,

The MOD was working for 2 days and now i'm receiving this error:

Query to short cache failed: MySQL server has gone away


Do you have any idea what is this error?

Thank You,

Marcelo

You only get those emails as the first time you translate a BIG page it times mysql out, no error actually occurs, mysql just sends an email warning.

Your forum users notice nothing, at all, it's just an email and once your site is fully translated they go away to a point.

[Dave Hybrid]

It looks like google has been indexing my translated pages. I noticed a strange thing though; google is starting with non-thread pages. Does this mean googlebot isn't sticking around long enough to index the thread pages?

Google considers pages closer to the domain root as more important, so that is why those pages get indexed 1st.

[yahoooh]

Hi :) As I see mod creates appropriate lins, but clicking clicking vbSEO is rediredting to url without hl param. You can see it by copying adress from flag image - there is hl param. But when you paste it to broswer and send, then hl pram dissapears.
I think that vbSEO makes 301 redirect. Talk with vbSEO stuff.

i open thread there and still wait support from them


also what about vba links and vba dyna which in subdomains and they use thier seo
i just make some added lines in templates to only fix entries there but still categories can not be fixed any help !

[Spinball]

Very interesting mod. Going from 10 to 280 million posts would have a crippling effect on our servers, though, wouldn't it?

[Dave Hybrid]

Very interesting mod. Going from 10 to 280 million posts would have a crippling effect on our servers, though, wouldn't it?

Yes, you would need more disk space and server resources, no different than if your site grew normally.

Traffic comes at a price, whatever way you use to get it.

[imported_silkroad]

Google considers pages closer to the domain root as more important, so that is why those pages get indexed 1st.

Not if you have a Sitemap with priorities and frequencies set propertly.

Dave, why are you so *against* proper Google Sitemaps?

You answer posts like "the Google expert" but you don't mention the basics which are so important :-) Some of your replies are technically incorrect about Google. (like your earlier comment about no non-english URLs.)

Lighten up :-)

[imported_silkroad]

Very interesting mod. Going from 10 to 280 million posts would have a crippling effect on our servers, though, wouldn't it?

You don't need to do all 28 languages, in fact I don't recommend it for big sites.

If you have 10 M pages, just create a Sitemap (for one language) and only translate your targetted best demographic to expand, one at a time, or a few more if you have plenty of resources.

PM if you have questions. I can give you the "scoop" on what happens when you have 1/2 M pages, which is a fraction of your site. Do not enable all 28 flags. It is a waste of resource, bandwidth, CPU, etc. for a large site. Focus on your targetted demographics. Also, if you make money with click-revenue, keep in mind that some countries pay low (because their economy is low, naturally) and some pay larger (because their economy is strong, naturally).

Also, you can easily create an ?hl= segment in Google Analytics and look careful at your analytics. Remember, it is much harder to dump an "unproductive language" (from Google's index) than to manage the process from the beginning.

Plan.

With 10M pages, you know what I mean :-)

[Dave Hybrid]

Not if you have a Sitemap with priorities and frequencies set propertly.

Dave, why are you so *against* proper Google Sitemaps?

You answer posts like "the Google expert" but you don't mention the basics which are so important :-) Some of your replies are technically incorrect about Google. (like your earlier comment about no non-english URLs.)

Lighten up :-)

Ay? How did you get that impression from a single sentence. You need to stop reading wrongly into my posts. You're always looking for a negative and jump on my 'attitude' at any excuse.

I have never proclaimed to be an expert, i am just putting across my opinion and yes re; the urls, i cant be right all the time and i doubt you are either. Maybe YOU should lighten up.

Back on topic though yeah...

I do use a proper sitemap and have never said you shouldn't. Google, on my sites at least and others I oversee index pages closer to the root first, they get more juice as 99% of a sites links goto the homepage and juice filters down. They simply get picked up faster. Ranking is a whole different ball game however.

Also Google says that a sitemap helps it find pages faster, they also say... they decide what and when it crawls, not you.

Disclaimer* This is just my opinion, and may differ from others opinions. Also, I am in a happy mood and am not being defensive. Just so we are clear lol.

[Dave Hybrid]

Remember, it is much harder to dump an "unproductive language" (from Google's index) than to manage the process from the beginning.



In the past I have just htaccess 301'd the hl=country to the root for any country's i want removed from the index after disabling them on the script first (removing the flag).

[imported_silkroad]

I have never proclaimed to be an expert, i am just putting across my opinion and yes re; the urls, i cant be right all the time and i doubt you are either. Maybe YOU should lighten up.

I know about how Google works pretty well, and your advice regarding how Google indexes is inaccurate.

I think it is important to advise accurately, and I am sure you agree.

You posted that Google does not use non-English URL - that is inaccurate. (NPL-er also corrected).

You posted that Google priorities crawling based on the how close the URL is to the "root domain" - that is also not really accurate. Google priorities based on priorities (and frequencies) in the sitemaps.

PS: I am not "jumping on you" - I am correcting some fairly important techincal errors you posted about Google (knowing you would take it personally, LOL) I would post the same if my Mother posted inaccurate information about how Google indexes, and I love my mom :-)

[imported_silkroad]

In the past I have just htaccess 301'd the hl=country to the root for any country's i want removed from the index after disabling them on the script first (removing the flag).

That is a good idea, it seems.

Thanks!

[Dave Hybrid]

I know about how Google works pretty well, and your advice regarding how Google indexes is inaccurate.

I think it is important to advise accurately, and I am sure you agree.

You posted that Google does not use non-English URL - that is inaccurate. (NPL-er also corrected).

You posted that Google priorities crawling based on the how close the URL is to the "root domain" - that is also not really accurate. Google priorities based on priorities (and frequencies) in the sitemaps.

PS: I am not "jumping on you" - I am correcting some fairly important technical errors you posted about Google (knowing you would take it personally, LOL) I would post the same if my Mother posted inaccurate information about how Google indexes, and I love my mom :-)

Ah I see now, so you're the expert. Is that your reasoning to why I am wrong? What's is it like to work in the plex alongsite Matt Cutts? Oh, that's right, you dont and thus are as clueless as the rest of us. All you have like the rest of us is an educated guess.

I said that is how Google behaves on my site, nothing more nothing less. I also said I got the url issue wrong, you cant buy non english domains so I assumed urls were no different. It's a simple mistake.

But here we go again, if YOU get personal with someone how else can they take it. If I start picking holes in your attitude than I'm sure you would take it personally, it's human nature.

I am not going to speak with you any more, you seem hell bent on making personal attacks, which i have no time for. You wanna talk technical I'm all ears, you wanna talk personal than no dice.

Are you really that bored and lonely that you need to pick fights and argue online. Get off the PC mate.

[Spinball]

Yes Dave, but it's not as simple as that. The servers for a huge forum cost a lot of money and there is a delay between having the impressions and your sales team being able to sell enough advertising to cover the additional cost.
Might be a good idea to get some feedback from huge forum administrators in your first post.

[allinvain]

I'm wondering, is it possible to add an additional language to the translation setup? The language I'm looking for is Vietnamese.

[basilrath]

I know about how Google works pretty well, and your advice regarding how Google indexes is inaccurate.

I think it is important to advise accurately, and I am sure you agree.

You posted that Google does not use non-English URL - that is inaccurate. (NPL-er also corrected).

You posted that Google priorities crawling based on the how close the URL is to the "root domain" - that is also not really accurate. Google priorities based on priorities (and frequencies) in the sitemaps.

PS: I am not "jumping on you" - I am correcting some fairly important techincal errors you posted about Google (knowing you would take it personally, LOL) I would post the same if my Mother posted inaccurate information about how Google indexes, and I love my mom :-)

--------------------------------
Ah I see now, so you're the expert. Is that your reasoning to why I am wrong? What's is it like to work in the plex alongsite Matt Cutts? Oh, that's right, you dont and thus are as clueless as the rest of us. All you have like the rest of us is an educated guess.

I said that is how Google behaves on my site, nothing more nothing less. I also said I got the url issue wrong, you cant buy non english domains so I assumed urls were no different. It's a simple mistake.

But here we go again, if YOU get personal with someone how else can they take it. If I start picking holes in your attitude than I'm sure you would take it personally, it's human nature.

I am not going to speak with you any more, you seem hell bent on making personal attacks, which i have no time for. You wanna talk technical I'm all ears, you wanna talk personal than no dice.

Are you really that bored and lonely that you need to pick fights and argue online. Get off the PC mate.


May i suggest that you guys move this onwards or at least try to work alongside, which if im honest would probably achieve tremendous results. The mod in my humble opinion is well worthy of mod of the month but as mentioned by imported_silkroad has its problems ............... so why not channel your thoughts into its workability rather than its negativity ?

Just my thoughts and again its a great mod.

[tpearl5]

You can help manage this by setting your both priority and update frequencies in your Google Sitemaps. You can set your threads a higher priority than posts, etc.

Our experience is that Google does tend to follow their own Sitemap standards, but you have to use them and use them wisely :-)

Google considers pages closer to the domain root as more important, so that is why those pages get indexed 1st.

Well, to be more specific, google is indexing tags, member pages, and blog pages first. I don't even have blogs in the sitemaps and the priority for the member and tags pages is lower than thread pages.

I don't know - I guess I'll just wait and see. My translate tables already total over 2 million records and are on a steady increase!

[tpearl5]

Yes Dave, but it's not as simple as that. The servers for a huge forum cost a lot of money and there is a delay between having the impressions and your sales team being able to sell enough advertising to cover the additional cost.
Might be a good idea to get some feedback from huge forum administrators in your first post.

I understand about servers being expensive, but like mentioned above, you don't have to enable every language. I chose only the most used. Regardless, I'm curious why you don't use adsense and advertisers like vibrant media, kontera, and chitika?

[allinvain]

Hmm, I see you're all too busy bickering amongst yourselves to answer my question...I'll look elsewhere.

[NLP-er]

... I am not going to speak with you any more, you seem hell bent on making personal attacks, which i have no time for. You wanna talk technical I'm all ears, you wanna talk personal than no dice.

Are you really that bored and lonely that you need to pick fights and argue online. Get off the PC mate.

There is such word - hypocrisy...

[NLP-er]

I'm wondering, is it possible to add an additional language to the translation setup? The language I'm looking for is Vietnamese.

I have over 40 translation languages on my forum (www.forum.simple-nlp.pl - see flags in right column). And there is Vietnamese. So it is possible :)

[NLP-er]

Hmm, I see you're all too busy bickering amongst yourselves to answer my question...I'll look elsewhere.

Yeah... You can find here some "fights", but as I see after your post there was no Dave posts, so could it be possible that he just wasn't on computer?... ;)

[imported_silkroad]

Ah I see now, so you're the expert. Is that your reasoning to why I am wrong? What's is it like to work in the plex alongsite Matt Cutts? Oh, that's right, you dont and thus are as clueless as the rest of us. All you have like the rest of us is an educated guess.

I said that is how Google behaves on my site, nothing more nothing less. I also said I got the url issue wrong, you cant buy non english domains so I assumed urls were no different. It's a simple mistake.

But here we go again, if YOU get personal with someone how else can they take it. If I start picking holes in your attitude than I'm sure you would take it personally, it's human nature.

I am not going to speak with you any more, you seem hell bent on making personal attacks, which i have no time for. You wanna talk technical I'm all ears, you wanna talk personal than no dice.

Are you really that bored and lonely that you need to pick fights and argue online. Get off the PC mate.

Wow!

All I do is point out that users can set Google indexing priorities with Sitemaps and you go balistic.

You are the person here is picks fights Dave. Everyone knows it. You are famous for it. This thread is full of your your anger and rage at anyone you disagree with.

In fact, look at how negative you are posting above because I point out a technical error you made.

The only person you do not beat up is NLP-er, LOL. When he and I say the same thing, you verbally assault me. LOL.

You are so funny.

[imported_silkroad]

There is such word - hypocrisy...



Dave, you should not reply, really. You are stressed out to the max. Just read your fights you pick in this thread. I have never seen a mod like it!

[imported_silkroad]

Ah I see now, so you're the expert. Is that your reasoning to why I am wrong? What's is it like to work in the plex alongsite Matt Cutts? Oh, that's right, you dont and thus are as clueless as the rest of us. All you have like the rest of us is an educated guess.

No Dave. You are the one guessing.

I work with Sitemaps all the time and know that Google does follow the Sitemap parameters (and so do the good folks at vBSEO).

Also, I know that URLs are not only in English, as you said earlier, and NLP-er corrected.

You simply shoot from the hip, toss out opinions, and get angry when you are wrong. Better to stop shooting from the hip and learn to work with others.

Cheers.

[tpearl5]

back to productive conversation...

something I found in the google language api (http://code.google.com/apis/ajaxlanguage/terms.html) is somewhat alarming:

You may...
copy, store, archive, republish or create a database of Google Results, in whole or in part, directly or indirectly, except that you may: (1) store Google Results in a temporary cache for a period not to exceed fifteen (15) days solely for the purpose of using Google Results to carry out a specific user-requested action; and/or (2) display Google Results that have been "clipped" through a user-requested action, provided that you comply with the attribution requirements described in Section 2.3 below;

also, from a google employee: http://groups.google.com/group/Google-AJAX-Search-API/msg/819ca6b30e8b1ea6?hl=en&pli=1

I fear that this is going to get my site banned...

[Dave Hybrid]

back to productive conversation...

something I found in the google language api (http://code.google.com/apis/ajaxlanguage/terms.html) is somewhat alarming:

You may...


also, from a google employee: http://groups.google.com/group/Google-AJAX-Search-API/msg/819ca6b30e8b1ea6?hl=en&pli=1

I fear that this is going to get my site banned...

A popular wordpress version based of the same idea here http://www.nothing2hide.net/wp-plugins/wordpress-global-translator-plugin/ has been out over 3 years and is on loads of sites. Not heard of a ban ever and the authors site ranks pretty well. But if you are concerned than all i would suggest is stop using the mod. Thanks.

[yahoooh]

how to make it when show translate page , will show all links with the same hl= languge so this will continue translate any page untill the use preffer to use default page

[bklynjava]

Has anyone tried this with vb3.7.5? Does it work?

Answer is YES :) ---> Clicks Install

Great Mod Thanks!

[rigodiaz]

Hi.

Can I use this mod with Lighttpd?.

[NLP-er]

Hi.

Can I use this mod with Lighttpd?.

If you have vBulletin there it will ;)

It is possible that some configuration changes could occur, but this is rare and necessary if some php libraries are disabled. Mostly - it's going smoothly :)

[Bellinis]

How effective is this mod in increasing Adense revenue?
Anyone willing to share his/her experience? :)

[Dave Hybrid]

How effective is this mod in increasing Adense revenue?
Anyone willing to share his/her experience? :)

It's unlikly anyone will share real numbers. But more traffic means more clicks.

[Lizard King]

A notice to vBSEO owners.

As vBSEO.com Staff we don't advise using this mod for the following reasons.

This modification breaks the purpose of correct link consensus.
Translation quality is bad and would you want your site visitors to face shitty translated pages
Google advises to use correct url structure for translated pages which should be defined as domain.com/en/thread1 domain.com/de/thread2 . The important part in here is that each translation should have a unique domain. With this mod you are outranking your original url by creating duplicate version of the urls.
Using this mod is clearly agains Google Translation API TOS.


For vBSEO Owners more information can be found at http://www.vbseo.com/f4/support-multiple-languages-35168/

[Dave Hybrid]

Thanks for the tip but I find your reasons are trivial at best. I base my usage on facts, and the fact is this mod brings in buckets of traffic.

[Coop1979]

Yeah, God forbid you listen to the experts in the field.

[Dave Hybrid]

Yeah, God forbid you listen to the experts in the field.

What makes them the experts exacly?

[1Unreal]

What makes them the experts exacly?

Well if Google wrote the API they kinda know what they are talking about.

Stop being a ++++ all the time and let people help you. Its not critisism. They just want to help improve it :cool:

Thanks for the tip but I find your reasons are trivial at best. I base my usage on facts, and the fact is this mod brings in buckets of traffic.

Its not trivial if Google stops you from using the API due to incorrect usage

[Dave Hybrid]

So you are saying they know seo better than me, they read the seo book and scored higher on the seo test than me did they? I have been doing seo and websites long before they came around. I also built and have used this mod for years, long before they glanced over it. So, i believe I know what I am talking about thank you so am inclined to side with myself. I never asked for any 'advice' and if someone comes to my mod thread and posts a statement about how it is soooo bad for your forum i'm going to defend my product frankly and you would do the same. Defensive or not, it is what it is. People bashing this looking for a reaction and ++++ yeah i'll give them one. Their reasons are trivial, and are unproven hear-say. No one has ever been banned from the API, the 5yr old wordpress version has 10,000's of users and they are all just fine. Even if one was, what happens? You go back to your standard pages, big deal. Either way it's gone now, fed up with this crap. I give this traffic gem away for free and all you lot do is b!tch.