Issue Details (XML | Word | Printable)

Key: MDL-18738
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Petr Skoda
Reporter: Ralf Krause
Votes: 0
Watchers: 0
Operations

Add/Edit UI Mockup to this issue
If you were logged in you would be able to see more operations.
Moodle

Can't update from Moodle 1.9.4+ to Moodle 2.0

Created: 30/Mar/09 12:06 AM   Updated: 06/Apr/09 03:01 PM
Return to search
Component/s: Administration, Database activity module, General
Affects Version/s: 1.9.4
Fix Version/s: None

File Attachments: None
Image Attachments:

1. macosx-server-10.5.6.png.jpg
(112 kB)
Environment: Mac OS X 10.5.6 Server with PHP 5.2.9

Database: MySQL
Participants: Martin Dougiamas, Petr Skoda and Ralf Krause
Security Level: None
Affected Branches: MOODLE_19_STABLE


 Description  « Hide
I installed Moodle 1.9.4+ (Build: 20090329) on the Mac OS X 10.5.6 Server with PHP 5.2.9.
Please look at http://docs.moodle.org/en/Step_by_Step_Installation_on_a_Mac_OS_X_10.5_Server

 I installed Moodle 1.9.4+ (Build: 20090329) because I wanted to update to Moodle 2.0.
It could be that this problem is the same as I wrote in http://tracker.moodle.org/browse/MDL-18737

Moodle 1.9.4+ works fine but upgrading to Moodle 2.0 does not work. I get the following error message

__________________________________________________________________________________________
|
| Error: Database connection failed
| It is possible that the database is overloaded or otherwise not running properly.
| The site administrator should also check that the database details have been correctly specified in config.php
|__________________________________________________________________________________________

Moodle uses the normal config.php (the names are moodle20 because I want to update)

<?php /// Moodle Configuration File

unset($CFG);

$CFG->dbtype = 'mysql';
$CFG->dbhost = 'localhost';
$CFG->dbname = 'moodle20';
$CFG->dbuser = 'moodle';
$CFG->dbpass = 'moodle!';
$CFG->dbpersist = false;
$CFG->prefix = 'mdl_';

$CFG->wwwroot = 'http://192.168.0.220/moodle20';
$CFG->dirroot = '/Library/WebServer/Documents/moodle20';
$CFG->dataroot = '/Library/WebServer/moodledata/moodle20';
$CFG->admin = 'admin';

$CFG->directorypermissions = 00777; // try 02777 on a server in Safe Mode

require_once("$CFG->dirroot/lib/setup.php");
// MAKE SURE WHEN YOU EDIT THIS FILE THAT THERE ARE NO SPACES, BLANK LINES,
// RETURNS, OR ANYTHING ELSE AFTER THE TWO CHARACTERS ON THE NEXT LINE.
?>




 All   Comments   Change History   Version Control      Sort Order: Ascending order - Click to sort in descending order
Martin Dougiamas added a comment - 30/Mar/09 04:41 PM
any ideas, eloy?

Ralf Krause added a comment - 30/Mar/09 05:12 PM
The server test says that an update should work.

You can look yourself on http://moodle4mac.dyndns.org:8080/moodle19/
Login with admin / 12345 to see the facts yourself.


Petr Skoda added a comment - 06/Apr/09 04:46 AM
Please make sure MySQLi PHP extension is installed, then change your config.php to include
$CFG->dbtype = 'mysqli';

please note the added "i".


Ralf Krause added a comment - 06/Apr/09 03:01 PM
Yes, a few days later I know this fact about mysqli.

I will just change Moodle4Mac but I wonder that I had no problem to update Moodle 2.0 up to the current version without using the mysqli database connection in my Moodle4Mac distribution. I think that the reason was that I did not update from Moodle 1.9 but from Moodle 2.0 (20090130).

At first I thought that Mac OS X 10.5 Server uses the software in a different way such I found this with PHP5 ... the server normally does not use the GD library and there could be a problem with MySQL, too. I think it was only my problem with the configuration in my.ini and the database connection. I will document my settings in the Moodle docs.
http://docs.moodle.org/en/Step_by_Step_Installation_on_a_Mac_OS_X_10.5_Server

Thanks for your support