Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 07-23-2012, 11:08 AM
Milobil Milobil is offline
 
Join Date: Jun 2012
Posts: 85
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default I really need help !

First, sorry for my english (i'm not).

Yesterday, i wanted to access to my forum, but i saw database error in the index page, so i I logged on my mailbox (gmail) and vbulletin (my forum) sent me some errors for database like this :
Code:
Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User xxx already has more than 'max_user_connections' active connections
/home/ah40607/web/www/forum/includes/class_core.php on line 317

MySQL Error   :
Error Number  :
Request Date  : Monday, July 23rd 2012 @ 02:19:38 AM
Error Date    : Monday, July 23rd 2012 @ 02:19:38 AM
Script        : http://www.myforum.com/forum/css.php?styleid=3&langid=1&d=1342049041&td=ltr&sheet=forumbits.css,forumhome.css,options.css
Referrer      : http://www.myforum.com/forum/forum.php
IP Address    : XXX.XX.XX.XXX
Username      :
Classname     : vB_Database
MySQL Version :
Or this :
Code:
Database error in vBulletin 4.2.0:

Invalid SQL:

                        SELECT IF(thread.visible = 2, 1, 0) AS isdeleted,


                        NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed, emailupdate, folderid,
                        post.pagetext AS description,
                        thread.*


                        FROM thread AS thread

                        LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = 0  AND subscribethread.canview = 1)


                        LEFT JOIN post AS post ON(post.postid = thread.firstpostid)


                        WHERE thread.threadid = 406;

MySQL Error   : MySQL server has gone away
Error Number  : 2006
Request Date  : Monday, July 23rd 2012 @ 01:59:27 AM
Error Date    : Monday, July 23rd 2012 @ 02:14:13 AM
Script        : http://www.myforum.com/forum/newreply.php?do=newreply&t=406
Referrer      :
IP Address    : XXX.XX.XX.XX
Username      : Unregistered
Classname     : vB_Database
MySQL Version :
So after i saw those errors, i went to my host and connect to mysql database using phpmyadmin and miraculously, my forum was now accessible and on...

I just wanted to know what are those errors and what i have to do to avoid this in the future.

Thank you for your help.
Reply With Quote
  #2  
Old 07-23-2012, 12:21 PM
kh99 kh99 is offline
 
Join Date: Aug 2009
Location: Maine
Posts: 13,185
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Those have to do with your server configuration and not vbulletin. If it only happened once, I wouldn't worry about it. If it continues to happen you should contact your host and ask them about it.
Reply With Quote
  #3  
Old 07-23-2012, 10:38 PM
Milobil Milobil is offline
 
Join Date: Jun 2012
Posts: 85
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Ok i have this problem now :
Code:
Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (11)
/home/ah40607/web/www/forum/includes/class_core.php on line 317

MySQL Error   :
Error Number  :
Request Date  : Tuesday, July 24th 2012 @ 01:31:44 AM
Error Date    : Tuesday, July 24th 2012 @ 01:31:44 AM
Script        : http://www.myforum.com/forum/login.php?do=login
Referrer      :
IP Address    : XXX.XX.XX.XX
Username      :
Classname     : vB_Database
MySQL Version :
When i want to connect to mysql using phpmyadmin, the page does not load, it comes from there ?
Reply With Quote
  #4  
Old 07-23-2012, 10:43 PM
kh99 kh99 is offline
 
Join Date: Aug 2009
Location: Maine
Posts: 13,185
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It sounds to me like maybe your mysql server isn't running.
Reply With Quote
  #5  
Old 07-23-2012, 10:49 PM
Milobil Milobil is offline
 
Join Date: Jun 2012
Posts: 85
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

So i have to contact my host ?
PS : I have seen this error too :
Code:
Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User mysqluser already has more than 'max_user_connections' active connections
/home/ah40607/web/www/forum/includes/class_core.php on line 317

MySQL Error   :
Error Number  :
Request Date  : Tuesday, July 24th 2012 @ 01:42:26 AM
Error Date    : Tuesday, July 24th 2012 @ 01:43:08 AM
Script        : http://www.myforum.com/forum/newreply.php?p=5197&noquote=1
Referrer      : http://www.myforum.com/forum/showthread.php?173-What-U-Want-But-In-Anal-Version-(Collection-By-ChapterX)/page7
IP Address    : 41.226.67.230
Username      :
Classname     : vB_Database
MySQL Version :
mysqluser (it's not the real mysql username) already has more than 'max_user_connections' active connections ?
What it means ?
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 01:53 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05247 seconds
  • Memory Usage 2,200KB
  • Queries Executed 13 (?)
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
  • (4)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (5)post_thanks_box
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (5)post_thanks_postbit_info
  • (5)postbit
  • (5)postbit_onlinestatus
  • (5)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_postinfo_query
  • fetch_postinfo
  • 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