vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Requests/Questions (Unpaid) (https://vborg.vbsupport.ru/forumdisplay.php?f=112)
-   -   Database error frequently, help please... (https://vborg.vbsupport.ru/showthread.php?t=117865)

coolphim 06-07-2006 03:25 AM
Database error frequently, help please...
 
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:
Code:

<!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


All times are GMT. The time now is 04:21 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.00973 seconds
  • Memory Usage 1,739KB
  • 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_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (8)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