By nfdan on

Hi. I was hoping to get a little assistance with installing Drupal 6.4 . I have version 6.2 successfully installed and running and has been up for months without any problems. I am trying to install 6.4 on my shared hosting account but after entering in my database credentials during the installation I receive the following error:

Warning: mysqli_error() [function.mysqli-error]: invalid object or resource mysqli in /www/drupal6.4/includes/install.mysqli.inc on line 98

Warning: mysqli_query() [function.mysqli-query]: invalid object or resource mysqli in /www/drupal6.4/includes/database.mysqli.inc on line 83

Your MySQL Server is too old. Drupal requires at least MySQL 4.1.1.

However I am using MySQL 5
------------

%mysql --version
mysql Ver 14.12 Distrib 5.0.24a, for unknown-freebsd6.2 (i386) using EditLine wrapper

------------

Thanks

⋅ Categories: Drupal 6.x

Comments

nfdan’s picture

nfdan commented

im confused now.

i deleted the files.. unpacked the tar.gz and tried again to the folder /drupal6.4/ and received the same error message.

I deleted the files again and unpacked the tar.gz to the folder /drupal-6.4/ (with a hyphen as the default unpacking does) and the installation works without any problems.

any clues?

gonefishing’s picture

gonefishing commented

Post what you have for:
* Database URL format:
* $db_url = 'mysql://username:password@localhost/databasename';
* $db_url = 'mysqli://username:password@localhost/databasename';
* $db_url = 'pgsql://username:password@localhost/databasename';
*/
$db_url = 'mysql://username:password@localhost/databasename';
$db_prefix = '';

in your settings.php file.

nfdan’s picture

nfdan commented

Thanks.

I have

$db_url = 'mysqli://uname:pass@mysqlhost/d60521709';
$db_prefix = '';

(uname:pass) substitutes my actual login info.

its weird.. the 3rd attempt at installing Drupal 6.4 to a different folder worked.

attempt one & two: install to a folder called /drupal6.4
attempt three: install to /drupal-6.4

trailerparkopera’s picture

trailerparkopera commented

Drupal was reporting that I had a 4..1.1 version of the MySQL server, but I had a 5. 0.x version installed. I resolved this particular issue by changing (in the /sites/mysite/settings.php file):

* $db_url = 'mysql://username:password@localhost/databasename';

to

* $db_url = 'mysqli://username:password@localhost/databasename';

I'm still left with my original problem (install.php, cron.php, update.php all hang), but at least I figured out this step.

promes’s picture

promes
Primary language Dutch
commented

I got this error as well with version 5.0.77 on a fresh install while other drupal-databases are running on the same MySQL.
But when I changed from mysql:// to mysqli:// the installation completed without any problem. But it was in total the third attempt.