From d730d7f2c396675a4f110b678550e33522a6c288 Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Mon, 27 Dec 2010 11:40:46 +0000 Subject: [PATCH] [0000356] Databse error on error voiding fixed. --- admin/db/transactions_db.inc | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) diff --git a/admin/db/transactions_db.inc b/admin/db/transactions_db.inc index 594c34d2..0233bc50 100644 --- a/admin/db/transactions_db.inc +++ b/admin/db/transactions_db.inc @@ -50,9 +50,8 @@ function get_sql_for_view_transactions($filtertype, $from, $to, &$trans_ref) elseif ($type_name != null) $sql .= " AND t.`$type_name` = ".db_escape($filtertype); - $sql .= " GROUP BY t.$type_name, t.$trans_no_name"; + $sql .= " GROUP BY ".($type_name ? "t.$type_name," : '')." t.$trans_no_name"; $sql .= " ORDER BY t.$trans_no_name"; - return $sql; } -- 2.30.2