sammarshallou
commented
10 years ago Thanks for reporting!
I happen to be familiar with this issue (since it was me who removed the availablefrom field). This needs fixing, but our master branch is still relating to Moodle 2.6 until some point in September, so we can't make this change in our codebase for a while. (There's an explanation of our release schedule in my blog from last year: http://learn1.open.ac.uk/mod/oublog/viewpost.php?post=0&u=sm449&time=1369232093 )
sam marshall Leading Technical Developer Information Technology Berrill Level 2
(01908) 655673 Study with the OU :: www.open.ac.uk
-----Original Message----- From: aspark21 [mailto:notifications@github.com] Sent: 20 May 2014 21:09 To: moodleou/moodle-mod_forumng Subject: [moodle-mod_forumng] Moodle 2.7 Issue - course content cannot be displayed (#27)
This seems to be preventing the content of a course from being loaded in Moodle 2.7 if a ForumNG forum has unread posts. Also prevents My Home from loading (this also displays unread posts).
Running Moodle 2.7 & current master branch of forumng
Debug info below:
cm_info::get_custom_data() is deprecated, please use the property cm_info->customdata instead. line 1156 of /lib/modinfolib.php: call to debugging() line 389 of /mod/forumng/mod_forumng.php: call to cm_info->__call() line 389 of /mod/forumng/mod_forumng.php: call to cm_info-
get_custom_data() line 3145 of /mod/forumng/mod_forumng.php: call to mod_forumng::get_type_from_modinfo_info() line 2989 of /mod/forumng/mod_forumng.php: call to mod_forumng::query_forums() line 443 of /mod/forumng/lib.php: call to mod_forumng::get_course_forums() line 1977 of /lib/modinfolib.php: call to mod_forumng_cm_info_view() line 2009 of /lib/modinfolib.php: call to cm_info->call_mod_function() line 1356 of /lib/modinfolib.php: call to cm_info->obtain_view_data() line 1176 of /lib/modinfolib.php: call to cm_info->get_after_link() line 996 of /course/renderer.php: call to cm_info->__get() line 919 of /course/renderer.php: call to core_course_renderer- course_section_cm() line 1088 of /course/renderer.php: call to core_course_renderer- course_section_cm_list_item() line 735 of /course/format/renderer.php: call to core_course_renderer- course_section_cm_list() line 56 of /course/format/topics/format.php: call to format_section_renderer_base->print_multiple_section_page() line 279 of /course/view.php: call to require()
Debug info: Unknown column 'cm.availablefrom' in 'field list'
SELECT f.id as f_id,f.course as f_course,f.name as f_name,f.type as f_type,f.intro as f_intro,f.ratingscale as f_ratingscale,f.ratingfrom as f_ratingfrom,f.ratinguntil as f_ratinguntil,f.grading as f_grading,f.attachmentmaxbytes as f_attachmentmaxbytes,f.reportingemail as f_reportingemail,f.subscription as f_subscription,f.feedtype as f_feedtype,f.feeditems as f_feeditems,f.maxpostsperiod as f_maxpostsperiod,f.maxpostsblock as f_maxpostsblock,f.postingfrom as f_postingfrom,f.postinguntil as f_postinguntil,f.typedata as f_typedata,f.magicnumber as f_magicnumber,f.originalcmid as f_originalcmid,f.shared as f_shared,f.canpostanon as f_canpostanon, cm.id as cm_id,cm.course as cm_course,cm.module as cm_module,cm.instance as cm_instance,cm.section as cm_section,cm.added as cm_added,cm.score as cm_score,cm.indent as cm_indent,cm.visible as cm_visible,cm.visibleold as cm_visibleold,cm.groupmode as cm_groupmode,cm.groupingid as cm_groupingid,cm.idnumber as cm_idnumber,cm.groupmembersonly as cm_groupmembersonly,cm.completion as cm_completion,cm.completiongradeitemnumber as cm_completiongradeitemnumber,cm.completionview as cm_completionview,cm.completionexpected as cm_completionexpected,cm.availablefrom as cm_availablefrom,cm.availableuntil as cm_availableuntil,cm.showavailability as cm_showavailability, c.id as c_id,c.shortname as c_shortname,c.fullname as c_fullname,c.format as c_format, (SELECT COUNT(1) FROM mdl_forumng_discussions cfd WHERE cfd.forumngid = f.id AND cfd.deleted = 0 AND ( ((cfd.timestart = 0 OR cfd.timestart <= ?) AND (cfd.timeend = 0 OR cfd.timeend > ?)) OR (cfd.forumngid = ?) ) ) AS f_numdiscussions, (EXISTS (SELECT 1 FROM mdl_forumng_discussions fd INNER JOIN mdl_forumng_posts fplast ON fd.lastpostid = fplast.id INNER JOIN mdl_forumng_posts fpfirst ON fd.postid = fpfirst.id LEFT JOIN mdl_forumng_read fr ON fd.id = fr.discussionid AND fr.userid = ? WHERE fd.forumngid = f.id AND fplast.modified>? AND ( (fd.groupid IS NULL) OR ((1=0)) OR cm.groupmode = 2 OR (fd.forumngid = ?) ) AND fd.deleted = 0 AND ( ((fd.timestart = 0 OR fd.timestart <= ?) AND (fd.timeend = 0 OR fd.timeend > ?)) OR (fd.forumngid = ?) ) AND ((fplast.edituserid IS NOT NULL AND fplast.edituserid<>?) OR fplast.userid<>?) AND (fr.time IS NULL OR fplast.modified>fr.time) ))AS f_hasunreaddiscussions FROM mdl_forumng f INNER JOIN mdl_course_modules cm ON cm.instance = f.id AND cm.module = (SELECT id from mdl_modules WHERE name = 'forumng') INNER JOIN mdl_course c ON c.id = f.course WHERE f.course = ? AND cm.id = ? ORDER BY LOWER(f.name) [array ( 0 => 1400616012, 1 => 1400616012, 2 => '2', 3 => '9', 4 => 1395432012, 5 => '2', 6 => 1400616012, 7 => 1400616012, 8 => '2', 9 => '9', 10 => '9', 11 => '11', 12 => '118', )] Error code: dmlreadexception Stack trace: line 443 of /lib/dml/moodle_database.php: dml_read_exception thrown line 1014 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end() line 3263 of /mod/forumng/mod_forumng.php: call to mysqli_native_moodle_database->get_records_sql() line 2989 of /mod/forumng/mod_forumng.php: call to mod_forumng::query_forums() line 443 of /mod/forumng/lib.php: call to mod_forumng::get_course_forums() line 1977 of /lib/modinfolib.php: call to mod_forumng_cm_info_view() line 2009 of /lib/modinfolib.php: call to cm_info->call_mod_function() line 1356 of /lib/modinfolib.php: call to cm_info->obtain_view_data() line 1176 of /lib/modinfolib.php: call to cm_info->get_after_link() line 996 of /course/renderer.php: call to cm_info->__get() line 919 of /course/renderer.php: call to core_course_renderer-
course_section_cm() line 1088 of /course/renderer.php: call to core_course_renderer- course_section_cm_list_item() line 735 of /course/format/renderer.php: call to core_course_renderer- course_section_cm_list() line 56 of /course/format/topics/format.php: call to format_section_renderer_base->print_multiple_section_page() line 279 of /course/view.php: call to require()
— Reply to this email directly or view it on GitHub https://github.com/moodleou/moodle-mod_forumng/issues/27 . https://github.com/notifications/beacon/68663__eyJzY29wZSI6Ik5ld3NpZX M6QmVhY29uIiwiZXhwaXJlcyI6MTcxNjIzNTc0MCwiZGF0YSI6eyJpZCI6MzI2O DM5Mzl9fQ==--15a6bf323c45cb57ea840438b4ca740e35190265.gif
-- The Open University is incorporated by Royal Charter (RC 000391), an exempt charity in England & Wales and a charity registered in Scotland (SC 038302). The Open University is authorised and regulated by the Financial Conduct Authority.
aspark21
colinmackinlay
nadavkav
jason-platts
This seems to be preventing the content of a course from being loaded in Moodle 2.7 if a ForumNG forum has unread posts. Also prevents My Home from loading (this also displays unread posts).
Running Moodle 2.7 & current master branch of forumng
Debug info below:
cm_info::get_custom_data() is deprecated, please use the property cm_info->customdata instead. line 1156 of /lib/modinfolib.php: call to debugging() line 389 of /mod/forumng/mod_forumng.php: call to cm_info->call() line 389 of /mod/forumng/mod_forumng.php: call to cm_info->get_custom_data() line 3145 of /mod/forumng/mod_forumng.php: call to mod_forumng::get_type_from_modinfo_info() line 2989 of /mod/forumng/mod_forumng.php: call to mod_forumng::query_forums() line 443 of /mod/forumng/lib.php: call to mod_forumng::get_course_forums() line 1977 of /lib/modinfolib.php: call to mod_forumng_cm_info_view() line 2009 of /lib/modinfolib.php: call to cm_info->call_mod_function() line 1356 of /lib/modinfolib.php: call to cm_info->obtain_view_data() line 1176 of /lib/modinfolib.php: call to cm_info->get_after_link() line 996 of /course/renderer.php: call to cm_info->get() line 919 of /course/renderer.php: call to core_course_renderer->course_section_cm() line 1088 of /course/renderer.php: call to core_course_renderer->course_section_cm_list_item() line 735 of /course/format/renderer.php: call to core_course_renderer->course_section_cm_list() line 56 of /course/format/topics/format.php: call to format_section_renderer_base->print_multiple_section_page() line 279 of /course/view.php: call to require()
Debug info: Unknown column 'cm.availablefrom' in 'field list'
SELECT f.id as f_id,f.course as f_course,f.name as f_name,f.type as f_type,f.intro as f_intro,f.ratingscale as f_ratingscale,f.ratingfrom as f_ratingfrom,f.ratinguntil as f_ratinguntil,f.grading as f_grading,f.attachmentmaxbytes as f_attachmentmaxbytes,f.reportingemail as f_reportingemail,f.subscription as f_subscription,f.feedtype as f_feedtype,f.feeditems as f_feeditems,f.maxpostsperiod as f_maxpostsperiod,f.maxpostsblock as f_maxpostsblock,f.postingfrom as f_postingfrom,f.postinguntil as f_postinguntil,f.typedata as f_typedata,f.magicnumber as f_magicnumber,f.originalcmid as f_originalcmid,f.shared as f_shared,f.canpostanon as f_canpostanon, cm.id as cm_id,cm.course as cm_course,cm.module as cm_module,cm.instance as cm_instance,cm.section as cm_section,cm.added as cm_added,cm.score as cm_score,cm.indent as cm_indent,cm.visible as cm_visible,cm.visibleold as cm_visibleold,cm.groupmode as cm_groupmode,cm.groupingid as cm_groupingid,cm.idnumber as cm_idnumber,cm.groupmembersonly as cm_groupmembersonly,cm.completion as cm_completion,cm.completiongradeitemnumber as cm_completiongradeitemnumber,cm.completionview as cm_completionview,cm.completionexpected as cm_completionexpected,cm.availablefrom as cm_availablefrom,cm.availableuntil as cm_availableuntil,cm.showavailability as cm_showavailability, c.id as c_id,c.shortname as c_shortname,c.fullname as c_fullname,c.format as c_format, (SELECT COUNT(1) FROM mdl_forumng_discussions cfd WHERE cfd.forumngid = f.id AND cfd.deleted = 0 AND ( ((cfd.timestart = 0 OR cfd.timestart <= ?) AND (cfd.timeend = 0 OR cfd.timeend > ?)) OR (cfd.forumngid = ?) ) ) AS f_numdiscussions, (EXISTS (SELECT 1 FROM mdl_forumng_discussions fd INNER JOIN mdl_forumng_posts fplast ON fd.lastpostid = fplast.id INNER JOIN mdl_forumng_posts fpfirst ON fd.postid = fpfirst.id LEFT JOIN mdl_forumng_read fr ON fd.id = fr.discussionid AND fr.userid = ? WHERE fd.forumngid = f.id AND fplast.modified>? AND ( (fd.groupid IS NULL) OR ((1=0)) OR cm.groupmode = 2 OR (fd.forumngid = ?) ) AND fd.deleted = 0 AND ( ((fd.timestart = 0 OR fd.timestart <= ?) AND (fd.timeend = 0 OR fd.timeend > ?)) OR (fd.forumngid = ?) ) AND ((fplast.edituserid IS NOT NULL AND fplast.edituserid<>?) OR fplast.userid<>?) AND (fr.time IS NULL OR fplast.modified>fr.time) ))AS f_hasunreaddiscussions FROM mdl_forumng f INNER JOIN mdl_course_modules cm ON cm.instance = f.id AND cm.module = (SELECT id from mdl_modules WHERE name = 'forumng') INNER JOIN mdl_course c ON c.id = f.course WHERE f.course = ? AND cm.id = ? ORDER BY LOWER(f.name) [array ( 0 => 1400616012, 1 => 1400616012, 2 => '2', 3 => '9', 4 => 1395432012, 5 => '2', 6 => 1400616012, 7 => 1400616012, 8 => '2', 9 => '9', 10 => '9', 11 => '11', 12 => '118', )] Error code: dmlreadexception Stack trace: line 443 of /lib/dml/moodle_database.php: dml_read_exception thrown line 1014 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end() line 3263 of /mod/forumng/mod_forumng.php: call to mysqli_native_moodle_database->get_records_sql() line 2989 of /mod/forumng/mod_forumng.php: call to mod_forumng::query_forums() line 443 of /mod/forumng/lib.php: call to mod_forumng::get_course_forums() line 1977 of /lib/modinfolib.php: call to mod_forumng_cm_info_view() line 2009 of /lib/modinfolib.php: call to cm_info->call_mod_function() line 1356 of /lib/modinfolib.php: call to cm_info->obtain_view_data() line 1176 of /lib/modinfolib.php: call to cm_info->get_after_link() line 996 of /course/renderer.php: call to cm_info->__get() line 919 of /course/renderer.php: call to core_course_renderer->course_section_cm() line 1088 of /course/renderer.php: call to core_course_renderer->course_section_cm_list_item() line 735 of /course/format/renderer.php: call to core_course_renderer->course_section_cm_list() line 56 of /course/format/topics/format.php: call to format_section_renderer_base->print_multiple_section_page() line 279 of /course/view.php: call to require()