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
  #572  
Old 08-03-2009, 04:59 AM
imported_silkroad imported_silkroad is offline
 
Join Date: Dec 2003
Posts: 563
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by bollie View Post
Wen i use Save the plugin and activate.
When you post lines of code errors, it is a bit "meaningless" if you don't also post the exact version of vB you are running, etc.

You are posting an "error" from a function outside of this mod. What is the calling function?
Reply With Quote
  #573  
Old 08-03-2009, 07:02 AM
matthewhotdude matthewhotdude is offline
 
Join Date: Jul 2009
Posts: 560
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'm at this part now

Code:
You need to comment out the flag for your base language otherwise you can cause duplicate URLs for those pages and this can be bad for SEO.

All the flags are on separate lines in alpha order, find your language and add <!-- to the start and --> to the end of the line.

eg; <!-- language flag code -->

Could someone past what this line is supposed too look like after the edit

Code:
. 'hl=en' : str_replace($xbit.'hl='.@$_GET['hl'], '', $_SERVER["REQUEST_URI"]) . $xbit . "hl=en"; ?>"><img src="/flags/United States.gif" alt="English" border="0" /></a>
Reply With Quote
  #574  
Old 08-03-2009, 07:10 AM
imported_silkroad imported_silkroad is offline
 
Join Date: Dec 2003
Posts: 563
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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

OBTW: Is the duplicate entry in the sitemap error by Google still unresolved?
Reply With Quote
  #576  
Old 08-03-2009, 10:56 AM
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 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.
There is no any slow query There is no any joins. Each query takes data only from 1 table. Each select takes indexed data, so answer is immediate Learn more about DB
Reply With Quote
  #577  
Old 08-03-2009, 11:03 AM
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 wolfstream View Post
rly 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.
You now such word as: hypocrite? Did you even look ad this mod DB structure? Did you even look at this mod SQL queries?

As I wrote - there is no any slow query. Queries are instant, cause each data in where cause is indexed and data is taken without any joins. This is fastest kind of queries in any DB engine

So take advice of your own and:
Stop trying to blame things which you know nothing of

Reply With Quote
  #578  
Old 08-03-2009, 11:05 AM
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
Wen i use Save the plugin and activate.
Make sure you copied all plugin content and you set appropriate hook.
Reply With Quote
  #579  
Old 08-03-2009, 11:09 AM
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 matthewhotdude View Post
I'm at this part now

Code:
You need to comment out the flag for your base language otherwise you can cause duplicate URLs for those pages and this can be bad for SEO.

All the flags are on separate lines in alpha order, find your language and add <!-- to the start and --> to the end of the line.

eg; <!-- language flag code -->

Could someone past what this line is supposed too look like after the edit

Code:
. 'hl=en' : str_replace($xbit.'hl='.@$_GET['hl'], '', $_SERVER["REQUEST_URI"]) . $xbit . "hl=en"; ?>"><img src="/flags/United States.gif" alt="English" border="0" /></a>
Coment the line:
Code:
<!--
EVERYTHING BETWEEN THOSE IS COMMENTED
-->
Reply With Quote
  #580  
Old 08-03-2009, 11:11 AM
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 imported_silkroad View Post
OBTW: Is the duplicate entry in the sitemap error by Google still unresolved?
Still have no idea As I wrote sitemap is not generated by this mod, but by vbSEO Sitemap Generator, so question should be for their staff. I don't care enough to ask them
Reply With Quote
  #581  
Old 08-03-2009, 11:12 AM
wolfstream wolfstream is offline
 
Join Date: Jan 2003
Location: Iowa
Posts: 382
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Wow, you really are clueless, aren't you?
Debugging PROVES that this mod caused the slow queries.

Previous to your mod:
Forum has 1-5 queries constantly running through mysql. Yeah, that's all, just 1-5, and that's normal and natural

Your mod installed:
Within 24 hours of having your mod installed, that 1-5 queries ran up to 50+, ALL with excessive time .

AFTER your mod removed
Forum has 1-5 queries constantly running through mysql. Yeah, that's all, just 1-5, and that's normal and natural


Don't even start with me and "that which you do not know". I develop and debug php/sql software for a living, it's what I do. I know full well how to develop, test, and work with software. In this case, the cause of the slow queries is quite evident. Just because you don't want to admit your product has this problem doesn't mean it's not so.

This product has nothing but slow queries. 10s response times? Yeah right, try 10 minutes, IF you're lucky.
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 01:15 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.04763 seconds
  • Memory Usage 2,320KB
  • 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
  • (5)bbcode_code
  • (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