[Dolibarr-bugtrack] [Bug #881] some errors

[Doliforge]

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

Dolibarr ERP & CRM » Bugs » bug #881

some errors

Dernières modifications

HENRY Florian (fhenry)

07/05/2013 19:00 (Europe/Paris)

https://github.com/Dolibarr/dolibarr/pull/933
https://github.com/FHenry/dolibarr/commit/8c37063541e06646009a3f9186cc0f35517d3267

Changements :

Resolution:

Aucun → Fixed

Répondre

État

Détails
Submitted by:	David A. G. (braito)		Submitted on:	07/05/2013 15:04
Last Modified On:	07/05/2013 18:38
Summary:	some errors
Description:	DoliDBMysqli::query SQL error: SELECT rowid, ref FROM llx_propal WHERE fk_projet is null AND fk_soc= ORDER BY ref DESC DB_ERROR_SYNTAX DoliDBMysqli::query SQL error: SELECT rowid, facnumber as ref FROM llx_facture WHERE fk_projet is null AND fk_soc= ORDER BY ref DESC DB_ERROR_SYNTAX DoliDBMysqli::query SQL error: SELECT rowid, titre as ref FROM llx_facture_rec WHERE fk_projet is null AND fk_soc= ORDER BY ref DESC DB_ERROR_SYNTAX DoliDBMysqli::query SQL error: SELECT rowid, ref FROM llx_commande_fournisseur WHERE fk_projet is null AND fk_soc= ORDER BY ref DESC DB_ERROR_SYNTAX DoliDBMysqli::query SQL error: SELECT rowid, facnumber as ref FROM llx_facture_fourn WHERE fk_projet is null AND fk_soc= ORDER BY ref DESC DB_ERROR_SYNTAX DoliDBMysqli::query SQL error: SELECT rowid, ref FROM llx_contrat WHERE fk_projet is null AND fk_soc= ORDER BY ref DESC DB_ERROR_SYNTAX DoliDBMysqli::query SQL error: SELECT rowid, ref FROM llx_fichinter WHERE fk_projet is null AND fk_soc= ORDER BY ref DESC DB_ERROR_SYNTAX DoliDBMysqli::query SQL error: SELECT id as rowid, label as ref FROM llx_actioncomm WHERE fk_project is null AND fk_soc= ORDER BY ref DESC DB
Step to reproduce bug:
Version:	develop		Category:	Other
Severity:	3		OS Type/Version:
PHP version:			Database type and version:
Etat
Status:	Open		Assigned to:	HENRY Florian (fhenry)
Resolution:	Fixed

Commentaires

HENRY Florian 07/05/2013 19:00

https://github.com/Dolibarr/dolibarr/pull/933
https://github.com/FHenry/dolibarr/commit/8c37063541e06646009a3f9186cc0f35517d3267

David A. G. 07/05/2013 18:38

To reproduce the bug, I go to my projects, and i display a single project (with the invoices, propostals, suppliers orders, ect)
Dolibarr doesn´t crash, but in the dolibarr log, appears this errors

HENRY Florian 07/05/2013 15:27

How do you reproduce this bug ?

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