Dolibarr ERP & CRM » Bugs » bug #1637 ALTER TABLE llx_contrat ALTER COLUMN fk_commercial_suivi DROP NOT NULL;Latest modifications
Answer now
Snapshot Details |
Submitted by: | damien clochard (daamien) | | Submitted on: | 2014-11-14 16:37 |
Last Modified On: | 2014-11-14 16:37 | |
Summary: | ALTER TABLE llx_contrat ALTER COLUMN fk_commercial_suivi DROP NOT NULL; |
Description: | and
ALTER TABLE llx_contrat ALTER COLUMN fk_commercial_signature DROP NOT NULL;
Both fk_commercial_signature and fk_commercial_suivi are declared obsolete here : http://wiki.dolibarr.org/index.php/Table_llx_contrat
This is a good thing.
But the "not null" constraints must be removed too ! |
Step to reproduce bug: |
1- go to /contrat/card.php
2- edit ref_supplier field
3- validate
You get the error below
2014-11-14 16:17:10 ERR 2.6.62.64 DoliDBPgsql::query SQL error usesavepoint = 0
2014-11-14 16:17:10 ERR 2.6.62.64 Contrat::update Error ERROR: 23502: null value in column "fk_commercial_signature" violates not-null constraint
DETAIL: Failing row contains (7, CT1411-0005, 1, 2014-11-14 16:17:10.008966, 2014-11-03 17:05:06, 2014-11-03 00:00:00, 1, null, null, null, 94, 3, null, null, 2, null, null, null, null, null, null, null, null, null).
SCHEMA NAME: public
TABLE NAME: llx_contrat
COLUMN NAME: fk_commercial_signature
LOCATION: ExecConstraints, execMain.c:1611 |
Detected in version: | develop | | Category: | Module: Contracts |
Severity: | 5 - Major | | OS Type/Version: | |
PHP version: | | | Database type and version: | |
Status |
Status: | Open | | Assigned to: | Laurent Destailleur (eldy) |
Resolution: | Fixed | |
Comments- Laurent Destailleur 2014-11-16 16:10
- The bug has been corrected inside GIT sources
(http://www.github.com/Dolibarr/dolibarr).
So fix should be available with next stable release. |
|
(http://www.github.com/Dolibarr/dolibarr).
So fix should be available with next stable release.
None→ Laurent Destailleur (eldy)None→ Fixed