dolibarr-bugtrack
[Top][All Lists]
Advanced
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Dolibarr-bugtrack] [Bug #1406] Impossible de modifier une facture fourn

From: Doliforge
Subject: [Dolibarr-bugtrack] [Bug #1406] Impossible de modifier une facture fournisseur
Date: Thu, 29 May 2014 20:41:19 +0200
Doliforge
Is this email not displaying correctly?
update email preferences.
Dolibarr ERP & CRM » Bugs » bug #1406

Impossible de modifier une facture fournisseur

Latest modifications

Laurent Destailleur (eldy)
2014-05-29 20:41 (Europe/Paris)
The bug has been corrected inside GIT sources
(http://www.github.com/Dolibarr/dolibarr).

So fix should be available with next stable release.
Changes:
  • Resolution: 
 None → Fixed

Answer now

Snapshot

 Details
Submitted by:  damien clochard (daamien) Submitted on:  2014-05-21 12:41
Last Modified On:  2014-05-26 15:37 
Summary:  Impossible de modifier une facture fournisseur
Description:  -------------------------

Dolibarr a détecté une erreur technique.
Voici les informations qui pourront aider au diagnostic:
Date: 20140521123141
Dolibarr: 3.5.2
Niveau de fonctionnalités: 0
PHP: 5.4.4-14+deb7u9
Server: Apache/2.2.22 (Debian)

Url sollicitée: /fourn/facture/fiche.php?id=3761
Referer: https://erp.dalibo.info/fourn/facture/fiche.php?action="">
Gestionnaire de menu: eldy_menu.php

Type gestionnaire de base de données: pgsql
Requête dernier accès en base en erreur: UPDATE llx_facture_fourn SET ref='(PROV3761)', ref_supplier='Frais transfert etranger', entity=1, type=0, fk_soc=377, datec='2014-05-21 11:02:14', datef='2014-05-22 12:00:00', tms='2014-05-21 12:31:32', libelle='Frais tenue compte trimestriel', paye=0, amount=0.00000000, remise=0.00000000, close_code=null, close_note=null, tva=0.00000000, localtax1=null, localtax2=null, total=0.00000000, total_ht=35.00000000, total_tva=0.00000000, total_ttc=35.00000000, fk_statut=0, fk_user_author=16, fk_user_valid=null, fk_facture_source=null, fk_projet=null, fk_cond_reglement=null, date_lim_reglement=null, note_private='', note_public='', model_pdf=null, import_key=null WHERE rowid=3761
Code retour dernier accès en base en erreur: DB_ERROR_23502
Information sur le dernier accès en base en erreur: ERROR: 23502: null value in column "fk_cond_reglement" violates not-null constraint DETAIL: Failing row contains (3761, Frais transfert etranger, 1, null, 0, 377, 2014-05-21 11:02:14, 2014-05-22, 2014-05-21 12:31:41.527045, Frais tenue compte trimestriel, 0, 0.00000000, 0.00000000, null, null, 0.00000000, null, null, 0.00000000, 35.00000000, 0.00000000, 35.00000000, 0, 16, null, null, null, null, null, , , null, null, null, (PROV3761), 2). LOCATION: ExecConstraints, execMain.c:1611

Message: Error ERROR: 23502: null value in column "fk_cond_reglement" violates not-null constraint DETAIL: Failing row contains (3761, Frais transfert etranger, 1, null, 0, 377, 2014-05-21 11:02:14, 2014-05-22, 2014-05-21 12:31:41.527045, Frais tenue compte trimestriel, 0, 0.00000000, 0.00000000, null, null, 0.00000000, null, null, 0.00000000, 35.00000000, 0.00000000, 35.00000000, 0, 16, null, null, null, null, null, , , null, null, null, (PROV3761), 2). LOCATION: ExecConstraints, execMain.c:1611
Step to reproduce bug:  1- créer une facture fournisseur

2- modifier un champs (par exemple la date)

3- cliquer sur modifier
Detected in version:  3.5.2 Category:  Module: Supplier Invoice
Severity:  9 - Blocking - Critical OS Type/Version:  
PHP version:   Database type and version:  pgsql
 Status
Status:  Open Assigned to:  HENRY Florian (fhenry)
Resolution:  Fixed 

Comments

Laurent Destailleur 2014-05-29 20:41
The bug has been corrected inside GIT sources
(http://www.github.com/Dolibarr/dolibarr).

So fix should be available with next stable release.
damien clochard 2014-05-26 15:37

I think you mean :

ALTER TABLE llx_facture_fourn ALTER COLUMN fk_mode_reglement SET DEFAULT NULL;
damien clochard 2014-05-26 15:34

These 2 lines are not compatible with PostgreSQL


The following line fix the issue:

ALTER TABLE llx_facture_fourn ALTER COLUMN fk_cond_reglement DROP NOT NULL;


HENRY Florian 2014-05-26 15:33
This is a know bug of transform MySQL to PgSQL (function convertSQLFromMysql of htdocs/core/db/pgsql.class.php) ALTER TABLE instruction.

This MySQL
ALTER TABLE llx_facture_fourn MODIFY COLUMN fk_mode_reglement integer NULL;

Is not transform to convert to
ALTER TABLE llx_facture_fourn ALTER COLUMN fk_mode_reglement DROP NOT NULL;
ALTER TABLE llx_facture_fourn ALTER COLUMN fk_mode_reglement SET NULL;
HENRY Florian 2014-05-26 15:20
There is this script into migration from 3.4 to 3.5
ALTER TABLE llx_facture_fourn MODIFY COLUMN fk_mode_reglement integer NULL;
ALTER TABLE llx_facture_fourn MODIFY COLUMN fk_cond_reglement integer NULL;

So I confirm this column accept null values. I will check why this SQL request was not exected during migration with PgSQL.

reply via email to
[Prev in Thread] Current Thread [Next in Thread]