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

Upgrading from 4.5.4 to 5.0 error : Duplicate value '53' found in column 'id'

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Not a bug
    • Icon: Minor Minor
    • None
    • 5.0
    • Tasks
    • None
    • MOODLE_500_STABLE

      After upgrading from 4.5.4 to 5.0, I got this error messagem when acessing ".../admin/tool/task/scheduledtasks.php":

      Did you remember to make the first column something unique in your call to get_records? Duplicate value '53' found in column 'id'.

      line 1066 of /lib/dml/pgsql_native_moodle_database.php: call to debugging()
      line 1507 of /lib/dml/moodle_database.php: call to pgsql_native_moodle_database->get_records_sql()
      line 1458 of /lib/dml/moodle_database.php: call to moodle_database->get_records_select()
      line 647 of /lib/classes/task/manager.php: call to moodle_database->get_records()
      line 105 of /admin/tool/task/scheduledtasks.php: call to core\task\manager::get_all_scheduled_tasks()

      Did you remember to make the first column something unique in your call to get_records? Duplicate value '53' found in column 'id'.

      line 1066 of /lib/dml/pgsql_native_moodle_database.php: call to debugging()
      line 1678 of /lib/dml/moodle_database.php: call to pgsql_native_moodle_database->get_records_sql()
      line 1650 of /lib/dml/moodle_database.php: call to moodle_database->get_record_sql()
      line 1629 of /lib/dml/moodle_database.php: call to moodle_database->get_record_select()
      line 506 of /lib/classes/task/manager.php: call to moodle_database->get_record()
      line 621 of /lib/classes/task/manager.php: call to core\task\manager::get_scheduled_task()
      line 401 of /admin/tool/task/renderer.php: call to core\task\manager::get_default_scheduled_task()
      line 106 of /admin/tool/task/scheduledtasks.php: call to tool_task_renderer->scheduled_tasks_table()

      ------------------
      Moodle 5.0
      PHP 8.3
      PostgreSQL 16
      Ubuntu 20.04

            Unassigned Unassigned
            caiado Ricardo Caiado
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved:

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