Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#1 2008-02-21 16:25:11
- joeamerica
- Member
- Registered: 2006-06-18
- Posts: 10
Debugging "Database Unavailable" message
Hello everyone. Looking for some guidance…
I have a very simple client site (a brochure-site with just a few articles) that has been working fine up until this morning when it shows the “Database Unavailable” error message. Some notes:
- The host doesn’t provide root access or phpmyadmin that I could use to check up on the database.
- We didn’t change anything with the install, content, templates, etc, since it was working.
- I double checked the config.php settings and they are unchanged (although I can’t imagine how they would have been changed overnight)
- The host says it is a “phpscript issue” and has nothing to do with them. I disagree.
- I’m running 4.0.6 with two plug-ins: asy_wondertag and mcw_templates.
The few times I’ve had the “database unavialable” message in the past it as always been something with the database server (which I can’t check) or config.php (which I did check). Any tips on how I can resolve this? Time to change hosts?
Thanks in advance,
-r
Offline
Re: Debugging "Database Unavailable" message
phpMyAdmin is a PHP script, just like Textpattern. If you need it, you can install it yourself.
If you have a very very recent backup and don’t mind re-creating what was done after the backup, you could opt to restore a backup and see if that fixes the problem (make a backup of the current database first, before doing this, so you can always revert to the current situation).
Offline
#3 2008-02-22 01:22:26
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: Debugging "Database Unavailable" message
- How did you create your database?
Offline
#4 2008-02-22 14:30:18
- kevinpotts
- Member
- From: Ghost Coast
- Registered: 2004-12-07
- Posts: 370
Re: Debugging "Database Unavailable" message
I occasionally run into these issues as well. Since I hate farking around in phpmyadmin, I use Rob’s rss_admin_db_manager plugin. It shows which tables in the DB need repairing, with a nice link to simply repair them. I find the 500 error pops up when the table “textpattern” starts chucking wobblies. This plugin has saved me hours of grief.
Kevin
(graphicpush)
Offline
#5 2008-02-23 20:12:49
- joeamerica
- Member
- Registered: 2006-06-18
- Posts: 10
Re: Debugging "Database Unavailable" message
Thanks everyone!
Just a quick followup. I was able to convince the host that something was definitely not right with their database server. Once they looked into it, the site was back up and running.
@mary: The created it for the client and gave me the connection parameters.
@ruud: good to know that it is easy to install. Duly noted in the log
Offline