FAQ: What do "This site is temporarily unavailable" - Database ERROR NUMBER CODE

This is the archive off all FAQ related threads.
Locked
User avatar
toubkal
Joomla! Hero
Joomla! Hero
Posts: 2860
Joined: Thu Aug 18, 2005 4:35 pm
Location: Cheshire, England
Contact:

FAQ: What do "This site is temporarily unavailable" - Database ERROR NUMBER CODE

Post by toubkal » Sun Sep 04, 2005 9:23 am

FAQ: My site fails to load and shows the following message:

This site is temporarily unavailable.
Please notify the System Administrator
3

What might this mean?

Answer:

The number following the message indicates a database problem. The error number is generated by joomla! and error numbers 1, 2 and 3 indicate the following:

Error 1 = FATAL ERROR: MySQL support not available.
Error 2 = FATAL ERROR: Connection to database server failed.
Error 3 = FATAL ERROR: Database not found

my view in plain speak would be:

error 1
Joomla! attempts to talk with mysql on the server and fails to even talk to it - this might be because the server does not have mysql installed at all or maybe it is not configured correctly

technically: function_exists( 'mysql_connect' ) FAILS

error 2
sql is installed but for some reason we cannot login to mysql (this is where it tries the host, username, password stuff) - may indicate that these details are wrong in your config

technically: $this->_resource = @mysql_connect( $host, $user, $pass ) FAILS

error 3
I think this is that it passed 1 and 2 so you can connect to mysql but not select the specific database

technically: mysql_select_db($db) FAILS

Up until 1.0.12, the offline message used to only have codes 1 through 3. In 1.0.12, those codes were replaced with text as defined in english.php.

Code: Select all

define( '_SYSERR1', 'The database adapter is not available' );
define( '_SYSERR2', 'Could not connect to the database server' );
define( '_SYSERR3', 'Could not connect to the database' );
One through three are still equivalent to the former numeric code system which translated to
Error 1 = FATAL ERROR: MySQL support not available.
Error 2 = FATAL ERROR: Connection to database server failed.
Error 3 = FATAL ERROR: Database not found



DISCUSSION THREAD HERE: http://forum.joomla.org/index.php/topic,37228.0.html
Last edited by mcsmom on Mon Jan 08, 2007 2:14 pm, edited 1 time in total.
Do you want the answer to be as vague as your question?

Locked

Return to “FAQ Archive”