Impossible de créer un tiers (déjà existant)

FredGB · Juin 7, 2023, 12:22

Bonjour,

Dolibarr v15.0.0
PHP7.4

Quand j’essaye de créer un tiers, j’ai ce message d’erreur:

Le nom de société TESTAZEFRAYGHBFCLZAMJ existe déjà. Veuillez en choisir un autre.

Comme vous pouvez le constater, le nom est bizarre, j’ai beau mettre tout et n’importe quoi, toujours le même message d’erreur. J’ai désactivé tous les modules tiers, ça ne fonctionne pas.

J’ai trouvé du logs, mais trop lourd pour le corps du message du forum.
Voici un extrait très court:

2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1   sql=INSERT INTO llx_societe (nom, name_alias, entity, datec, fk_user_creat, fk_typent, canvas, status, ref_ext, fk_stcomm, fk_incoterms, location_incoterms, import_key, fk_multicurrency, multicurrency_code, accountancy_code_buy, accountancy_code_sell) VALUES ('zdgfbzergbzrgbzrgb', '', 1, '2023-06-07 12:31:46', -1, 1, null, 1, null, 0, 0, '', null, 1, 'EUR', '', '')
2023-06-07 12:31:46 ERR     37.169.143.186, 127.0.0.1 -> 127.0.0.1   DoliDBMysqli::query SQL Error message: DB_ERROR_RECORD_ALREADY_EXISTS Duplicate entry 'NULL-1' for key 'uk_societe_code_client'

Et un peu plus lourd de logs:

