problem with Forumng #54
Comments
|
Hi Irith, Which version of ForumNG are you on? We have it running in a variety of Moodle 2.8 & 2.9 sites without issues currently, this message seems similar to a couple of old issues #41 & #43 which have been resolved. |
|
THIS is the version I have אירית הרמן - Irith Herman 2015-11-04 22:12 GMT+02:00 Alistair Spark notifications@github.com:
|
|
That's definitely a very out of date version, use this one https://github.com/moodleou/moodle-mod_forumng/archive/MOODLE_28_STABLE.zip |
|
I can"t upload the file to my server. Date: Wed, 4 Nov 2015 21:06:30 GMT <!doctype html public "-//W3C//DTD HTML 3.2 Final//EN"> <script> var rowsel = new Array(); </script> <script type='text/javascript' src='/unauthenticated/sorttable.js'></script> <title></title> HTTP/1.0 400 Timeout Server: MiniServ/1.760 Date: Wed, 4 Nov 2015 21:06:30 GMT Content-type: text/html; Charset=iso-8859-1 Connection: closeError - TimeoutWaited more than 60 seconds for request data אירית הרמן - Irith Herman 2015-11-04 22:32 GMT+02:00 Alistair Spark notifications@github.com:
|
Hi
I upgraded my moodle to 2.8.8 from 2.5/
I don"t know if this couse the problem I have now.
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,
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.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 => 1446660665,
1 => 1446660665,
2 => '145',
3 => '3',
4 => 1441476665,
5 => '145',
6 => 1446660665,
7 => 1446660665,
8 => '145',
9 => '3',
10 => '3',
11 => '398',
12 => '32641',
)]
Error code: dmlreadexception
Stack trace:
line 443 of /lib/dml/moodle_database.php: dml_read_exception thrown
line 1080 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
line 3204 of /mod/forumng/mod_forumng.php: call to mysqli_native_moodle_database->get_records_sql()
line 2930 of /mod/forumng/mod_forumng.php: call to mod_forumng::query_forums()
line 425 of /mod/forumng/lib.php: call to mod_forumng::get_course_forums()
line 2020 of /lib/modinfolib.php: call to mod_forumng_cm_info_view()
line 2052 of /lib/modinfolib.php: call to cm_info->call_mod_function()
line 1353 of /lib/modinfolib.php: call to cm_info->obtain_view_data()
line 1165 of /lib/modinfolib.php: call to cm_info->get_after_link()
line 993 of /course/renderer.php: call to cm_info->__get()
line 916 of /course/renderer.php: call to core_course_renderer->course_section_cm()
line 1085 of /course/renderer.php: call to core_course_renderer->course_section_cm_list_item()
line 767 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 281 of /course/view.php: call to require()
Irith
The text was updated successfully, but these errors were encountered: