moodleou / moodle-mod_forumng

ForumNG forum module for Moodle
19 stars 20 forks source link

problem with Forumng #54

Open irith opened 8 years ago

irith commented 8 years ago

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

aspark21 commented 8 years ago

Hi Irith,

Which version of ForumNG are you on? Are you definitely on the latest MOODLE_28_STABLE branch for ForumNG? https://github.com/moodleou/moodle-mod_forumng/tree/MOODLE_28_STABLE

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.

irith commented 8 years ago

THIS is the version I have 2013082000

אירית הרמן - Irith Herman ניהול ופיתוח אתרי אינטרנט Website Manager 052-6070766

2015-11-04 22:12 GMT+02:00 Alistair Spark notifications@github.com:

Hi Irith,

Which version of ForumNG are you on? Are you definitely on the latest MOODLE_28_STABLE branch for ForumNG? https://github.com/moodleou/moodle-mod_forumng/tree/MOODLE_28_STABLE

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 https://github.com/moodleou/moodle-mod_forumng/issues/41 & #43 https://github.com/moodleou/moodle-mod_forumng/issues/43 .

— Reply to this email directly or view it on GitHub https://github.com/moodleou/moodle-mod_forumng/issues/54#issuecomment-153849552 .

aspark21 commented 8 years ago

That's definitely a very out of date version, use this one https://github.com/moodleou/moodle-mod_forumng/archive/MOODLE_28_STABLE.zip

irith commented 8 years ago

I can"t upload the file to my server. I have webmin in the server and when i "m uploading the file I got this

Date: Wed, 4 Nov 2015 21:06:30 GMT Server: MiniServ/1.760 Connection: Close X-Frame-Options: SAMEORIGIN Content-Security-Policy: script-src 'self' 'unsafe-inline'; frame-src 'self' Content-type: text/html; Charset=UTF-8 content-length: 855

<!doctype html public "-//W3C//DTD HTML 3.2 Final//EN">

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: close

Error - Timeout

Waited more than 60 seconds for request data
אירית הרמן - Irith Herman ניהול ופיתוח אתרי אינטרנט Website Manager 052-6070766 2015-11-04 22:32 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 > > — > Reply to this email directly or view it on GitHub > https://github.com/moodleou/moodle-mod_forumng/issues/54#issuecomment-153854135 > .