2023-06-07 12:31:18 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 HookManager::executeHooks Qualified hook found (hooktype=output). We call method ActionsExternalinventory->getNomUrl, context=main, module=externalinventory, action=create, object id=3, object element=user
2023-06-07 12:31:18 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 HookManager::executeHooks Qualified hook found (hooktype=output). We call method ActionsExternalinventory->getNomUrl, context=main, module=externalinventory, action=create, object id=20, object element=user
2023-06-07 12:31:18 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 HookManager::executeHooks Qualified hook found (hooktype=output). We call method ActionsExternalinventory->getNomUrl, context=main, module=externalinventory, action=create, object id=15, object element=user
2023-06-07 12:31:18 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 HookManager::executeHooks Qualified hook found (hooktype=output). We call method ActionsExternalinventory->getNomUrl, context=main, module=externalinventory, action=create, object id=22, object element=user
2023-06-07 12:31:18 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 HookManager::executeHooks Qualified hook found (hooktype=output). We call method ActionsExternalinventory->getNomUrl, context=main, module=externalinventory, action=create, object id=12, object element=user
2023-06-07 12:31:18 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 HookManager::executeHooks Qualified hook found (hooktype=output). We call method ActionsExternalinventory->getNomUrl, context=main, module=externalinventory, action=create, object id=11, object element=user
2023-06-07 12:31:18 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 HookManager::executeHooks Qualified hook found (hooktype=output). We call method ActionsExternalinventory->getNomUrl, context=main, module=externalinventory, action=create, object id=10, object element=user
2023-06-07 12:31:18 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 HookManager::executeHooks Qualified hook found (hooktype=output). We call method ActionsExternalinventory->getNomUrl, context=main, module=externalinventory, action=create, object id=23, object element=user
2023-06-07 12:31:18 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 HookManager::executeHooks Qualified hook found (hooktype=output). We call method ActionsListExportImport->printCommonFooter, context=main, module=listexportimport, action=
2023-06-07 12:31:18 INFO    37.169.143.186, 127.0.0.1 -> 127.0.0.1 --- End access to /societe/card.php
2023-06-07 12:31:45 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1
2023-06-07 12:31:45 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.civility as civility_code, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.datelastpassvalidation, u.datestartvalidity, u.dateendvalidity, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC
2023-06-07 12:31:45 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos
2023-06-07 12:31:45 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1
2023-06-07 12:31:45 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 HookManager::initHooks Loading hooks: context=main-path=/externalinventory/class/actions_externalinventory.class.php, context=main-path=/listexportimport/class/actions_listexportimport.class.php
2023-06-07 12:31:45 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND r.entity = 1 AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
2023-06-07 12:31:45 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity IN (0,1) AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
2023-06-07 12:31:45 NOTICE  37.169.143.186, 127.0.0.1 -> 127.0.0.1 --- Access to POST /societe/card.php - action=add, massaction=
2023-06-07 12:31:45 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC
2023-06-07 12:31:45 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.prefix, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llx_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('auguria','all') AND m.usertype IN (0,2) ORDER BY m.position, m.rowid
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help FROM llx_extrafields WHERE elementtype = 'societe' ORDER BY pos
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 sql=SELECT rowid, code, label, url, icon, active FROM llx_c_socialnetworks WHERE entity=1
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 HookManager::initHooks Loading hooks: context=thirdpartycard-path=/pricelist/class/actions_pricelist.class.php, context=globalcard-path=/externalinventory/class/actions_externalinventory.class.php
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method ActionsPriceList->doActions, context=thirdpartycard, module=pricelist, action=add, object id=, object element=societe
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 dol_getIdFromCode (value for field code from key -1 not found into cache)
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 sql=SELECT code as valuetoget FROM llx_c_typent WHERE id = '-1'
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 sql=SELECT rowid, code, label FROM llx_c_country WHERE rowid = 1
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 BEGIN Transaction
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1  MultiCurrency::getIdFromCode
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1  sql=SELECT rowid FROM llx_multicurrency WHERE code = 'EUR' AND entity = 1
2023-06-07 12:31:46 INFO    37.169.143.186, 127.0.0.1 -> 127.0.0.1  Societe::create zdgfbzergbzrgbzrgb
2023-06-07 12:31:46 INFO    37.169.143.186, 127.0.0.1 -> 127.0.0.1   Societe::check_codeclient code_client=CU2306-0111 module=mod_codeclient_monkey
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1   mod_codeclient_monkey::verif_dispo
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1   sql=SELECT rowid FROM llx_societe WHERE code_client = 'CU2306-0111' AND entity IN (1)
2023-06-07 12:31:46 INFO    37.169.143.186, 127.0.0.1 -> 127.0.0.1   mod_codeclient_monkey::verif code=CU2306-0111 type=0 result=0
2023-06-07 12:31:46 INFO    37.169.143.186, 127.0.0.1 -> 127.0.0.1   Societe::check_codefournisseur code_fournisseur=SU2306-0111 module=mod_codeclient_monkey
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1   mod_codeclient_monkey::verif_dispo
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1   sql=SELECT rowid FROM llx_societe WHERE code_fournisseur = 'SU2306-0111' AND entity IN (1)
2023-06-07 12:31:46 INFO    37.169.143.186, 127.0.0.1 -> 127.0.0.1   mod_codeclient_monkey::verif code=SU2306-0111 type=1 result=0
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1   Societe::create
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1   sql=INSERT INTO llx_societe (nom, name_alias, entity, datec, fk_user_creat, fk_typent, canvas, status, ref_ext, fk_stcomm, fk_incoterms, location_incoterms, import_key, fk_multicurrency, multicurrency_code, accountancy_code_buy, accountancy_code_sell) VALUES ('zdgfbzergbzrgbzrgb', '', 1, '2023-06-07 12:31:46', -1, 1, null, 1, null, 0, 0, '', null, 1, 'EUR', '', '')
2023-06-07 12:31:46 ERR     37.169.143.186, 127.0.0.1 -> 127.0.0.1   DoliDBMysqli::query SQL Error message: DB_ERROR_RECORD_ALREADY_EXISTS Duplicate entry 'NULL-1' for key 'uk_societe_code_client'
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 ROLLBACK Transaction
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 HookManager::initHooks Loading hooks: context=main-path=/externalinventory/class/actions_externalinventory.class.php, context=main-path=/listexportimport/class/actions_listexportimport.class.php
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 HookManager::initHooks Loading hooks: context=main-path=/externalinventory/class/actions_externalinventory.class.php, context=main-path=/listexportimport/class/actions_listexportimport.class.php
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 sql=SELECT rowid, title, url, target FROM llx_bookmark WHERE (fk_user = 1 OR fk_user is NULL OR fk_user = 0) AND entity IN (1) ORDER BY position
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 HookManager::initHooks Loading hooks: context=leftblock-path=/externalinventory/class/actions_externalinventory.class.php
2023-06-07 12:31:46 WARNING 37.169.143.186, 127.0.0.1 -> 127.0.0.1 Error. Modules cyberoffice has defined a menu entry with a parent='fk_mainmenu=customers,fk_leftmenu=customers' and position=100. The parent was not found. May be you forget it into your definition of menu, or may be the parent has a "position" that is after the child (fix field "position" of parent or child in this case).
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 HookManager::initHooks Loading hooks: context=main-path=/externalinventory/class/actions_externalinventory.class.php, context=main-path=/listexportimport/class/actions_listexportimport.class.php
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 sql=SELECT rowid, code, label FROM llx_c_country WHERE rowid = 1
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 mod_codeclient_monkey::getNextValue
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 sql=SELECT MAX(CAST(SUBSTRING(code_client FROM 8) AS SIGNED)) as max FROM llx_societe WHERE code_client LIKE 'CU____-%' AND entity IN (1)
2023-06-07 12:31:46 INFO    37.169.143.186, 127.0.0.1 -> 127.0.0.1 mod_codeclient_monkey::getNextValue return CU2306-00001
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 mod_codeclient_monkey::getNextValue
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 sql=SELECT MAX(CAST(SUBSTRING(code_fournisseur FROM 8) AS SIGNED)) as max FROM llx_societe WHERE code_fournisseur LIKE 'SU____-%' AND entity IN (1)
2023-06-07 12:31:46 INFO    37.169.143.186, 127.0.0.1 -> 127.0.0.1 mod_codeclient_monkey::getNextValue return SU2306-00001
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 Form::select_country
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 sql=SELECT rowid, code as code_iso, code_iso as code_iso3, label, favorite, eec FROM llx_c_country WHERE active > 0
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 FormCompany::select_departement selected=0, country_codeid=FR
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 sql=SELECT d.rowid, d.code_departement as code, d.nom as name, d.active, c.label as country, c.code as country_code, r.nom as region_name FROM llx_c_departements as d, llx_c_regions as r,llx_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid AND d.active = 1 AND r.active = 1 AND c.active = 1 AND c.code = 'FR' ORDER BY c.code, d.code_departement
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 FormCompany::select_departement num=100
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 sql=SELECT cc.code FROM llx_c_country as cc WHERE cc.eec = 1
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 FormCompany::typent_array
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 sql=SELECT id, code, libelle FROM llx_c_typent WHERE active = 1 AND (fk_country IS NULL OR fk_country = 1) ORDER by position, id
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 FormCompany::effectif_array
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 sql=SELECT id, code, libelle FROM llx_c_effectif WHERE active = 1 ORDER BY id ASC
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 FormCompany::select_juridicalstatus
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 sql=SELECT f.rowid, f.code as code , f.libelle as label, f.active, c.label as country, c.code as country_code FROM llx_c_forme_juridique as f, llx_c_country as c WHERE f.fk_pays=c.rowid AND f.active = 1 AND c.active = 1 AND c.code = 'FR' ORDER BY c.code
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 Form::select_incoterm
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 sql=SELECT rowid, code FROM llx_c_incoterms WHERE active > 0 ORDER BY code ASC
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 Categorie::load_motherof
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 sql=SELECT fk_parent as id_parent, rowid as id_son FROM llx_categorie WHERE fk_parent != 0 AND entity IN (1)
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 Categorie::get_full_arbo get category list
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 sql=SELECT DISTINCT c.rowid, c.label, c.ref_ext, c.description, c.color, c.fk_parent, c.visible FROM llx_categorie as c WHERE c.entity IN (1) AND c.type = 2
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 Categorie::get_full_arbo call to build_path_from_id_categ
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 Categorie::build_path_from_id_categ id_categ=1 protection=0
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 Categorie::build_path_from_id_categ id_categ=2 protection=0
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 Categorie::build_path_from_id_categ id_categ=3 protection=0
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 Categorie::build_path_from_id_categ id_categ=4 protection=0
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 Categorie::build_path_from_id_categ id_categ=9 protection=0
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 Categorie::build_path_from_id_categ id_categ=24 protection=0
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 Categorie::build_path_from_id_categ id_categ=25 protection=0
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 Categorie::build_path_from_id_categ id_categ=26 protection=0
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 Categorie::build_path_from_id_categ id_categ=41 protection=0
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 Categorie::build_path_from_id_categ id_categ=42 protection=0
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 Categorie::build_path_from_id_categ id_categ=43 protection=0
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 Categorie::build_path_from_id_categ id_categ=44 protection=0
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 Categorie::build_path_from_id_categ id_categ=48 protection=0
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 Categorie::build_path_from_id_categ id_categ=66 protection=0
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 Categorie::get_full_arbo dol_sort_array
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 Categorie::load_motherof
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 sql=SELECT fk_parent as id_parent, rowid as id_son FROM llx_categorie WHERE fk_parent != 0 AND entity IN (1)
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 Categorie::get_full_arbo get category list
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 sql=SELECT DISTINCT c.rowid, c.label, c.ref_ext, c.description, c.color, c.fk_parent, c.visible FROM llx_categorie as c WHERE c.entity IN (1) AND c.type = 1
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 Categorie::get_full_arbo call to build_path_from_id_categ
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 Categorie::build_path_from_id_categ id_categ=5 protection=0
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 Categorie::build_path_from_id_categ id_categ=6 protection=0
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 Categorie::build_path_from_id_categ id_categ=7 protection=0
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 Categorie::build_path_from_id_categ id_categ=10 protection=0
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 Categorie::build_path_from_id_categ id_categ=49 protection=0
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 Categorie::build_path_from_id_categ id_categ=67 protection=0
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 Categorie::get_full_arbo dol_sort_array
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 Translate::loadCacheCurrencies
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 Translate::getLabelFromKey
2023-06-07 12:31:46 DEBUG   37.169.143.186, 127.0.0.1 -> 127.0.0.1 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'AED'

