Go Back   vb.org Archive > vBulletin Modifications > Archive > Modification Graveyard
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
vB Global Translator - Multiply your indexed pages & put search traffic on autopilot Details »»
vB Global Translator - Multiply your indexed pages & put search traffic on autopilot
Version: 2.4, by Dave Hybrid Dave Hybrid is offline
Developer Last Online: Dec 2013 Show Printable Version Email this Page

Category: Miscellaneous Hacks - Version: 3.8.x Rating:
Released: 06-27-2009 Last Update: 07-07-2009 Installs: 67
Uses Plugins Template Edits
Additional Files  
No support by the author.

**Text Removed**

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #562  
Old 08-02-2009, 05:54 PM
wolfstream wolfstream is offline
 
Join Date: Jan 2003
Location: Iowa
Posts: 382
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

WAYYYY too many slow SQL queries, killing SQL server.

uninstalled
Reply With Quote
  #563  
Old 08-02-2009, 09:02 PM
NLP-er's Avatar
NLP-er NLP-er is offline
 
Join Date: Aug 2008
Location: Wrocław
Posts: 1,353
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by bollie View Post
I have eror

Parse error: syntax error, unexpected $end in /home/xxxxxxxx/public_html/includes/functions.php(5721) : eval()'d code on line 59
When this error happens?
Reply With Quote
  #564  
Old 08-02-2009, 09:25 PM
cyc cyc is offline
 
Join Date: Nov 2002
Posts: 48
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by wolfstream View Post
WAYYYY too many slow SQL queries, killing SQL server.

uninstalled
Once pages are cached, users shouldn't notice much difference in load times.

Was your mysql server getting killed once you installed this on the forum linked to in your sig?
Reply With Quote
  #565  
Old 08-02-2009, 09:36 PM
wolfstream wolfstream is offline
 
Join Date: Jan 2003
Location: Iowa
Posts: 382
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It doesn't matter at this point, I have no intention of reinstalling this mod.
Your mod caused hundreds of slow sql queries, which, of course, caused massive problems with the server.
Reply With Quote
  #566  
Old 08-02-2009, 09:42 PM
matthewhotdude matthewhotdude is offline
 
Join Date: Jul 2009
Posts: 560
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

So the SQL am i adding that to the current database that my forum uses?
Reply With Quote
  #567  
Old 08-02-2009, 10:21 PM
cyc cyc is offline
 
Join Date: Nov 2002
Posts: 48
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by wolfstream View Post
It doesn't matter at this point, I have no intention of reinstalling this mod.
Your mod caused hundreds of slow sql queries, which, of course, caused massive problems with the server.
the initial caching of a page is slow, we found 3 - 10 seconds. After that we found pages were generated almost as fast as standard pages eg; not noticeable when browsing.

You only have a hand full of posts. If it caused, as you put it "massive problems" i'd say you need to find a decent host or get a more powerful server. Maybe you could post some detail about the "massive problems" so dave or his off sider could comment?
Reply With Quote
  #568  
Old 08-02-2009, 11:59 PM
wolfstream wolfstream is offline
 
Join Date: Jan 2003
Location: Iowa
Posts: 382
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It's not the host, or the server that is causing the problem, the mod is.
Stop trying to make assumptions about that which you know nothing of.

Prior to installing this mod, the forum used 1-5 mysql processes constantly. SINCE using the mod (before removing it), the forum jumped from 1-5 mysql processes constantly to 50-70. There is no reason for this except the mod. Once the mod was disabled and removed? Back to 1-5 mysql processes.

This mod handles sql VERY poorly and causes issues. It's not the server's fault the mod is slow, it's the mod's fault. It's not the server's fault the mod handles queries slowly, it's the mod's fault. It's not the server's fault the mod takes forever to work, it's the mod's fault.

Stop trying to blame things which you know nothing of. The server wasn't under load at all, in fact, it was just fine. The mod makes entirely too many slow queries, end of story.
Reply With Quote
  #569  
Old 08-03-2009, 12:37 AM
cyc cyc is offline
 
Join Date: Nov 2002
Posts: 48
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by wolfstream View Post
It's not the host, or the server that is causing the problem, the mod is.
Stop trying to make assumptions about that which you know nothing of.
I've installed this on 3 forums so far, one has 7 million+ posts, the other 3.5million and the smallest 1.1 million. 1,500+ active user sessions are common on all of them.

MySQL usage obversely increased, there were no noticeable effects on server performance from a users POV. Average load floats between 1 and 2 on all of our servers, none of them have "massive problems".

You have 2,300 posts in the forum linked in your sig. You must be able to see why I suggested server or host maybe not up to scratch. You inital post was vauge so I went for the low fruit

The mod isn't perfect, but it does a reasonable job. It's very easy to install and once translated pages are cached, they load fast enough for a user not to notice a speed difference between translated and non-translated pages.

regards
Reply With Quote
  #570  
Old 08-03-2009, 01:42 AM
imported_silkroad imported_silkroad is offline
 
Join Date: Dec 2003
Posts: 563
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by NLP-er View Post
Do you know some automatic translation service which gives good translations?
One of our forum members has a lot of experience in this area. I will ask for his suggestions and get back to you on this.

As for Japanese, so far we have found the Yahoo translation service much better than Google's service. However, I have no idea about the API service.
Reply With Quote
  #571  
Old 08-03-2009, 04:29 AM
bollie's Avatar
bollie bollie is offline
 
Join Date: Jun 2006
Location: Zele (Belgium)
Posts: 259
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by bollie View Post
I have eror

Parse error: syntax error, unexpected $end in /home/xxxxxxxx/public_html/includes/functions.php(5721) : eval()'d code on line 59
Wen i use Save the plugin and activate.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 05:35 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.10331 seconds
  • Memory Usage 2,312KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (6)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (4)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete