From: Janusz Dobrowolski <janusz@frontaccounting.eu>
Date: Sun, 15 Jan 2017 17:28:20 +0000 (+0100)
Subject: [0003658] Errors during reference line edition when no table prefix is used.
X-Git-Tag: v2.4.2~19^2~26
X-Git-Url: https://delta.frontaccounting.com/gitweb/?p=fa-stable.git;a=commitdiff_plain;h=c1008ae8cb2e9415052229701c325fd114fdbf3b

[0003658] Errors during reference line edition when no table prefix is used.
---

diff --git a/includes/db/class.reflines_db.inc b/includes/db/class.reflines_db.inc
index 22c472dc..47976504 100644
--- a/includes/db/class.reflines_db.inc
+++ b/includes/db/class.reflines_db.inc
@@ -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");