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 09-25-2010, 02:29 AM
silencio2222 silencio2222 is offline
 
Join Date: Feb 2010
Location: Colorado
Posts: 10
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default vBulletin Database Error

I started getting a database error just before I upgraded the v4.0.7 but now they are continuing.

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/xxxxxxx/public_html/forum/includes/class_core.php on line 313

Any suggestions?

Thanks.
Reply With Quote
  #2  
Old 09-25-2010, 12:25 PM
KevinL KevinL is offline
 
Join Date: Apr 2005
Posts: 1,287
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Read here http://www.vbulletin.com/docs/html/t...t_mysql_errors that should help you
Reply With Quote
  #3  
Old 09-25-2010, 12:39 PM
silencio2222 silencio2222 is offline
 
Join Date: Feb 2010
Location: Colorado
Posts: 10
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks Much. Appreciate your help. I will see what my host can share with me.
Reply With Quote
  #4  
Old 09-27-2010, 02:15 AM
Videx's Avatar
Videx Videx is offline
 
Join Date: Feb 2007
Posts: 3,085
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

If you're on shared hosting, this is a very common error on oversold servers. Check your CPU loads. As the server gets slowed down, odd errors start happening.
Reply With Quote
  #5  
Old 09-27-2010, 02:49 PM
silencio2222 silencio2222 is offline
 
Join Date: Feb 2010
Location: Colorado
Posts: 10
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks...the error doesn't seem to be affecting the forum but it does concern me. The errors are generated at random times and I can't seem to pin point the error and the host doesn't seem to think that there is anything they can do short of moving it to a new server.

I did make some changes to the bandwidth and ran some mysql repair and checks using cpanel and vbulletin's options. So far so good but I don't have a clue yet if it is corrected....thanks so much for your help.

Quote:
Originally Posted by Videx View Post
If you're on shared hosting, this is a very common error on oversold servers. Check your CPU loads. As the server gets slowed down, odd errors start happening.
Reply With Quote
  #6  
Old 09-27-2010, 03:20 PM
Videx's Avatar
Videx Videx is offline
 
Join Date: Feb 2007
Posts: 3,085
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Although changing servers can wreak havoc, if they're actually offering to do that for free it may be your best choice. Again, assuming this is a load issue. I know a move solved ours.

Forget playing around with your vb stuff, none of that will cause the mysql socket to not be available.
Reply With Quote
  #7  
Old 09-27-2010, 03:24 PM
silencio2222 silencio2222 is offline
 
Join Date: Feb 2010
Location: Colorado
Posts: 10
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Videx,

Let me ask you if moving to a new server is recommended over creating a new mysql database on the same server?
Reply With Quote
  #8  
Old 09-27-2010, 03:34 PM
Videx's Avatar
Videx Videx is offline
 
Join Date: Feb 2007
Posts: 3,085
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Those are two totally different things that have nothing at all to do with one another. Create all the new dbs you want, but if the server is overloaded you won't be able to connect to those at times either.
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 02:01 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.03666 seconds
  • Memory Usage 2,223KB
  • 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_quote
  • (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