Printer Profiles: fixed sql error on update under some MySQL versions.

[fa-stable.git] / admin / db / printers_db.inc

diff --git a/admin/db/printers_db.inc b/admin/db/printers_db.inc
index 43e13b4c9bbd1c016e241e35d9dc46f346538634..d6c44c2901b19163a8d35cf76399631da2b8e364 100644 (file)
--- a/admin/db/printers_db.inc
+++ b/admin/db/printers_db.inc
@@ -57,7 +57,7 @@ function update_printer_profile($name, $dest)
                        ."(profile, report, printer) VALUES ("
                        .db_escape($name).","
                        .db_escape($rep).","
-                       .db_escape($printer).")";
+                       .db_escape($printer ? $printer: null, true).")";
                } else {
                        $sql = "DELETE FROM ".TB_PREF."print_profiles WHERE ("
                                ."report=" . db_escape($rep)