DAtabase Unavailable

dreamer · 2011-01-26 20:50:00

Everynow and then, I’ll have some of my sites say that. Sometimes, it’s gone within a couple minutes of refreshing. Others tend to stay alot longer. What would be causing this and how to fix? Or prevent this from happening?

Last edited by dreamer (2011-01-26 20:55:53)

the_ghost · 2011-01-26 21:00:26

Contact your hoster – 100% problem is with access to mysql database. If it’s shared hosting – is your site under big load? How many visitors you have?

dreamer · 2011-01-26 21:03:19

Nah- it’s a small business site. It is shared hosting. What do you mean by “access to mysql database” ? Thank you

maverick · 2011-01-26 21:10:59

dreamer wrote:

What do you mean by “access to mysql database” ?

For some reason your mysql server isn’t responding to requests from Txp

jsoo · 2011-01-26 21:12:01

Txp needs a connection to the database. You might be getting the ‘database unavailable’ message because the database is overloaded with current connections, i.e. from other users on the same shared web host. The way to prevent it from happening is to find a web hosting configuration where the database isn’t overloaded. Usually that means spending a little more, but not necessarily a lot more.

xtreme164 · 2011-01-26 22:03:41

thanks jsoo, i have the same problem with my hosting service!

MattD · 2011-01-26 22:40:23

I used to have that problem. Changing hosts solved it.

sweed · 2012-11-01 17:19:34

I lived with this issue for a year or more. I finally broke down and contacted Network Solutions. Below is their response. Worked for me, hope this helps others…

Your issue can be resolved by customizing PHP settings on your hosting package. Default values for PHP can be modified by use of the “php.ini” file that can be created in the /cgi-bin. Modifications to the php.ini file are not supported by Network Solutions technical support. You may create or make changes to the “php.ini” file and upload it to your /cgi-bin folder, but any changes to the “php.ini” file that are detrimental to the server’s performance may result in a suspension of your hosting account.

Whenever changing (or removing) a custom php.ini, you need to remove the file /cgi-bin/.php/php.coalesced.ini. Failure to delete this file will mean that the previous settings are used until the server re-generates this file. Deleting it forces the server to re-generate it on the next PHP load.

An example php.ini:
register_globals = On
safe_mode = Off
memory_limit = 64M

The “example” above is all I did. Saved as php.ini and uploaded.

Gocom · 2012-11-01 17:21:45

Please, do not enable register_globals.

sweed · 2012-11-01 17:39:20

Ok, followed your advice and omitted the ‘register_globals’ line. The results still seem to be successful for the original problem.

Textpattern CMS

Textpattern CMS support forum

#1 2011-01-26 20:50:00

DAtabase Unavailable

#2 2011-01-26 21:00:26

Re: DAtabase Unavailable

#3 2011-01-26 21:03:19

Re: DAtabase Unavailable

#4 2011-01-26 21:10:59

Re: DAtabase Unavailable

#5 2011-01-26 21:12:01

Re: DAtabase Unavailable

#6 2011-01-26 22:03:41

Re: DAtabase Unavailable

#7 2011-01-26 22:40:23

Re: DAtabase Unavailable

#8 2012-11-01 17:19:34

Re: DAtabase Unavailable

#9 2012-11-01 17:21:45

Re: DAtabase Unavailable

#10 2012-11-01 17:39:20

Re: DAtabase Unavailable

Board footer