just after it. Of course have to change NOT_TRANSLATED_TEXT to somesthing real. Dave is working on making it product right now, so hope it will be configurable soon
Still making fun with cache by improving it so get new issue here
During spidering my site I realized, that sometimes google translation returns just empty result. And right now those empty results are included in cache, so If once filled - used forever...
To avoid this you must do 3 things.
1. Made change described under link - approptiate handling of non breaking spaces (not sure does necessary but I'm already working on correted code, and it works this way) https://vborg.vbsupport.ru/showpost....&postcount=189
2. In translate.php change:
Code:
/* Save to cache */
if ($enablecache) {
to:
Code:
/* Save to cache */
if ($enablecache && (strlen($ttext)>0)) {
So even if ocassionally google will joke with you, you will not cache it and just ask again during next page generation hoping this time result will be included and cached
Dave - it would be good to include it in new release
3. get rid of already cached dummy content by executing those queries:
Code:
delete from wt_cache where translated='' or translated is null;
delete from wt_cache_medium where translated='' or translated is null;
delete from wt_cache_short where translated='' or translated is null;
Note that I'm still working improving cache so future changes are possible Who don't like to mess in code - just wait till Dave made new official release with changes included For others - installing this will give me feedback about possible issues which I don't have on my forum.
Also - Dave I noted you was asking to wrote changes proposals as PM - I prefere this way because I have a chance that someone will use it and maybe discover some additional issues before official release.
the 2 tables medium and short are increasing, but nothing is in the translated fields of the tables....its just empty on my end. the site isnt translating. ill be uninstalling this i guess untill a later date.
Upload the new translate.php and run the following MySQL query on your DB.
Code:
delete from wt_cache where translated='' or translated is null;
delete from wt_cache_medium where translated='' or translated is null;
delete from wt_cache_short where translated='' or translated is null;
Still making fun with cache by improving it so get new issue here
.......................................
Thanks for the DB update again, this one seems to improve speed even further and data size reduced, thanks a bunch! :up:
I'm still trying to sort the few remaining DB errors, it's a PITA to fix, I can get rid of them but the DB has to be opened and closed twice to avoid timeout so it makes everything slow... Grrrr. Ha. I'll keep trying.
the 2 tables medium and short are increasing, but nothing is in the translated fields of the tables....its just empty on my end. the site isnt translating. ill be uninstalling this i guess untill a later date.
This maybe becuase :
Firewall blocked google IP .
Curl functions disable on " disable_functions " On PHP ..
This functions must be enabled : curl_exec and curl_init