Unsupported database type

The database type is unsupported. Please use either mysql for MySQL 3.x & 4.0.x databases, mysqli for MySQL 4.1.x+ databases, or pgsql for PostgreSQL databases. The database information is in your settings.php file.

this is the error I got when I am installing drupal5.2
If any body knows please help me

Comments

tm’s picture

need input... standard stuff.

what is the technology stack (operating system, web server, php, mysql; please include versions). hosted (shared, vps, dedicated), own the server, on your local machine, etc. ?

what steps have you taken so far, and what is the exact error message (take out the personal/confidential stuff)?

not that i can help you personally, but someone else might, given enough information.

: )

incaic’s picture

I get the same problem:

my stats are:

php 5.2.4
mysql 5.0.45
drupal 5.3
Apache 2.0.52
Red Hat Linux 4 ES

Don't even know where to start to look for the problem.

Anyone?

incaic’s picture

Doh!
Had to change the db_url variable in settings.php from:

mysql to mysqli

Just like the message said ...

At least this post could now be used as reference for someone else. :)

walterbyrd’s picture

That did not work for me. I tried both, on two different platforms, and I keep getting the same error.

1st platform: debian sid, apache 2, php 5, mysql 5, drupal 5.3.

2nd platform: apache 1.3, php 4 & 5, mysql - not sure but I've tried both mysql and mysqli in the settings.php file. Also drupal 5.3.

stellarvisions’s picture

it seems perhaps that you cannot change this protocol after the fact. Which means that you cannot use the form that appears with the install script, which put in mysql:// by default. So, drop your tables (or revert to your pre-upgrade table structure) and change the settings.php manually, and then run install.php.

Unfortunately, although this got me further I must have a PHP issue because I now get: In your ./sites/default/settings.php file you have configured Drupal to use a mysqli server, however your PHP installation currently does not support this database type.

So I have to check with my host.

---
Stella Gassaway
principal

STELLARViSIONs : communication architects
215. 545. 7531 x21

We design culture-driven tools™
that shape how information is
organized, displayed, shared, and
experienced to reflect core values.

[web] http://w

---
Stella Gassaway
principal

stellarvisions : communication architects
http://www.stellarvisions.com

We design culture-driven tools™
that shape how information is
organized, displayed, shared, and
experienced.

tm’s picture

if permitted, you could reload the drupal files again. might be easier for some than to upload a new settings.php and resetting permissions.

sometimes, i wonder about having that selection in the collapsed area of the install screen...

Taxoman’s picture

This problem may occur with subdomain and/or on multisite setup where the URL does not have www at the beginning. Dont ask me why, but it solved the problem when I arranged so that it was using www.mydomain.com instead of either mydomain.com or subdomain1.mydomain.com.

irakli’s picture

Sorry, but "solutions" on this page are misleading and wrong.

In reality, you get the error when Apache does not have read access on sites/default/settings.php file

caspercash’s picture

How do we solve this irakli? If it is true that Apache doesn't have a read access on the settings.php, how do we correct this and ensure that Apache has already a read access on the settings.php?

tgiaccone’s picture

Your installation of php may not support postgress. The postgress drivers for PHP are not part of the standard Mac OS X 10.6 install of PHP. To solve this problem you have to either build php and ensure the php drivers are installed as part of the build. Or disable the distributed version of php and install the version that is distributed here:

http://www.entropy.ch/software/macosx/php/#install