-
Bug
-
Resolution: Fixed
-
Major
-
1.9
-
None
-
1.9 moodle with a 8.2.4 postgres installed in a SUSE Linux Enterprise Server 10 SP1
-
PostgreSQL
-
MOODLE_19_STABLE
-
MOODLE_19_STABLE
When importing a database preset, there is an SQL error by an uninitialized variable.
The error shows some like this:
ERROR: invalid input syntax for integer: ""
UPDATE mdl_data SET course .....defaultsortdir = '0',editany = '0',notification = '' WHERE id = 9
the error is in the notification variable.
For solve this we must modify the file /moodle/mod/data/lib.php
and put in the function: data_update_instance($data)
this code:
if (empty($data->notification))
before call the function:
if (! update_record('data', $data))
See you