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

    • Database:
      PostgreSQL
    • Affected Branches:
      MOODLE_19_STABLE
    • Fixed Branches:
      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

            Assignee:
            skodak Petr Skoda
            Reporter:
            mudrd8mz David Mudrák (@mudrd8mz)
            Tester:
            Eloy Lafuente (stronk7)
            Participants:
            Component watchers:
            Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Fix Release Date:
              15/May/08