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

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

XMLWordPrintable

    • MOODLE_31_STABLE
    • MOODLE_31_STABLE
    • MDL-54542-master
    • 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

      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)
      

            fred Frédéric Massart
            rajeshtaneja Rajesh Taneja
            Rajesh Taneja Rajesh Taneja
            Andrew Lyons Andrew Lyons
            Jake Dallimore Jake Dallimore
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.