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

[Dave Hybrid]

vB Global Translator

Note - There are 2 versions of this script depending on your setup. This script is compatible with users running standard vBulletin and vBSEO only and all vB release versions. If you cannot install this I am more than happy to answer support questions.

So what does this do?

vB Global Translator automatically translates your forum into 28 other languages via the Google translate API, stores those translations in a MYSQL database then rewrites new URLs so you end up with 28 new pages for every current page.

So, if you have 10,000 pages, this MOD will translate those pages into 28 languages making a total of 280,000 pages in 28 languages. This results in a flood of international traffic and referrals from the search engines. If you are getting 1,000 visits a day from your 10,000 pages imagine how many referrals you will get from 280,000 pages!

The current languages this MOD works with are all supported by AdSense so you can expect your income to rise accordingly. I have this running on a 20,000 page forum and after a few months I have more than doubled my search engine traffic.

How do I Install?

Note - Please make sure you have CURL enabled on your server, it will be listed in you php.ini file. If in doubt ask your host.

First download the relevant package below for your setup.

Next you need to add a new MySQL database to your domain to store the translated pages. Open the database in phpmyadmin or similar and import the db.sql file to install the database tables. Once you have done that you need to select the 'wt_cache' table on the left then 'operations' from the top menu and change the storage engine to InnoDB, then click Go.

Add your new database details to translate.php then, if your forums base language is different to English, change your country code. Otherwise ignore this step.

Find:

REMOVED

Change en to:

REMOVED

Next save translate.php and upload that, translateflags.php and overloadcache.txt to your forum root, so if your forums are in a /forums/ folder upload these files there. Upload the flags folder to your domain root, thats the domain root.

CHMOD overloadcache.txt to 777

In your vBulletin admin panel add a new plugin with the following settings.

Hook Location: global_complete
Title: vB Global Translator
Execution Order: 5
Plugin PHP Code:

REMOVED

Save the plugin and activate.

In your vBulletin admin panel add another new plugin with the following settings.

Hook Location: global_start
Title: vB Global Translator Flags
Execution Order: 5
Plugin PHP Code:

REMOVED

Save and activate.

Finally add the code below to your template so the flags to select languages appear. This is typically the header, navbar or footer so that they display on every page.

REMOVED

Load Issues:

This script is can be quite server intensive for large sites. As you are adding links to all of these new pages from all of your current pages the search engine bots will crawl these 1,000's of new pages fast. As the MySQL trys to deal with the many, many translations and querys I have seen my server load spike a bit.

To combat this we have written in a condition that if server load is more than 1.5, the cache setting will disable and pages will be read live from the Google API and no database writing will take place.

If you feel this setting too high/low you can change it by finding the variable below in translate.php and editing accordingly. The only reason to change this is if - A) You are on a slow server and it is overloaded/crashing or B) You have a very fast server and it can handle more, this will mean your site will get fully cached faster resulting in faster page load times when people re-visit the translated pages.

if(floatval(getServerLoad()) >= 1.5)

One final thing to remember is while your site is being cached and data written to the new database read access times to already cached pages may vary. Uncached pages need to be translated and this can take time when translating a fresh page. Cached pages may load fast or slow depending on whether your server is under load or not as when under load read access from the database is disabled. You just need to be patient and wait until your site is fully cached which will vary between site size, server spec and how often search bots crawl your pages.

Please rate and click install

THANK YOU!

Version History:

v1.7

* Removed ioncube encryption to bring script inline with vBulletin.org rules

v1.6

* Fixed nofollow block on flag links for users with vbseo sites
* Fixed adsense ads showing for translation services etc. by adding section targeting ignore tags

v1.5

* Fixed database speed issues by using InnoDB instead of MyISAM
* Code encrypted with ioncube

v1.0

* Script base version

[rob01]

cool i will try this and see how this work out

thought is not risky? ..so many databese reading

why dont use vb language packs?

thanks

[Dave Hybrid]

That is not an issue, the script can be limited to avoid server overload.

Also language packs will not do anything like what this script does.

[GamerPerfection]

Ok i've installed it, but when I choose a language it comes up with a 404 Not Found page.

Now, might be a silly question, but how do I know if I'm using a Windows or Linux Server?

[Dave Hybrid]

I would ask your host, Linux supports mod_rewrite and thus the .htaccess file that you should have uploaded... it is essential.

PM me the URL and I can take a look.

[GamerPerfection]

I would ask your host, Linux supports mod_rewrit and .htaccess files (that you should have uploaded)... it is essential.

Yes mine supports .htaccess files.

In fact I have my own one on my root directory, but I also placed your one in the forum root directory. Is that ok?

[Dave Hybrid]

Sounds like they may be conflicting, why do you have a htaccess in the root, what is it's content?

[GamerPerfection]

Sounds like they may be conflicting, why do you have a htaccess in the root, what is it's content?

I used to use it to block certain IP's. It's rather obsolete now anyway.
But I removed my old one and it's not causing the 404 error, so something else is wrong.

Here's my forum: http://www.galaxyofstars.co.uk/forums/

[GamerPerfection]

Then add your database details to translate.php

I take it you mean the new database details?

[Dave Hybrid]

Looks like a htaccess issue for sure, make sure it is in /forums/

Without ftp access I can't help much further, PM me if you want.

[Dave Hybrid]

I take it you mean the new database details?

Yes. :D

[Selene]

taking too long time to load

not good enough

please improve it

[GamerPerfection]

Sorry uninstalled this.

Can't get it to work, and I can't chance giving someone I don't know FTP access.

[Dave Hybrid]

Translating a page can take some time, this is down to Google, not the script.

Once translated they are called from a database, so are much faster.

It could take a few days to a few months to cache your whole site.

I can take a look if you PM me your site URL.

[Dave Hybrid]

Sorry uninstalled this.

Can't get it to work, and I can't chance giving someone I don't know FTP access.

No problem, support is there is you want it.

It's a shame, you didnt really give it a chance.

[GamerPerfection]

No problem, support is there is you want it.

It's a shame, you didnt really give it a chance.

I'd love to give it a chance, but I run my forums for an Actor, and I can't risk giving out FTP access to anyone.

[Dave Hybrid]

All I can suggest is uploading all the files supplied to both root and /forums/

Just in case the folders are causing some issue. Let me know.

[GamerPerfection]

All I can suggest is uploading all the files supplied to both root and /forums/

Just in case the folders are causing some issue. Let me know.

LOL somehow I missed this bit:

Open the database in phpmyadmin or similar and import the db.sql file to install the database tables.

I'll update you once I've done this. DOH!

[Dave Hybrid]

That shouldn't case a 404, the database part willl be skipped if not setup anyway.

You issues is with the urls.

[bigtime]

If anyone installs this that is using vBSEO, please post your .htaccess contents here to help the rest of us using vBSEO get it set up correctly.

Thanks.

[Dave Hybrid]

If enough people chime in running vbseo I will look into it further and release how to add it for those users.

[FreshFroot]

If enough people chime in running vbseo I will look into it further and release how to add it for those users.
I'd be interested, but I am using vbseo too.

Can't we just merge the htaccess files? or do you have code, which will interfere?

[GamerPerfection]

Marked as Installed again.

I realised I had to change the code for the template from:

http://www.galaxyofstars.co.uk/ar/

to

http://www.galaxyofstars.co.uk/forums/ar/

So i've now gone through all the list and added forums/ to it.

I'm now testing all of the languages. It's going to take a little while, so think i'll get some sleep before I finish it off.

However, the only one not to work so far is:

http://www.galaxyofstars.co.uk/forums/zh-TW/

Not sure why.

[Dave Hybrid]

Try this htaccess. I have updated the main download also.

################################################## ###########
# DefaultType application/x-httpd-php5
################################################## ############
Options +FollowSymLinks
RewriteEngine On
# Set file extension you wish to translate here [you may add your desired extension]
# Definition ##/[^\./]*## for translating index files or files without extension [delete to disable]
################################################## ############
RewriteRule !(/[^\./]*|\.(|shtml|shtml|html|htm|shtml|php|php3|php4|php 5|php6))$ - [S=1]
RewriteRule ^(sq|ar|bg|ca|zh-CN|zh-TW|hr|cs|da|nl|en|et|tl|fi|fr|gl|de|el|iw|hi|hu|id |it|ja|ko|lv|lt|mt|no|pl|pt|ro|ru|sr|sk|sl|es|sv|t h|tr|uk|vi)/(.*)$ $2?hl=$1 [L,QSA]
# If not valid html file, view as original (without traslation)
RewriteRule ^(sq|ar|bg|ca|zh-CN|zh-TW|hr|cs|da|nl|en|et|tl|fi|fr|gl|de|el|iw|hi|hu|id |it|ja|ko|lv|lt|mt|no|pl|pt|ro|ru|sr|sk|sl|es|sv|t h|tr|uk|vi)/(.*)$ $2 [L,QSA]
################################################## ############

[GamerPerfection]

Right, I tested out all of the languages/ They all work except this one:

http://www.galaxyofstars.co.uk/forums/zh-TW/

Not sure why, but i'm off to bed. I'm glad I got this working. :)

[Dave Hybrid]

See my post above.

[GamerPerfection]

Ah ok, I'll take a look tomorrow. Thanks again.

[Dave Hybrid]

You're welcome, glad you stuck with it and put up with being a beta tester ;)

Can't be helped sometimes, so many server and vb configs.

[Dave Hybrid]

n\a

[Medtech]

looks great, guess i'll have to give it a try :D

[zefyx]

vBSEO here too.

[vijayninel]

Sad that this will run only on Linux servers :(

[tansu]

I merged .htaccess file with mine of Zoints SEO.
I installed, and actually saw my web site in different languages.
But when I click on a thread it redirects me to the original one.

[hilfe-forum]

vBSEO and Zoints SEO .htaccess version please ;)

[tansu]

Does it work in localhost?
I think I did everything right in my localhost (ubuntu).
But it gives 404

[Dave Hybrid]

Does it work in localhost?
I think I did everything right in my localhost (ubuntu).
But it gives 404
404 generally means the htaccess is wrong or if your forums are in a subfolder the template code wasnt edited according to the instructions.

