Dolibarr ERP & CRM » Bugs » bug #1285 error displaying transactionsLatest modifications
Answer now
Snapshot| Details |
| Last Modified On: | 2014-03-15 14:55 | | Submitted by: | braito (braito) |
| Submitted 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: | Need more info | | Assigned to: | HENRY Florian (fhenry) |
| Resolution: | Works for me | |
Comments- Marcos García 2014-06-10 00:00
- The problematic piece is "WHERE b.fk_account= "
The problem is when you try to access a non-existing bank account.
Screenshot is attached.
Because this is the expected behaviour in Dolibarr until we design a common behaviour for non-existing objects, the bug won't be fixed.
- HENRY Florian 2014-03-15 14:55
- I have create two bank account, delete it and delete one of them. Impossible to see the deleted ones on dolibarr nivagation arrow (at the end of ref) and there is no more deleted account
- 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.
|
|
|
|
|
|
|
The problem is when you try to access a non-existing bank account.
Screenshot is attached.
Because this is the expected behaviour in Dolibarr until we design a common behaviour for non-existing objects, the bug won't be fixed.