MDL-24339 fix for old mysql invalid NULLs in resource options field

diff --git a/mod/resource/db/upgradelib.php b/mod/resource/db/upgradelib.php
index 28ac6dd..df04b0c 100644 (file)
--- a/mod/resource/db/upgradelib.php
+++ b/mod/resource/db/upgradelib.php
@@ -202,9 +202,11 @@ function resource_20_prepare_migration() {
         return true;
     }
 
-    // fix invalid NULL popup data in old mysql databases
+    // fix invalid NULL popup and options data in old mysql databases
     $sql = "UPDATE {resource} SET popup = ? WHERE popup IS NULL";
     $DB->execute($sql, array($DB->sql_empty()));
+    $sql = "UPDATE {resource} SET options = ? WHERE options IS NULL";
+    $DB->execute($sql, array($DB->sql_empty()));
 
     // Adding fields to table resource_old
     $table->add_field('id', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, XMLDB_SEQUENCE, null);