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

[Dolibarr-bugtrack] [Bug #1398] [pgsql] Massive silent error in user/per

From: Doliforge
Subject: [Dolibarr-bugtrack] [Bug #1398] [pgsql] Massive silent error in user/perms.php and group/perms.php
Date: Mon, 19 May 2014 11:04:18 +0200
Doliforge
Ce message ne s'affiche pas correctement?
mettez à jour vos préférences utilisateur.
Dolibarr ERP & CRM » Bugs » bug #1398

[pgsql] Massive silent error in user/perms.php and group/perms.php

État

 Détails
Submitted by:  damien clochard (daamien) Submitted on:  19/05/2014 11:04
Last Modified On:  19/05/2014 11:04 
Summary:  [pgsql] Massive silent error in user/perms.php and group/perms.php
Description:  
The usr/group permissions page seems to work fine but it throws a lot of errors in the dolibarr.log





2014-05-19 10:56:37 WARNING 2.6.254.185 DoliDBPgsql::query SQL error usesavepoint = 1 - INSERT INTO llx_rights_def (id, entity, libelle, module, type, bydefault, perms, subperms) VALUES (151,1,'Read withdrawals','prelevement','r',1,'bons','lire') - ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(151, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398 => DB_ERROR_RECORD_ALREADY_EXISTS
2014-05-19 10:56:37 ERR 2.6.254.185 modPrelevement::insert_permissions errno = 0 error ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(151, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398
2014-05-19 10:56:37 WARNING 2.6.254.185 DoliDBPgsql::query SQL error usesavepoint = 1 - INSERT INTO llx_rights_def (id, entity, libelle, module, type, bydefault, perms) VALUES (1181,1,'Consulter les fournisseurs','fournisseur','r',1,'lire') - ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(1181, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398 => DB_ERROR_RECORD_ALREADY_EXISTS
2014-05-19 10:56:37 ERR 2.6.254.185 modFournisseur::insert_permissions errno = 0 error ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(1181, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398
2014-05-19 10:56:37 WARNING 2.6.254.185 DoliDBPgsql::query SQL error usesavepoint = 1 - INSERT INTO llx_rights_def (id, entity, libelle, module, type, bydefault, perms) VALUES (20001,1,'Lire/créer/modifier ses demandes de congés payés','holiday','w',1,'write') - ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(20001, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398 => DB_ERROR_RECORD_ALREADY_EXISTS
2014-05-19 10:56:37 ERR 2.6.254.185 modHoliday::insert_permissions errno = 0 error ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(20001, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398
2014-05-19 10:56:37 WARNING 2.6.254.185 DoliDBPgsql::query SQL error usesavepoint = 1 - INSERT INTO llx_rights_def (id, entity, libelle, module, type, bydefault, perms) VALUES (701,1,'Lire les dons','don','r',1,'lire') - ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(701, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398 => DB_ERROR_RECORD_ALREADY_EXISTS
2014-05-19 10:56:37 ERR 2.6.254.185 modDon::insert_permissions errno = 0 error ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(701, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398
2014-05-19 10:56:37 WARNING 2.6.254.185 DoliDBPgsql::query SQL error usesavepoint = 1 - INSERT INTO llx_rights_def (id, entity, libelle, module, type, bydefault, perms) VALUES (161,1,'Lire les contrats','contrat','r',1,'lire') - ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(161, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398 => DB_ERROR_RECORD_ALREADY_EXISTS
2014-05-19 10:56:37 ERR 2.6.254.185 modContrat::insert_permissions errno = 0 error ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(161, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398
2014-05-19 10:56:37 WARNING 2.6.254.185 DoliDBPgsql::query SQL error usesavepoint = 1 - INSERT INTO llx_rights_def (id, entity, libelle, module, type, bydefault, perms) VALUES (121,1,'Lire les societes','societe','r',1,'lire') - ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(121, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398 => DB_ERROR_RECORD_ALREADY_EXISTS
2014-05-19 10:56:37 ERR 2.6.254.185 modSociete::insert_permissions errno = 0 error ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(121, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398
2014-05-19 10:56:37 WARNING 2.6.254.185 DoliDBPgsql::query SQL error usesavepoint = 1 - INSERT INTO llx_rights_def (id, entity, libelle, module, type, bydefault, perms, subperms) VALUES (95,1,'Lire CA, bilans, resultats','compta','r',1,'resultat','lire') - ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(95, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398 => DB_ERROR_RECORD_ALREADY_EXISTS
2014-05-19 10:56:37 ERR 2.6.254.185 modComptabilite::insert_permissions errno = 0 error ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(95, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398
2014-05-19 10:56:37 WARNING 2.6.254.185 DoliDBPgsql::query SQL error usesavepoint = 1 - INSERT INTO llx_rights_def (id, entity, libelle, module, type, bydefault, perms) VALUES (21,1,'Lire les propositions commerciales','propale','r',1,'lire') - ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(21, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398 => DB_ERROR_RECORD_ALREADY_EXISTS
2014-05-19 10:56:37 ERR 2.6.254.185 modPropale::insert_permissions errno = 0 error ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(21, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398
2014-05-19 10:56:37 WARNING 2.6.254.185 DoliDBPgsql::query SQL error usesavepoint = 1 - INSERT INTO llx_rights_def (id, entity, libelle, module, type, bydefault, perms) VALUES (531,1,'Lire les services','service','r',1,'lire') - ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(531, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398 => DB_ERROR_RECORD_ALREADY_EXISTS
2014-05-19 10:56:37 ERR 2.6.254.185 modService::insert_permissions errno = 0 error ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(531, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398
2014-05-19 10:56:37 WARNING 2.6.254.185 DoliDBPgsql::query SQL error usesavepoint = 1 - INSERT INTO llx_rights_def (id, entity, libelle, module, type, bydefault, perms) VALUES (331,1,'Lire les bookmarks','bookmark','r',1,'lire') - ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(331, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398 => DB_ERROR_RECORD_ALREADY_EXISTS
2014-05-19 10:56:37 ERR 2.6.254.185 modBookmark::insert_permissions errno = 0 error ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(331, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398
2014-05-19 10:56:37 WARNING 2.6.254.185 DoliDBPgsql::query SQL error usesavepoint = 1 - INSERT INTO llx_rights_def (id, entity, libelle, module, type, bydefault, perms) VALUES (61,1,'Lire les fiches d''intervention','ficheinter','r',1,'lire') - ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(61, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398 => DB_ERROR_RECORD_ALREADY_EXISTS
2014-05-19 10:56:37 ERR 2.6.254.185 modFicheinter::insert_permissions errno = 0 error ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(61, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398
2014-05-19 10:56:37 WARNING 2.6.254.185 DoliDBPgsql::query SQL error usesavepoint = 1 - INSERT INTO llx_rights_def (id, entity, libelle, module, type, bydefault, perms, subperms) VALUES (91,1,'Lire les charges','tax','r',1,'charges','lire') - ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(91, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398 => DB_ERROR_RECORD_ALREADY_EXISTS
2014-05-19 10:56:37 ERR 2.6.254.185 modTax::insert_permissions errno = 0 error ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(91, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398
2014-05-19 10:56:37 WARNING 2.6.254.185 DoliDBPgsql::query SQL error usesavepoint = 1 - INSERT INTO llx_rights_def (id, entity, libelle, module, type, bydefault, perms, subperms) VALUES (2401,1,'Read actions/tasks linked to his account','agenda','r',1,'myactions','read') - ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(2401, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398 => DB_ERROR_RECORD_ALREADY_EXISTS
2014-05-19 10:56:37 ERR 2.6.254.185 modAgenda::insert_permissions errno = 0 error ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(2401, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398
2014-05-19 10:56:37 WARNING 2.6.254.185 DoliDBPgsql::query SQL error usesavepoint = 1 - INSERT INTO llx_rights_def (id, entity, libelle, module, type, bydefault, perms) VALUES (1251,1,'Run mass imports of external data (data load)','import','r',0,'run') - ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(1251, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398 => DB_ERROR_RECORD_ALREADY_EXISTS
2014-05-19 10:56:37 ERR 2.6.254.185 modImport::insert_permissions errno = 0 error ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(1251, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398
2014-05-19 10:56:37 WARNING 2.6.254.185 DoliDBPgsql::query SQL error usesavepoint = 1 - INSERT INTO llx_rights_def (id, entity, libelle, module, type, bydefault, perms) VALUES (11,1,'Lire les factures','facture','a',1,'lire') - ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(11, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398 => DB_ERROR_RECORD_ALREADY_EXISTS
2014-05-19 10:56:37 ERR 2.6.254.185 modFacture::insert_permissions errno = 0 error ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(11, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398
2014-05-19 10:56:37 WARNING 2.6.254.185 DoliDBPgsql::query SQL error usesavepoint = 1 - INSERT INTO llx_rights_def (id, entity, libelle, module, type, bydefault, perms) VALUES (111,1,'Lire les comptes bancaires','banque','r',1,'lire') - ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(111, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398 => DB_ERROR_RECORD_ALREADY_EXISTS
2014-05-19 10:56:37 ERR 2.6.254.185 modBanque::insert_permissions errno = 0 error ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(111, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398
2014-05-19 10:56:37 WARNING 2.6.254.185 DoliDBPgsql::query SQL error usesavepoint = 1 - INSERT INTO llx_rights_def (id, entity, libelle, module, type, bydefault, perms) VALUES (171,1,'Lire les deplacements','deplacement','r',1,'lire') - ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(171, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398 => DB_ERROR_RECORD_ALREADY_EXISTS
2014-05-19 10:56:37 ERR 2.6.254.185 modDeplacement::insert_permissions errno = 0 error ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(171, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398
2014-05-19 10:56:37 WARNING 2.6.254.185 DoliDBPgsql::query SQL error usesavepoint = 1 - INSERT INTO llx_rights_def (id, entity, libelle, module, type, bydefault, perms) VALUES (1201,1,'Lire les exports','export','r',1,'lire') - ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(1201, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398 => DB_ERROR_RECORD_ALREADY_EXISTS
2014-05-19 10:56:37 ERR 2.6.254.185 modExport::insert_permissions errno = 0 error ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(1201, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398
2014-05-19 10:56:37 WARNING 2.6.254.185 DoliDBPgsql::query SQL error usesavepoint = 1 - INSERT INTO llx_rights_def (id, entity, libelle, module, type, bydefault, perms) VALUES (81,1,'Lire les commandes clients','commande','r',1,'lire') - ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(81, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398 => DB_ERROR_RECORD_ALREADY_EXISTS
2014-05-19 10:56:37 ERR 2.6.254.185 modCommande::insert_permissions errno = 0 error ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(81, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398
2014-05-19 10:56:37 WARNING 2.6.254.185 DoliDBPgsql::query SQL error usesavepoint = 1 - INSERT INTO llx_rights_def (id, entity, libelle, module, type, bydefault, perms, subperms) VALUES (251,1,'Consulter les autres utilisateurs','user','r',0,'user','lire') - ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(251, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398 => DB_ERROR_RECORD_ALREADY_EXISTS
2014-05-19 10:56:37 ERR 2.6.254.185 modUser::insert_permissions errno = 0 error ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(251, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398
2014-05-19 10:56:37 WARNING 2.6.254.185 DoliDBPgsql::query SQL error usesavepoint = 1 - INSERT INTO llx_rights_def (id, entity, libelle, module, type, bydefault, perms) VALUES (103001,1,'Voir les sessions','agefodd','w',1,'lire') - ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(103001, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398 => DB_ERROR_RECORD_ALREADY_EXISTS
2014-05-19 10:56:37 ERR 2.6.254.185 modAgefodd::insert_permissions errno = 0 error ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(103001, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398
2014-05-19 10:56:37 WARNING 2.6.254.185 DoliDBPgsql::query SQL error usesavepoint = 1 - INSERT INTO llx_rights_def (id, entity, libelle, module, type, bydefault, perms) VALUES (1031111,1,'See Leads','lead','w',1,'read') - ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(1031111, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398 => DB_ERROR_RECORD_ALREADY_EXISTS
2014-05-19 10:56:37 ERR 2.6.254.185 modLead::insert_permissions errno = 0 error ERROR: 23505: duplicate key value violates unique constraint "llx_rights_def_pkey"
DETAIL: Key (id, entity)=(1031111, 1) already exists.
LOCATION: _bt_check_unique, nbtinsert.c:398
Step to reproduce bug:  
Go to https://.../user/perms.php?id=1
or https://....../user/group/perms.php?id=5
Detected in version:  3.5.2 Category:  Core Problem
Severity:  2 OS Type/Version:  
PHP version:   Database type and version:  postgresql
 Etat
Status:  Open Assigned to:  Aucun
Resolution:  Aucun 

Répondre


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