Comment 6 for bug 1247715

Works for me.

Thank you
Gary

Quoting Aaron Wells <email address hidden>:

> Okay, here's a patch that should resolve the issue:
>
> https://reviews.mahara.org/2688
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/1247715
>
> Title:
> Upgrade to 1.8.0 fails - can't connect to mysql
>
> Status in Mahara ePortfolio:
> Confirmed
>
> Bug description:
> After upgrading to 1.8.0 I couldn't open the admin/upgrade.php page.
> The error displayed stated that mahara could not connect to the mysql
> db. Running on Ubuntu LTS Server.
>
> After some poking around I managed to get things running by altering
> the code in init.php.
>
> The new code read:
>
>     // Transform $CFG->dbtype into the name of the ADODB driver we will use
>     if (is_postgres()) {
>         $CFG->dbtype = 'postgres7';
>     }
>     else if (is_mysql()) {
>         // If they have mysqli, use it. Otherwise, fall back to
> the older "mysql" extension.
>         if (extension_loaded('mysqli')) {
>             $CFG->dbtype = 'mysqli';
>         }
>         else {
>             $CFG->dbtype = 'mysql';
>         }
>     }
>
> I replace this with:
>
>     // Transform $CFG->dbtype into the name of the ADODB driver we will use
>     if (is_postgres()) {
>         $CFG->dbtype = 'postgres7';
>     }
>     else if (is_mysql()) {
>         // If they have mysqli, use it. Otherwise, fall back to
> the older "mysql" extension.
>         //if (extension_loaded('mysqli')) {
>         // $CFG->dbtype = 'mysqli';
>         //}
>         //else {
>         // $CFG->dbtype = 'mysql';
>         //}
>         $CFG->dbtype = 'mysql';
>     }
>
> I also receive the error:
>
> The mysqli PHP extension is not installed on your server. Thus, Mahara
> is falling back to the deprecated original mysql PHP extension. We
> recommend installing mysqli. Trouble is that fallback doesn't seem to
> be working at all.
>
> Fact is mysqli is included with php5-mysql in ubuntu. Mahara doesn't
> seem to see that. Maybe the code that is suppose to detect that in
> init.php blocks connection to the server, stopping mahara from running
> at all.
>
> This does not happen in 1.7.x.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/mahara/+bug/1247715/+subscriptions