Auriez-vous une idée ou suggestion?

Merci d’avance,

ksar · Juin 7, 2023, 1:40

Bonjour,

mettez à jour dans la dernière version de la branche donc 15.0.3
il y a visiblement un module externe qui rentre dans l’équation : externalinventory => Essayez de le désactiver+ supprimer.

FredGB · Juin 8, 2023, 5:38

Bonjour @ksar et merci de ta réponse.

J’ai attendu ce matin que personne ne soit connecté. J’ai fait la mise à jour en 15.0.3, il n’y a pas eu de problème lors de la mise à jour. C’est déjà bien.

J’ai désactivé et supprimer le plugin externalinventory

Mais malheureusement, toujours l’erreur:

2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1
2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.civility as civility_code, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_pu
blic, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.datelastpassvalidation, u.datestartvalidity, u.dateendvalidity, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm
, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admi
n' ORDER BY u.entity ASC
2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos
2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1
2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 HookManager::initHooks Loading hooks: context=main-path=/listexportimport/class/actions_listexportimport.class.php
2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND r.entity = 1 AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity IN (0,1) AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
2023-06-08 05:28:58 NOTICE  37.174.4.116, 127.0.0.1 -> 127.0.0.1 --- Access to POST /societe/card.php - action=add, massaction=
2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC
2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.prefix, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llx_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('auguria','all') AND m.usertype IN (0,2) ORDER BY m.position, m.rowid
2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help FROM llx_extrafields WHERE elementtype = 'societe' ORDER BY pos
2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT rowid, code, label, url, icon, active FROM llx_c_socialnetworks WHERE entity=1
2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 HookManager::initHooks Loading hooks: context=thirdpartycard-path=/pricelist/class/actions_pricelist.class.php
2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method ActionsPriceList->doActions, context=thirdpartycard, module=pricelist, action=add, object id=, object element=societe
2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 dol_getIdFromCode (value for field code from key -1 not found into cache)
2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT code as valuetoget FROM llx_c_typent WHERE id = '-1'
2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT rowid, code, label FROM llx_c_country WHERE rowid = 1
2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 BEGIN Transaction
2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1  MultiCurrency::getIdFromCode
2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1  sql=SELECT rowid FROM llx_multicurrency WHERE code = 'EUR' AND entity = 1
2023-06-08 05:28:58 INFO    37.174.4.116, 127.0.0.1 -> 127.0.0.1  Societe::create efbzetbzertbzrtb
2023-06-08 05:28:58 INFO    37.174.4.116, 127.0.0.1 -> 127.0.0.1   Societe::check_codeclient code_client=zrgbzergnetryn module=mod_codeclient_leopard
2023-06-08 05:28:58 INFO    37.174.4.116, 127.0.0.1 -> 127.0.0.1   mod_codeclient_leopard::verif type=0 result=0
2023-06-08 05:28:58 INFO    37.174.4.116, 127.0.0.1 -> 127.0.0.1   Societe::check_codefournisseur code_fournisseur=zrgbnezrgnethrn module=mod_codeclient_leopard
2023-06-08 05:28:58 INFO    37.174.4.116, 127.0.0.1 -> 127.0.0.1   mod_codeclient_leopard::verif type=1 result=0
2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1   Societe::create
2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1   sql=INSERT INTO llx_societe (nom, name_alias, entity, datec, fk_user_creat, fk_typent, canvas, status, ref_ext, fk_stcomm, fk_incoterms, location_incoterms, import_key, fk_multicurrency, multicurrency_code, accountancy_code_buy, accountancy_code_sell) VALUES ('efbzetbzertbzrtb', '', 1, '2023-06-08 05:28:58', 1, -1, null, 1, null, 0, 0, '', null, 1, 'EUR', '',
 '')
