The Arcive of Official vBulletin Modifications Site.

coolphim · #1 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 · #2 06-07-2006, 03:45 AM

Whats the exact error message you are getting?

coolphim · #3 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 · #4 06-07-2006, 04:07 AM

right click view source, paste error message, or check the techncial email set in config.php

coolphim · #5 06-07-2006, 05:35 AM

This is the error message

SaintDog · #6 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 · #7 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 · #8 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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04719 seconds Memory Usage 2,230KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (1)bbcode_code (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (8)post_thanks_box (8)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (8)post_thanks_postbit_info (8)postbit (8)postbit_onlinestatus (8)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!