-
Sub-task
-
Resolution: Fixed
-
Major
-
1.9
-
None
-
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.