Dolibarr ERP & CRM » Bugs » bug #1637 ALTER TABLE llx_contrat ALTER COLUMN fk_commercial_suivi DROP NOT NULL;État| Détails |
| Last Modified On: | 14/11/2014 16:37 | | Submitted by: | damien clochard (daamien) |
| Submitted on: | 14/11/2014 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: | |
| Etat |
| Status: | Open | | Assigned to: | Aucun |
| Resolution: | Aucun | |
Répondre
|
|