From baa7e47822e02ca4550d1a15092ff1eef20c01b4 Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Wed, 18 Apr 2007 20:34:02 +0000 Subject: [PATCH] MySQL 5.0.12 syntax changed for INNER JOIN (LEFT JOIN) mixed with commas. Line 1381. --- includes/ui/ui_lists.inc | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/includes/ui/ui_lists.inc b/includes/ui/ui_lists.inc index 0946945f..2e61861e 100644 --- a/includes/ui/ui_lists.inc +++ b/includes/ui/ui_lists.inc @@ -1377,7 +1377,7 @@ function gl_all_accounts_list($name, $selected_id, $skip_bank_accounts=false, if ($skip_bank_accounts) $sql = "SELECT ".TB_PREF."chart_master.account_code, ".TB_PREF."chart_master.account_name, ".TB_PREF."chart_types.name - FROM ".TB_PREF."chart_master,".TB_PREF."chart_types LEFT JOIN ".TB_PREF."bank_accounts ON ".TB_PREF."chart_master.account_code=".TB_PREF."bank_accounts.account_code + FROM (".TB_PREF."chart_master,".TB_PREF."chart_types) LEFT JOIN ".TB_PREF."bank_accounts ON ".TB_PREF."chart_master.account_code=".TB_PREF."bank_accounts.account_code WHERE ".TB_PREF."bank_accounts.account_code IS NULL AND ".TB_PREF."chart_master.account_type=".TB_PREF."chart_types.id ORDER BY account_code;"; -- 2.30.2