[tansu]

404 generally means the htaccess is wrong or if your forums are in a subfolder the template code wasnt edited according to the instructions.

Thanks for the reply,

I installed my forum in localhost/doctus
I created another database fro d sql file you provide, and it creates one table.

This is my .htaccess file:
################################################## ###########

# DefaultType application/x-httpd-php5

################################################## ############

Options +FollowSymLinks

RewriteEngine On

# Set file extension you wish to translate here [you may add your desired extension]

# Definition ##/[^\./]*## for translating index files or files without extension [delete to disable]

################################################## ############

RewriteRule !(/[^\./]*|\.(|shtml|shtml|html|htm|shtml|php|php3|php4|php 5|php6))$ - [S=1]

RewriteRule ^(sq|ar|bg|ca|zh-CN|zh-TW|hr|cs|da|nl|en|et|tl|fi|fr|gl|de|el|iw|hi|hu|id |it|ja|ko|lv|lt|mt|no|pl|pt|ro|ru|sr|sk|sl|es|sv|t h|tr|uk|vi)/(.*)$ $2?hl=$1 [L,QSA]

# If not valid html file, view as original (without traslation)

RewriteRule ^(sq|ar|bg|ca|zh-CN|zh-TW|hr|cs|da|nl|en|et|tl|fi|fr|gl|de|el|iw|hi|hu|id |it|ja|ko|lv|lt|mt|no|pl|pt|ro|ru|sr|sk|sl|es|sv|t h|tr|uk|vi)/(.*)$ $2 [L,QSA]

################################################## ############


An this is my template codes:
<!-- vB Global Translator Code -->
<div align="right" class="smallfont"><form id="langsel" name="langsel" action="get"><select id="selector" name="hl" onchange="javascript: window.location.href='/'+this.options[this.selectedIndex].value+'/';"><option value="">Choose language:</option><option value="doctus/ar">Arabic</option><option value="doctus/bg">Bulgarian</option><option value="doctus/zh-CN">Chinese (Simplified)</option><option value="doctus/zh-TW">Chinese (Traditional)</option><option value="doctus/hr">Croatian</option><option value="doctus/cs">Czech</option><option value="doctus/da">Danish</option><option value="doctus/nl">Dutch</option><option value="doctus/en">English</option><option value="doctus/fi">Finnish</option><option value="doctus/fr">French</option><option value="doctus/de">German</option><option value="doctus/el">Greek</option><option value="doctus/iw">Hebrew</option><option value="doctus/hu">Hungarian</option><option value="doctus/it">Italian</option><option value="doctus/ja">Japanese</option><option value="doctus/ko">Korean</option><option value="doctus/no">Norwegian</option><option value="doctus/pl">Polish</option><option value="doctus/pt">Portuguese</option><option value="doctus/ro">Romanian</option><option value="doctus/ru">Russian</option><option value="doctus/sr">Serbian</option><option value="doctus/sk">Slovak</option><option value="doctus/es">Spanish</option><option value="doctus/sv">Swedish</option><option value="doctus/th">Thai</option><option value="doctus/tr">Turkish</option></select></form><a href="http://www.computer-juice.com/forums/">By Hybr!d</a></div>
<!-- vB Global Translator Code -->

Is there anything wrong?

[Dave Hybrid]

You uploaded all the files to your domain root or forum folder?

PM me the URL too if you need me to help further.

[tansu]

You uploaded all the files to your domain root or forum folder?
domain root
in /doctus folder, which is root ..
Well first of all I tried with the default template code, but it gave me 4004, so I changed them do "doctus/ar"

[Dave Hybrid]

right, but the files need to be uploaded to /doctus too. Have you done that?

Domain root and forum root are not the same.

[tansu]

its in the localhost, I cant pm you the url :)

[tansu]

right, but the files need to be uploaded to /doctus too. Have you done that?

Domain root and forum root are not the same.
Yes, files are in the /doctus folder

[Dave Hybrid]

its in the localhost, I cant pm you the url :)

Then I cant support you. Sorry.

[yahoooh]

conflict with vbseo

[ibanez32]

please post for VBseo !!

[ubcforums]

Hi...Can You Please Add Hindi ? (Indian Language)
Thanks ..and please post .htaccess for vbseo users because many use them

[Dave Hybrid]

It would require my coder to rework the htaccess, he is away for the next 10 days or so. After that time I may look into it.

[ibanez32]

hi

i have placed your Ht beofor VBseo Ht code:

################################################## ###########
# DefaultType application/x-httpd-php5
################################################## ############
Options +FollowSymLinks
RewriteEngine On
# Set file extension you wish to translate here [you may add your desired extension]
# Definition ##/[^\./]*## for translating index files or files without extension [delete to disable]
################################################## ############
RewriteRule !(/[^\./]*|\.(|shtml|shtml|html|htm|shtml|php|php3|php4|php 5|php6))$ - [S=1]
RewriteRule ^(sq|ar|bg|ca|zh-CN|zh-TW|hr|cs|da|nl|en|et|tl|fi|fr|gl|de|el|iw|hi|hu|id |it|ja|ko|lv|lt|mt|no|pl|pt|ro|ru|sr|sk|sl|es|sv|t h|tr|uk|vi)/(.*)$ $2?hl=$1 [L,QSA]
# If not valid html file, view as original (without traslation)
RewriteRule ^(sq|ar|bg|ca|zh-CN|zh-TW|hr|cs|da|nl|en|et|tl|fi|fr|gl|de|el|iw|hi|hu|id |it|ja|ko|lv|lt|mt|no|pl|pt|ro|ru|sr|sk|sl|es|sv|t h|tr|uk|vi)/(.*)$ $2 [L,QSA]
################################################## ############





# Comment the following line (add '#' at the beginning)
# to disable mod_rewrite functions.
# Please note: you still need to disable the hack in
# the vBSEO control panel to stop url rewrites.
RewriteEngine On

# Some servers require the Rewritebase directive to be
# enabled (remove '#' at the beginning to activate)
# Please note: when enabled, you must include the path
# to your root vB folder (i.e. RewriteBase /forums/)
#RewriteBase /

#RewriteCond %{HTTP_HOST} !^www\.yourdomain\.com
#RewriteRule (.*) http://www.yourdomain.com/forums/$1 [L,R=301]

RewriteRule ^((urllist|sitemap_).*\.(xml|txt)(\.gz)?)$ vbseo_sitemap/vbseo_getsitemap.php?sitemap=$1 [L]

RewriteCond %{REQUEST_URI} !(admincp/|modcp/|cron|vbseo_sitemap)
RewriteRule ^((archive/)?(.*\.php(/.*)?))$ vbseo.php [L,QSA]

RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !^(admincp|modcp|clientscript|cpstyles|images)/
RewriteRule ^(.+)$ vbseo.php [L,QSA]





but i have the following error :eek: :

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/home/admin/:/tmp:/usr/local/lib/php/) in [path]/translate.php on line 60

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/home/admin/:/tmp:/usr/local/lib/php/) in [path]/translate.php on line 60

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/home/admin/:/tmp:/usr/local/lib/php/) in [path]/translate.php on line 60

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/home/admin/:/tmp:/usr/local/lib/php/) in [path]/translate.php on line 60

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/home/admin/:/tmp:/usr/local/lib/php/) in [path]/translate.php on line 60

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/home/admin/:/tmp:/usr/local/lib/php/) in [path]/translate.php on line 60

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/home/admin/:/tmp:/usr/local/lib/php/) in [path]/translate.php on line 60

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/home/admin/:/tmp:/usr/local/lib/php/) in [path]/translate.php on line 60

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/home/admin/:/tmp:/usr/local/lib/php/) in [path]/translate.php on line 60

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/home/admin/:/tmp:/usr/local/lib/php/) in [path]/translate.php on line 60

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/home/admin/:/tmp:/usr/local/lib/php/) in [path]/translate.php on line 60

[Dave Hybrid]

I have uploaded a vbseo version, no .htaccess needed, see the origianal post for install, demo and download.

[Dave Hybrid]

hi

i have placed your Ht beofor VBseo Ht code:

################################################## ###########
# DefaultType application/x-httpd-php5
################################################## ############
Options +FollowSymLinks
RewriteEngine On
# Set file extension you wish to translate here [you may add your desired extension]
# Definition ##/[^\./]*## for translating index files or files without extension [delete to disable]
################################################## ############
RewriteRule !(/[^\./]*|\.(|shtml|shtml|html|htm|shtml|php|php3|php4|php 5|php6))$ - [S=1]
RewriteRule ^(sq|ar|bg|ca|zh-CN|zh-TW|hr|cs|da|nl|en|et|tl|fi|fr|gl|de|el|iw|hi|hu|id |it|ja|ko|lv|lt|mt|no|pl|pt|ro|ru|sr|sk|sl|es|sv|t h|tr|uk|vi)/(.*)$ $2?hl=$1 [L,QSA]
# If not valid html file, view as original (without traslation)
RewriteRule ^(sq|ar|bg|ca|zh-CN|zh-TW|hr|cs|da|nl|en|et|tl|fi|fr|gl|de|el|iw|hi|hu|id |it|ja|ko|lv|lt|mt|no|pl|pt|ro|ru|sr|sk|sl|es|sv|t h|tr|uk|vi)/(.*)$ $2 [L,QSA]
################################################## ############





# Comment the following line (add '#' at the beginning)
# to disable mod_rewrite functions.
# Please note: you still need to disable the hack in
# the vBSEO control panel to stop url rewrites.
RewriteEngine On

# Some servers require the Rewritebase directive to be
# enabled (remove '#' at the beginning to activate)
# Please note: when enabled, you must include the path
# to your root vB folder (i.e. RewriteBase /forums/)
#RewriteBase /

#RewriteCond %{HTTP_HOST} !^www\.yourdomain\.com
#RewriteRule (.*) http://www.yourdomain.com/forums/$1 [L,R=301]

