vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Major Additions - vB Enterprise Translator (https://vborg.vbsupport.ru/showthread.php?t=232456)

NLP-er 04-12-2010 11:16 AM

Quote:

Originally Posted by motorola (Post 2019836)
Today I got a lot of database errors like this below. What happens ?

Database error in vBulletin 4.0.3:

Invalid SQL:
SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbenterprisetranslator_cache_short help, vbenterprisetranslator_cache_short cache WHERE help.originaltext='Old+forum%2Carchive+sections%21 ' AND help.tl='cy' AND cache.serie=help.serie;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Monday, April 12th 2010 @ 09:47:58 AM
Error Date : Monday, April 12th 2010 @ 09:55:46 AM
Script : http://www.mydomain.com/forum/forumd...ve&language=cy
Referrer :
IP Address : 67.195.115.116
Username : Unregistered
Classname : vB_Database
MySQL Version :

Google was responding slow with translations so mysql connection timed out. Just increase your timeout for mysql connection - this is official vBulletin solution for 'MySQL server has gone away' issue.

motorola 04-12-2010 01:33 PM

Quote:

Originally Posted by NLP-er (Post 2019881)
Google was responding slow with translations so mysql connection timed out. Just increase your timeout for mysql connection - this is official vBulletin solution for 'MySQL server has gone away' issue.


and how can I do that ?

Noerenberg 04-12-2010 08:27 PM

Quote:

Originally Posted by NLP-er (Post 2017891)
Please turn on option to nod transalte usernames. Please note that this option works in specific places - there still can be some places where usernames are translated. In such case please describe specifically where it happens. Also - you cannot use mods which are clearing HTML comments - otherwise usernames will be translated, because mark about not translating it will be removed.

I turn it ot, but the username are translate.

mikeinjersey 04-17-2010 06:35 PM

I'm interested in this.

For the people that have this installed already, Has it increased traffic for ya ? If so, how much ? And how long did it take ?

I'm visually it must be weird having people from other countries signing up. The spelling must be hard to interpret at times. (even though its still converted over for us)

thx much

motorola 04-19-2010 11:18 AM

Quote:

Originally Posted by motorola (Post 2019932)
and how can I do that ?

Someone an answere :( .
Please !
Thanks :)

mikeinjersey 04-19-2010 02:31 PM

Quote:

Originally Posted by motorola (Post 2023714)
Someone an answere :( .
Please !
Thanks :)


Here's the technical reference -

http://dev.mysql.com/doc/refman/5.1/en/gone-away.html

But i'm sure if you google "increase time out mysql" , you'll find a more basic solution.

Jesh 04-19-2010 02:55 PM

Quote:

Originally Posted by NLP-er (Post 1949580)
Integration instructions:
You just have to edit one file: vbseo_sitemap_functions.php in vbseo_sitemap directory.

Find:
PHP Code:

vbseo_log_entry("[showthread] forum_id: $forumid, thread_id: $threadrow[threadid], total posts: $totalposts, pages: $totalpages, views: $threadrow[views] $prior"); 

And place AFTER it...

For SEO links
PHP Code:

//additional code 
$alanguages = array ('af','sq','ar','be','bg','ca','zh-CN','hr','cs','da','nl','en','pl','et','tl','fi','fr','gl','de','el','iw','hi','hu','is','id','ga','it','ja','ko','lv','lt','mk','ms','mt','no','fa','pt','ro','ru','sr','sk','sl','es','sw','sv','zh-TW','th','tr','uk','vi','cy','yi'); 
if(!
$archived) { 
  
$strlenhost strlen($vbseo_vars['bburl']."/"); 
  
$currentthreadurl vbseo_url_thread($threadrow1$archived);
  
$currentthreadurl_before substr($currentthreadurl,0,$strlenhost);
  
$currentthreadurl_after "/".substr($currentthreadurl,$strlenhost);
  
$lastpost =& $threadrow['lastpost'];
  
$vbseo_stat['t'] += sizeof($alanguages);
  foreach(
$alanguages as $language) { 
    
vbseo_add_url($currentthreadurl_before.$language.$currentthreadurl_after$prior$lastpost$freq); 
  } 
}   
//end additional code 

NOTE: REMOVE YOUR DEFAULT LANGUAGE CODE from $alanguages
Also if you disabled some languages in option panel you have to delete its codes too.

For links with language=
PHP Code:

//additional code
$alanguages = array ('af','sq','ar','be','bg','ca','zh-CN','hr','cs','da','nl','en','pl','et','tl','fi','fr','gl','de','el','iw','hi','hu','is','id','ga','it','ja','ko','lv','lt','mk','ms','mt','no','fa','pt','ro','ru','sr','sk','sl','es','sw','sv','zh-TW','th','tr','uk','vi','cy','yi');
if(!
$archived) {
  
$currentthreadurl vbseo_url_thread($threadrow1$archived) . '&language=';
  
$vbseo_stat['t'] += sizeof($alanguages);
  
$lastpost =& $threadrow['lastpost'];
  foreach(
$alanguages as $language) {
    
vbseo_add_url($currentthreadurl.$language$prior$lastpost$freq);
  } 
}  
//end additional code 

NOTE: REMOVE YOUR DEFAULT LANGUAGE CODE from $alanguages
Also if you disabled some languages in option panel you have to delete its codes too.

NOTE FOR SITEMAP INTEGRATION:
If you want to add to sitemap also links for other thread pages (if thread have several pages), then additional code must be added BEFORE:
PHP Code:

$vbseo_stat[$archived?'at':'t'] += vbseo_add_2urls

Also in additional code you have to change 1 to $p.


Piece of cake :)

Do I have to do BOTH or just one? Meaning, do I add additional code before $vbseo_stat AND also before "vbseo_log_entry..."? Or do I only do additional code 1x?

Jesh 04-19-2010 04:01 PM

Also, has anyone managed to get this implemented with photopost gallery?

NLP-er 04-23-2010 08:01 PM

Quote:

Originally Posted by motorola (Post 2019932)
and how can I do that ?

Just Google ;) MySQL manual about this issue:
http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

NLP-er 04-23-2010 08:04 PM

Quote:

Originally Posted by Noerenberg (Post 2020134)
I turn it ot, but the username are translate.

Make sure that you are not using any mod which removes html comments. If you do, then this is a reason...
Also vBET do not translate usernames in specific places (as I remember those are described in parameter description), so in other place those still will be translated. You can write me in which places exactly usernames are still translated and I will work on it for future version.


All times are GMT. The time now is 03:23 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01565 seconds
  • Memory Usage 1,784KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_php_printable
  • (8)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete