I get the following error whenever I make any changes to the admin:

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 114

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 128

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 114

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 128

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 114

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 128

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 114

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 128

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 114

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 128

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 114

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 128

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 114

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 128

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 329

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 114

Warning: Couldn't fetch mysqli in /home/thengthi/public_html/includes/database.mysqli.inc on line 128

CommentFileSizeAuthor
#9 mysql_php_5.0.5_install.php_.patch738 bytesredndahead

Comments

scoutbaker’s picture

scoutbaker commented

I'm not able to reproduce this with a fresh install of D6 RC1.

Could you provide some more information about your environment (PHP version, MySQL version, etc.)? Also, is this a fresh install, or did you try to upgrade over a beta version of D6?

redndahead’s picture

redndahead commented

I am receiving the same error. I am using siteground.com for my hosting.

linux
php 5.0.5
Apache 1.3.7
mysql 5.0.45

asimmonds’s picture

asimmonds commented

I think this is a problem with php 5.0.5 and mysqli, can you try updating you php installation?

catch’s picture

catch
he/him
Primary language English
commented
Status: Active » Postponed (maintainer needs more info)

asimmonds: unless he's an admin on siteground (or has root access to a vps) I think that's unlikely.

redndahead: if you're not able to change this yourself, could you contact siteground to see if they have servers with different versions of php available?

Could you also try with a mysql connection in settings.php instead of mysqli? (iirc, simply remove the "i" that line in your database settings.)

redndahead’s picture

redndahead commented

Changing from mysqli to mysql has fixed this issue. Maybe there is a way to detect if the server has 5.0.5 and just make a switch from mysqli to mysql?

catch’s picture

catch
he/him
Primary language English
commented
Title: MySQL error report on all site admin pages » PHP 5.0.5 doesn't support mysqli
Version: 6.0-rc1 » 6.x-dev
Component: base system » documentation
Status: Postponed (maintainer needs more info) » Active

OK apparently core doesn't normally do special case checking for bad php and mysql releases, so I'm moving this to documentation. Would be good to have a note in troubleshooting faq.

Oh and this is an issue now because core now automatically detects if you have mysqli available during the installer and sets up settings.php accordingly. I imagine 5.05 does have it, but for some reason can't use it.

redndahead’s picture

redndahead commented

So when you say normally that means you won't accept any patches to do php 5.0.5 checking? If you will then I have a patch for the installer.

mfer’s picture

mfer commented

@redndahead - I think the issue here might be different than needing some special case tracking for php 5.0.5. The installer is detecting that mysqli is available. The code in the installer is:

// If both 'mysql' and 'mysqli' are available, we disable 'mysql':
  if (isset($db_types['mysqli'])) {
    unset($db_types['mysql']);
  }

So, there is something else going on here. Is there some bug that would cause D6 mysqli code to not work right for php 5.0.5? More detail might help us find a better solution. Is mysqli somehow different in php 5.0.5?

redndahead’s picture

redndahead commented
StatusFileSize
new mysql_php_5.0.5_install.php_.patch738 bytes

I've patched that code in the installer. and am ready to submit that if drupal will accept special cases for PHP 5.0.5. Looking at the history it's a bug in the 5.0.5 version of php and using a certain mysql function. I don't think that fixing the usage of that function in all of drupal just for v5.0.5 support is the answer. I think making it use mysql for the special case of 5.0.5 in the installer will work better.

I have attached the patch anyway just in case it could be useful for someone.

catch’s picture

catch
he/him
Primary language English
commented
Component: documentation » install system
Status: Active » Needs review

This is a patch.

catch’s picture

catch
he/him
Primary language English
commented
Component: install system » documentation
Status: Needs review » Active

already won't fix, so back to docs. http://drupal.org/node/36828#comment-354901

But thanks for the patch anyway!

Anonymous’s picture

Anonymous (not verified) commented
Project: Drupal core » Documentation
Version: 6.x-dev »
Component: documentation » Installation
Category: bug » task
Anonymous’s picture

Anonymous (not verified) commented
Assigned: Unassigned »
Status: Active » Fixed

This has been noted at:

http://drupal.org/node/201869

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.