2023-06-08 05:28:58 ERR     37.174.4.116, 127.0.0.1 -> 127.0.0.1   DoliDBMysqli::query SQL Error message: DB_ERROR_RECORD_ALREADY_EXISTS Duplicate entry 'NULL-1' for key 'uk_societe_code_client'
2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 ROLLBACK Transaction
2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 HookManager::initHooks Loading hooks: context=main-path=/listexportimport/class/actions_listexportimport.class.php
2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 HookManager::initHooks Loading hooks: context=main-path=/listexportimport/class/actions_listexportimport.class.php
2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT rowid, title, url, target FROM llx_bookmark WHERE (fk_user = 1 OR fk_user is NULL OR fk_user = 0) AND entity IN (1) ORDER BY position
2023-06-08 05:28:58 WARNING 37.174.4.116, 127.0.0.1 -> 127.0.0.1 Error. Modules cyberoffice has defined a menu entry with a parent='fk_mainmenu=customers,fk_leftmenu=customers' and position=100. The parent was not found. May be you forget it into your definition of menu, or may be the parent has a "position" that is after the child (fix field "position" of parent or child in this case).
2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 HookManager::initHooks Loading hooks: context=main-path=/listexportimport/class/actions_listexportimport.class.php
2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT rowid, code, label FROM llx_c_country WHERE rowid = 1
2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 Form::select_country
2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT rowid, code as code_iso, code_iso as code_iso3, label, favorite, eec FROM llx_c_country WHERE active > 0
2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 FormCompany::select_departement selected=0, country_codeid=FR
2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT d.rowid, d.code_departement as code, d.nom as name, d.active, c.label as country, c.code as country_code, r.nom as region_name FROM llx_c_departements as d, llx_c_regions as r,llx_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid AND d.active = 1 AND r.active = 1 AND c.active = 1 AND c.code = 'FR' ORDER BY c.code, d.code_departemen
t
2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 FormCompany::select_departement num=100
2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT cc.code FROM llx_c_country as cc WHERE cc.eec = 1
2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 FormCompany::typent_array
2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT id, code, libelle FROM llx_c_typent WHERE active = 1 AND (fk_country IS NULL OR fk_country = 1) ORDER by position, id
2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 FormCompany::effectif_array
2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT id, code, libelle FROM llx_c_effectif WHERE active = 1 ORDER BY id ASC
2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 FormCompany::select_juridicalstatus
2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT f.rowid, f.code as code , f.libelle as label, f.active, c.label as country, c.code as country_code FROM llx_c_forme_juridique as f, llx_c_country as c WHERE f.fk_pays=c.rowid AND f.active = 1 AND c.active = 1 AND c.code = 'FR' ORDER BY c.code
2023-06-08 05:28:58 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 Form::select_incoterm

