error while trying to access course-related features

error while trying to access course-related features

by Eran Levin -
Number of replies: 2

Hi,

I've recently upgraded my moodle from 2.9 to 3.2.

Anytime I access a page that somehow is related to courses I get these:


×Debug info: Unknown column 'c.enddate' in 'field list'
SELECT c.id,c.category,c.sortorder,c.shortname,c.fullname,c.idnumber,c.startdate,c.enddate,c.visible,c.cacherev,c.summary,c.summaryformat, ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance 
FROM mdl_course c 
JOIN mdl_context ctx ON c.id = ctx.instanceid AND ctx.contextlevel = ? 
WHERE c.id <> ? AND c.category = ? ORDER BY c.sortorder
[array (
0 => 50,
1 => '1',
2 => '5',
)]
Error code: dmlreadexception
×Stack trace:
  • line 479 of /lib/dml/moodle_database.php: dml_read_exception thrown
  • line 1175 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
  • line 947 of /lib/coursecatlib.php: call to mysqli_native_moodle_database->get_records_sql()
  • line 1528 of /lib/coursecatlib.php: call to coursecat::get_course_records()
  • line 1399 of /course/renderer.php: call to coursecat->get_courses()
  • line 1496 of /course/renderer.php: call to core_course_renderer->coursecat_category_content()
  • line 1620 of /course/renderer.php: call to core_course_renderer->coursecat_tree()
  • line 67 of /course/index.php: call to core_course_renderer->course_category()
×Output buffer:

Anyone knows what it is?


Thanks!

Average of ratings: -
In reply to Eran Levin

Re: error while trying to access course-related features

by Eran Levin -

somebody can help me?

In reply to Eran Levin

Re: error while trying to access course-related features

by Eran Levin -

solution has been found, just query this in the database:


alter table mdl_course add enddate bigint;