RewriteRule ^((urllist|sitemap_).*\.(xml|txt)(\.gz)?)$ vbseo_sitemap/vbseo_getsitemap.php?sitemap=$1 [L]

RewriteCond %{REQUEST_URI} !(admincp/|modcp/|cron|vbseo_sitemap)
RewriteRule ^((archive/)?(.*\.php(/.*)?))$ vbseo.php [L,QSA]

RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !^(admincp|modcp|clientscript|cpstyles|images)/
RewriteRule ^(.+)$ vbseo.php [L,QSA]





but i have the following error :eek: :

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/home/admin/:/tmp:/usr/local/lib/php/) in [path]/translate.php on line 60

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/home/admin/:/tmp:/usr/local/lib/php/) in [path]/translate.php on line 60

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/home/admin/:/tmp:/usr/local/lib/php/) in [path]/translate.php on line 60

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/home/admin/:/tmp:/usr/local/lib/php/) in [path]/translate.php on line 60

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/home/admin/:/tmp:/usr/local/lib/php/) in [path]/translate.php on line 60

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/home/admin/:/tmp:/usr/local/lib/php/) in [path]/translate.php on line 60

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/home/admin/:/tmp:/usr/local/lib/php/) in [path]/translate.php on line 60

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/home/admin/:/tmp:/usr/local/lib/php/) in [path]/translate.php on line 60

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/home/admin/:/tmp:/usr/local/lib/php/) in [path]/translate.php on line 60

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/home/admin/:/tmp:/usr/local/lib/php/) in [path]/translate.php on line 60

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/home/admin/:/tmp:/usr/local/lib/php/) in [path]/translate.php on line 60

Sounds like translate.php is not uploaded at all or in the correct folder. PM me your URL for further support.

[GhoHan]

Hello sir how about htaccess?
i'm not using apache but i'm using nginx as webserver.

[Dave Hybrid]

Please let me know how you get on, keen to know of any successful installs.

[Dave Hybrid]

Hello sir how about htaccess?
i'm not using apache but i'm using nginx as webserver.

As you are running standard vb urls you must use the htaccess method. If you cannot use htaccess then this is not for you I'm afraid.

[Dave Hybrid]

New version released.

Now no htaccess files at all so this should run on all servers, linux, windows etc.

It is however restricted to standard vB users and vBSEO users because of URL formats.

Install is the same for both except you download a different zip for each type.

If you have already installed this I suggest you check the new instructions and reinstall, if you tried it and it didn't work I would try again.

Hope you vBSEO lot are now happy. :P

Thanks for your patience.

[GamerPerfection]

If you have already installed this I suggest you check the new instructions and reinstall, if you tried it and it didn't work I would try again.

So I should reinstall too?

[Dave Hybrid]

Yes. The update uses much nicer flags and fixes a few bugs too. It is also now working for vbseo users.

[GamerPerfection]

Yes. The update uses much nicer flags and fixes a few bugs too. It is also now working for vbseo users.

Re-installed, and no problems this time. :p

[Dave Hybrid]

Great, the coding is now much better to accommodate more people. Thanks.

[hilfe-forum]

HELP ;)

Warnung: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/var/www/) in [path]/translate.php (Zeile 60)

[burlesque]

I just tried the vbseo version and I received a blank white screen when I activated the first plugin. I've double checked everything and I've not done anything wrong.
:(

[Dave Hybrid]

HELP ;)

Warnung: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/var/www/) in [path]/translate.php (Zeile 60)

php is being overly protective by restricting access to the script, pass the error to your host.

You need to set open_basedir to none or comment it out in php.ini

It's a common problem with php scripts and hosts eg; http://forum.mamboserver.com/showthread.php?t=1263

Let me know how you get on and if I can help further.

[Dave Hybrid]

I just tried the vbseo version and I received a blank white screen when I activated the first plugin. I've double checked everything and I've not done anything wrong.
:(

I am more than happy to take a look if you PM me your URL and a temp admin/FTP login.

I have installed this on quite a few peoples sites including vBSEO enabled ones.

Without seeing what is going on properly it's hard to troubleshoot.

[Sweeks]

Not working for me properly, it just constantly loads when clicking a language. Any ideas?

[Dave Hybrid]

Not working for me properly, it just constantly loads when clicking a language. Any ideas?

It will, translation can take time, especially with large pages.

But, as your site gets 'cached' the pages will load as fast as normal vB pages.

I tested your site and it seems slow you can login to phpmyadmin and refresh it to watch the db to be sure it is caching.

Oh, and thanks for removing the credit badge/link.

[Sweeks]

Just did ;)

[Sweeks]

I wasnt too happy about it being thrown in there without any warning in the first post of this thread. Is it okay to have removed it? Thanks

The DB size doesnt seem to have increased at all.

[Dave Hybrid]

Just did ;)


Pages do translate http://www.teenforumz.com/a/?hl=ar

Seems others overload your server a bit, what load are you running? and shared hosting , VPS etc?

[Sweeks]

Shared, what is the best setting do you recommend? :)

[Dave Hybrid]

I wasnt too happy about it being thrown in there without any warning in the first post of this thread. Is it okay to have removed it? Thanks

Was it really that big of a deal? Whats the harm in giving credit to something that will benifit you and was given away for free.

[Dave Hybrid]

Shared, what is the best setting do you recommend? :)

Well if your server cant handle it not much you can do but upgrade.

[Sweeks]

It wasnt a big deal at all no, I would have preffered to have known it was going to be there instead of thrown in amongst the languages.

I guess this one will be getting disabled until we upgrade in the future then :)

[hilfe-forum]

php is being overly protective by restricting access to the script, pass the error to your host.

You need to set open_basedir to none or comment it out in php.ini

It's a common problem with php scripts and hosts eg; http://forum.mamboserver.com/showthread.php?t=1263

Let me know how you get on and if I can help further.

ok i deactivate open_basedir now i got blank Page....

http://forum.hilfe-forum.eu/?hl=it

[Dave Hybrid]

It wasnt a big deal at all no, I would have preffered to have known it was going to be there instead of thrown in amongst the languages.

I guess this one will be getting disabled until we upgrade in the future then :)


Seems ok now,

http://www.teenforumz.com/chillout-room/9360-song-refreshes-you.html?hl=da

http://www.teenforumz.com/chillout-room/9360-song-refreshes-you.html?hl=sv

Some times it can take a few refeshes to cache the page. The search bots will hit them enough, and over time they will be cached and indexed fine.

[TimberFloorAu]

Good Idea but.

1. you must constantly click the language icon of your choice, as you navigate to each page/post/thread

2. your demo, is quite basic. With one forum post with one word in it. I would like to see this on a busy board, I hazzard a guess, the page load would be immensely slow

[Dave Hybrid]

ok i deactivate open_basedir now i got blank Page....

http://forum.hilfe-forum.eu/?hl=it

You're using a subdomain, im not sure it is compatible. I would need to see what is going on behind the scenes.

[Dave Hybrid]

Good Idea but.

1. you must constantly click the language icon of your choice, as you navigate to each page/post/thread

2. your demo, is quite basic. With one forum post with one word in it. I would like to see this on a busy board, I hazzard a guess, the page load would be immensely slow

And as I have said, once pages get cached after a few loads it works just fine. I have it on a few personal huge sites.

The search bots will happily hit the pages all day long until they load, caching them for you.

It is a tool for getting more pages indexed and more traffic without writing 100x more content. That's it.

[hilfe-forum]

You're using a subdomain, im not sure it is compatible. I would need to see what is going on behind the scenes.

:( hmm ok i try on this:
http://www.hilfe-forum.eu/hilfe-forum/
tomorrow ;)

[Sweeks]

Is it normal for the DB size to not increase at all or change? Thanks

[SuperTaz]

I will install this later on tonight. Seems like a great mod.

[TimberFloorAu]

Surely tho:

To enable bots to spider all of your pages, you would need to allow guests to read all posts/threads etc.

So the reality is, based on your figures:

If you have 10,000 threads
average 5 replies per thread, and limit guest viewing to 1 view per thread, then yes you are getting potentially 280,000 indexed posts. But surely this makes no difference to the pages being indexed, because the indexing is carried out based on the language for the forum.

Your forum button doesnt change this ( icon wise )

Isnt it a bit like saying, if you have 30 styles, then it would be 30 x 10,000 x 28 languages, which would increase indexing. Which in reality it does not.?

[SuperTaz]

Thank you. Works nice. Installed.

Only one thing. When I click a language, it takes about a minute to load the new page in the new language. I have a fast server. What number do I set it at to load it faster?


if(floatval(getServerLoad()) >= 1.5)

[GamerPerfection]

Good Idea but.

1. you must constantly click the language icon of your choice, as you navigate to each page/post/thread


Yes this happens to me too.
It never happened when I had the drop down list of languages.

http://www.galaxyofstars.co.uk/forums/
If you click Arabic for example, then click anywhere on my forum it reverts back to the default language, which for me is English.

In fact, it happens on your own demo too.

EDIT: This was also causing multiple database errors during the night, which I nicely woke up to an inbox full of emails informing me about a vbulletin database error, which were all related to the languages.

[Dave Hybrid]

Yes this happens to me too.
It never happened when I had the drop down list of languages.

http://www.galaxyofstars.co.uk/forums/
If you click Arabic for example, then click anywhere on my forum it reverts back to the default language, which for me is English.

In fact, it happens on your own demo too.

EDIT: This was also causing multiple database errors during the night, which I nicely woke up to an inbox full of emails informing me about a vbulletin database error, which were all related to the languages.

It is ment to do that, there was a bug in the first version.

You do not want to translate everything, do you want people posting in arabic? I'm sure you don't.

This mod is to get more traffic without doing any work, some of that traffic might convert to using your site in it's intended language or click an advert, tell a friend etc.

If you want to have you site in 30 languages for users then install language packs.

This mod is for auto generating pages and getting them indexed.

[Dave Hybrid]

Surely tho:

To enable bots to spider all of your pages, you would need to allow guests to read all posts/threads etc.

So the reality is, based on your figures:

