[0000494] Cannot set second company pref when setup System and General GL

diff --git a/CHANGELOG.txt b/CHANGELOG.txt
index c38a6b7f97d550a012ac9abee9882d6e833a931a..3d2a021909d2fd71e9ca26222885deea8b09abac 100644 (file)
--- a/CHANGELOG.txt
+++ b/CHANGELOG.txt
@@ -19,6 +19,9 @@ Legend:
 ! -> Note
 $ -> Affected files
 
+17-Jan-2011 Joe Hunt
+# [0000494] Cannot set second company pref when setup System and General GL 
+$ /admin/db/company_db.inc
 
 12-Jan-2011 Janusz Dobrowolski
 + Added access extensions hook method, cleanup

diff --git a/admin/db/company_db.inc b/admin/db/company_db.inc
index 0a01a7c493c7048fae374606ea6d520b11ee9b4b..b3339053640565e13d49430baa629385e2caca36 100644 (file)
--- a/admin/db/company_db.inc
+++ b/admin/db/company_db.inc
@@ -78,8 +78,8 @@ function get_company_prefs($tbpref = TB_PREF)
 
 function set_company_pref($pref, $category, $type, $length, $value)
 {
-       $sql = "REPLACE `0_sys_prefs` SET `name`=".db_escape($pref).", `category`=".db_escape($category)
-               .", `type`=".db_escape($type).", `length`=".db_escape($length).", `value`=".db_escape($value);
+       $sql = "REPLACE ".TB_PREF."sys_prefs SET name=".db_escape($pref).", category=".db_escape($category)
+               .", type=".db_escape($type).", length=".db_escape($length).", value=".db_escape($value);
        return db_query($sql, "cannot set company pref");
 }