Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-54542

Listing competency throw exception with oracle db, because of long table names

    XMLWordPrintable

    Details

    • Testing Instructions:
      Hide

      Test to execute on Oracle

      1. As an admin
      2. Create a role 'Reviewer' in which you allow
        • competency:planreview
        • competency:usercompetencyreview
      3. Assign the role to a user A at the system level
      4. Create a framework with 1 competency
      5. Then visit the profile of user B and go to their learning plans
      6. Create a new draft plan, and add the competency to it
      7. Request the review of the competency
      8. Also request the review of the plan
      9. Login as the user A and add the block "Learning plans" to your dashboard if not there already
      10. Confirm that the block lists both competencies and that no errors are displayed
      Show
      Test to execute on Oracle As an admin Create a role 'Reviewer' in which you allow competency:planreview competency:usercompetencyreview Assign the role to a user A at the system level Create a framework with 1 competency Then visit the profile of user B and go to their learning plans Create a new draft plan, and add the competency to it Request the review of the competency Also request the review of the plan Login as the user A and add the block "Learning plans" to your dashboard if not there already Confirm that the block lists both competencies and that no errors are displayed
    • Affected Branches:
      MOODLE_31_STABLE
    • Fixed Branches:
      MOODLE_31_STABLE
    • Pull from Repository:
    • Pull Master Branch:
      MDL-54542-master

      Description

      Following behat fails were observed with oracle db.

      When I log in as "manager1" # /home/rajesh/moodles/im/moodle/admin/tool/lp/tests/behat/plan_workflow.feature:99
            Other backtraces found:
            line 271 of /lib/dml/oci_native_moodle_database.php: call to moodle_database->query_end()
            line 1114 of /lib/dml/oci_native_moodle_database.php: call to oci_native_moodle_database->query_end()
            line 2413 of /competency/classes/api.php: call to oci_native_moodle_database->get_recordset_sql()
            line 77 of /blocks/lp/classes/output/summary.php: call to core_competency()
            line 71 of /blocks/lp/block_lp.php: call to block_lp()
            line 288 of /blocks/moodleblock.class.php: call to block_lp->get_content()
            line 230 of /blocks/moodleblock.class.php: call to block_base->formatted_contents()
            line 976 of /lib/blocklib.php: call to block_base->get_content_for_output()
            line 1028 of /lib/blocklib.php: call to block_manager->create_block_contents()
            line 476 of /lib/outputrenderers.php: call to block_manager->ensure_content_created()
            line 39 of /theme/bootstrapbase/renderers/core_renderer.php: call to core_renderer->standard_head_html()
            line 52 of /theme/clean/layout/columns3.php: call to theme_bootstrapbase_core_renderer->standard_head_html()
            line 1028 of /lib/outputrenderers.php: call to include()
            line 958 of /lib/outputrenderers.php: call to core_renderer->render_page_layout()
            line 164 of /my/index.php: call to core_renderer->header() (Exception)
       
          And I log in as "manager1" # /home/rajesh/moodles/im/moodle/admin/tool/lp/tests/behat/plan_workflow.feature:108
            Other backtraces found:
            line 271 of /lib/dml/oci_native_moodle_database.php: call to moodle_database->query_end()
            line 1114 of /lib/dml/oci_native_moodle_database.php: call to oci_native_moodle_database->query_end()
            line 2413 of /competency/classes/api.php: call to oci_native_moodle_database->get_recordset_sql()
            line 77 of /blocks/lp/classes/output/summary.php: call to core_competency()
            line 71 of /blocks/lp/block_lp.php: call to block_lp()
            line 288 of /blocks/moodleblock.class.php: call to block_lp->get_content()
            line 230 of /blocks/moodleblock.class.php: call to block_base->formatted_contents()
            line 976 of /lib/blocklib.php: call to block_base->get_content_for_output()
            line 1028 of /lib/blocklib.php: call to block_manager->create_block_contents()
            line 476 of /lib/outputrenderers.php: call to block_manager->ensure_content_created()
            line 39 of /theme/bootstrapbase/renderers/core_renderer.php: call to core_renderer->standard_head_html()
            line 52 of /theme/clean/layout/columns3.php: call to theme_bootstrapbase_core_renderer->standard_head_html()
            line 1028 of /lib/outputrenderers.php: call to include()
            line 958 of /lib/outputrenderers.php: call to core_renderer->render_page_layout()
            line 164 of /my/index.php: call to core_renderer->header() (Exception)
       
          And I log in as "manager1" # /home/rajesh/moodles/im/moodle/admin/tool/lp/tests/behat/plan_workflow.feature:120
            Other backtraces found:
            line 271 of /lib/dml/oci_native_moodle_database.php: call to moodle_database->query_end()
            line 1114 of /lib/dml/oci_native_moodle_database.php: call to oci_native_moodle_database->query_end()
            line 2413 of /competency/classes/api.php: call to oci_native_moodle_database->get_recordset_sql()
            line 77 of /blocks/lp/classes/output/summary.php: call to core_competency()
            line 71 of /blocks/lp/block_lp.php: call to block_lp()
            line 288 of /blocks/moodleblock.class.php: call to block_lp->get_content()
            line 230 of /blocks/moodleblock.class.php: call to block_base->formatted_contents()
            line 976 of /lib/blocklib.php: call to block_base->get_content_for_output()
            line 1028 of /lib/blocklib.php: call to block_manager->create_block_contents()
            line 476 of /lib/outputrenderers.php: call to block_manager->ensure_content_created()
            line 39 of /theme/bootstrapbase/renderers/core_renderer.php: call to core_renderer->standard_head_html()
            line 52 of /theme/clean/layout/columns3.php: call to theme_bootstrapbase_core_renderer->standard_head_html()
            line 1028 of /lib/outputrenderers.php: call to include()
            line 958 of /lib/outputrenderers.php: call to core_renderer->render_page_layout()
            line 164 of /my/index.php: call to core_renderer->header() (Exception)
       
          And I log in as "manager1" # /home/rajesh/moodles/im/moodle/admin/tool/lp/tests/behat/plan_workflow.feature:133
            Other backtraces found:
            line 271 of /lib/dml/oci_native_moodle_database.php: call to moodle_database->query_end()
            line 1114 of /lib/dml/oci_native_moodle_database.php: call to oci_native_moodle_database->query_end()
            line 2413 of /competency/classes/api.php: call to oci_native_moodle_database->get_recordset_sql()
            line 77 of /blocks/lp/classes/output/summary.php: call to core_competency()
            line 71 of /blocks/lp/block_lp.php: call to block_lp()
            line 288 of /blocks/moodleblock.class.php: call to block_lp->get_content()
            line 230 of /blocks/moodleblock.class.php: call to block_base->formatted_contents()
            line 976 of /lib/blocklib.php: call to block_base->get_content_for_output()
            line 1028 of /lib/blocklib.php: call to block_manager->create_block_contents()
            line 476 of /lib/outputrenderers.php: call to block_manager->ensure_content_created()
            line 39 of /theme/bootstrapbase/renderers/core_renderer.php: call to core_renderer->standard_head_html()
            line 52 of /theme/clean/layout/columns3.php: call to theme_bootstrapbase_core_renderer->standard_head_html()
            line 1028 of /lib/outputrenderers.php: call to include()
            line 958 of /lib/outputrenderers.php: call to core_renderer->render_page_layout()
            line 164 of /my/index.php: call to core_renderer->header() (Exception)
      

        Attachments

          Activity

            People

            • Assignee:
              fred Frédéric Massart
              Reporter:
              rajeshtaneja Rajesh Taneja
              Peer reviewer:
              Rajesh Taneja
              Integrator:
              Andrew Nicols
              Tester:
              Jake Dallimore
              Participants:
              Component watchers:
              Andrew Nicols, Mathew May, Michael Hawkins, Shamim Rezaie, Simey Lameze, Damyon Wiese, Jean-Philippe Gaudreau, Steve Massicotte, Serge Gauthier, Issam Taboubi, Adrian Greeve, Mihail Geshoski, Peter Dias
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Fix Release Date:
                23/May/16