Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-13847 backup/restore issues meta
  3. MDL-13393

Empty old_id during an assignment recover throws an error

XMLWordPrintable

    • PostgreSQL
    • MOODLE_19_STABLE
    • MOODLE_19_STABLE

      Error at three places:
      =======================================================
      ERROR: invalid input syntax for integer: ""
      DELETE FROM mdl_backup_ids
      WHERE backup_code = 1202567977 AND
      table_name = 'assignment' AND
      old_id = ''
      ...
      line 451 of backup/lib.php: call to backup_delid()
      ...

      =======================================================
      ERROR: invalid input syntax for integer: ""
      DELETE FROM mdl_backup_ids
      WHERE backup_code = 1202567977 AND
      table_name = 'quiz' AND
      old_id = ''
      ...
      line 451 of backup/lib.php: call to backup_delid()
      ...
      =======================================================
      ERROR: invalid input syntax for integer: ""
      SELECT * FROM mdl_backup_ids WHERE backup_code = '1202567977' AND table_name = 'assignment' AND old_id = '

      ...
      line 32 of mod/assignment/restorelib.php: call to backup_getid()
      ...

      =======================================================

      I do not know if this is problem of dmlib, backup/recovery or assignment module. I will try to look at assignment to realize if empty old_id is allowed during recovery process.

            skodak Petr Skoda
            mudrd8mz David Mudrák (@mudrd8mz)
            Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

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