Je suis désolé… Si vous avez une idée de procédure. Merci

clad63 · Juin 8, 2023, 5:42

et en désactivant Cyberoffice?

FredGB · Juin 8, 2023, 5:52

Bonjour @clad63
Merci aussi de participer.

Pareil…

2023-06-08 05:50:32 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1
2023-06-08 05:50:32 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.civility as civility_code, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_pu
blic, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.datelastpassvalidation, u.datestartvalidity, u.dateendvalidity, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm
, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admi
n' ORDER BY u.entity ASC
2023-06-08 05:50:32 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos
2023-06-08 05:50:32 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1
2023-06-08 05:50:32 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 HookManager::initHooks Loading hooks: context=main-path=/listexportimport/class/actions_listexportimport.class.php
2023-06-08 05:50:32 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND r.entity = 1 AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
2023-06-08 05:50:32 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity IN (0,1) AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
2023-06-08 05:50:32 NOTICE  37.174.4.116, 127.0.0.1 -> 127.0.0.1 --- Access to POST /societe/card.php - action=add, massaction=
2023-06-08 05:50:32 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC
2023-06-08 05:50:32 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.prefix, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llx_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('auguria','all') AND m.usertype IN (0,2) ORDER BY m.position, m.rowid
2023-06-08 05:50:32 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help FROM llx_extrafields WHERE elementtype = 'societe' ORDER BY pos
2023-06-08 05:50:32 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT rowid, code, label, url, icon, active FROM llx_c_socialnetworks WHERE entity=1
2023-06-08 05:50:32 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 HookManager::initHooks Loading hooks: context=thirdpartycard-path=/pricelist/class/actions_pricelist.class.php
2023-06-08 05:50:32 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 HookManager::executeHooks Qualified hook found (hooktype=addreplace). We call method ActionsPriceList->doActions, context=thirdpartycard, module=pricelist, action=add, object id=, object element=societe
2023-06-08 05:50:32 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 dol_getIdFromCode (value for field code from key -1 not found into cache)
2023-06-08 05:50:32 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT code as valuetoget FROM llx_c_typent WHERE id = '-1'
2023-06-08 05:50:32 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT rowid, code, label FROM llx_c_country WHERE rowid = 1
2023-06-08 05:50:32 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 BEGIN Transaction
2023-06-08 05:50:32 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1  MultiCurrency::getIdFromCode
2023-06-08 05:50:32 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1  sql=SELECT rowid FROM llx_multicurrency WHERE code = 'EUR' AND entity = 1
2023-06-08 05:50:32 INFO    37.174.4.116, 127.0.0.1 -> 127.0.0.1  Societe::create sqdfgjazriughae
2023-06-08 05:50:32 INFO    37.174.4.116, 127.0.0.1 -> 127.0.0.1   Societe::check_codeclient code_client=zrnbetyhnetyn module=mod_codeclient_leopard
2023-06-08 05:50:32 INFO    37.174.4.116, 127.0.0.1 -> 127.0.0.1   mod_codeclient_leopard::verif type=0 result=0
2023-06-08 05:50:32 INFO    37.174.4.116, 127.0.0.1 -> 127.0.0.1   Societe::check_codefournisseur code_fournisseur=entynetyne module=mod_codeclient_leopard
2023-06-08 05:50:32 INFO    37.174.4.116, 127.0.0.1 -> 127.0.0.1   mod_codeclient_leopard::verif type=1 result=0
2023-06-08 05:50:32 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1   Societe::create
2023-06-08 05:50:32 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1   sql=INSERT INTO llx_societe (nom, name_alias, entity, datec, fk_user_creat, fk_typent, canvas, status, ref_ext, fk_stcomm, fk_incoterms, location_incoterms, import_key, fk_multicurrency, multicurrency_code, accountancy_code_buy, accountancy_code_sell) VALUES ('sqdfgjazriughae', '', 1, '2023-06-08 05:50:32', 1, -1, null, 1, null, 0, 0, '', null, 1, 'EUR', '',
'')
2023-06-08 05:50:32 ERR     37.174.4.116, 127.0.0.1 -> 127.0.0.1   DoliDBMysqli::query SQL Error message: DB_ERROR_RECORD_ALREADY_EXISTS Duplicate entry 'NULL-1' for key 'uk_societe_code_client'
2023-06-08 05:50:33 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 ROLLBACK Transaction
2023-06-08 05:50:33 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 HookManager::initHooks Loading hooks: context=main-path=/listexportimport/class/actions_listexportimport.class.php
2023-06-08 05:50:33 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 HookManager::initHooks Loading hooks: context=main-path=/listexportimport/class/actions_listexportimport.class.php
2023-06-08 05:50:33 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT rowid, title, url, target FROM llx_bookmark WHERE (fk_user = 1 OR fk_user is NULL OR fk_user = 0) AND entity IN (1) ORDER BY position
2023-06-08 05:50:33 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 HookManager::initHooks Loading hooks: context=main-path=/listexportimport/class/actions_listexportimport.class.php
2023-06-08 05:50:33 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT rowid, code, label FROM llx_c_country WHERE rowid = 1
2023-06-08 05:50:33 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 Form::select_country
2023-06-08 05:50:33 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT rowid, code as code_iso, code_iso as code_iso3, label, favorite, eec FROM llx_c_country WHERE active > 0
2023-06-08 05:50:33 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 FormCompany::select_departement selected=0, country_codeid=FR
2023-06-08 05:50:33 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT d.rowid, d.code_departement as code, d.nom as name, d.active, c.label as country, c.code as country_code, r.nom as region_name FROM llx_c_departements as d, llx_c_regions as r,llx_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid AND d.active = 1 AND r.active = 1 AND c.active = 1 AND c.code = 'FR' ORDER BY c.code, d.code_departemen
t
2023-06-08 05:50:33 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 FormCompany::select_departement num=100
2023-06-08 05:50:33 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT cc.code FROM llx_c_country as cc WHERE cc.eec = 1
2023-06-08 05:50:33 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 FormCompany::typent_array
2023-06-08 05:50:33 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT id, code, libelle FROM llx_c_typent WHERE active = 1 AND (fk_country IS NULL OR fk_country = 1) ORDER by position, id
2023-06-08 05:50:33 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 FormCompany::effectif_array
2023-06-08 05:50:33 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT id, code, libelle FROM llx_c_effectif WHERE active = 1 ORDER BY id ASC
2023-06-08 05:50:33 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 FormCompany::select_juridicalstatus
2023-06-08 05:50:33 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT f.rowid, f.code as code , f.libelle as label, f.active, c.label as country, c.code as country_code FROM llx_c_forme_juridique as f, llx_c_country as c WHERE f.fk_pays=c.rowid AND f.active = 1 AND c.active = 1 AND c.code = 'FR' ORDER BY c.code
2023-06-08 05:50:33 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 Form::select_incoterm
2023-06-08 05:50:33 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT rowid, code FROM llx_c_incoterms WHERE active > 0 ORDER BY code ASC
2023-06-08 05:50:33 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 Categorie::load_motherof
2023-06-08 05:50:33 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT fk_parent as id_parent, rowid as id_son FROM llx_categorie WHERE fk_parent != 0 AND entity IN (1)
2023-06-08 05:50:33 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 Categorie::get_full_arbo get category list
2023-06-08 05:50:33 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 sql=SELECT DISTINCT c.rowid, c.label, c.ref_ext, c.description, c.color, c.fk_parent, c.visible FROM llx_categorie as c WHERE c.entity IN (1) AND c.type = 2
2023-06-08 05:50:33 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 Categorie::get_full_arbo call to build_path_from_id_categ
2023-06-08 05:50:33 DEBUG   37.174.4.116, 127.0.0.1 -> 127.0.0.1 Categorie::build_path_from_id_categ id_categ=1 protection=0

