[0003658] Errors during reference line edition when no table prefix is used.
authorJanusz Dobrowolski <janusz@frontaccounting.eu>
Sun, 15 Jan 2017 17:28:20 +0000 (18:28 +0100)
committerJanusz Dobrowolski <janusz@frontaccounting.eu>
Sun, 15 Jan 2017 17:31:42 +0000 (18:31 +0100)
includes/db/class.reflines_db.inc

index 22c472dc88df2262d1e000fc435b55e910033ded..47976504a550f29cbbaa7f5db4f4bf7993221d5c 100644 (file)
@@ -79,12 +79,12 @@ class reflines_db extends data_set {
        {
 
                $sql = "SELECT *
-                       FROM (SELECT r.* FROM 0_refs r 
+                       FROM (SELECT r.* FROM ".TB_PREF."refs r 
                                LEFT JOIN ".TB_PREF."voided as v
                                        ON r.id=v.id AND r.type=v.type
                                WHERE r.type=".db_escape($trans_type)." AND ISNULL(v.id)
                                ) ref
-                       LEFT JOIN 0_reflines line ON ref.type=line.trans_type AND substr(ref.reference,1, LENGTH(line.prefix))= line.prefix AND line.prefix<>''
+                       LEFT JOIN ".TB_PREF."reflines line ON ref.type=line.trans_type AND substr(ref.reference,1, LENGTH(line.prefix))= line.prefix AND line.prefix<>''
                        WHERE ".($prefix == '' ? "ISNULL(prefix)" : "prefix=".db_escape($prefix));
 
                $res = db_query($sql, "cannot check reference line");