If you have 10,000 threads
average 5 replies per thread, and limit guest viewing to 1 view per thread, then yes you are getting potentially 280,000 indexed posts. But surely this makes no difference to the pages being indexed, because the indexing is carried out based on the language for the forum.

Your forum button doesnt change this ( icon wise )

Isnt it a bit like saying, if you have 30 styles, then it would be 30 x 10,000 x 28 languages, which would increase indexing. Which in reality it does not.?

You're totally missing the point mate.

Google doesnt index styles, or even websites. It indexes pages/urls.

Styles dont create new pages/urls, neither do language packs.

Also multiple styles are all in the same language, so again, how is that generating more original content?

This mod creates original content pages in languages you otherwise wouldnt target, with little or no effort. No need to write any content, nothing. Install and wait.

Yes if you hide pages for guests then that limits you, but that would limit your current pages too.

I dont see why people are complaining, most of you have a few thousand threads and know how hard it was to get there. This MOD multiplys those pages overnight.

[Dave Hybrid]

Thank you. Works nice. Installed.

Only one thing. When I click a language, it takes about a minute to load the new page in the new language. I have a fast server. What number do I set it at to load it faster?

The speed is governed by your server spec and configuration settings.

All that vBGT setting does is stop the cache part of the script when your load gets high to avoid crashing your server.

So individual pages will still operate at the same speed whatever you set it at, it just means more can be cached at any one moment.

[Dave Hybrid]

Thank you. Works nice. Installed.

Only one thing. When I click a language, it takes about a minute to load the new page in the new language. I have a fast server. What number do I set it at to load it faster?

I just checked it out on your site looks great.

Can you PM me your server specs please, it seems very fast on your setup, would really help me out as I may release a min server spec for this.

For anyone else questioning the speed etc. on a larger site...

http://www.global-gamers.net/forums/?hl=ar

Works just fine.

[tansu]

it just waits tooo long
should I increase or decrease this value?
if(floatval(getServerLoad()) >= 1.5)

doctus(dot)org btw.

[Dave Hybrid]

it just waits tooo long
should I increase or decrease this value?
if(floatval(getServerLoad()) >= 1.5)

doctus(dot)org btw.

Pages have to be cached as you are creating them on the fly, one they are cached they will load faster.

So, it may take a few days to a few months to cache your site fully, this is a long term mod. Even if the pages were cached overnight Google wouldn't index them for a few months anyway.

See here to answer you other question. https://vborg.vbsupport.ru/showpost.php?p=1831159&postcount=85

[Dave Hybrid]

it just waits tooo long
should I increase or decrease this value?
if(floatval(getServerLoad()) >= 1.5)

doctus(dot)org btw.


I also take it as your base language is not english you changed it to you site base language in translate.php?

if your forums base language is different to English, change your country code.

[tansu]

Pages have to be cached as you are creating them on the fly, one they are cached they will load faster.

So, it may take a few days to a few months to cache your site fully, this is a long term mod. Even if the pages were cached overnight Google wouldn't index them for a few months anyway.

See here to answer you other question. https://vborg.vbsupport.ru/showpost.php?p=1831159&postcount=85
Hmm
Ok, thanks a lot

[Calash]

I am having no luck getting this mod to work.

After a long pageload I get the following error.


Content Encoding Error (content_encoding_error)

Server response could not be decoded using encoding type returned by server.
This is typically caused by a Web Site presenting a content encoding header of one type, and then encoding the data differently.

For assistance, contact your network support team.



This lines up with a MySQL error that I get



Invalid SQL:

UPDATE vb_session
SET lastactivity = 1245251364, location = '/vb/index.php?hl=ar', inforum = 0, inthread = 0, incalendar = 0, badlocation = 0
WHERE sessionhash = 'bacffa01e4fe73a708c9d524862b0472';

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Wednesday, June 17th 2009 @ 10:09:24 AM
Error Date : Wednesday, June 17th 2009 @ 10:10:48 AM


The documentation says is likely the server timing out. I am going to check with my host and see if that can be increased.

[The Realist]

Added the code for the flags but they dont dont show up in any template I edit, any ideas?

[Dave Hybrid]

You have to add the code to the template, upload the file and setup a plugin for them to show. One or more is wrong.

[The Realist]

Code is added to the template, files are uploaded and the plugin code has been created. I think its the template Im using myself.

[Dave Hybrid]

I cant think why it would conflict, i can take a look if you want, PM me the URL if so...

[The Realist]

PM sent.

[The Realist]

Found the problem, I didnt add the 2nd plugin, flags now show.

Thanks.

[RWerksman]

How does this mod handle non-standard language responses or forums?

[Bounce]

I'm getting ....

Warning: require_once(translate.php) [function.require-once]: failed to open stream: No such file or directory in [path]/includes/functions.php(5721) : eval()'d code on line 1

Fatal error: require_once() [function.require]: Failed opening required 'translate.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/xxxxx/public_html/forum/includes/functions.php(5721) : eval()'d code on line 1

on my portal pages..

I'm gueessin its coz it uses Hook Location: global_complete

[GamerPerfection]

It is ment to do that, there was a bug in the first version.

Ah ok, didn't realise that. Cool, everything is fine then. :)

[GamerPerfection]

I keep getting emails notifying me of vbulletin database errors.

And they all seem to centre around the languages. For example:

Database error in vBulletin 3.8.3:

Invalid SQL:

UPDATE session
SET lastactivity = 1245267656, location = '/forums/index.php?hl=de', inforum = 0, inthread = 0, incalendar = 0, badlocation = 0
WHERE sessionhash = '5b2512f2b64d205f4087c9b7ef3758fb';

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Wednesday, June 17th 2009 @ 08:40:56 PM
Error Date : Wednesday, June 17th 2009 @ 09:10:14 PM
Script : http://www.galaxyofstars.co.uk/forums/index.php?hl=de
Referrer :
IP Address : 72.30.79.27
Username : Unregistered
Classname : vB_Database
MySQL Version :


Database error in vBulletin 3.8.3:

Invalid SQL:

UPDATE session
SET lastactivity = 1245267677, location = '/forums/index.php?hl=cs', inforum = 0, inthread = 0, incalendar = 0, badlocation = 0
WHERE sessionhash = '5b2512f2b64d205f4087c9b7ef3758fb';

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Wednesday, June 17th 2009 @ 08:41:17 PM
Error Date : Wednesday, June 17th 2009 @ 09:10:08 PM
Script : http://www.galaxyofstars.co.uk/forums/index.php?hl=cs
Referrer :
IP Address : 72.30.79.27
Username : Unregistered
Classname : vB_Database
MySQL Version :


As you can see where the script bit is it always is to do with the languages.

I just got 13 emails.

[Dave Hybrid]

I keep getting emails notifying me of vbulletin database errors.

And they all seem to centre around the languages. For example:







As you can see where the script bit is it always is to do with the languages.

I just got 13 emails.

I get a few of them on my sites too, we are looking into it as we speak. So long as your site functions it is nothing to really worry about allbeit a little annoying I know. This happens when the bots try to translate a page and get bored and move on so the MySQL query gets halted and an error thrown.

[Dave Hybrid]

I'm getting ....

Warning: require_once(translate.php) [function.require-once]: failed to open stream: No such file or directory in [path]/includes/functions.php(5721) : eval()'d code on line 1

Fatal error: require_once() [function.require]: Failed opening required 'translate.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/xxxxx/public_html/forum/includes/functions.php(5721) : eval()'d code on line 1

on my portal pages..

I'm gueessin its coz it uses Hook Location: global_complete

If your portal is in a different folder to your forum you will need to upload the files to both folders.

[GamerPerfection]

I get a few of them on my sites too, we are looking into it as we speak. So long as your site functions it is nothing to really worry about allbeit a little annoying I know. This happens when the bots try to translate a page and get bored and move on so the MySQL query gets halted and an error thrown.

Ok, thanks for the quick response.

Yes it's not really a problem, just an annoyance, but as long as I know it's nothing major. :D

[nascimbeni]

Can I select fewer languages ? My forum will probably work well with just English and Italian for example

since my forum is a sub domain I uploaded the flag folder in both the subdomain root and main domain root .

I am getting this error
"Fatal error: Call to undefined function mysql_set_charset() in /home/vhosts/lifeinitaly.com/subdomains/my/httpdocs/translate.php on line 36"

Thanks

[Dave Hybrid]

Can I select fewer languages ? My forum will probably work well with just English and Italian for example


PS since my forum is a sub domain where do I uploaf the flag folder in the subdomain root or the main domain root ?

Thanks


Sure, just open translateflags.php and remove the ones you don't want, I'd appreciate if you would leave the credit link/flag badge in.

[Dave Hybrid]

How does this mod handle non-standard language responses or forums?

Can you explain what you mean, I'm not sure I understand. :)

[Bounce]

If your portal is in a different folder to your forum you will need to upload the files to both folders.

ahhhh, thanks :up:

[nascimbeni]

Thanks for the fast answer !

Since my forum is a sub domain ( not in a folder ) I uploaded the flag folder in both the subdomain root and main domain root .

but I am getting this error
"Fatal error: Call to undefined function mysql_set_charset() in /home/vhosts/lifeinitaly.com/subdomains/my/httpdocs/translate.php on line 36"

[Dave Hybrid]

Thanks for the fast answer !

Since my forum is a sub domain ( not in a folder ) I uploaded the flag folder in both the subdomain root and main domain root .

but I am getting this error
"Fatal error: Call to undefined function mysql_set_charset() in /home/vhosts/lifeinitaly.com/subdomains/my/httpdocs/translate.php on line 36"

I would ask your host, seems to be a php.ini config issue.

http://www.idealog.us/2005/01/howto_fix_fatal.html

[goxy63]

Rated, tagged
Will check it out ASAP
Thanks

[RWerksman]

Can you explain what you mean, I'm not sure I understand. :)
Sure - I currently have forums in Italian, Greek, French, and Spanish in addition to the main English forums. If the post is in the French forum, will this mod be able ot adjust?

[Dave Hybrid]

Sure - I currently have forums in Italian, Greek, French, and Spanish in addition to the main English forums. If the post is in the French forum, will this mod be able ot adjust?

