vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Miscellaneous Hacks - vB Global Translator - Multiply your indexed pages & put search traffic on autopilot (https://vborg.vbsupport.ru/showthread.php?t=217329)

imported_silkroad 08-03-2009 04:59 AM

Quote:

Originally Posted by bollie (Post 1860520)
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?

matthewhotdude 08-03-2009 07:02 AM

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>

imported_silkroad 08-03-2009 07:10 AM

(Deleted by imported_silkroad)

imported_silkroad 08-03-2009 07:43 AM

OBTW: Is the duplicate entry in the sitemap error by Google still unresolved?

NLP-er 08-03-2009 10:56 AM

Quote:

Originally Posted by wolfstream (Post 1860335)
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 :)

NLP-er 08-03-2009 11:03 AM

Quote:

Originally Posted by wolfstream (Post 1860423)
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

:D

NLP-er 08-03-2009 11:05 AM

Quote:

Originally Posted by bollie (Post 1860520)
Wen i use Save the plugin and activate.

Make sure you copied all plugin content and you set appropriate hook.

NLP-er 08-03-2009 11:09 AM

Quote:

Originally Posted by matthewhotdude (Post 1860560)
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
-->

:)

NLP-er 08-03-2009 11:11 AM

Quote:

Originally Posted by imported_silkroad (Post 1860570)
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 ;)

wolfstream 08-03-2009 11:12 AM

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.


All times are GMT. The time now is 09:08 PM.

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.01429 seconds
  • Memory Usage 1,746KB
  • 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
  • (5)bbcode_code_printable
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)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