Description: | A extrange error displaying transactions in the bank account.
2014-03-04 11:43:40 DEBUG account.php get transactions - sql=SELECT b.rowid, b.dateo as do, b.datev as dv, b.amount, b.label, b.rappro, b.num_releve, b.num_chq, b.fk_type, b.fk_bordereau, ba.rowid as bankid, ba.ref as bankref, ba.label as banklabel FROM llx_bank_account as ba, llx_bank as b WHERE b.fk_account= AND b.fk_account = ba.rowid AND ba.entity = 1 ORDER BY b.datev ASC,b.datec ASC
2014-03-04 11:43:40 WARNING DoliDBMysqli::query SQL error: SELECT b.rowid, b.dateo as do, b.datev as dv, b.amount, b.label, b.rappro, b.num_releve, b.num_chq, b.fk_type, b.fk_bordereau, ba.rowid as bankid, ba.ref as bankref, ba.label as banklabel FROM llx_bank_account as ba, llx_bank as b WHERE b.fk_account= AND b.fk_account = ba.rowid AND ba.entity = 1 ORDER BY b.datev ASC,b.datec ASC DB_ERROR_SYNTAX
2014-03-04 11:43:40 ERR Error url="" query_string=ref=BC001, sql=SELECT b.rowid, b.dateo as do, b.datev as dv, b.amount, b.label, b.rappro, b.num_releve, b.num_chq, b.fk_type, b.fk_bordereau, ba.rowid as bankid, ba.ref as bankref, ba.label as banklabel FROM llx_bank_account as ba, llx_bank as b WHERE b.fk_account= AND b.fk_account = ba.rowid AND ba.entity = 1 ORDER BY b.datev ASC,b.datec ASC, db_error=You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.fk_account = ba.rowid AND ba.entity = 1 ORDER BY b.datev ASC,b.datec ASC' at line 1 |