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

Missing logstore_standard_log table after upgrading Moodle

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Cannot Reproduce
    • Icon: Minor Minor
    • None
    • 4.1.3
    • Database SQL/XMLDB, Logging
    • None
    • MOODLE_401_STABLE

      Trying to upgrade from Moodle 3 to 4.
      I can upgrade from Moodle 3.9 to 4.0.8 with no problems. But everytime I upgrade Moodle from 3.9 to 4.1.3 I keep getting the same error when upgrading either via command line or the GUI. I have even gone the route of upgrade from 3.9 to 4.0.8 and then to 4.1.3 but still the same missing table. 

      !!! DDL sql execution error !!!
      !! Table 'lamp.mdl_logstore_standard_log' doesn't exist
      CREATE INDEX mdl_logsstanlog_use_ix ON mdl_logstore_standard_log (userid)
      Error code: ddlexecuteerror !!
      !! Stack trace: * line 500 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
      * line 293 of /lib/dml/moodle_read_slave_trait.php: call to moodle_database->query_end()
      * line 1103 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->query_end()
      * line 77 of /lib/ddl/database_manager.php: call to mysqli_native_moodle_database->change_database_structure()
      * line 758 of /lib/ddl/database_manager.php: call to database_manager->execute_sql_arr()
      * line 45 of /admin/tool/log/store/standard/db/upgrade.php: call to database_manager->add_key()
      * line 784 of /lib/upgradelib.php: call to xmldb_logstore_standard_upgrade()
      * line 1953 of /lib/upgradelib.php: call to upgrade_plugins()
      * line 202 of /admin/cli/upgrade.php: call to upgrade_noncore()
       !! 

      I can see the table in the database before and see it's missing in the upgrade, But WHY??

      I have made sure my PHP is 7.4 and MariaDB is 10.4

      Current moodle version is 3.9.11.

            Unassigned Unassigned
            jenniferaube Jennifer Aube
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved:

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