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 12-03-2016, 06:38 PM
diysmps diysmps is offline
 
Join Date: Dec 2012
Posts: 16
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default vBulletin 4.2.3 Database ERRORS driving me crazy

We are suffering from this issue since we had the VB installed years ago, it used to happen from time to time, without finidng the answer why its happening.

We are unable to find a proper solution to this issue at the VB forums, but hopefully tihis time we will.


Problem is we are getting thousands of emails notifying us with the database errors.

Database error in vBulletin :

mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) /var/www/vhosts/diysmps.com/forums/includes/class_core.php on line 317

MySQL Error :
Error Number :
Request Date : Thursday, December 1st 2016 @ 01:57:40 AM
Error Date : Thursday, December 1st 2016 @ 02:05:54 AM
Script : http://www.diysmps.com/forums/entry....S&goto=newpost
Referrer :
IP Address : 46.229.168.72
Username :
Classname : vB_Database
MySQL Version :


Can any one help us to get rid of this painful problem? COMPLETELY?

In the past we had to change our host from GODADDY to Rackspace, we thought its the HOST.

And its NOT, its the VB itself.

Please help
Reply With Quote
  #2  
Old 12-03-2016, 06:48 PM
Dave Dave is offline
 
Join Date: May 2010
Posts: 2,583
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

If you have the MySQL settings in the vBulletin config file correctly configured then it's not a problem with vBulletin, it's a problem with your MySQL server.

Either something happens that causes the MySQL server to crash or the MySQL's ini settings are not right.

Refer to:
http://stackoverflow.com/questions/5...-mysql-sock-38
http://alvinalexander.com/mysql/mysq...-server-socket < definitely look at this.
Reply With Quote
2 благодарности(ей) от:
Brandon Sheley, Lynne
  #3  
Old 12-03-2016, 10:17 PM
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Location: CT - Down in a hole..
Posts: 3,057
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It is not Vbulletin. Vbulletin runs on almost any server.

Is that the only error you get and did it just start happening?

If you do not want the emails just remove your email from the config.php file.

##I'm not saying to remove your email address and not fix these issues. I am just saying that if you're inbox is getting flooded than you can remove your address from config just until you fix the issues. I'm fairly certain everyone knew this is what I meant but apparently I need to clarify.
Reply With Quote
Благодарность от:
blind-eddie
  #4  
Old 12-04-2016, 12:41 AM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by diysmps View Post
And its NOT, its the VB itself.
No, its not.

Thats actually PHP unable to connect to the MySQL server, and has nothing to do with vBulletin at all.

It even tells you that in the error message : mysql_connect(): Can't connect to local MySQL server
Reply With Quote
  #5  
Old 12-04-2016, 12:44 AM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by RichieBoy67 View Post
If you do not want the emails just remove your email from the config.php file.
Thats not really very good advice, its just ignoring the errors, and hiding any future errors.
Reply With Quote
  #6  
Old 12-04-2016, 12:47 AM
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Location: CT - Down in a hole..
Posts: 3,057
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Paul M View Post
Thats not really very good advice, its just ignoring the errors, and hiding any future errors.
It's not an ultimate fix but rather a temporary fix until issues are taken care of.
Reply With Quote
  #7  
Old 12-04-2016, 11:15 AM
Brandon Sheley's Avatar
Brandon Sheley Brandon Sheley is offline
 
Join Date: Mar 2005
Location: Google Kansas
Posts: 4,678
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Paul M View Post
Thats not really very good advice, its just ignoring the errors, and hiding any future errors.
I agree, should fix the issue, don't just hide the errors
https://www.vbulletin.com/forum/foru...66#post4000466
Reply With Quote
  #8  
Old 12-04-2016, 11:39 AM
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Location: CT - Down in a hole..
Posts: 3,057
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Ok, post amended.

Seems pretty obvious that I did not mean to hide the errors and not fix the issues but I added some clarification.
Reply With Quote
  #9  
Old 12-04-2016, 04:27 PM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Brandon Sheley View Post
I agree, should fix the issue, don't just hide the errors
https://www.vbulletin.com/forum/foru...66#post4000466
Are you trying to be funny, or just being a jerk ? its hard for me to tell from that.
Reply With Quote
  #10  
Old 12-04-2016, 06:08 PM
Brandon Sheley's Avatar
Brandon Sheley Brandon Sheley is offline
 
Join Date: Mar 2005
Location: Google Kansas
Posts: 4,678
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Paul M View Post
Are you trying to be funny, or just being a jerk ? its hard for me to tell from that.
I was trying to be funny in a smart a$$ way

That's the code that I thought of when I first read the reply. I wasn't searching for a post by you, but it's what pulled up first.

I would have rather had the source post from Mark to be honest..lol

Anyways, it was meant to be in good humor
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 08:44 PM.


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.05063 seconds
  • Memory Usage 2,271KB
  • 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
  • (6)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (3)post_thanks_box_bit
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (2)post_thanks_postbit
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)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
  • fetch_musername
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • post_thanks_function_fetch_thanks_bit_start
  • post_thanks_function_show_thanks_date_start
  • post_thanks_function_show_thanks_date_end
  • post_thanks_function_fetch_thanks_bit_end
  • post_thanks_function_fetch_post_thanks_template_start
  • post_thanks_function_fetch_post_thanks_template_end
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete