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

Details

    • PostgreSQL
    • MOODLE_19_STABLE
    • MOODLE_19_STABLE

    Description

      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.

      Attachments

        Activity

          People

            skodak Petr Skoda
            mudrd8mz David Mudrák (@mudrd8mz)
            Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
            Ilya Tregubov, Kevin Percy, Mathew May, Mihail Geshoski, Shamim Rezaie, Adrian Greeve, David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo, David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              15/May/08