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

**Text Removed**

[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]

Originally Posted by tpearl5

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]

Originally Posted by imported_silkroad

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]

Originally Posted by imported_silkroad

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]

Originally Posted by cyc

I also think this is the way to go!

OK, thanks to Oleg at vBSEO, 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]

Originally Posted by Saviour

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.