Uploaded image for project: 'Plugins'
  1. Plugins
  2. CONTRIB-3602

ILP Plugin Status Entry Table - "mdl_block_ilp_plu_sts_ent" doesn't exist



    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 2.1, 2.2
    • Fix Version/s: None
    • Component/s: Package: ILP
    • Labels:
    • Affected Branches:


      This table is not created with HEAD of code on https://github.com/ULCC/moodle-block_ilp(Community Edition)pulled on Tue 17/04/2012. This is either a bug or code yet to be written.

      It seeems that "mdl_block_ilp_plu_sts_ent" doesn't exist in my moodle ilp install, or in ilp_dp.php/install.xml.

      I assume this status_entry table for ILP 2 Reports is the equivalent of 'log status' in ILP 1.0, but the CE doesn't seem to have this 3rd, triumvirate 'Entries' (..._ent) table for this plugin? When time I will investigate. Maybe a simple matter of adding SQL CREATE statement to install?

      Debug info given on Moodle 2.2 on Windows & 2.1 on Linux:

      Table 'moodle.mdl_block_ilp_plu_sts_ent' doesn't exist
      SELECT *
      FROM mdl_block_ilp_plu_rf_sts as s,
      mdl_block_ilp_plu_sts_ent as se
      WHERE se.parent_id = s.id
      AND se.entry_id = 2
      AND s.reportfield_id = 10
      [array (
      Stack trace:
      • line 394 of \lib\dml\moodle_database.php: dml_read_exception thrown
      • line 809 of \lib\dml\mysqli_native_moodle_database.php: call to moodle_database->query_end()
      • line 1297 of \lib\dml\moodle_database.php: call to mysqli_native_moodle_database->get_records_sql()
      • line 987 of \blocks\ilp\db\ilp_db.php: call to moodle_database->get_record_sql()
      • line ? of unknownfile: call to ilp_db_functions->get_entrystatus()
      • line 50 of \blocks\ilp\db\ilp_db.php: call to call_user_func_array()
      • line ? of unknownfile: call to ilp_db->__call()
      • line 287 of \blocks\ilp\classes\form_elements\plugins\ilp_element_plugin_status.php: call to ilp_db->get_entrystatus()
      • line 368 of \blocks\ilp\classes\dashboard\tabs\ilp_dashboard_reports_tab.php: call to ilp_element_plugin_status->view_data()
      • line 106 of \blocks\ilp\classes\dashboard\plugins\ilp_dashboard_main_plugin.php: call to ilp_dashboard_reports_tab->display()
      • line 154 of \blocks\ilp\classes\dashboard\ilp_dashboard_template.php: call to ilp_dashboard_main_plugin->display()
      • line 27 of \blocks\ilp\views\view_main.html: call to ilp_dashboard_template->display_template()
      • line 98 of \blocks\ilp\actions\view_main.php: call to require_once()




            • Votes:
              2 Vote for this issue
              3 Start watching this issue


              • Created: