Installation help

 
 
Picture of Winter Quan
"error reading database" after migration
 

I'm planning to migrate moodle(2.1.1+ (Build: 20110921) ) from windows to Ubuntu.

I used the "source" command to migrate the database, and updated the config.php.

However, the brower said "error reading database" at my first try. Then I used phpmyadmin to repaire the database, it turned out in vain.

Any suggestion?

Thanks quit a lot!

 
Average of ratings: -
Picture of Winter Quan
Re: "error reading database" after migration
 

help!

help!!

 
Average of ratings: -
Picture of Visvanath Ratnaweera
Re: "error reading database" after migration
 
Average of ratings: -
Picture of Winter Quan
Re: "error reading database" after migration
 

Is it a must to turn on the "Maintenance mode"? Even there is no one visiting the website while backuping the mysql database.

 
Average of ratings: -
Picture of Boris Puhanic
Re: "error reading database" after migration
 

I'm having the same kind of problem, several actually, even though I did have maintenance mode turned on before migration.

1. First I got a blank page after login, which seems to have been fixed by increasing memory limit from 32M to 128M in php.ini

2. Now I'm getting this error in IE after login: Coding error detected, it must be fixed by a programmer: moodle_database::update_record_raw() id field must be specified.

3. And these errors in Firefox: Table "config_plugins" does not exist; and Table "context" does not exist.

4. And just now I got an error from cron saying !!! Table "modules" does not exist !!!

Don't know what's going on.  I'm guessing it's something to do with the nameservers not updated fully yet.  So, I'm waiting.

Plus, there seems to be something wrong with phpmyadmin on the server, so I'm waiting for the hosting providers to check that out.

Anyway, had maintenance mode on, but still getting plenty of errors.

 
Average of ratings: -
Picture of Winter Quan
Re: "error reading database" after migration
 

My God!

What shall I do then? Thousands of students are waiting!!!!

 
Average of ratings: -
Picture of Boris Puhanic
Re: "error reading database" after migration
 

I found this in one of the docs on how to determine php/debug errors when you can't login. Add the following lines at the end of config.php, and then try to login again:

ini_set ('display_errors', 'on');
ini_set ('log_errors', 'on');
ini_set ('display_startup_errors', 'on');
ini_set ('error_reporting', E_ALL);
$CFG->debug = DEBUG_ALL;

See if the errors tell you anything more specific.

 
Average of ratings: -
Picture of Winter Quan
Solved
 

Solved.

I used sqldump command instead of phpmyadmin, and everythings worked out smoothly.

Phpadmin is not reliable, I think.

 
Average of ratings: -
Picture of Visvanath Ratnaweera
Re: Solved
Group Particularly helpful Moodlers
Making those "Thousands of students are waiting" happy must be a nice feeling!
smile
 
Average of ratings: -