Voilà la liste des plugins externes.

pascal_z · Juin 8, 2023, 6:07

Bonjour,

Vous tentez d’enregistrer un tiers avec un code client déjà existant (ici un code client vide ie NULL).
Le code client doit être unique, il faut donc renseigner le code client quand vous créez un tiers.

FredGB · Juin 8, 2023, 6:14

Bonjour @pascal_z

Merci de vos tentatives pour m’aider.

Malheureusement, j’avais déjà fait plusieurs tentatives, en changeant le système de générateur de codes.

A l’origine c’était sur Leopard en mode libre donc.
Je suis passé à Elephant, pareil.
Je suis passé à Monkey, pareil.
Je suis revenu à Leopard et même en mettant n’importe nawak:

pascal_z · Juin 8, 2023, 6:29

Le champ code_client n’est pas présent dans la requête sql qui apparait dans vos logs. Vous avez une incohérence entre le code source de votre dolibarr qui génère la requête et la clé unique sur le code client qui existe dans votre base de données.
Vous avez une mise à jour qui s’est mal passée ?

FredGB · Juin 8, 2023, 6:38

L’historique de ce dolibarr c’est que j’ai récupéré l’année dernière un Dolibarr en version 8.

J’ai fait toutes les mises à jours jusqu’à version 15 qui était la max de l’époque, puis j’ai fait la mise à jour des plugins en achetant les mises à jours.