I believe this only works for sites in one base language. As per the first install instruction you need to set your base language so the script knows what to tell the Google translate APi to translate from and into. So multiple languages will confuse it a lot and cause errors.

[Hornstar]

This is really great. Nice work. I was actually asking over at vbseo how I could do something similiar like this.

One question tho. If someone lands on my site from a Japanese search engine and they are viewing my site in Japanese. They then sign up and begin replying to a thread in Japanese. What will happen then? Because I believe this could cause much confusion unless the script knows what language they are typing in.

[Dave Hybrid]

This is really great. Nice work. I was actually asking over at vbseo how I could do something similiar like this.

One question tho. If someone lands on my site from a Japanese search engine and they are viewing my site in Japanese. They then sign up and begin replying to a thread in Japanese. What will happen then? Because I believe this could cause much confusion unless the script knows what language they are typing in.

Once someone clicks a next page they are forced back to the base site language.

[Dave Hybrid]

Here you can see a vBGT user has translated pages indexed after just a few hours.....

http://www.google.com/search?hl=en&safe=off&q=site%3Awww.galaxyofstars.co.uk+inurl%3Ahl%3D&aq=f&oq=&aqi=

[tansu]

it just waits tooo long
should I increase or decrease this value?
if(floatval(getServerLoad()) >= 1.5)

doctus(dot)org btw.
Still same here..
it waits and waits, then internal server error

[Dave Hybrid]

Still same here..
it waits and waits, then internal server error

https://vborg.vbsupport.ru/showpost.php?p=1831176&postcount=89

I replied here, you did not answer.

[Geraldm]

Hi,

Great plugin!!

I've installed it on my site and it works fine ... get quite a few MySQL 2006 (server has gone away) errors but as you said above you are looking into that ...

The only issue I have is that when you change the language and then click on any link in the forum the forum reverts back to english (the default) ... is there a way so the forum keeps the language setting which the user selects rather than having to reselect the language every time you changes pages on my forum?

btw: I have vbSEO installed as well.

Thanks,
Gerald.

[Calash]

I get a few of them on my sites too, we are looking into it as we speak. So long as your site functions it is nothing to really worry about allbeit a little annoying I know. This happens when the bots try to translate a page and get bored and move on so the MySQL query gets halted and an error thrown.


I get this all the time on my site. I tried lowering the serverload selection but no luck. It never writes to the database or to the text file.

Any ideas or is this a hosting issue that I will not be able to resolve?

[Dave Hybrid]

That is normal, if someone want the next page translated they just click a flag again.

[tansu]

https://vborg.vbsupport.ru/showpost.php?p=1831176&postcount=89

I replied here, you did not answer.
sorry, I did not see that

Question is yes, I changed the language code like this:

function callback($buffer){
$fl = 'tr'; //current language (original) - refer table for language initials
$modifyhref = false;

[Dave Hybrid]

I get this all the time on my site. I tried lowering the serverload selection but no luck. It never writes to the database or to the text file.

Any ideas or is this a hosting issue that I will not be able to resolve?

What is you current serverload? and did you CHMOD 777 the cache file?

The load setting on the script means if server load is x then cache is disabled. If you already have a high load it will be disabled and no db writing will happen, get you load down or up the setting to something above what your load is. Be careful though as upping the setting will put even more load on your server. Are you on shared hosting? Might be time for an upgrade.

[Dave Hybrid]

sorry, I did not see that

Question is yes, I changed the language code like this:

function callback($buffer){
$fl = 'tr'; //current language (original) - refer table for language initials


What is your URL?

[Dave Hybrid]

sorry, I did not see that

Question is yes, I changed the language code like this:

function callback($buffer){
$fl = 'tr'; //current language (original) - refer table for language initials
$modifyhref = false;



http://doctus.org/downloads.php?hl=ar

Seems to work here, what is your server spec? Shard? VPS, Dedi?

[tansu]

http://doctus.org/downloads.php?hl=ar

Seems to work here, what is your server spec? Shard? VPS, Dedi?
it's VPS
2.4 GHZ cpu and 1 GB Ram

[Geraldm]

What is you current serverload?

How do you find out the current server load on a shared hosting (Hostgator) account?

Cheers ...
Gerald.

[Dave Hybrid]

it's VPS
2.4 GHZ cpu and 1 GB Ram


And what are your load averages?

[Dave Hybrid]

How do you find out the current server load on a shared hosting (Hostgator) account?

Cheers ...
Gerald.


It should be in your vB admin CP homepage under - Quick Administrator Links

[tansu]

And what are your load averages?
My load averages are: 1.33, 1.53, 1.58

[Dave Hybrid]

My load averages are: 1.33, 1.53, 1.58

Hmm, ok, seems some have issues and some dont, mysql seems to overload on some servers. We are looking into it. Will update shortly.

[Geraldm]

It should be in your vB admin CP homepage under - Quick Administrator Links

Ah ok found it .... it says:
Server Load: 2.16 (2 cpus)

Server Load Averages: 3.71 2.80 2.52

I would expect this to be normal and would very rarely go below the set threshold of 1.5 as defined in your plugin...

Should I increase the threshold to something like 2.5? Is that advisable?

[Dave Hybrid]

If you are constant above 1.5 then the script will work but pages will not be cached.

You can increase it to say 2.5 and caching will work, but server load will increase more, so 3 may be a better option.

If it has a negative effect, like the site gets very slow then let me know.

[nascimbeni]

I solved a previous error ( php had to be upgraded to 5.2 ) -
Now however I have this message when I activate the plug in
"The page you are trying to view cannot be shown because it uses an invalid or unsupported form of compression."

[Calash]

What is you current serverload? and did you CHMOD 777 the cache file?

The load setting on the script means if server load is x then cache is disabled. If you already have a high load it will be disabled and no db writing will happen, get you load down or up the setting to something above what your load is. Be careful though as upping the setting will put even more load on your server. Are you on shared hosting? Might be time for an upgrade.

Yes to shared hosting and I am not going to be upgrading just for a single modification. If it is incompatible with a shared host then I am going to uninstall for now.

Thanks, it looks to be a very well done modification :)

[Dave Hybrid]

It is very MySQL intensive, some servers have an issue with this, we are working to narrow down the cause. We may need to release a upgrade or it may be a simple case of server spec. We're still testing.

[nascimbeni]

Dave
Did you see my posting ( a copy below ) -
I have this message when I activate the plug in
"The page you are trying to view cannot be shown because it uses an invalid or unsupported form of compression."

PS I am on a dedicated server

[Dave Hybrid]

Also you say you wont upgrade for one mod. If your traffic doubled overnight and loaded your server would you not upgrade? Because this is what this mod will do in the long run anyway...

[Dave Hybrid]

Dave
Did you see my posting ( a copy below ) -
I have this message when I activate the plug in
"The page you are trying to view cannot be shown because it uses an invalid or unsupported form of compression."

PS I am on a dedicated server

To be honest I'm not sure, I dont think the script likes subdomains as I said before, sorry.

[Geraldm]

To be honest I'm not sure, I dont think the script likes subdomains as I said before, sorry.

I'm running it on a subdomain (forums.mydomain.com) just fine... apart from the mysql errors ;)

[The Realist]

Installed and working but when I go here: http://www.xxxxxxx.co.uk/photoplog/index.php

I get this error:

Code Removed.

Any ideas?

Works everywhere else.

[Dave Hybrid]

Installed and working but when I go here: http://www.sattalk.co.uk/photoplog/index.php

I get this error:

Warning: require_once(translate.php) [function.require-once]: failed to open stream: No such file or directory in [path]/includes/functions.php(5721) : eval()'d code on line 9

Fatal error: require_once() [function.require]: Failed opening required 'translate.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/sattalk/public_html/includes/functions.php(5721) : eval()'d code on line 9

Any ideas?

Works everywhere else.

try uploading translate.php to the photoplg folder

[The Realist]

Yep that did the trick, well done :)

[SuperTaz]

Seems to be working great on my site so far with no errors.

[RWerksman]

I believe this only works for sites in one base language. As per the first install instruction you need to set your base language so the script knows what to tell the Google translate APi to translate from and into. So multiple languages will confuse it a lot and cause errors.
Dave,

Then correct me if I'm wrong here - this would effectively drive traffic to your forum then it wouldn't be able to cope with anyone actually replying to messages, correct?

[Dave Hybrid]

This mod will drive foreign visitors you otherwise would net get to your pages, if they want to contribute they will need to also speak your base language. That said on most sites 90% of search traffic bounces after reading one page via the back button or an advert. So, on my sites all this really does is increase my CPM on my banners and adsense clicks. For free. You're use may vary.

If you are simply wanting to offer parts of your site in other languages as a feature rather than a search traffic tool look into language packs. You will however need to create new content in those languages in order to get search referrals, language packs will not translate a site. They just allow other languages to be used.

[Dave Hybrid]

I have just made a leap in improving load times on large sites, we found that on big sites the sheer volume of MySQL writes being made as the search bots and users try to translate all your pages was locking the translate database. This means cached pages were loading slow, even though they were cached and a few other bugs. The new method seems to allow sites to be cached much faster with lower server load and cached pages load instant or there abouts. I will update when we are 100%, it's a simple upgrade too. Thanks.

[Sweeks]

We upgraded to a VPS tonight and now it gives a blank page, any fix for this? :)

http://www.teenforumz.com/?hl=ar

Thanks!

[Dave Hybrid]

<font color="Red">Ok so here is the information for those of you experiencing slow load times, it is recommended that all users make these changes.</font>

Add a new MySQL database to your domain. Open the database in phpmyadmin or similar and import the db.sql file to install the database tables the same as before but once you have done that you need to select 'operations' from the top menu and change the storage engine to InnoDB, then click Go. Then enter the new DB details into translate.php and re-upload that file.

InnoDB seems to handle the multiple read/write requests without issue whereas MyISAM had issues with tables locking and thus locking read/write access under load which caused huge bottlenecks on larger/busier sites.

We tested this on a few huge 100k thread sites without issue.

Thanks, enjoy the traffic.

