From 2c8036f5ea6310585af2238ff3f433273e5519bb Mon Sep 17 00:00:00 2001
From: Janusz Dobrowolski <janusz@frontaccounting.eu>
Date: Wed, 18 Sep 2013 15:28:00 +0200
Subject: [PATCH] Printer Profiles: fixed sql error on update under some MySQL
 versions.

---
 admin/db/printers_db.inc | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/admin/db/printers_db.inc b/admin/db/printers_db.inc
index 43e13b4c..d6c44c29 100644
--- 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)
-- 
2.30.2