vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Error with the script and possible with the vbshout 2.0 PLEASE WE NEED HELP! (https://vborg.vbsupport.ru/showthread.php?t=161222)

lasatormentadas 10-27-2007 12:30 AM

Error with the script and possible with the vbshout 2.0 PLEASE WE NEED HELP!
 
Hello,

I?m the webmaster of the site www.atormentadas.net, we have a vbulletin forum in that hosting.

We have received an email from the server (www.siteground.com). They say there are several errors in our script, that are slowing down the server. And that they will suspend our account if we don?t fix them.

Quote:

The reasons for such slow queries can be several:

1. Large database
2. Not well written scripts
3. Large number of internal links that query the database directly.
The problem is that we don?t understand where the problems are coming from, but we have some idea, we think they come from the vshout 2.0 we have installed. The repeated error they told us is ONE of the errors they found, is this one:


Quote:

# Time: 071026 6:17:06
# User@Host: atormen1_atormen[atormen1_atormen] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 10 Rows_examined: 166396
select s.*, count(s.sid) as `TS`, u.username, u.usergroupid from shout s
I would like to know if someone have had the same problem, and if so, HOW YOU FIXED THEM?

Just shutting off the vbshout? Is there any update that works better than the version 2.0?

Is there any FAST way of finding another possible problems?

Thanks very much for your help!

Marco van Herwaarden 10-27-2007 07:55 AM

If you have questions/problems with a modification, then please post in the thread (or support forum/board) about that modification. Best chance to receive a reply from either the author or another member using the same modification.

lasatormentadas 10-27-2007 06:13 PM

OK, I´m sorry,

Awjvail 10-27-2007 06:28 PM

vBShout doesn't cause a large database.. I have over 35000 shouts in my shoutbox and the shoutbox database is only a few mb big.

djdonx 10-27-2007 06:57 PM

vBShout does use up a large amount of your bandwidth I think...

Paul M 10-27-2007 07:40 PM

According to what you posted, your shout database has 166,396 records in it - if it's not using indexes then it's going to slow down. I suggest you prune it down to a much smaller size.


All times are GMT. The time now is 05:09 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.01015 seconds
  • Memory Usage 1,719KB
  • 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
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (6)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete