Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
1 registered (Ruben), 43 Guests and 14 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 03/24/10
Posts: 8
Top Posters (30 Days)
Ruben 50
Gizmo 24
DennyP 24
Dunny 15
SteveS 13
AllenAyres 12
dbremer 10
SD 10
drkknght00 9
doug 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Page 1 of 2 1 2 >
Topic Options
#228235 - 08/09/09 02:47 PM MySQL Crash Cause?
Lori.j Offline
stranger
Registered: 07/06/08
Posts: 10
My board has crashed (I didn't do anything!), and is giving this error:

Script:
Line#:
SQL Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Please verify that your MySQL server is running
SQL Error #: 2002
Query: Unable to connect to the database!


Is it correct to assume that this is caused on the host's end, like their server is down? Thank you.
Top
#228236 - 08/09/09 03:07 PM Re: MySQL Crash Cause? [Re: Lori.j]
JAISP Offline
old hand
Registered: 02/10/07
Posts: 1144
It looks that way. It is telling you that it can not connect to the database for one reason or another.
Top
#228239 - 08/09/09 04:47 PM Re: MySQL Crash Cause? [Re: Lori.j]
Ruben Online   hyper

Registered: 12/20/03
Posts: 4424
Loc: Lutz,FL
This can also happen if your config.inc.php file has been corrupted. This file holds all of your settings including your connection to mysql.
HERE is a post from another user that reported the exact same error.

So I would double check the file in question.

BTW, This is the same issue as JAISP stated. "No connection to MYSQL" If this file is corrupted the board does know how to connect to the database.
_________________________
Blue Man Group
Top
#228240 - 08/09/09 05:23 PM Re: MySQL Crash Cause? [Re: Ruben]
Ruben Online   hyper

Registered: 12/20/03
Posts: 4424
Loc: Lutz,FL
Also it would be helpful if you added your board url to your profile. So people like me can take a quick peek at the problem.
Sometimes it helps sometimes it doesn't.
But it does save time posting back and forth asking for the url.
_________________________
Blue Man Group
Top
#228242 - 08/09/09 05:59 PM Re: MySQL Crash Cause? [Re: Ruben]
Lori.j Offline
stranger
Registered: 07/06/08
Posts: 10
Thank you very much for your replies. Here's the error URL: http://www.wheelchairjunkie.com/forums/ubbthreads.php I am able to log into phpMyAdmin, but I can't find a config.inc.php file. It's odd because the board has run flawless for a year, and suddenly it's just showing this error. Thanks again.
Top
#228243 - 08/09/09 06:02 PM Re: MySQL Crash Cause? [Re: Lori.j]
Ruben Online   hyper

Registered: 12/20/03
Posts: 4424
Loc: Lutz,FL
Well I can't say for version 6 but for version 7 the file is in includes/config.inc.php.
Looking at the last 6.x download it seems to be the same.
_________________________
Blue Man Group
Top
#228244 - 08/09/09 06:10 PM Re: MySQL Crash Cause? [Re: Ruben]
Lori.j Offline
stranger
Registered: 07/06/08
Posts: 10
Ruben, if I can access the phpMyAdmin control panel, does that mean it's not the server that's the issue, but my board files? Thanks.
Top
#228245 - 08/09/09 06:14 PM Re: MySQL Crash Cause? [Re: Lori.j]
Ruben Online   hyper

Registered: 12/20/03
Posts: 4424
Loc: Lutz,FL
I would probably say yes. If you did read my post link. It could be your server over wrote the config.inc.php file due to out of disk space. A big clue is the file is 0 bytes.
See if you can find the config file. and restore it even if it is out of date the paths.login,password should be correct.
_________________________
Blue Man Group
Top
#228247 - 08/09/09 06:58 PM Re: MySQL Crash Cause? [Re: Ruben]
Lori.j Offline
stranger
Registered: 07/06/08
Posts: 10
Ruben, my config.inc.php file is 0. Unfortunately, I don't have access to the original files, and my membership expired last month... so I guess I have to buy an upgrade, and go from there. Thanks.
Top
#228249 - 08/09/09 07:06 PM Re: MySQL Crash Cause? [Re: Lori.j]
Ruben Online   hyper

Registered: 12/20/03
Posts: 4424
Loc: Lutz,FL
Well,
You may have other options.If you have a old backup you can use it like I said before. You just will need to update it after uploading.
Another option is if you have the original zip file, set up a test board and let it create a new config file and copy it over to the live board.

Or somebody may have a default config file for you to use. But you need to let us know what the version is. Also Rick could rebuild your config file. If you open a support ticket.
_________________________
Blue Man Group
Top
#228264 - 08/10/09 06:43 PM Re: MySQL Crash Cause? [Re: Ruben]
Ruben Online   hyper

Registered: 12/20/03
Posts: 4424
Loc: Lutz,FL
Looks like you are up and running. I assume Rick restored your config file?
_________________________
Blue Man Group
Top
#235565 - 03/12/10 03:18 PM Re: MySQL Crash Cause? [Re: Ruben]
BellaOnline Offline
addict
Registered: 06/12/06
Posts: 515
Thank YOU!!!

I just had this happen and I found this thread, and I copied over the config file. Everything is back again!!

Thank you so much!! smile
_________________________
Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums
Top
#235573 - 03/12/10 05:58 PM Re: MySQL Crash Cause? [Re: BellaOnline]
Ruben Online   hyper

Registered: 12/20/03
Posts: 4424
Loc: Lutz,FL
All I can say is "BEWARE"
Some problem caused the file to be corrupted.
But glad to see you got it resolved for now.
_________________________
Blue Man Group
Top
#235921 - 03/29/10 11:34 PM Re: MySQL Crash Cause? [Re: Ruben]
Dunny Offline
addict
Registered: 01/16/08
Posts: 460
Loc: DE USA
The only time I have ever had an issue with the config file was when I was editing it locally, and I forgot it was opened when I switched between computers and accessed it via my CP and updated it there as well.... when I switched back to my forums (locally) I saved changes and voila everything was wiped and I had to use a backup. Maybe something like this happened, where there were two instances of the config file being written and it burped out a WTH are you doing to me kind of thing.

tongue

Dunny
_________________________
Dunny

Removed link due to bleedover spammers

Dawn of Iskirra
Top
Page 1 of 2 1 2 >



Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Temporary Password email not being received
by
05/24/12 10:02 PM
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Forum Stats
10492 Members
36 Forums
33842 Topics
181709 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image