[Dolibarr-bugtrack] [Bug #1285] error displaying transactions

[Doliforge]

Ce message ne s'affiche pas correctement? mettez à jour vos préférences utilisateur.

Dolibarr ERP & CRM » Bugs » bug #1285

error displaying transactions

Dernières modifications

HENRY Florian (fhenry)

15/03/2014 14:55 (Europe/Paris)

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

Changements :

Status:	Open → Need more info
Assigned to:	Aucun → HENRY Florian (fhenry)
Resolution:	Aucun → Works for me

Répondre

État

Détails
Last Modified On:	04/03/2014 12:27		Submitted by:	braito (braito)
Submitted on:	04/03/2014 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:
Etat
Status:	Need more info		Assigned to:	HENRY Florian (fhenry)
Resolution:	Works for me

Commentaires

HENRY Florian 15/03/2014 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 04/03/2014 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.

 Lien direct vers l'artefact  |  Mettre à jour vos préférences