Cannot find data record in database table course_modules.

The error that you may see if you are currently using Moodle may be seen after cron runs or when heavy access occurs.  The error,

!!! Can not find data record in database table course_modules. !!!

The error is related to heavy transactions and what we believe is caching corrupting the database.

To fix the error, you can run this query:

select modinfo from mdl_course where id = PutYourCourseIDHere;

Below, we use MySQL Workbench to run the query on a course id of 2

mysql workbench




There is also a Moodle plugin that rebuilds all of the site’s cache.


About TCAT Shelbyville IT Department

The Tennessee College of Applied Technology - is one of 46 institutions in the Tennessee Board of Regents System, the seventh largest system of higher education in the nation. This system comprises six universities, fourteen community colleges, and twenty-six Applied Technology Colleges.
This entry was posted in Computers, Education, Information Technology, Linux, Windows and tagged , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s