Dave.

[Sweeks]

Would this sort out the blank page after moving servers? :)

[Sweeks]

I was having the problem with open_basedir but thats no longer the problem and I now have the same problem as the hilfe forum guy where it is just a blank page, gonna try the tweak mentioned above and see if it works.

[Dave Hybrid]

Sorry, but I only support users whom don't remove credit links. This script took a lot of time and money to code and I give it away for free. Frankly, it's an insult.

[Sweeks]

Try stating that you stick a credit link in the middle of all the languages upon installation in your thread and that you dont want it to be removed, also try mentioning that you wont support anyone who removes it in there too.

You never said we need to keep it there or had any comments saying please keep in place etc

Will you please support me with this as you stated this mod is supported and frankly, the support is conditional.

[Dave Hybrid]

Wow, the front on you.

You knew dam well when you removed the credit that you were removing something intended to stay, why else would I include it?

Conditional support? LOL, it's a free product. No I will not support you. I suggest you uninstall.

[Sweeks]

If you never wanted it to be removed you could have said so like I said above. I am asking for support as you have marked this as supported.

[Dave Hybrid]

As I said, you removed the credit and you knew what you were doing when you did it. I still supported you and dropped a big hint I wasn't happy, then you ask for support again and you still hadn't added the credit back. It's too late now, I gave you the chance to fix it.

[Sweeks]

Well I think this is a joke as most people who make mods have in their code that you should not remove their link and if you want to you need to pay such and such amount, you never once stated that, so no actually, I didnt know I wasnt allowed to remove it seen as you had never said so.

It is okay thanks, I would rather not have your kind of support. In future a little tip for you, try commenting in your code that the link should not be removed or mentioning it in your thread like a lot of other coders do and you wont have so many removing it.

[Dave Hybrid]

So many? It's just you mate, everyone else isn't a leech.

[Sweeks]

I know two other forums with this mod and the middle flag isnt there so obviously is isnt just me who removed the link. Honestly if your code was commented where the link was I wouldnt have removed it. It is pointless arguing about this.

Thank you for the modification as it works really well on the right setup :)

[Dave Hybrid]

People like you and them would remove it anyway, it just the way you are.

[Dave Hybrid]

Version 1.5 release:

More major bug fixes and speed improvements. This is a essential upgrade. Old versions will now no longer be supported and will soon cease to function.

Upgrading:

If you have not yet setup a new InnoDB type MySQL database as explained in the last update please do so now, this improves speed 100x. See main post install instructions for details.

If you have done so you now need to download the latest files and re-upload all of them to the relevant places also explained in the install instructions.

You also now need ioncube for the script to work, your host can install this, it is free.

Thanks.

[GamerPerfection]

I know two other forums with this mod and the middle flag isnt there so obviously is isnt just me who removed the link. Honestly if your code was commented where the link was I wouldnt have removed it. It is pointless arguing about this.

Thank you for the modification as it works really well on the right setup :)

Mate just shut up and leave the thread if you're not happy with the service.

What IS that harm in having a link in the middle? To be honest I hadn't even noticed it until you came up. It doesn't stick out like a sore thumb, it's the same size as all the others. What IS the problem????

You want support yet you won't support the Coder by having the link.

YOU'RE a joke!

[Sweeks]

Mate just shut up and leave the thread if you're not happy with the service.

What IS that harm in having a link in the middle? To be honest I hadn't even noticed it until you came up. It doesn't stick out like a sore thumb, it's the same size as all the others. What IS the problem????

You want support yet you won't support the Coder by having the link.

YOU'RE a joke!

Sorry but no I will not shut up, I have no problem putting the link back in but most coders tend to say so within their code that they would prefer the link to be left in there and he never expressly said this at all. So I am sure like me, plenty of others would have also removed it.

I have the problem fixed now anyway so I dont require the support, so I will happily leave this thread.

[Dave Hybrid]

Keep digging buddy, you're just making yourself look like a real deal a$$hole.

Stop talking and put the link back then.

But why bother ay? You don't need me anymore and you have your free script.

Parasite.

What happens when it breaks again?

Karma is a b!tch.

[Sweeks]

Keep digging buddy, you're just making yourself look like a real deal a$$hole.

Stop talking and put the link back then.

But why bother ay? You don't need me anymore and you have your free script.

Parasite.

What happens when it breaks again?

Karma is a b!tch.

Parasite? You shouldnt make modifications for free then and not expressly state you dont want the link taken out, simple.

I am sorry but I have seen many coders on here clearly express their wishes for links and copyrights not to be removed and it isnt my problem you never.

And if it breaks, then it breaks, thats what you do, you take your chances with modifications. There is no point being funny with me just because you didnt state that you never wanted the link taken out and people can argue with me all they like but it is the truth that you never mentioned the link being there or your wishes for it to be kept there.

I am gone now, save your time in replying as I am not interested.

[Calash]

Well with the database changes and the updated files/plugins I am still getting the database errors.

However the database actually has information in it now. This is better than before.

I am going to let it sit for a bit so the spiders can crawl and see if the database gets more data.

[Dave Hybrid]

Well with the database changes and the updated files/plugins I am still getting the database errors.

However the database actually has information in it now. This is better than before.

I am going to let it sit for a bit so the spiders can crawl and see if the database gets more data.

The pages seem to throw an error in the browser, are you 100% you installed it perfect?

[Kolbi]

Can you please make a history, what you fixed in the new version?
I mean:

*1.1
fixed xyz
*1.2
fixed abc
...
:)
That would be nice for the future.

[Calash]

The pages seem to throw an error in the browser, are you 100% you installed it perfect?

Yes, triple checked. The browser errors line up with MySQL errors as posted previously (Sever has gone away).

I am thinking that my shared host is doing something that kills the query.

I disabled the plugins for now because I was getting flooded with errors. When I have more time I will check everything again and see if I can work out the details.


Thanks for your effort with this mod :)

[Dave Hybrid]

Version 1.6 release;

* Fixed nofollow block on flag links for users with vbseo sites
* Fixed adsense ads showing for translation services etc. by adding section targeting ignore tags

All users should exchange their template code to include adsense ignore tags;

<!-- vBGT Code Start-->
<div align="center">
<!-- google_ad_section_start(weight=ignore) -->
$translateflags
<!-- google_ad_section_end -->
</div>
<!-- vBGT Code End -->

*IMPORTANT VBSEO USERS*

We have just found vBSEO adds nofollow to the flag links so if you want the search bots to crawl and index your translated pages - thats all of you right? ;) - you must download version 1.6 and upload the new translateflags.php file.

Thanks.

[Geraldm]

We have just found vBSEO adds nofollow to the flag links so if you want the search bots to crawl and index your translated pages - thats all of you right? ;) - you must download version 1.6 and upload the new translateflags.php file.

Ahhh ..... I was wondering why Google wasn't taking any notice of the new language links ;)
Thanks for the update!

[relaxiha]

Hello.
Google also recently supported the Persian language. Please update as you can for us.
thanks

[Dave Hybrid]

Hello.
Google also recently supported the Persian language. Please update as you can for us.
thanks

Most of us run Adsense and Adsense do not like it if you put their ads on pages using languages they don't support.

[Dave Hybrid]

Ahhh ..... I was wondering why Google wasn't taking any notice of the new language links ;)
Thanks for the update!

You're welcome.

[relaxiha]

I do think you are wrong. For more information see here
http://translate.google.com/
Translation: Persian ? English — ALPHA

[GamerPerfection]

Updated to latest version no problems. :D:up:

[Dave Hybrid]

I do think you are wrong. For more information see here
http://translate.google.com/
Translation: Persian ? English ? ALPHA

I never said it wasn't support by google translate.

I said it wasn't support by ADSENSE.

IE; you cannot run adsense on Persian language pages, so, as most of us run adsense it is not of much use.

[Dave Hybrid]

v1.7

* Removed ioncube encryption to bring script inline with vBulletin.org rules

************************************************** *************

Apologies to vbulletin.org, I was not aware of that rule.

All current users of the script should click install and rate again to receive support and updates. Thanks and sorry for the inconvenience.

[yahoooh]

thank u but still i need to know how it will be update the pages as u know every thread will have new comments

[Dave Hybrid]

The script can detect page changes and they update (save to cache) automatically on page refresh.

[GamerPerfection]

So what do I need to amend? Or do I need to install the whole thing again?

[Dave Hybrid]

So what do I need to amend? Or do I need to install the whole thing again?

Nothing if you don't want to, this update just removes the encryption on the files. The code and functions are unchanged.

[GamerPerfection]

Nothing if you don't want to, this update just removes the encryption on the files. The code and functions are unchanged.

Ah ok, thanks.

[Kolbi]

Are there any statistics yet?

Indexed sites...
traffic increase?
:)

A short question, if I use this addon will it influence the speed of my community?
I don?t think so because this script is working on another database?

Another question, a user comes from a translated page to my communits registers and starts to open a new thread. Will it be saved in the "new translated" Database or in the original database? Or will we translated version been saved in the original database?

When I move with my community to another server to I have to took the translated database over? Or will it automatically been new translated? So a transfer isn?t needed?

Thank you.

[Dave Hybrid]

Are there any statistics yet?

Indexed sites...
traffic increase?
:)

It's been 5 days, some sites have pages indexed but as with regular pages it can take months to see traffic and also depends on the page topic and 100 other things.

A short question, if I use this addon will it influence the speed of my community?
I don?t think so because this script is working on another database?

No,it will not impact you other databases or normal site speed.

Another question, a user comes from a translated page to my communits registers and starts to open a new thread. Will it be saved in the "new translated" Database or in the original database? Or will we translated version been saved in the original database?

All your written content is in your main DB, the users can only read pages in other languages and those languages are stored in the new translate DB.

When I move with my community to another server to I have to took the translated database over? Or will it automatically been new translated? So a transfer isn?t needed?

Not sure what you mean, if you move servers you take the database with you, so you wouldn't start over.

Thank you.

[burlesque]

Hi, the files are still saying version 1.6.

[burlesque]

