Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 01-29-2011, 11:13 PM
kinkarso kinkarso is offline
 
Join Date: May 2006
Location: Canada
Posts: 69
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Sudden MySQL Database Error, for no reason

Hi there,

One of my larger forums is currently experiencing something weird. Every page is now displaying a 'Database Error' message:


Nothing at all was edited in FTP or the database, confirmed by all the raw stats available. Additionally, I did a database repair via WHM for the site, and it went through with all green lights. I've restarted the server, restarted MySQL, but still the site remains to have this error message.

Do you happen to know what may be the cause of this?

Thanks!
Donny
Reply With Quote
  #2  
Old 01-29-2011, 11:29 PM
bobster65's Avatar
bobster65 bobster65 is offline
 
Join Date: Mar 2006
Location: Montana
Posts: 1,169
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

paste a copy of the error emails you are receiving.. that would help anyone here know whats going on.
Reply With Quote
  #3  
Old 01-30-2011, 12:39 AM
kinkarso kinkarso is offline
 
Join Date: May 2006
Location: Canada
Posts: 69
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I got the following error message:

Database error in vBulletin :

Cannot use database **********

MySQL Error : Access denied for user '*****'@'localhost' to database '******'
Error Number : 1044
Request Date : Saturday, January 29th 2011 @ 09:37:13 PM
Error Date : Saturday, January 29th 2011 @ 09:37:13 PM
Script : *************
Referrer :
IP Address : **********
Username :
Classname : vB_Database
MySQL Version :

I have not changed config.php or modified the password in any way. I've just now changed the MySQL password and updated config.php to the new one. However, the problem persists and gives off the same error message. Very weird.

Any ideas?

Thanks!
Donny
Reply With Quote
  #4  
Old 01-30-2011, 01:49 AM
cungchuctanxuan's Avatar
cungchuctanxuan cungchuctanxuan is offline
 
Join Date: Oct 2010
Posts: 38
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

what is the latest plug-in/product you installed on your VB?
Reply With Quote
  #5  
Old 01-30-2011, 01:51 AM
kinkarso kinkarso is offline
 
Join Date: May 2006
Location: Canada
Posts: 69
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I can't login to check, but I haven't touched it since sometime last year. Though an admin may have installed something that doesn't require FTP access. Do you know how I can check? Do you think this may be the cause of this problem?

Donny
Reply With Quote
  #6  
Old 01-30-2011, 01:56 AM
TNCclubman's Avatar
TNCclubman TNCclubman is offline
 
Join Date: Sep 2008
Posts: 690
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

maybe the host is restarting your server
Reply With Quote
  #7  
Old 01-30-2011, 01:58 AM
cungchuctanxuan's Avatar
cungchuctanxuan cungchuctanxuan is offline
 
Join Date: Oct 2010
Posts: 38
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yes because the same exact thing thing happened to my VB.
In my case there was an error message that told me where the error happened.
OK log into your FTP and back up all files before anything else happens
And maybe wait one night?
Reply With Quote
  #8  
Old 01-30-2011, 02:03 AM
kinkarso kinkarso is offline
 
Join Date: May 2006
Location: Canada
Posts: 69
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks for the replies.

It's been 48 hours now, still no avail unfortunately.

I've restarted my server to try to fix this problem, but that hasn't helped either.

Thanks,
Donny
Reply With Quote
  #9  
Old 01-30-2011, 05:24 AM
kh99 kh99 is offline
 
Join Date: Aug 2009
Location: Maine
Posts: 13,185
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I know very little about MySQL admin, but looking up error 1044 it looks like it's a database access control issue rather than a user/password thing (i.e. user exists and password is good, but the user isn't allowed the access (privileges) it needs to do what it's trying to do).

Your error message doesn't have the part about exactly what it's trying to do (sometimes there's a file/line number) - I guess you might want to figure that out before playing around with the access control in case it's actually trying to do something it shouldn't be doing. ETA: Maybe the "cannot use database" means it was trying to do a mysql_select_db()?.

You might also figure out something by googling "mysql error 1044" or something like that.
Reply With Quote
  #10  
Old 01-30-2011, 04:45 PM
kinkarso kinkarso is offline
 
Join Date: May 2006
Location: Canada
Posts: 69
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I was able to get the site back up successfully!

Unfortunately, I'm still having trouble with the boards. Although the site is up consistantly, every couple of minutes or so it reverts back to the vBulletin Database Error page. Then it comes back around after 2-3 refreshes. It's been doing this for the entire day. Here's the error message attached to the vBulletin Database Error page:

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/*****/public_html/includes/class_core.php on line 311

Any ideas?

Thanks!
Donny
Reply With Quote
Reply

Thread Tools
Display Modes

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:54 AM.


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.04108 seconds
  • Memory Usage 2,241KB
  • 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
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (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_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