Je n’ai eu aucun problème lors des mises à jours, cela a juste était très long. Mais pas d’erreurs.

Puis il y a quelques semaines, mon client m’a demandé d’activer la comptabilité avancé et à partir de là, ça été très bizarre.

&

github.com/Dolibarr/dolibarr

Empty page

opened 01:24PM - 26 May 23 UTC

fred-gb

Bug Bug invalid or external DevCamp 2023 Bordeaux

### Bug Hi, Following this post: https://www.dolibarr.fr/forum/t/impossible…-dafficher-comptabilite-avancee/43105 What I can do? Thanks ### Environment Version 16.0.5 ### Environment OS Ubuntu ### Environment Web server Apache2 ### Environment PHP php8 ### Environment Database mariadb ### Environment URL(s) _No response_ ### Expected and actual behavior actual: <img width="1439" alt="Capture d’écran 2023-05-26 à 14 48 33" src="https://github.com/Dolibarr/dolibarr/assets/17061623/a234ff19-2919-4888-930b-07a77c44df1e"> ### Steps to reproduce the behavior I try in dev environnement/install to upgrade from 15.0.0 to 16.0.5 (not 17.0.1, because not compatible with cyberoffice plugin) I try a step to 15.0.2, same error. This test environnement uses: https://hub.docker.com/r/upshift/dolibarr I disable all cores modules and externals modules. Empty cache. Remove custom folder. ### Attached files For most of pages, this type of error: ``` [Fri May 26 12:45:41.086258 2023] [php:error] [pid 39] [client 127.0.0.1:37716] PHP Fatal error: Uncaught Error: Object of class stdClass could not be converted to string in /var/www/html/core/menus/standard/eldy.lib.php:962\nStack trace:\n#0 /var/www/html/core/menus/standard/eldy_menu.php(150): print_left_eldy_menu()\n#1 /var/www/html/main.inc.php(2870): MenuManager->showmenu()\n#2 /var/www/html/main.inc.php(1387): left_menu()\n#3 /var/www/html/societe/index.php(78): llxHeader()\n#4 {main}\n thrown in /var/www/html/core/menus/standard/eldy.lib.php on line 962, referer: https://dolibarr-FQDN.com/comm/index.php?mainmenu=commercial&leftmenu= ``` And: ``` Fri May 26 12:55:45.744856 2023] [php:warn] [pid 38] [client 127.0.0.1:48716] PHP Warning: is_dir(): open_basedir restriction in effect. File(/var/www/html/..) is not within the allowed path(s): (/var/www/localhost/htdocs:/var/www/documents:/var/www/run:/tmp) in /var/www/html/core/lib/functions2.lib.php on line 100, referer: https://dolibarr-FQDN.com/admin/index.php?mainmenu=home&leftmenu=setup ```

