Details

    • Type: Sub-task Sub-task
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Component/s: moodle.org
    • Labels:
      None
    • Rank:
      44387

      Description

      To-do:

      1. Post in Lounge (Mary) and moodle.org design forum (Helen) to inform everyone
      2. Move all Lounge discussion threads into new Lounge forum in Using Moodle
      3. Hide the Lounge course
      4. Create redirects for http://moodle.org/course/view.php?id=55 and http://moodle.org/mod/forum/view.php?f=934 to the new Lounge forum
      5. Remove Lounge link from http://moodle.org/forums/ and http://moodle.org/support/

      I guess it would be a good plan to test the move first on the moodle.org clone site.

      Some things to consider:

      Looking at scales

      http://moodle.org/grade/edit/scale/index.php?id=5
      http://moodle.org/grade/edit/scale/index.php?id=55

      it seems that both the Lounge and Using Moodle have custom cool scales. I tried making the Lounge custom cool scale into a standard scale but found that I couldn't. Anyway, all Lounge posts when moved need to somehow keep their cool ratings.

      The Lounge also has an experimental redirect scale which is apparently used, though I've not found out where. Any posts rated with this scale do NOT need to keep their ratings when moved.

      Regarding forum subscription, let's go for the simplest solution and just inform everyone that they need to re-subscribe to the Lounge after it has been moved, rather than trying to keep subscription data in the move.

      There are a few Lounge legacy course files http://moodle.org/files/index.php?contextid=55. Perhaps we could keep lounge2.jpg in the Lounge forum introduction and delete the rest? (I don't know where they are used.)

      There used to be a multimedia Jukebox glossary (used together with a random glossary entry block) but I don't know where it went.

      Anything else we need to consider?

        Issue Links

          Activity

          Hide
          Helen Foster added a comment -

          VIP watchers added.

          Show
          Helen Foster added a comment - VIP watchers added.
          Hide
          Mary Cooch added a comment -
          Show
          Mary Cooch added a comment - Message posted in the Lounge http://moodle.org/mod/forum/discuss.php?d=212322
          Hide
          Helen Foster added a comment -

          1. done - http://moodle.org/mod/forum/discuss.php?d=212322 and http://moodle.org/mod/forum/discuss.php?d=212345

          Just noting Visvanath's comment from http://moodle.org/mod/forum/discuss.php?d=212322#p925327

          Did you check all the technical implications, like whether discussion numbers and the references to the post (d=200642 and #p878602 above) are preserved?

          Show
          Helen Foster added a comment - 1. done - http://moodle.org/mod/forum/discuss.php?d=212322 and http://moodle.org/mod/forum/discuss.php?d=212345 Just noting Visvanath's comment from http://moodle.org/mod/forum/discuss.php?d=212322#p925327 Did you check all the technical implications, like whether discussion numbers and the references to the post (d=200642 and #p878602 above) are preserved?
          Hide
          Helen Foster added a comment -

          I found the multimedia jukebox glossary here http://moodle.org/mod/glossary/view.php?id=6828 plus a few hidden activities. After moving all discussion threads from the social forum, the Lounge course can simply be hidden.

          Show
          Helen Foster added a comment - I found the multimedia jukebox glossary here http://moodle.org/mod/glossary/view.php?id=6828 plus a few hidden activities. After moving all discussion threads from the social forum, the Lounge course can simply be hidden.
          Hide
          Dan Poltawski added a comment -

          I think that the safest way to do this is the following. (Trying to think of the gotchas).

          1/ Create a new hidden social forum in using moodle.
          2/ Switch social course to topics (just to make things clearer)
          3/
          UPDATE forum_discussions SET course = [newcourse], forum =[newforum] WHERE course = [oldcourse] AND forum =[oldforum]
          UPDATE forum_subscriptions SET forum = [newforum] WHERE forum = [oldforum]

          With regard to the discussion numbers, these should be retained.

          Show
          Dan Poltawski added a comment - I think that the safest way to do this is the following. (Trying to think of the gotchas). 1/ Create a new hidden social forum in using moodle. 2/ Switch social course to topics (just to make things clearer) 3/ UPDATE forum_discussions SET course = [newcourse] , forum = [newforum] WHERE course = [oldcourse] AND forum = [oldforum] UPDATE forum_subscriptions SET forum = [newforum] WHERE forum = [oldforum] With regard to the discussion numbers, these should be retained.
          Hide
          Dan Poltawski added a comment -

          Ah but that will add forum subscriptions for users who may not be enrolled in using moodle

          Show
          Dan Poltawski added a comment - Ah but that will add forum subscriptions for users who may not be enrolled in using moodle
          Hide
          Dan Poltawski added a comment -

          The scales are going to be tricky:

          mysql> select * from grade_items where scaleid=79;
          +-----+----------+------------+---------------------------+----------+------------+--------------+------------+----------+----------+-------------+-----------+----------+----------+---------+-----------+-----------+------------+------------+-----------------+-----------+---------+----------+--------+--------+----------+-------------+-------------+--------------+
          | id  | courseid | categoryid | itemname                  | itemtype | itemmodule | iteminstance | itemnumber | iteminfo | idnumber | calculation | gradetype | grademax | grademin | scaleid | outcomeid | gradepass | multfactor | plusfactor | aggregationcoef | sortorder | display | decimals | hidden | locked | locktime | needsupdate | timecreated | timemodified |
          +-----+----------+------------+---------------------------+----------+------------+--------------+------------+----------+----------+-------------+-----------+----------+----------+---------+-----------+-----------+------------+------------+-----------------+-----------+---------+----------+--------+--------+----------+-------------+-------------+--------------+
          | 363 |       55 |         35 | Social forum              | mod      | forum      |          934 |          0 | NULL     | 6801     | NULL        |         2 |  6.00000 |  1.00000 |      79 |      NULL |   0.00000 |    1.00000 |    0.00000 |         0.00000 |         2 |       0 |        2 |      0 |      0 |        0 |           0 |  1187158941 |   1248021397 |
          
          Show
          Dan Poltawski added a comment - The scales are going to be tricky: mysql> select * from grade_items where scaleid=79; +-----+----------+------------+---------------------------+----------+------------+--------------+------------+----------+----------+-------------+-----------+----------+----------+---------+-----------+-----------+------------+------------+-----------------+-----------+---------+----------+--------+--------+----------+-------------+-------------+--------------+ | id | courseid | categoryid | itemname | itemtype | itemmodule | iteminstance | itemnumber | iteminfo | idnumber | calculation | gradetype | grademax | grademin | scaleid | outcomeid | gradepass | multfactor | plusfactor | aggregationcoef | sortorder | display | decimals | hidden | locked | locktime | needsupdate | timecreated | timemodified | +-----+----------+------------+---------------------------+----------+------------+--------------+------------+----------+----------+-------------+-----------+----------+----------+---------+-----------+-----------+------------+------------+-----------------+-----------+---------+----------+--------+--------+----------+-------------+-------------+--------------+ | 363 | 55 | 35 | Social forum | mod | forum | 934 | 0 | NULL | 6801 | NULL | 2 | 6.00000 | 1.00000 | 79 | NULL | 0.00000 | 1.00000 | 0.00000 | 0.00000 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 1187158941 | 1248021397 |
          Hide
          Dan Poltawski added a comment -

          Consulted with Petr about this and he pointed out the problem of the files needing context info updating

          Show
          Dan Poltawski added a comment - Consulted with Petr about this and he pointed out the problem of the files needing context info updating
          Hide
          Dan Poltawski added a comment -

          rating - contextid
          posts
          forum_subscriptions
          forum_read - forumid
          forum_track_prefs -forumid
          fetch_activity_grade_items
          files - contextid (intro, post, attachment)

          activity_grades
          activity_grading

          – Course module:
          mysql> select * from course_modules where instance = 934;
          -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

          id course module instance section idnumber added score indent visible visibleold groupmode groupingid groupmembersonly completion completiongradeitemnumber completionview completionexpected availablefrom availableuntil showavailability showdescription

          -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

          6801 55 7 934 1688   1161150687 0 0 1 1 0 0 0 0 NULL 0 0 0 0 0 0

          -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
          1 row in set (0.00 sec)

          – context:
          mysql> select * from context where contextlevel = 70 AND instanceid = 6801;
          ---------------------------------------------

          id contextlevel instanceid path depth

          ---------------------------------------------

          554 70 6801 /50/54/55/554 4

          ---------------------------------------------
          1 row in set (0.00 sec)

          – files

          mysql> select count(id) from files where contextid = 554;
          -----------

          count(id)

          -----------

          1322

          -----------
          1 row in set (0.00 sec)

          select count(id) from rating where contextid = 554;
          -----------

          count(id)

          -----------

          1345

          -----------
          1 row in set (0.06 sec)

          Show
          Dan Poltawski added a comment - rating - contextid posts forum_subscriptions forum_read - forumid forum_track_prefs -forumid fetch_activity_grade_items files - contextid (intro, post, attachment) activity_grades activity_grading – Course module: mysql> select * from course_modules where instance = 934; ----- ------ ------ -------- ------- -------- ---------- ----- ------ ------- ---------- --------- ---------- ---------------- ---------- ------------------------- -------------- ------------------ ------------- -------------- ---------------- ----------------+ id course module instance section idnumber added score indent visible visibleold groupmode groupingid groupmembersonly completion completiongradeitemnumber completionview completionexpected availablefrom availableuntil showavailability showdescription ----- ------ ------ -------- ------- -------- ---------- ----- ------ ------- ---------- --------- ---------- ---------------- ---------- ------------------------- -------------- ------------------ ------------- -------------- ---------------- ----------------+ 6801 55 7 934 1688   1161150687 0 0 1 1 0 0 0 0 NULL 0 0 0 0 0 0 ----- ------ ------ -------- ------- -------- ---------- ----- ------ ------- ---------- --------- ---------- ---------------- ---------- ------------------------- -------------- ------------------ ------------- -------------- ---------------- ----------------+ 1 row in set (0.00 sec) – context: mysql> select * from context where contextlevel = 70 AND instanceid = 6801; ---- ------------ ---------- ------------- ------ id contextlevel instanceid path depth ---- ------------ ---------- ------------- ------ 554 70 6801 /50/54/55/554 4 ---- ------------ ---------- ------------- ------ 1 row in set (0.00 sec) – files mysql> select count(id) from files where contextid = 554; ----------- count(id) ----------- 1322 ----------- 1 row in set (0.00 sec) select count(id) from rating where contextid = 554; ----------- count(id) ----------- 1345 ----------- 1 row in set (0.06 sec)
          Hide
          Dan Poltawski added a comment -

          Lounge
          courseid: 55
          forumid: 934
          cmid: 6801
          contextid: 554
          contextpath: /50/54/55/554

          using moodle
          context path: /50/54/53

          UPDATE forum SET course = 5 where id = 934;
          UPDATE course_modules SET course = 5 WHERE id = 6801;
          UPDATE context SET contextpath = '/50/54/53/554' WHERE id = 554;

          Show
          Dan Poltawski added a comment - Lounge courseid: 55 forumid: 934 cmid: 6801 contextid: 554 contextpath: /50/54/55/554 using moodle context path: /50/54/53 UPDATE forum SET course = 5 where id = 934; UPDATE course_modules SET course = 5 WHERE id = 6801; UPDATE context SET contextpath = '/50/54/53/554' WHERE id = 554;
          Hide
          Dan Poltawski added a comment - - edited

          do:
          UPDATE forum SET course = 5 where id = 934;
          UPDATE forum_discussions SET course = 5 WHERE forum = 934;
          UPDATE course_modules SET course = 5, section = 800 WHERE id = 6801;
          UPDATE context SET path = '/50/54/53/554' WHERE id = 554;
          UPDATE scale SET courseid = 0 WHERE id = 79;
          UPDATE grade_items SET courseid = 5, categoryid = 1 WHERE id = 363;
          UPDATE course_sections SET sequence = '6827,6828,6842,6995,7007' WHERE id = 1688;
          UPDATE course_sections SET sequence = '3930,7211,28,50,6799,2784,596,7301,851,6801' WHERE id = 800;
          UPDATE course SET modinfo = NULL, sectioncache = NULL WHERE id = 55 OR id = 5;

          Undo:
          UPDATE forum SET course = 55 where id = 934;
          UPDATE forum_discussions SET course = 55 WHERE forum = 934;
          UPDATE course_modules SET course = 55, section = 19 WHERE id = 6801;
          UPDATE context SET path = '/50/54/55/554' WHERE id = 554;
          UPDATE scale SET courseid = 55 WHERE id = 79;
          UPDATE grade_items SET courseid = 55, categoryid = 35 WHERE id = 363;
          UPDATE course_sections SET sequence = '6801,6827,6828,6842,6995,7007' WHERE id = 1688;
          UPDATE course_sections SET sequence = '3930,7211,28,50,6799,2784,596,7301,851' WHERE id = 800;
          UPDATE course SET modinfo = NULL, sectioncache = NULL WHERE id = 55 OR id = 5;

          Show
          Dan Poltawski added a comment - - edited do: UPDATE forum SET course = 5 where id = 934; UPDATE forum_discussions SET course = 5 WHERE forum = 934; UPDATE course_modules SET course = 5, section = 800 WHERE id = 6801; UPDATE context SET path = '/50/54/53/554' WHERE id = 554; UPDATE scale SET courseid = 0 WHERE id = 79; UPDATE grade_items SET courseid = 5, categoryid = 1 WHERE id = 363; UPDATE course_sections SET sequence = '6827,6828,6842,6995,7007' WHERE id = 1688; UPDATE course_sections SET sequence = '3930,7211,28,50,6799,2784,596,7301,851,6801' WHERE id = 800; UPDATE course SET modinfo = NULL, sectioncache = NULL WHERE id = 55 OR id = 5; Undo: UPDATE forum SET course = 55 where id = 934; UPDATE forum_discussions SET course = 55 WHERE forum = 934; UPDATE course_modules SET course = 55, section = 19 WHERE id = 6801; UPDATE context SET path = '/50/54/55/554' WHERE id = 554; UPDATE scale SET courseid = 55 WHERE id = 79; UPDATE grade_items SET courseid = 55, categoryid = 35 WHERE id = 363; UPDATE course_sections SET sequence = '6801,6827,6828,6842,6995,7007' WHERE id = 1688; UPDATE course_sections SET sequence = '3930,7211,28,50,6799,2784,596,7301,851' WHERE id = 800; UPDATE course SET modinfo = NULL, sectioncache = NULL WHERE id = 55 OR id = 5;
          Hide
          Dan Poltawski added a comment -

          Helen: I think we are good to test this now

          Show
          Dan Poltawski added a comment - Helen: I think we are good to test this now
          Hide
          Helen Foster added a comment -

          Thanks Dan, testing the moved social forum in the Using Moodle course http://clone.moodle.org/mod/forum/post.php?forum=934 I found that when I tried editing the settings I obtained the following error:

          Can not find data record in database table course_sections.

          More information about this error
          Debug info: SELECT * FROM

          {course_sections}

          WHERE id = ?
          [array (
          0 => '1',
          )]
          Error code: invalidrecord
          Stack trace:

          line 1335 of /lib/dml/moodle_database.php: dml_missing_record_exception thrown
          line 1311 of /lib/dml/moodle_database.php: call to moodle_database->get_record_select()
          line 139 of /course/modedit.php: call to moodle_database->get_record()

          Show
          Helen Foster added a comment - Thanks Dan, testing the moved social forum in the Using Moodle course http://clone.moodle.org/mod/forum/post.php?forum=934 I found that when I tried editing the settings I obtained the following error: Can not find data record in database table course_sections. More information about this error Debug info: SELECT * FROM {course_sections} WHERE id = ? [array ( 0 => '1', )] Error code: invalidrecord Stack trace: line 1335 of /lib/dml/moodle_database.php: dml_missing_record_exception thrown line 1311 of /lib/dml/moodle_database.php: call to moodle_database->get_record_select() line 139 of /course/modedit.php: call to moodle_database->get_record()
          Hide
          Helen Foster added a comment -

          Also, the social forum has 112 subscribers http://clone.moodle.org/mod/forum/subscribers.php?id=934 who may not be enrolled in Using Moodle. Perhaps we should remove ALL subscriptions when the forum is moved?

          Also Settings > Forum administration > Logs throws lots of errors:

          Did you remember to make the first column something unique in your call to get_records? Duplicate value '1' found in column 'course'.

          line 1023 of /lib/dml/mysqli_native_moodle_database.php: call to debugging()
          line 91 of /report/log/locallib.php: call to mysqli_native_moodle_database->get_records_sql()
          line 157 of /report/log/index.php: call to report_log_print_mnet_selector_form()

          Otherwise everything else looks fine and dandy!

          Show
          Helen Foster added a comment - Also, the social forum has 112 subscribers http://clone.moodle.org/mod/forum/subscribers.php?id=934 who may not be enrolled in Using Moodle. Perhaps we should remove ALL subscriptions when the forum is moved? Also Settings > Forum administration > Logs throws lots of errors: Did you remember to make the first column something unique in your call to get_records? Duplicate value '1' found in column 'course'. line 1023 of /lib/dml/mysqli_native_moodle_database.php: call to debugging() line 91 of /report/log/locallib.php: call to mysqli_native_moodle_database->get_records_sql() line 157 of /report/log/index.php: call to report_log_print_mnet_selector_form() Otherwise everything else looks fine and dandy!
          Hide
          Dan Poltawski added a comment -

          Just remembered that I also the upgraded to 2.4, forgetting about this testing, which wasn't so sensible to combine with this!

          Show
          Dan Poltawski added a comment - Just remembered that I also the upgraded to 2.4, forgetting about this testing, which wasn't so sensible to combine with this!
          Hide
          Dan Poltawski added a comment -

          I have fixed the 'debugging' problem.

          Helen and I have agreed that for the best use of time, we just ask people to resubscribe because there are more important jobs than being fancy with this.

          So final step is:

          delete from forum_subscriptions where forum = 934;

          Show
          Dan Poltawski added a comment - I have fixed the 'debugging' problem. Helen and I have agreed that for the best use of time, we just ask people to resubscribe because there are more important jobs than being fancy with this. So final step is: delete from forum_subscriptions where forum = 934;
          Hide
          Dan Poltawski added a comment -

          Helen, as dicussed in the chat, as soon as you are happy with the look of the clone, we can apply this to the real site.

          Show
          Dan Poltawski added a comment - Helen, as dicussed in the chat, as soon as you are happy with the look of the clone, we can apply this to the real site.
          Hide
          Helen Foster added a comment -

          Thanks Dan, the Lounge on the clone looks really fine, can't find anything at all amiss, so I've posted in the moodle.org Lounge informing people that the move is about to happen https://moodle.org/mod/forum/discuss.php?d=217263 and have also added a note to the Lounge introduction.

          Just checking our to-do list, after moving the Lounge, it seems we're just left with

          3. Hide the Lounge course
          4. Create redirects for http://moodle.org/course/view.php?id=55 and http://moodle.org/mod/forum/view.php?f=934 to the new Lounge forum

          Thanks again for your work on this!

          Show
          Helen Foster added a comment - Thanks Dan, the Lounge on the clone looks really fine, can't find anything at all amiss, so I've posted in the moodle.org Lounge informing people that the move is about to happen https://moodle.org/mod/forum/discuss.php?d=217263 and have also added a note to the Lounge introduction. Just checking our to-do list, after moving the Lounge, it seems we're just left with 3. Hide the Lounge course 4. Create redirects for http://moodle.org/course/view.php?id=55 and http://moodle.org/mod/forum/view.php?f=934 to the new Lounge forum Thanks again for your work on this!
          Hide
          Dan Poltawski added a comment -

          Done. Special thanks to Tim & Eloy and helped with this while they were in Perth

          BTW, I think it would be best to delete the lounge course when you are happy, Helen. Since it doesn't have any other content.

          Show
          Dan Poltawski added a comment - Done. Special thanks to Tim & Eloy and helped with this while they were in Perth BTW, I think it would be best to delete the lounge course when you are happy, Helen. Since it doesn't have any other content.
          Hide
          Dan Poltawski added a comment -

          I made a mistake with this change, which removed the partners forum from the course_section sequence.

          It took me a while for this to click, following that I ran the following query to find other inconsistencies:

          SELECT cm.id, s.sequence from course_modules cm JOIN course_sections s ON s.id = cm.section WHERE cm.course = 5 AND NOT sequence like CONCAT('%', cm.id, '%');
          
          Show
          Dan Poltawski added a comment - I made a mistake with this change, which removed the partners forum from the course_section sequence. It took me a while for this to click, following that I ran the following query to find other inconsistencies: SELECT cm.id, s.sequence from course_modules cm JOIN course_sections s ON s.id = cm.section WHERE cm.course = 5 AND NOT sequence like CONCAT('%', cm.id, '%');
          Hide
          Dan Poltawski added a comment -

          After talking to Marina, i've created MDL-37028 to look at whether we should do some integrity checking on this duplciated data.

          Show
          Dan Poltawski added a comment - After talking to Marina, i've created MDL-37028 to look at whether we should do some integrity checking on this duplciated data.
          Hide
          Dan Poltawski added a comment -

          Another oversight now fixed:

          update forum set type = 'general' where id = 934;
          
          Show
          Dan Poltawski added a comment - Another oversight now fixed: update forum set type = 'general' where id = 934;

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development