Log in

View Full Version : database error


ArsMagnum
11-21-2012, 02:00 PM
I'm getting a complete database error. I can't even get in to the page, so everything I can do, is only by the FTP.
This happened yesterday while I was traying to install an addon (https://vborg.vbsupport.ru/showthread.php?t=267506). After I did, it completely crushed.

I tried to unable all the addons from the config.php, but it didn't work eader.
Now i'm trying to get an email to get an especific information of the error, but nothing happens...

I need serious help in this

kh99
11-21-2012, 02:13 PM
We would have to know what the database error is. Did you try viewing the html source of a page when you get the error? You could also contact you host if you have no other way to find out what the error is.

ArsMagnum
11-21-2012, 02:19 PM
Yes, I tried to view the html source, but nothing usefull shows up.
I added my personal email in to the technical error code in the config.php, so I can get an email with the specific error. But I haven't recived anything yet.

ForceHSS
11-21-2012, 02:25 PM
link to site

ArsMagnum
11-21-2012, 02:28 PM
<a href="http://forum.arsmagnum.com" target="_blank">http://forum.arsmagnum.com</a>

kh99
11-21-2012, 02:52 PM
So you inserted
define('DISABLE_HOOKS', true);


in your includes/config.php and you still got the same error?

ArsMagnum
11-21-2012, 02:58 PM
I did, and yes. Still got the same error. And thats what I find weird, becouse all this problem started just after I installed this addon

kh99
11-21-2012, 03:05 PM
Hmm...do you have phpMyAdmin? If so. try going to the database page (with the list of tables), scroll to the bottom and click "check all" and then in the "With Selected" dropdown choose "Analyze Table" and see if you see any error messages.

ArsMagnum
11-21-2012, 03:11 PM
I'm sorry, I downloaded phpMyAdmin, but I really didn't understand what I have to do.
Can you explain me a little bit more?

kh99
11-21-2012, 03:14 PM
Well, to be honest I don't know. You'd have to set it up to access your database, and I've never done that myself. It probably has instructions and you have the database information in your config.php.

I mentioned it because I know some hosts provide it already installed. If not, maybe you have some other way to manage databases? I don't know a lot about different hosting setups so I can't tell you waht to look for.

I'm also not sure if this will fix the problem.

ArsMagnum
11-21-2012, 03:22 PM
I see... Well, I'll keep investigating this. Thanks for your help, kh.

kh99
11-21-2012, 03:31 PM
lol, yeah I know I wasn't any help. But probably someone else will have an idea.

ArsMagnum
11-21-2012, 03:33 PM
Hey! At least you try to help me <.< that counts as something... So accept my thanks.

Lynne
11-21-2012, 03:45 PM
The exact database error will be emailed to the email you entered into your /includes/config.php file. So, go check that email and let us know what the exact error is that you are getting.

ArsMagnum
11-21-2012, 03:49 PM
That IS the problem.
The config.php file has 2 emails. The one that is admin@arsmagnum.com, wich I dont have acces to, and the other one is my personal one. Wich I added in the config.php file after the crush, and I still haven't received any email.

kh99
11-21-2012, 03:55 PM
It looks like if you put the forum in debug mode (add $config['Misc']['debug'] = 1; to config.php) then it should display the message.

ArsMagnum
11-21-2012, 03:59 PM
Aaaaalright! so, now I see the source page and showes me this:

Database error in vBulletin :

mysql_connect() [&lt;a href='function.mysql-connect'&gt;function.mysql-connect&lt;/a&gt;]: User arsmagnu_forum already has more than 'max_user_connections' active connections
/home4/arsmagnu/public_html/forum/includes/class_core.php on line 317

MySQL Error :
Error Number :
Request Date : Wednesday, November 21st 2012 @ 09:58:59 AM
Error Date : Wednesday, November 21st 2012 @ 09:58:59 AM
Script : http://forum.arsmagnum.com/forum.php
Referrer :
IP Address : 190.160.136.137
Username :
Classname : vB_Database
MySQL Version :

Stack Trace:

#0 vB_Database-&gt;halt() called in [path]/includes/class_core.php on line 5578
#1 catch_db_error() called in on line
#2 mysql_connect() called in [path]/includes/class_core.php on line 317
#3 vB_Database-&gt;db_connect() called in [path]/includes/class_core.php on line 282
#4 vB_Database-&gt;connect() called in [path]/includes/init.php on line 189
#5 require_once([path]/includes/init.php) called in [path]/includes/class_bootstrap.php on line 101
#6 vB_Bootstrap-&gt;init() called in [path]/includes/class_bootstrap.php on line 72
#7 vB_Bootstrap-&gt;bootstrap() called in [path]/global.php on line 26
#8 require_once([path]/global.php) called in [path]/forum.php on line 63

Lynne
11-21-2012, 04:06 PM
The config.php file should only have ONE email. Please remove the other one and only enter your own.

ArsMagnum
11-21-2012, 04:09 PM
I got the email and said this:

Database error in vBulletin :

mysql_connect() [<a
href='function.mysql-connect'>function.mysql-connect</a>]: User
arsmagnu_forum already has more than 'max_user_connections' active
connections
/home4/arsmagnu/public_html/forum/includes/class_core.php on line 317

MySQL Error :
Error Number :
Request Date : Wednesday, November 21st 2012 @ 10:02:55 AM
Error Date : Wednesday, November 21st 2012 @ 10:02:55 AM
Script :
http://forum.arsmagnum.com/showthread.php?70-%A1Inscripciones-al-Team-Death-Note!
Referrer :
IP Address : 180.76.5.110
Username :
Classname : vB_Database
MySQL Version :

Stack Trace:

#0 vB_Database->halt() called in [path]/includes/class_core.php on line 5578
#1 catch_db_error() called in on line
#2 mysql_connect() called in [path]/includes/class_core.php on line 317
#3 vB_Database->db_connect() called in [path]/includes/class_core.php on
line 282
#4 vB_Database->connect() called in [path]/includes/init.php on line 189
#5 require_once([path]/includes/init.php) called in
[path]/includes/class_bootstrap.php on line 101
#6 vB_Bootstrap->init() called in [path]/includes/class_bootstrap.php on
line 72
#7 vB_Bootstrap->bootstrap() called in [path]/global.php on line 26
#8 require_once([path]/global.php) called in [path]/showthread.php on line
107

Lynne
11-21-2012, 04:17 PM
That is an error you would need to show your host to fix (if they will). Usually if you are on shared hosting, they only allow xx (think, small number) connections for your user.

ArsMagnum
11-21-2012, 04:39 PM
Ummm... We are in justhost, I don't know how is that relevant, but is good to say it...

Anyhow, I don't really know how is it that the host only allows X connection for a user, this connections are for the time you are in their host?

Simon Lloyd
11-21-2012, 06:17 PM
the "x" connections doesn't mean the number of users on your site but more the number of calls per user to the database, as Lynne says, on shared hosting this is usually very limited, they do this so that they can oversell their resources, ask them to raise the number of max connections. You may find that they will refuse unless you upgrade your account.