This morning, I was cleaning up our Elearning site and was trying to delete a test course I had created. I was getting an error when I tried to delete it so I went a different route and was going to use the “Mass-Action” block to delete all the elements in the course. However, when I did this, the site went down with a very scary database error (Coding error detected, it must be fixed by a programmer: moodle_database::update_record_raw() no fields found.) I had never seen this particular error message. I would have Googled the error message but the Moodle support site was down for maintenance. So, I knew I could not mend the current database. But I did have a database backup from earlier in the morning.
Therefore, I dropped the affected database and created a new one and I restored the last database dump. Now I was getting a “Error reading from database” message. My thought at this point was that perhaps the mass-action block may have messed up something in the Moodle core files so I restored those from a sister site. I also created a new database with a completely different name.
This time it worked and also worked when I went back to using the original Moodle core files. The new database name seemed to have made the difference.
So, all in all, about 4 or 5 hours of work was lost (if indeed anyone was actually on the site during those early morning hours.) The marvelous thing was that I was not panicked during this breakdown and instead of worrying, went directly to God with my request that He guide me and give me wisdom and that He would fix the problem. Praise be to His name for helping me to remember to go to Him immediately instead of as the last resort!
You must be logged in to post a comment.