Il y a quelques jours j’ai cloné l’installation, pour essayer de faire passer en version 16.0.5 car le plugin cyberoffice n’accepte que jusqu’à la version 16.
Cela n’a pas corrigé tous les problèmes, mais dans cette version de dev, je peux créer des tiers.

Je ne sais pas ce qu’il s’est passé en une semaine sur la version de prod pour qu’il y ait ce nouveau bug.

Le développement des plugins en php est hors de mes compétences.

Merci d’avance, pour vos idées qui peuvent m’aider.

pascal_z · Juin 8, 2023, 6:58

En fait vous avez un problème avec votre base de données. Il ne devrait pas y avoir de problème de valeur unique sur le code client si cette valeur est NULL (c’est à dire non renseignée).

FredGB · Juin 8, 2023, 8:17

Quand il n’y en a plus, il y en a encore!

J’ai trouvé pour faire le repair.php

Et donc ça bloque:

Erreur DB_ERROR_1712: DELETE from llx_menu where module = 'margins' and url = '/margin/index.php' and not exists (select * from llx_const where name = 'MAIN_MODULE_MARGIN' or name = 'MAIN_MODULE_MARGINS');
Index llx_const is corrupted

Pour epair.php?clean_orphelin_dir=confirmed

Fatal error: Uncaught Error: Class 'HookManager' not found in /srv/core/lib/functions.lib.php:112 Stack trace: #0 /srv/compta/facture/class/facture.class.php(1666): getEntity('invoice') #1 /srv/install/repair.php(876): Facture->fetch(0, 'FA2210-3179') #2 {main} thrown in /srv/core/lib/functions.lib.php on line 112

Pour repair.php?force_disable_of_modules_not_found=confirmed

MAIN_MODULE_ADOC_HOOKS - File of hooks (adoc/class/actions_adoc.class.php) NOT found, we disable the module. - Cleaned

pascal_z · Juin 8, 2023, 8:54

Vous avez des corruptions dans les index de votre base de données (et peut être aussi dans les tables).
Je pense que repartir d’une sauvegarde saine est préférable à ce stade.

FredGB · Juin 8, 2023, 11:05

J’ai supprimé dans la base de donnée ce qui correspondait à l’erreur:

Erreur DB_ERROR_1712: DELETE from llx_menu where module = 'margins' and url = '/margin/index.php' and not exists (select * from llx_const where name = 'MAIN_MODULE_MARGIN' or name = 'MAIN_MODULE_MARGINS');

Quand je fais le repair.php, il n’y a plus d’erreur d’après l’outil.

J’ai quand même l’erreur quand je créé un tiers.

@pascal_z j’ai bien lu ton conseil, j’ai effectivement des backups. Ca sera vraiment la dernière solutions possible avec le travail qui a été effectué cette semaine. Pour éviter de la perte de données à refaire.

Merci

FredGB · Juin 8, 2023, 2:21

Bon bah…

Restauration d’un backup de 48h précédent. Il n’y a plus d’erreur lors de la création d’un tiers.

J’ai même mis à jour en 16.0.5 (maximum supporté du plugin Cyberoffice Prestashop) et ça fonctionne.

Pourvu que cela dure, mais c’est dommage de ne pas pouvoir diagnostiquer plus. Les mystères de l’informatique…

Merci pour vos suggestions et aides.