LOL! Ignore that. They said 1.6 when I posted the message, but by the time that it had been submitted (2 seconds) they had been updated to 1.7!

[Dave Hybrid]

Changed, thanks.

[jaryx]

When plugin 'vB Global Translator' is enabled Firefox shows me that:

Error coding content

This page can not be displayed, because it uses incorrect or unsupported compression methods.

This page can not be displayed, because it uses incorrect or unsupported compression methods.

* Please inform the site owners about this issue.

Why?

[nascimbeni]

Dave
I just tried reinstalling the mod and I am getting the same as Jaryx above. I am using the mod on a sub domain but it seems that somebody else is using it on a sub domain with no problems.
If you find a fix please pm me. I will also try to keep an eye on this thread.

[Dave Hybrid]

When plugin 'vB Global Translator' is enabled Firefox shows me that:

Error coding content

This page can not be displayed, because it uses incorrect or unsupported compression methods.

This page can not be displayed, because it uses incorrect or unsupported compression methods.

* Please inform the site owners about this issue.

Why?


What is your URL.

[WxP]

What i need to do to translate in Albania Language?

[jaryx]

What is your URL.

http://fifa.pes.com.pl

I have vBSEO & vBadvanced.

and I use subdomain like nascimbeni...

[Dave Hybrid]

http://fifa.pes.com.pl

I have vBSEO & vBadvanced.

and I use subdomain like nascimbeni...

Did you follow the instructions exact, the flags are not on you pages and the translate.php code is not being called at all.

[Sweeks]

Do you think this mod would attract foreign spammers who otherwise wouldnt be able to spam so easily on the site? I have removed quite a few of the languages because of this possibility. What does everyone else think of this?

[Dave Hybrid]

Do you think this mod would attract foreign spammers who otherwise wouldnt be able to spam so easily on the site? I have removed quite a few of the languages because of this possibility. What does everyone else think of this?

I dont see how this MOD would make any difference.

[jaryx]

Did you follow the instructions exact, the flags are not on you pages and the translate.php code is not being called at all.

I know. I tried early previus version and reslts its same like now.

Now code is added and... Error coding content

I load page when plugin is disabled and I see site and flags.

If a click on flag (plugin enabled) a see results of page http://fifa.pes.com.pl/index.php?hl=de :
Warning: set_time_limit() has been disabled for security reasons in [path]/translate.php on line 27

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/tmp:/var/tmp:/var/lib/php:/var/lib/php-pkg/dev-lang/php-5.2.5/:/usr/lib64/php5:/usr/share/pear:/usr/share/php:/usr/share/php5:/usr/share/php5/Zend/:[path]) in [path]/translate.php on line 60

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/translate.php on line 148

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/tmp:/var/tmp:/var/lib/php:/var/lib/php-pkg/dev-lang/php-5.2.5/:/usr/lib64/php5:/usr/share/pear:/usr/share/php:/usr/share/php5:/usr/share/php5/Zend/:[path]) in [path]/translate.php on line 60

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/translate.php on line 148

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/tmp:/var/tmp:/var/lib/php:/var/lib/php-pkg/dev-lang/php-5.2.5/:/usr/lib64/php5:/usr/share/pear:/usr/share/php:/usr/share/php5:/usr/share/php5/Zend/:[path]) in [path]/translate.php on line 60

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/translate.php on line 148

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/tmp:/var/tmp:/var/lib/php:/var/lib/php-pkg/dev-lang/php-5.2.5/:/usr/lib64/php5:/usr/share/pear:/usr/share/php:/usr/share/php5:/usr/share/php5/Zend/:[path]) in [path]/translate.php on line 60

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/translate.php on line 148

[Dave Hybrid]

I know. I tried early previus version and reslts its same like now.

Now code is added and... Error coding content

I load page when plugin is disabled and I see site and flags.

If a click on flag a see results of page http://fifa.pes.com.pl/index.php?hl=de :
Warning: set_time_limit() has been disabled for security reasons in [path]/translate.php on line 27

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/tmp:/var/tmp:/var/lib/php:/var/lib/php-pkg/dev-lang/php-5.2.5/:/usr/lib64/php5:/usr/share/pear:/usr/share/php:/usr/share/php5:/usr/share/php5/Zend/:[path]) in [path]/translate.php on line 60

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/translate.php on line 148

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/tmp:/var/tmp:/var/lib/php:/var/lib/php-pkg/dev-lang/php-5.2.5/:/usr/lib64/php5:/usr/share/pear:/usr/share/php:/usr/share/php5:/usr/share/php5/Zend/:[path]) in [path]/translate.php on line 60

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/translate.php on line 148

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/tmp:/var/tmp:/var/lib/php:/var/lib/php-pkg/dev-lang/php-5.2.5/:/usr/lib64/php5:/usr/share/pear:/usr/share/php:/usr/share/php5:/usr/share/php5/Zend/:[path]) in [path]/translate.php on line 60

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/translate.php on line 148

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/proc/loadavg) is not within the allowed path(s): (/tmp:/var/tmp:/var/lib/php:/var/lib/php-pkg/dev-lang/php-5.2.5/:/usr/lib64/php5:/usr/share/pear:/usr/share/php:/usr/share/php5:/usr/share/php5/Zend/:[path]) in [path]/translate.php on line 60

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/translate.php on line 148


open_basedir restriction in effect error

you need to ask you host to fix that.

[GamerPerfection]

Do you think this mod would attract foreign spammers who otherwise wouldnt be able to spam so easily on the site? I have removed quite a few of the languages because of this possibility. What does everyone else think of this?

No.

[nascimbeni]

Well ... if I get it to work I think I will disable a few flags like the China one to avoid spammers from China ( they seem to like my website ) -

[Dave Hybrid]

Spammers target the majority. As most forums are in English spammers target that, maybe you should stop posting in English?

[Dave Hybrid]

For people getting the compression error in the browser my coder says this is due to a plugin that is conflicting with the script. You can try disabling any other plugins to troubleshoot if you want.

This page can not be displayed, because it uses incorrect or unsupported compression methods.

[SuperTaz]

Works good with new files.

[chris1979]

This is a great idea. I have a similar thing on my wordpress blog and it is excellent for bringing in extra traffic.

I have a problem with my installation though. As soon as I created the plug in, my site crashed. I just got a blank white page when I went to the site.

I've disabled the plugin for now but I'm very keen to make it work.

Can you help?

This is the plugin code I am referring to:

require_once("translate.php");
// Enable UTF-8 characters
if(isset($_GET['hl']))
{
header ('Content-type: text/html; charset=utf-8');
}
// Keep remainders of <style and <script tags!
$time = time(); // Unique Tag Identifier!
preg_match_all('|<script[^>]*>(.*?)</script>|si', $output,$scripttags, PREG_SET_ORDER);
for($i=0;$i<count($scripttags);$i++)
{
$output = str_replace($scripttags[$i][0], "<a name=\"$i\"></a>",$output);
}
//preg_match_all("<style[^>]*>.*</style>",$buffer,$styletags);
preg_match_all('|<style[^>]*>(.*?)</style>|si',$output,$styletags);
for($i=0;$i<count($styletags);$i++)
{
$output = str_replace($styletags[1][$i], "<a name=\"s$i\"></a>",$output);
}

$output=callback($output);

// Place back remainders of <style and <script tags!
for($i=0;$i<count($styletags);$i++)
{
$output = str_replace("<a name=\"s$i\"></a>", $styletags[1][$i], $output);
}
for($i=0;$i<count($scripttags);$i++)
{
$output = str_replace("<a name=\"$i\"></a>",$scripttags[$i][0] ,$output);
}
//print_r($scripttags);
//die("c:".count($scripttags).":".count($styletags));

(I am using vb 3.8.)

[merkaz]

Thanks Dave ..

It's really amazing hack ..

I installed it yesterday .. the page load but without the text ..

I see the database growing up now it's 9.5 MB with 118,279 records ...

http://www.alhnuf.com/18.html?hl=en

What i can do ?

[burlesque]

This is a great idea. I have a similar thing on my wordpress blog and it is excellent for bringing in extra traffic.

I have a problem with my installation though. As soon as I created the plug in, my site crashed. I just got a blank white page when I went to the site.

I've disabled the plugin for now but I'm very keen to make it work.

Can you help?


This is exactly the problem that I am having. I'm using vbSEO and 3.8.2.

[Dave Hybrid]

This is a great idea. I have a similar thing on my wordpress blog and it is excellent for bringing in extra traffic.

I have a problem with my installation though. As soon as I created the plug in, my site crashed. I just got a blank white page when I went to the site.

I've disabled the plugin for now but I'm very keen to make it work.

Can you help?

This is the plugin code I am referring to:

require_once("translate.php");
// Enable UTF-8 characters
if(isset($_GET['hl']))
{
header ('Content-type: text/html; charset=utf-8');
}
// Keep remainders of <style and <script tags!
$time = time(); // Unique Tag Identifier!
preg_match_all('|<script[^>]*>(.*?)</script>|si', $output,$scripttags, PREG_SET_ORDER);
for($i=0;$i<count($scripttags);$i++)
{
$output = str_replace($scripttags[$i][0], "<a name=\"$i\"></a>",$output);
}
//preg_match_all("<style[^>]*>.*</style>",$buffer,$styletags);
preg_match_all('|<style[^>]*>(.*?)</style>|si',$output,$styletags);
for($i=0;$i<count($styletags);$i++)
{
$output = str_replace($styletags[1][$i], "<a name=\"s$i\"></a>",$output);
}

$output=callback($output);

// Place back remainders of <style and <script tags!
for($i=0;$i<count($styletags);$i++)
{
$output = str_replace("<a name=\"s$i\"></a>", $styletags[1][$i], $output);
}
for($i=0;$i<count($scripttags);$i++)
{
$output = str_replace("<a name=\"$i\"></a>",$scripttags[$i][0] ,$output);
}
//print_r($scripttags);
//die("c:".count($scripttags).":".count($styletags));

(I am using vb 3.8.)

You uploaded all the files too?

[Dave Hybrid]

