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 (https://vborg.vbsupport.ru/showthread.php?t=173847)

R.Solutions 03-22-2008 05:29 PM
DB Error
 
I get a error and i dont know what caused it. please help.

www.centexracingscene.com/forums

THanks a lot,.

King Kovifor 03-22-2008 05:38 PM
More information on the error would help.

R.Solutions 03-22-2008 06:15 PM
I just said,i dont knwo what the error is from lol.

Thus, sayin, i dont know what caused it.

Lynne 03-22-2008 06:22 PM
When you get a database error, if you aren't having them mailed to you, you can View Source for the page and it will show the error at the bottom of the page:

PHP Code:
<!--
Database error in vBulletin :

mysql_connect() [&lt;a href='function.mysql-connect'&gt;function.mysql-connect&lt;/a&gt;]: Too many connections
/home/centexra/public_html/forums/includes/class_core.php on line 273

MySQL Error  : 
Error Number : 
Date         : Saturday, March 22nd 2008 @ 03:20:27 PM
Script       : [url]http://www.centexracingscene.com/forums/[/url]
Referrer     : [url]https://vborg.vbsupport.ru/showthread.php?p=1471813[/url]
IP Address   : xx.xxx.xxx.xx
Username     : 
Classname    : vb_database
--> 
Too many connections is a server issue. So, you will need to talk to your host about it.

R.Solutions 03-22-2008 06:25 PM
Ahhh thank you. So what do i need to do fix that? I have my server, a resellers.

Lynne 03-22-2008 06:27 PM
Quote:
Originally Posted by R.Solutions (Post 1471829)
Ahhh thank you. So what do i need to do fix that? I have my server, a resellers.
Your my.cnf file would have to be edited, I believe.

SEOvB 03-22-2008 06:28 PM
You need to increase the mysql_max_connections string in the mysql configuration file. If you can not do that, or do not have access to it, you'll have to try to contact your hosting company.

If they have it set as a hard limit and you can't use any more connections, you'll need to find a new host, or limit the connections some how.

R.Solutions 03-22-2008 06:31 PM
Quote:
Originally Posted by Lynne (Post 1471833)
Your my.cnf file would have to be edited, I believe.
\
Okay and thats located where?

Quote:
Originally Posted by FRDS (Post 1471835)
You need to increase the mysql_max_connections string in the mysql configuration file. If you can not do that, or do not have access to it, you'll have to try to contact your hosting company.

If they have it set as a hard limit and you can't use any more connections, you'll need to find a new host, or limit the connections some how.

Okay, i'll check that, i think i can do that. located where?

snakes1100 03-22-2008 06:45 PM
Typically /etc/my.cnf or /etc/mysql/my.cnf

From a shell:

find / -name my.cnf -print
or
locate my.cnf

Edit my.cnf and change max_connections to a higher number, increase it by 100 and save it, then restart mysql:
/etc/rc.d/init.d/mysql restart

R.Solutions 03-22-2008 06:54 PM
Hmm im lookin in my WHM, would that be it>?

and i looked in etc/....

and didnt see no cnf file.

Lynne 03-22-2008 06:58 PM
Quote:
Originally Posted by R.Solutions (Post 1471856)
Hmm im lookin in my WHM, would that be it>?

and i looked in etc/....

and didnt see no cnf file.
Quote:
Originally Posted by snakes1100 (Post 1471849)
Typically /etc/my.cnf or /etc/mysql/my.cnf

From a shell:

find / -name my.cnf -print
or
locate my.cnf

Edit my.cnf and change max_connections to a higher number, increase it by 100 and save it, then restart mysql:
/etc/rc.d/init.d/mysql restart
After you change the my.cnf file, you need to restart mysql. Do you have access to do that?

snakes1100 03-22-2008 07:04 PM
whm isnt going to show you the file, you need to open a shell and edit the file.

once you have edited the file restart mysql as i posted previously.

you can also restart mysql in whm, if its a resellers account you may not have permissions to restart mysql


All times are GMT. The time now is 06:43 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.01135 seconds
  • Memory Usage 1,743KB
  • 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
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (12)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