Dolibarr ERP & CRM » Bugs » bug #1285 error displaying transactionsLatest modifications
Answer now
Snapshot| Details |
| Submitted by: | braito (braito) | | Submitted on: | 2014-03-04 11:49 |
| Last Modified On: | 2014-03-04 11:49 | |
| Summary: | error displaying transactions |
| 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 |
| Step to reproduce bug: | Just changing to the page before in the bank account |
| Detected in version: | 3.5.0 | | Category: | Module: Banks and Cash |
| Severity: | 2 | | OS Type/Version: | |
| PHP version: | | | Database type and version: | |
| Status |
| Status: | Open | | Assigned to: | None |
| Resolution: | None | |
Comments- braito 2014-03-04 12:27
- ok, I think I found the problem
I had a previously account that I ereased but still in the data base list.
Then when i swap between accounts, display the error.
|
|
|
|
|
|
|
I had a previously account that I ereased but still in the data base list.
Then when i swap between accounts, display the error.