clean log

Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.0.v20150309-bf26070): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'tenant_2_keruleti.t2.lgif_voucher_no' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Error Code: 1055
Call: SELECT t0.ldgh_id AS a1, t1.jrnl_name AS a2, t1.jrnl_code AS a3, t0.ldgh_voucher_no AS a4, t0.ldgh_voucher_date AS a5, t0.ldgh_booking_period AS a6, t2.lgif_voucher_no AS a7, t2.lgif_voucher_date AS a8, t3.part_name AS a9, t0.ldgh_currency_voucher AS a10, t0.ldgh_currency_bookkeeping AS a11, t0.ldgh_booking_date AS a12, t0.ldgh_exch_rate_date_bookkeeping AS a13, t0.ldgh_business_event_name AS a14, t4.mod_code AS a15, t5.ldgh_id AS a16, t6.ldgh_id AS a17, t7.ldgh_id AS a18, t8.ldgh_id AS a19, t9.ldgh_id AS a20, t3.part_code AS a21, t3.part_registered_address AS a22, t3.part_tax_no AS a23, t3.part_eu_tax_no AS a24, t2.lgif_part_pay_vat AS a25, t0.ldgh_comment AS a26, t2.lgif_vat_statement_date AS a27, t2.lgif_continous_fulfillment AS a28, COUNT(DISTINCT(t10.lgit_currency_voucher)), t11.lgit_id AS a29, SUM((t10.lgit_debit_value_currency_voucher + t10.lgit_credit_value_currency_voucher)) FROM cb_gl_ledger_head t0 LEFT OUTER JOIN cb_gl_ledger_invoice_info t2 ON (t2.ldgh_id = t0.ldgh_id) LEFT OUTER JOIN cb_bd_partner t3 ON (t2.part_id = t3.part_id) LEFT OUTER JOIN cleanbook_master.cb_bd_module t4 ON (t0.ldgh_post_up_module = t4.mod_guid) LEFT OUTER JOIN cb_gl_ledger_postup_item t12 ON (t0.ldgh_id = t12.ldgh_id) LEFT OUTER JOIN cb_gl_financial_account_head t5 ON (t12.fiach_id = t5.ldgh_id) LEFT OUTER JOIN cb_gl_billing_head t6 ON (t12.billh_id = t6.ldgh_id) LEFT OUTER JOIN cb_fa_fixed_asset_event_head t7 ON (t12.fiaeh_id = t7.ldgh_id) LEFT OUTER JOIN cb_ba_budget_head t8 ON (t12.bdgh_id = t8.ldgh_id) LEFT OUTER JOIN cb_gl_ledger_head t9 ON (t0.ldgh_storno = t9.ldgh_id) LEFT OUTER JOIN cb_gl_ledger_item t10 ON ((t10.ldgh_id = t0.ldgh_id) AND (t10.lgit_item_no NOT IN (?,?,?))) LEFT OUTER JOIN cb_gl_ledger_item t11 ON ((t11.ldgh_id = t0.ldgh_id) AND (t11.lgit_item_no = ?)), cb_bd_journal t1 WHERE ((t0.fisy_id = ?) AND (t1.jrnl_id = t0.jrnl_id)) GROUP BY t0.ldgh_id ORDER BY t0.ldgh_voucher_date ASC LIMIT ?, ?
bind => [7 parameters bound]
Query: ReportQuery(referenceClass=LedgerHead sql="SELECT t0.ldgh_id AS a1, t1.jrnl_name AS a2, t1.jrnl_code AS a3, t0.ldgh_voucher_no AS a4, t0.ldgh_voucher_date AS a5, t0.ldgh_booking_period AS a6, t2.lgif_voucher_no AS a7, t2.lgif_voucher_date AS a8, t3.part_name AS a9, t0.ldgh_currency_voucher AS a10, t0.ldgh_currency_bookkeeping AS a11, t0.ldgh_booking_date AS a12, t0.ldgh_exch_rate_date_bookkeeping AS a13, t0.ldgh_business_event_name AS a14, t4.mod_code AS a15, t5.ldgh_id AS a16, t6.ldgh_id AS a17, t7.ldgh_id AS a18, t8.ldgh_id AS a19, t9.ldgh_id AS a20, t3.part_code AS a21, t3.part_registered_address AS a22, t3.part_tax_no AS a23, t3.part_eu_tax_no AS a24, t2.lgif_part_pay_vat AS a25, t0.ldgh_comment AS a26, t2.lgif_vat_statement_date AS a27, t2.lgif_continous_fulfillment AS a28, COUNT(DISTINCT(t10.lgit_currency_voucher)), t11.lgit_id AS a29, SUM((t10.lgit_debit_value_currency_voucher + t10.lgit_credit_value_currency_voucher)) FROM cb_gl_ledger_head t0 LEFT OUTER JOIN cb_gl_ledger_invoice_info t2 ON (t2.ldgh_id = t0.ldgh_id) LEFT OUTER JOIN cb_bd_partner t3 ON (t2.part_id = t3.part_id) LEFT OUTER JOIN cleanbook_master.cb_bd_module t4 ON (t0.ldgh_post_up_module = t4.mod_guid) LEFT OUTER JOIN cb_gl_ledger_postup_item t12 ON (t0.ldgh_id = t12.ldgh_id) LEFT OUTER JOIN cb_gl_financial_account_head t5 ON (t12.fiach_id = t5.ldgh_id) LEFT OUTER JOIN cb_gl_billing_head t6 ON (t12.billh_id = t6.ldgh_id) LEFT OUTER JOIN cb_fa_fixed_asset_event_head t7 ON (t12.fiaeh_id = t7.ldgh_id) LEFT OUTER JOIN cb_ba_budget_head t8 ON (t12.bdgh_id = t8.ldgh_id) LEFT OUTER JOIN cb_gl_ledger_head t9 ON (t0.ldgh_storno = t9.ldgh_id) LEFT OUTER JOIN cb_gl_ledger_item t10 ON ((t10.ldgh_id = t0.ldgh_id) AND (t10.lgit_item_no NOT IN ?)) LEFT OUTER JOIN cb_gl_ledger_item t11 ON ((t11.ldgh_id = t0.ldgh_id) AND (t11.lgit_item_no = ?)), cb_bd_journal t1 WHERE ((t0.fisy_id = ?) AND (t1.jrnl_id = t0.jrnl_id)) GROUP BY t0.ldgh_id ORDER BY t0.ldgh_voucher_date ASC LIMIT ?, ?")