Add-ons
  1. Add-ons
  2. CONTRIB-3220

error in the gradebook when I try to view the scales

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 2.1
    • Fix Version/s: None
    • Component/s: Module: Adobeconnect
    • Labels:
      None
    • Affected Branches:
      MOODLE_21_STABLE
    • Rank:
      23401

      Description

      Hi all,

      I get an error in the gradebook when I try to view the scales section either for a course or in site admin but while I post it here I don't know if its actually related to the Connect module. The error states Field "grade" does not exist in table "adobeconnect" but I haven't finished configuring the adobeconnect module

      If I disable the connect module the error goes away and I can access the scales settings

      I'm using Moodle 2.1+ (Build: 20110713) and the help documentation directs me to this http://docs.moodle.org/20/en/error/moodle/ddlfieldnotexist but that appears to be about the glossary

      Any suggestions as I hope to use the connect module when I upgrade my Connect 8 server to SP2

        Activity

        Hide
        Murphy Wong added a comment -

        I've the same problem on my Moodle 2.1.1. After upgrading to the latest Moodle 2.1.2, the problem persists. Finally, I try adding a field "grade" in the "adobeconnect" table and the scales is resume to normal. I know this is not a good solution but it stops the pain at the moment. I will drop the field before the next upgrade available from the Connect module. Useful SQL below:

        alter table mdl_adobeconnect add grade decimal(10,5) unsigned;

        alter table mdl_adobeconnect drop grade;

        Hope this help...

        Show
        Murphy Wong added a comment - I've the same problem on my Moodle 2.1.1. After upgrading to the latest Moodle 2.1.2, the problem persists. Finally, I try adding a field "grade" in the "adobeconnect" table and the scales is resume to normal. I know this is not a good solution but it stops the pain at the moment. I will drop the field before the next upgrade available from the Connect module. Useful SQL below: alter table mdl_adobeconnect add grade decimal(10,5) unsigned; alter table mdl_adobeconnect drop grade; Hope this help...
        Hide
        Murphy Wong added a comment -

        A better solution is to update file ~moodle/mod/adobeconnect/lib.php function to stop the scale checking in Moodle 1.9 as below

        function adobeconnect_scale_used_anywhere($scaleid) {
        global $DB;

        // for debugging on 24 November 2011
        return false;

        $param = array('grade' => $scaleid);
        if ($scaleid and $DB->record_exists('adobeconnect', $param))

        { return true; }

        else

        { return false; }

        }

        diff lib.php.ori lib.php
        546a547,549
        > // for debugging on 24 November 2011
        > return false;
        >

        Show
        Murphy Wong added a comment - A better solution is to update file ~moodle/mod/adobeconnect/lib.php function to stop the scale checking in Moodle 1.9 as below function adobeconnect_scale_used_anywhere($scaleid) { global $DB; // for debugging on 24 November 2011 return false; $param = array('grade' => $scaleid); if ($scaleid and $DB->record_exists('adobeconnect', $param)) { return true; } else { return false; } } diff lib.php.ori lib.php 546a547,549 > // for debugging on 24 November 2011 > return false; >
        Hide
        Akin Delamarre added a comment -

        Thanks Murphy I will take a look at it. I've been quite busy but I do intend on making some updates to the code.

        Show
        Akin Delamarre added a comment - Thanks Murphy I will take a look at it. I've been quite busy but I do intend on making some updates to the code.
        Hide
        Michael OBrien added a comment -

        Out of interest, which option would you suggest would be the best (most suitable to resolve the problem & less likely to cause upgrade problems for the module later) if I needed to use the module as it stands

        Show
        Michael OBrien added a comment - Out of interest, which option would you suggest would be the best (most suitable to resolve the problem & less likely to cause upgrade problems for the module later) if I needed to use the module as it stands
        Hide
        Akin Delamarre added a comment -

        Hello Michael,

        The solution you posted would be the best in my opinion. That linke of code in ..._scale_used_anywhere should simply return false, but it was left in my accident.

        Adobe's intention for this module was never to have it as a graded module.

        I haven't yet updated the code as I'm quite busy with another project. However, I do plan to release an update of the code.

        Show
        Akin Delamarre added a comment - Hello Michael, The solution you posted would be the best in my opinion. That linke of code in ..._scale_used_anywhere should simply return false, but it was left in my accident. Adobe's intention for this module was never to have it as a graded module. I haven't yet updated the code as I'm quite busy with another project. However, I do plan to release an update of the code.

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development