Details

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

      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?

        Gliffy Diagrams

          Issue Links

            Activity

            Hide
            tsala Helen Foster added a comment -

            VIP watchers added.

            Show
            tsala Helen Foster added a comment - VIP watchers added.
            Hide
            marycooch Mary Cooch added a comment -
            Show
            marycooch Mary Cooch added a comment - Message posted in the Lounge http://moodle.org/mod/forum/discuss.php?d=212322
            Hide
            tsala 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
            tsala 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
            tsala 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
            tsala 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
            poltawski 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
            poltawski 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
            poltawski Dan Poltawski added a comment -

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

            Show
            poltawski Dan Poltawski added a comment - Ah but that will add forum subscriptions for users who may not be enrolled in using moodle
            Hide
            poltawski 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
            poltawski 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
            poltawski Dan Poltawski added a comment -

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

            Show
            poltawski Dan Poltawski added a comment - Consulted with Petr about this and he pointed out the problem of the files needing context info updating
            Hide
            poltawski 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
            poltawski 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
            poltawski 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
            poltawski 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
            poltawski 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
            poltawski 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
            poltawski Dan Poltawski added a comment -

            Helen: I think we are good to test this now

            Show
            poltawski Dan Poltawski added a comment - Helen: I think we are good to test this now
            Hide
            tsala 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
            tsala 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
            tsala 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
            tsala 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
            poltawski 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
            poltawski 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
            poltawski 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
            poltawski 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
            poltawski 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
            poltawski 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
            tsala 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
            tsala 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
            poltawski 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
            poltawski 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
            poltawski 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
            poltawski 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
            poltawski 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
            poltawski 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
            poltawski Dan Poltawski added a comment -

            Another oversight now fixed:

            update forum set type = 'general' where id = 934;

            Show
            poltawski 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