PDA

View Full Version : Database error frequently, help please...

coolphim
06-07-2006, 03:25 AM
Hello,
Recently, my site is down many times in a day. I contacted the host supporter and they said that there were too many query from my site ( which is around 200 users online in my forum). They suggested me to use arrays of database user which can fix the problem. Please help me to do it because i really dont want to lose my customers. THANKS

Ps: Below is my chat log between me and my host supporter, plz take a look for more understanding. (Samuel is my host supporter)

Samuel P.: I have fix it for you.
Anh: so everytime it's down, i have to ask somebody to fix it?
Anh: it's been down so frequently that makes my site loses customers
Samuel P.: Presently we have set max limit(no of requests) on our server as 50000 per hour.
Samuel P.: Your database user is crossing the max question limit.
Samuel P.: You can solve it by recreating your database user.
Samuel P.: But it would be the temporary fix.
Samuel P.: There's a permanent solution for this that you can use arrays of database user.
Anh: can you show me how to use arrays of database user
Samuel P.: I'm sorry, you have to contact your web coding developer.
Zachery
06-07-2006, 03:45 AM
Whats the exact error message you are getting?
coolphim
06-07-2006, 03:49 AM
Then my website was blank and there is a message in return "There is a database error to Coolphim.com. The error has been submitted to the techinal support".
Zachery
06-07-2006, 04:07 AM
right click view source, paste error message, or check the techncial email set in config.php
coolphim
06-07-2006, 05:35 AM
This is the error message

http://img208.imageshack.us/img208/3696/error0ka.jpg
SaintDog
06-07-2006, 05:48 AM
Right Click -> View Page Source

That will contain a MySQL error number/code, this is what is needed :).
coolphim
06-07-2006, 05:57 AM
And this is the source of the error page:


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>Coolphim - Dien Dan Phim Le, Phim Bo, Phim Nguoi Lon ** MIEN PHI ** Database Error</title>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<style type="text/css">
<!--
blockquote { margin-top: 75px; }
p { font: 11px tahoma, verdana, arial, sans-serif; }
-->
</style>
</head>
<body>
<blockquote>
<blockquote>
<p><strong>There seems to have been a problem with the Coolphim - Dien Dan Phim Le, Phim Bo, Phim Nguoi Lon ** MIEN PHI **

database.</strong><br />
Please try again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web

browser.</p>
<p>An E-Mail has been dispatched to our <a href="mailto:dbmaster@example.com">Technical Staff</a>, whom you can also contact if the

problem persists.</p>
<p>We apologise for any inconvenience.</p>


<!--
Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_holiday AS phrasegroup_holiday,
language.phrasegroup_global AS phrasegroup_global,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep

FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) INNER JOIN language AS language ON (language.languageid =

IF(user.languageid = 0, 1, user.languageid))

WHERE user.userid = 1;

MySQL Error : User 'coolphim_anh' has exceeded the 'max_questions' resource (current value: 50000)
Error Number : 1226
Date : Tuesday, June 6th 2006 @ 11:46:14 PM
Script : http://coolphim.com/
Referrer :
IP Address : 69.236.97.46
Username :
Classname : vb_database
-->


</blockquote>
</blockquote>
</body>
</html>
Mighty Mojo
06-10-2006, 02:53 AM
Yes this is frustrating----Some web providers limit connections per database user....

Allowing VBulletin to use multiple database users would fix that (i.e. one fills up, it rolls over to the next database user)

Of course you can just find a new provider, but for me----taking all my sites over to a new provider has a very high cost