From c1008ae8cb2e9415052229701c325fd114fdbf3b Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Sun, 15 Jan 2017 18:28:20 +0100 Subject: [PATCH] [0003658] Errors during reference line edition when no table prefix is used. --- includes/db/class.reflines_db.inc | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) 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"); -- 2.30.2