This product might conflict with other plugins, i suggest you disable other products and enable them one by one to troubleshoot. That is all I can offer really unless you have a installation error. This works just fine an a vanilla vB install.

[chris1979]

I've disabled all the other products as a test and it still creates a blank page, even with no products enabled.

Any ideas what can cause that? It seems like a few others are getting the same thing.

I use branding free versions of vb and vbseo - could that be relevant?

[burlesque]

I've disabled all the other products as a test and it still creates a blank page, even with no products enabled.

Any ideas what can cause that? It seems like a few others are getting the same thing.

I use branding free versions of vb and vbseo - could that be relevant?

I have done this too and am also receiving the white page of doom. :(

Like Chris, I am using branding free vbSEO, but my vbulletin still shows the branding.

[Dave Hybrid]

I can only support install issues, I do not have the time or manpower to customize the script to suit the minority it doesn't work for. If you are 100% you installed it correct I suggest you seek the advice of a php coder to see where the issue lies.

[Geraldm]

Hi,

I have just moved my forum to a VPS host. But now when trying to click on a flag I get the following errors:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/translate.php on line 148

I am using v1.7 of your script.

Any suggestions?

[Dave Hybrid]

Hi,

I have just moved my forum to a VPS host. But now when trying to click on a flag I get the following errors:



I am using v1.7 of your script.

Any suggestions?

http://www.google.co.uk/search?q=mysql_fetch_array()%3A+supplied+argument+ is+not+a+valid+MySQL+result+resource+in&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a

[Geraldm]

http://www.google.co.uk/search?q=mysql_fetch_array()%3A+supplied+argument+ is+not+a+valid+MySQL+result+resource+in&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a

ohhh ignore me ..... forgot to import the wt_cache table to the new database!! :rolleyes:
All working now ... faster than before and without any 2006 mysql errors!! :cool:

[Dave Hybrid]

Yay! 99% of these issues are because of not following the install properly.

I'm glad it's working.

[Dave Hybrid]

ohhh ignore me ..... forgot to import the wt_cache table to the new database!! :rolleyes:
All working now ... faster than before and without any 2006 mysql errors!! :cool:

Could you also PM your URL? We are trying to gather info on how it performs on others sites/servers. You'd really be helping further the product.

[Dave Hybrid]

ohhh ignore me ..... forgot to import the wt_cache table to the new database!! :rolleyes:
All working now ... faster than before and without any 2006 mysql errors!! :cool:

Oh, also, you set the new DB type to InnoDB? Just checking...

[chris1979]

I can only support install issues, I do not have the time or manpower to customize the script to suit the minority it doesn't work for. If you are 100% you installed it correct I suggest you seek the advice of a php coder to see where the issue lies.

It's ok if you don't want to help - it's a free mod so no reason you should help - but this is an install issue. The instructions you gave don't work for several people here and actually the instructions you gave have crashed our site to a blank white screen. It's probably something to do with the vbseo code. Maybe you'll take a look when you have time.

[Dave Hybrid]

It's ok if you don't want to help - it's a free mod so no reason you should help - but this is an install issue. The instructions you gave don't work for several people here and actually the instructions you gave have crashed our site to a blank white screen. It's probably something to do with the vbseo code. Maybe you'll take a look when you have time.

No, it is not an install issue if you followed the instructions perfect, they work for 99% of others, it's a conflict, which I cannot recode for one or two people.

If you have a blank screen uninstall the script, you can disable plugins in config.php if you cannot access the site.

[bhanuprasad1981]

i am using litespeed web server and vbseo , i did all , if i click image of language file it work good if i click any link on translated page its back to english :(

[Geraldm]

Oh, also, you set the new DB type to InnoDB? Just checking...

The DB type is currently set to MyISAM .. I have not changed it to InnoDB yet ... I'll wait until Monday when I get more users on my site so I can test between the two DB types with some server load.

Cheers ...
Gerald.

[Dave Hybrid]

The DB type is currently set to MyISAM .. I have not changed it to InnoDB yet ... I'll wait until Monday when I get more users on my site so I can test between the two DB types with some server load.

Cheers ...
Gerald.

Trust me InnoDB is what you want, MyISSAM doesnt like constant write access to the db and locks tables, you should start a new InnoDB database.

[Dave Hybrid]

i am using litespeed web server and vbseo , i did all , if i click image of language file it work good if i click any link on translated page its back to english :(

This is normal. This mod creates pages in other languages for bots and thus search traffic, nothing else.

[vividbreeze]

Lets say the entire forum is english. Someone finds the site in spanish, so they register, and then post in their own language. Still on the main forum, will it show up as spanish or english on the american side?
And will the registration form be in spanish too?

[vividbreeze]

id also like to pay you a donation to remove the linkback. :)

[Bounce]

Dave,

Just installed so the database is empty, now when I click on a flag it loads but then I get the sql error.

UPDATE session
SET lastactivity = 1245602157, location = '/forum/?hl=nl', inforum = 0, inthread = 0, incalendar = 0, badlocation = 0, useragent = 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.9.0.11) Gecko/2009060215 Firefox/3.0.11 (.NET CLR 3.5.30729)'
WHERE sessionhash = '798f2cab09a90c3aed27bcc7d47f217f';

MySQL Error : MySQL server has gone away
Error Number : 2006

I'm presuming this is normal as it will need to input all the data into the DB ?

Great hack as we have a lot of non english users on our forums :)

[bhanuprasad1981]

This is normal. This mod creates pages in other languages for bots and thus search traffic, nothing else.


sorry i didn't get you but why will bot click on each flag ?

let me explain i open a page it is english , now i have to click "x" language to see it in action now when i see another thread it is back in english , maybe i am missing some thing ?

[Sweeks]

sorry i didn't get you but why will bot click on each flag ?

let me explain i open a page it is english , now i have to click "x" language to see it in action now when i see another thread it is back in english , maybe i am missing some thing ?

It translates only the current page when clicked and the SE's will follow each of these flag links on every pag thus giving lots of copies of the same page in lots of different languages which is unique content driving traffic from other countries to your site :)

[vktechnology]

very good mode
thank you for making this mode

I voted mode of the Month.

[vktechnology]

When i click translat flag I have go this error

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/translate.php on line 148

[Kottonmouth801]

I VOTED MOD OF THE MONTH :up::up:

Thank You for this wonderful modification. :D

:up::up:

[Kottonmouth801]

When i click translat flag I have go this error

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/translate.php on line 148

Looks like paths to data are wrong ?

"BUT I COULD BE WRONG"

[vktechnology]

Looks like paths to data are wrong ?

"BUT I COULD BE WRONG"

it work now
becuase i didn;t setup database correctly

when translation store in database it load fast.

[vktechnology]

it would be good if can set in cron translate all threads for all language at night and store in database
When people click it will load faster don't have to wait too long from google server
or it load fast for search engine.

[valendono]

I got this on firefox .. any clue ?

Content Encoding Error

The page you are trying to view cannot be shown because it uses an invalid or unsupported form of compression.

[vktechnology]

Does google rerally crawl vB Global Translator URL ?
i checked for few sites i didnt see google crawl it

[Dave Hybrid]

Lets say the entire forum is english. Someone finds the site in spanish, so they register, and then post in their own language. Still on the main forum, will it show up as spanish or english on the american side?
And will the registration form be in spanish too?

They can't, they have to register and post in your base language.

[Dave Hybrid]

id also like to pay you a donation to remove the linkback. :)

Right now this is not available.

[Dave Hybrid]

Dave,

Just installed so the database is empty, now when I click on a flag it loads but then I get the sql error.



I'm presuming this is normal as it will need to input all the data into the DB ?

Great hack as we have a lot of non english users on our forums :)

Some sites throw an error from time to time when large pages get translated and are a bit slow. I ignore them. They will stop/slow down as your site gets cached.

[Dave Hybrid]

it would be good if can set in cron translate all threads for all language at night and store in database
When people click it will load faster don't have to wait too long from google server
or it load fast for search engine.

The search bots crawl them and translate them, so there is no need!

[Dave Hybrid]

Does google rerally crawl vB Global Translator URL ?
i checked for few sites i didnt see google crawl it

It crawls and indexes them just fine. I wouldn't say it did if I hadn't fully tested it.

[vividbreeze]

They can't, they have to register and post in your base language.

Ah, would there be a way to do this at all?

If not, I have a forum that is 95% english and then also a Spanish section, will this skrew anything up?

[Dave Hybrid]

Use if conditions and exclude the flags from showing on non english pages.

[jaryx]

open_basedir restriction in effect error

you need to ask you host to fix that.

I've got answer from my host:
set_time_limit - it's only warning - but that unfortunately we can not
unlock ...
In contrast, open_basedir is set out by the safety recommendations - and completely
should be sufficient to operate each function.

We can modify it a bit but in this case, the script tries to access the
/ proc / loadavg - and to the / proc powers we can not give - what is the
attempt to reach an explanation of this file?

And what can I do? :confused:

[Bounce]

Some sites throw an error from time to time when large pages get translated and are a bit slow. I ignore them. They will stop/slow down as your site gets cached.

Any idea how long this will take ? Threads: 35,170 | Posts: 632,397

[t3nt3tion]

Nice script. Although I can see how it`s generating alot of MySQL usage.
After a page loads in a certain language and you use cache, it will search for the text in the new database, which, when searching for text without full text search enable, it will put pressure weather you like it or not.
Alternatives can be adopted though ...

[Nytol]

Does it have to be InnoDB? :confused: I don't see it on my DB list. Was wondering if I could pick another option.

[Dave Hybrid]

I've got answer from my host:


And what can I do? :confused:

Get a better host, seriously.

[Dave Hybrid]

Does it have to be InnoDB? :confused: I don't see it on my DB list. Was wondering if I could pick another option.

Yes, or it will be slower, your host can enable it.

[Dave Hybrid]

Nice script. Although I can see how it`s generating alot of MySQL usage.
After a page loads in a certain language and you use cache, it will search for the text in the new database, which, when searching for text without full text search enable, it will put pressure weather you like it or not.
Alternatives can be adopted though ...

I'd love to hear suggestions...