delme

This error became a problem after many desperate attempts to get imagecache working I saw a post that said there were problems with my version of PHP. I was running PHP 5.2.8.

I downloaded the latest stable version of PHP (as of 28/09/09) which is PHP 5.2.11.

It says duringĀ  the installation that it is not recommended that all features available should be installed by default – this will cause problems! I’m running on 2003 Server (IIS 6.0) using FastCGI. After re-booting my server a few times and adding more bits to my PHP install I saw this error message:

Site off-line

The site is currently not available due to technical problems. Please try again later. Thank you for your understanding.

If you are the maintainer of this site, please check your database settings in the settings.php file and ensure that your hosting provider’s database server is running. For more help, see the handbook, or contact your hosting provider.

Ok, the solution really is there. It’s in settings.php it’s on line 92 the following code:
If your host doesn’t have mysqli installed, you can it change to use mysql. (MySQLi stands for MySQL Improved.)

Open settings.php change $db_url from mysql to mysqli (settings usually in /sites/default-folder in your drupal installation).

BEFORE:
$db_url = ‘mysqli://user:[email protected]/table’;

AFTER
$db_url = ‘mysql://user:[email protected]/table’;
This means that you can either install MySQLi with your PHP install OR you can simply make the changes to your settings.php file as detailed above. If this works for you please let me know in the comments area.
Reference from Experts Exchange

5 comments

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>