Ask your host to turn on php error message in the browser, it should output an error.

99% of install problems are because of your server config or the install wasn't followed correct, check everything thoroughly.

WHOOOO!!! I thought this was a goner :)

THANK YOU DAVE!!!! :up::up::up:

You're welcome!

Make sure you install and test it because your current setup isnt translating a thing, not sure if you are aware.

Just installed just now, yes when I click on a flag its all still in english? How is that?

No idea tbh, i can tell you've skipped parts of the install, so i would advise following the upgrade and new install instructions to the T.

Ah never deleted the old plugins and overload text, sorry was in a hurry as was all excited LOL :)

Doesn't feel right mate, see my previous post, you need to fresh install, new flags files, complete new database, everything, delete everything, start fresh and do not skip parts and it will work much better.

LOL, ok. :)

A small note to the flags.
English language (EN) is... english from England, not the U.S.
When Sir Thomas Wyatt wrote his poems, then the Americans running the prairie for the bizons. ;)

ps.
My english is bad english, but english. ;)

Ok, well, en code is the only one Google Translate offers. I used US flag as there are more US Internet users than UK. Trying to cater for the larger audience lol. :)

I still does not no, right off to delete it all and start again closely following the instructions, I'm a bit confused (not hard LOL) by this...

Dumb that I am I presume I don't change that as my forums english?

BE right back LOL :)

thank you :up: installed so far no issue to report.

Looks great on your site and very fast, nice one!

Can't I drop the tables in the DB or it needs to be brand new ?

Brand new dude. Everything is new. All files, all code, database format and tables. Fresh install it.

testing this on a different site on a different server i am getting this error when i click the flags:

Fatal error: Call to undefined function mysql_set_charset() in /home/SITE/public_html/forum/translate.php on line 35

thanks


on this instruction


I want to make sure that i follow you so it should be like this

There.

It will stop that flag showing, so it should disappear.

wt_cache_medium
wt_cache_short

these 2 tables on the db have lines in it now. the short has 20 and the medium has 3. but the text still isnt converting over to other languages. this is on the site i sent u on the PM.

the other error i am having is on another site different server

gotcha thanks :up:

Wrong version of PHP. From manual about mysql_set_charset() This function requires MySQL 5.0.7 or later

arghhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh lol :D

I've installed this (I THINK) as per the instructions, even created new database and sql user for it, on clicking a flag I get

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

then the database error,

Must have fooked up the install somewhere but fooked if I can figure out where LOL

No data is being "written" into the database either, LOL the joys

For the first translation of some page to some language you have to be very patient. A lot of things to translate by google... And It is not possible to skip this time - it have to be translated. But after that having this page translated again to this language if very fast, because google isn’t asked for that anymore - just taken from DB.

Give it a chance and just wait till page is translated.

On line 148 there is no mysql_fetch_array() call - probably you have old version. Please update it :)

your issue is right here brotha
timing out issue ...i clocked my to 60 second before it translate then after that it's quick

Some large pages can take a few minutes, test it on pages will low text. It's not a big deal as the search bots will hit large pages a few times to translate them in the background. Next time the load from cache and are fast.

One more question i have a friend that is from Germany.The only thing he noticed that for each page you have to click on the flag.Is that how it works?

Yep, that is correct.

thanks, think I did doh lol

weird now i'm getting the error..

but its translating the pages ....

http://www.hibeesbounce.com/forum/sh...?t=86933&hl=ja

Is it just a case of waiting or have I got something else wrong lol

yea I did LOL

$dbusername = "bdname";
$dbpassword = "me";
$mysqlserver = "localhost"; > had this as the db name pmsl :)
$dbname = "dbname";

THAT link now translates :):)

Still get myqsl server has gone away on forumhome thou, patience needed?

PHP Version 5.1.4


??

Double check your MySQL data you entered is correct ;)

how long are we to wait for the site to be translated? a few hours went by and nothing happend so far.

http://us3.php.net/manual/en/functio...et-charset.php

I know that first question can look silly, but have to be sure - no other ideas :p
- Are you sure you check PHP version on server where script is intalled?
- Are you sure php was properly installed? In PHP 5+ MySQL is not enabled by default (In order to have these functions available, you must compile PHP with MySQL support - http://us3.php.net/manual/en/mysql.requirements.php) If not here you have PHP installation instructions: http://us3.php.net/manual/en/mysql.installation.php

Definitively not that long ;) 30 seconds, maybe 1minute if there is lot of text or lot of short words (i.e. tag cloud). On my forum I sometimes have such behavior that it translates, and translates, and... And after reload it is already translated. I assume that those are some browser sever issues because of long download time, and after reload it is already cached and goes fast.

So if reload gives you also nothing and you see that number of rows in cache tables is same - definitively it's something wrong. Need more info to be able to say what... some error logs?

nlp - only 2 tables are doing "something" on 1 of the sites. the medium and short tables are writing something in there. the cache isnt writing anything....what could be causing the cache not to write?

those tables are to separate short, medium and long translations. Most forums have lot of short translations, then some medium and sometimes long. So it is ok.

I just wrote my own spider which goes to every page generated by vbSEO sitemap generator (must done little change in their code to automatically add all translations to sitemap) and also add rest languages available in google (over 40).

Now I have in sitemap 56 000 addresses. Spider will work for long time, and I will give you all some image about DB cache size.

Right now it just started only 100 pages done (not counting those which was clicked by users or other spiders), but it will already give you some proportions (keep in mind that I have over 40 languages not 28).

wt_cache_short 70 000 entries
wt_cache_medium 11 000 entries
wt_cache 5 000 entries

So it is ok that your wt_cache don't have to mutch data.

Also you can heck does wt_cache was appropriately created during installation. You need MySQL 5.0.3 or higher to be able to have it works, because I used varchar(65000) and in previous mysql versions varchar could have max size 255. If you have lower version - you can still use it. Just change VARCHAR(65000) to TEXT for column oryginalText drop table and create again from changed code.

When I finish my spidering ;) I will made some automatic performance tests. Also change some other solutions (different indexes sizes, other order of filtering in SQL WHERE clause...). So it is possible that it will be even faster :)

Also good news is that when my spider makes translations all the time it doesn't affects speed of normal site generation (all lags are because of google translation server). So you can be calm - even if you wait long time for translation other users don’t feel it at all being on forum :)

i dont need to worrie about this part if im using english correct?
thx.

if i do have to worry about this step, can i ask the code i have to put around this line plz???

if im completely not making sense please explain thanks m8.

I just use Googlebot lol, I have 500,000 total entrys after 24hrs. :eek:

Also no slow down at all, pages still fast as usual. DB size is 100MB so far.

Well I am still getting the database errors I quoted from the previous version, however the database is being populated and I actually finally got a page to show up in another language.

I will let this run for a bit now and see if I get more translated pages. Great job with this mod :)