[8.0.3] pas possible de modifier une fiche produit

bonjour,
malgré mes vérifications, je découvre encore un nouveau problème depuis ma mise à jour version 8 …
cette fois-ci je n’ai aucun bouton de modification sur la fiche produit
je n’ai trouvé aucune erreur SQL dans le log ci-joint
quelqu’un a t il déjà rencontré ce problème ?

merci à vous

Capture_ecran_product.jpg

Bonjour
J’imagine que vous avez activé les logs ? Quoi dedans lors de l’ouverture de la fiche ?
C’est le cas de toutes les fiches ?
Pouvez vous créer ?
Contrôle des droits c’est fait ?
Avec un autre utilisateur ?
@+

bonjour,
merci
oui, j’ai activé les logs, je n’ai pas trouvé d’erreur mais je ne sais pas tout interpréter
j’ai bien le lien « Nouveau produit » à gauche, mais lorsque je veux créer un nouveau produit, le formulaire s’affiche … sauf les boutons en bas, donc je ne peux pas créer de nouveau produit …
je doute que cela soit un problème de droit subitement, je suis le seul administrateur, mais je vais regarder quand même

ci-dessous : le log lors de l’affichage d’une fiche produit

2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ CountryFR › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 DEBUG 88.177.222.91 - This is an already logged session. _SESSION[‹ dol_login ›]=AM _SESSION[‹ dol_entity ›]=1
2018-11-24 09:00:52 DEBUG 88.177.222.91 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.signature, u.office_phone, u.office_fax, u.user_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, 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.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, 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.ref_int, 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 = ‹ AM › ORDER BY u.entity ASC
2018-11-24 09:00:52 INFO 88.177.222.91 fetch_name_optionals_label elementtype=user
2018-11-24 09:00:52 DEBUG 88.177.222.91 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,fielddefault,fieldcomputed,entity,enabled FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = ‹ user › ORDER BY pos
2018-11-24 09:00:52 WARNING 88.177.222.91 Warning: fetch_optionals was called with param optionsArray defined when you should pass null now
2018-11-24 09:00:52 DEBUG 88.177.222.91 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1
2018-11-24 09:00:52 DEBUG 88.177.222.91 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (0,1) AND user_id IN (0, 1)
2018-11-24 09:00:52 DEBUG 88.177.222.91 sql=SELECT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
2018-11-24 09:00:52 DEBUG 88.177.222.91 sql=SELECT 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 r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
2018-11-24 09:00:52 INFO 88.177.222.91 — Access to /erpnew/htdocs/product/card.php - action=, massaction=
2018-11-24 09:00:52 DEBUG 88.177.222.91 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang=‹ fr_FR ›
2018-11-24 09:00:52 DEBUG 88.177.222.91 Menubase::menuLoad mymainmenu=products myleftmenu=product type_user=0 menu_handler=eldy tabMenu size=0
2018-11-24 09:00:52 DEBUG 88.177.222.91 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, 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 (‹ eldy ›,‹ all ›) AND m.usertype IN (0,2) ORDER BY m.position, m.rowid
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ TMenuAgenda › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ Margins › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ Module103111Name › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ Insertion auto DP/AO › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ Insertion auto DP › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ AO › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ Insertion auto DP/AO › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ Insertion auto DP › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ AO › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ MenuResourceIndex › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ Insertion auto DP/AO › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ Insertion auto DP › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ AO › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ Tableau des DP › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ Tableau des DP › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ FTP › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ FTP › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ Insertion auto DP/AO › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ Insertion auto DP › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ AO › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ Tableau des DP › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ Tableau des DP › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ Websites › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ Websites › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ OrderManager › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ PriceOfferManager › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ ImportDPAO › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ ImportDPAO › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ Compte de résultat › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ Compte de résultat › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ ECMArea › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ Woocommerce synchro › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ Woocommerce synchro › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ BarCodePrintsheet › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ Survey › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ SupplierProposalsShort › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 INFO 88.177.222.91 fetch_name_optionals_label elementtype=product
2018-11-24 09:00:52 DEBUG 88.177.222.91 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,fielddefault,fieldcomputed,entity,enabled FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = ‹ product › ORDER BY pos
2018-11-24 09:00:52 INFO 88.177.222.91 Product::fetch id=1072 ref= ref_ext=
2018-11-24 09:00:52 DEBUG 88.177.222.91 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, customcode, fk_country, price, price_ttc, price_min, price_min_ttc, price_base_type, cost_price, default_vat_code, tva_tx, recuperableonly as tva_npr, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, tosell, tobuy, fk_product_type, duration, seuil_stock_alerte, canvas, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 1072
2018-11-24 09:00:52 INFO 88.177.222.91 fetch_name_optionals_label elementtype=product
2018-11-24 09:00:52 DEBUG 88.177.222.91 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,fielddefault,fieldcomputed,entity,enabled FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = ‹ product › ORDER BY pos
2018-11-24 09:00:52 WARNING 88.177.222.91 Warning: fetch_optionals was called with param optionsArray defined when you should pass null now
2018-11-24 09:00:52 DEBUG 88.177.222.91 sql=SELECT rowid, ecommerceng_wc_status_1_1, ecommerceng_description_1, ecommerceng_short_description_1, ecommerceng_tax_class_1_1 FROM llx_product_extrafields WHERE fk_object = 1072
2018-11-24 09:00:52 DEBUG 88.177.222.91 sql=SELECT lang, label, description, note as other FROM llx_product_lang WHERE fk_product=1072
2018-11-24 09:00:52 DEBUG 88.177.222.91 sql=SELECT COUNT(dbt.rowid) as nb FROM llx_product as dbt WHERE dbt.rowid IN (1072) AND dbt.entity IN (1)
2018-11-24 09:00:52 DEBUG 88.177.222.91 sql=SELECT COUNT(dbt.rowid) as nb FROM llx_product as dbt WHERE dbt.rowid IN (1072) AND dbt.entity IN (1)
2018-11-24 09:00:52 INFO 88.177.222.91 HookManager::initHooks Loading hook class for context searchform: actions_lead.class.php
2018-11-24 09:00:52 DEBUG 88.177.222.91 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
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ Inventory › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 INFO 88.177.222.91 files.lib.php::dol_dir_list path=/home/enolia/public_html/erpnew/documents/produit/ANT-PULS-FDR-100-AT types=files recursive=0 filter= excludefilter="(\.meta|_preview.*\.png)$"
2018-11-24 09:00:52 DEBUG 88.177.222.91 sql=SELECT COUNT(rowid) as nb FROM llx_links WHERE objecttype = ‹ product › AND objectid = 1072 AND entity = 1
2018-11-24 09:00:52 INFO 88.177.222.91 Product::fetch_barcode this->element=product this->barcode_type=
2018-11-24 09:00:52 DEBUG 88.177.222.91 sql=SELECT MAX(te.ref) FROM llx_product as te WHERE te.ref < ‹ ANT-PULS-FDR-100-AT › AND fk_product_type = 0 AND te.entity IN (1)
2018-11-24 09:00:52 DEBUG 88.177.222.91 sql=SELECT MIN(te.ref) FROM llx_product as te WHERE te.ref > ‹ ANT-PULS-FDR-100-AT › AND fk_product_type = 0 AND te.entity IN (1)
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ KeyboardShortcut › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ KeyboardShortcut › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 INFO 88.177.222.91 Product::fetch_barcode this->element=product this->barcode_type=
2018-11-24 09:00:52 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key ‹ ShowAccountingAccount › in /erpnew/htdocs/product/card.php
2018-11-24 09:00:52 INFO 88.177.222.91 — End access to /erpnew/htdocs/product/card.php

Droits vérifiés : aucun souci de ce côté là …

Bonjour,

Avez-vous procédé à une réactivation systématique des modules concernés ? (désactivation puis réactivation).
Cette procédure m’a aidé dans le passé.

Cordialement,
Sylvain Legrand.

bonjour,
Oui j’avais tenté cela aussi … sans succès et je viens de le refaire, en prenant le soin de purger le navigateur
cela ne vient pas du navigateur, j’ai fait le test sur firefox et chrome

j’ai encore une version 7 en test, je vais essayer de comparer les logs pour tenter de comprendre ce qui coince …

j’ai comparé les logs d’une verison 8.0.3 qui fonctionne avec le même paramétrage, et celui de ma version de prod qui pose pb

en fait, je n’arrive pas à voir ce qui coince, il n’y a aucune erreur dans le log, mais la différence c’est que j’ai beaucoup moins de lignes dans celui qui coince pour l’activation du product/card.php

voici la fin du fichier log sur l’install qui pose le problème :

2018-12-01 14:35:03 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key 'Woocommerce synchro' in /erpnew/htdocs/product/card.php 2018-12-01 14:35:03 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key 'Survey' in /erpnew/htdocs/product/card.php 2018-12-01 14:35:03 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key 'SupplierProposalsShort' in /erpnew/htdocs/product/card.php 2018-12-01 14:35:03 INFO 88.177.222.91 fetch_name_optionals_label elementtype=product 2018-12-01 14:35:03 DEBUG 88.177.222.91 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,fielddefault,fieldcomputed,entity,enabled FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'product' ORDER BY pos 2018-12-01 14:35:03 INFO 88.177.222.91 Product::fetch id=1015 ref= ref_ext= 2018-12-01 14:35:03 DEBUG 88.177.222.91 sql=SELECT rowid, ref, ref_ext, label, description, url, note as note_private, customcode, fk_country, price, price_ttc, price_min, price_min_ttc, price_base_type, cost_price, default_vat_code, tva_tx, recuperableonly as tva_npr, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, tosell, tobuy, fk_product_type, duration, seuil_stock_alerte, canvas, weight, weight_units, length, length_units, width, width_units, height, height_units, surface, surface_units, volume, volume_units, barcode, fk_barcode_type, finished, accountancy_code_buy, accountancy_code_sell, accountancy_code_sell_intra, accountancy_code_sell_export, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 1015 2018-12-01 14:35:03 INFO 88.177.222.91 fetch_name_optionals_label elementtype=product 2018-12-01 14:35:03 DEBUG 88.177.222.91 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,fielddefault,fieldcomputed,entity,enabled FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'product' ORDER BY pos 2018-12-01 14:35:03 WARNING 88.177.222.91 Warning: fetch_optionals was called with param optionsArray defined when you should pass null now 2018-12-01 14:35:03 DEBUG 88.177.222.91 sql=SELECT rowid, ecommerceng_wc_status_1_1, ecommerceng_description_1, ecommerceng_short_description_1, ecommerceng_tax_class_1_1 FROM llx_product_extrafields WHERE fk_object = 1015 2018-12-01 14:35:03 DEBUG 88.177.222.91 sql=SELECT lang, label, description, note as other FROM llx_product_lang WHERE fk_product=1015 2018-12-01 14:35:03 DEBUG 88.177.222.91 sql=SELECT COUNT(dbt.rowid) as nb FROM llx_product as dbt WHERE dbt.rowid IN (1015) AND dbt.entity IN (1) 2018-12-01 14:35:03 DEBUG 88.177.222.91 sql=SELECT COUNT(dbt.rowid) as nb FROM llx_product as dbt WHERE dbt.rowid IN (1015) AND dbt.entity IN (1) 2018-12-01 14:35:03 INFO 88.177.222.91 HookManager::initHooks Loading hook class for context searchform: actions_lead.class.php 2018-12-01 14:35:03 DEBUG 88.177.222.91 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 2018-12-01 14:35:03 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key 'Inventory' in /erpnew/htdocs/product/card.php 2018-12-01 14:35:03 INFO 88.177.222.91 files.lib.php::dol_dir_list path=/home/enolia/public_html/erpnew/documents/produit/FL-BL-316-DN20-150-RF-AT types=files recursive=0 filter= excludefilter="(\.meta|_preview.*\.png)$" 2018-12-01 14:35:03 DEBUG 88.177.222.91 sql=SELECT COUNT(rowid) as nb FROM llx_links WHERE objecttype = 'product' AND objectid = 1015 AND entity = 1 2018-12-01 14:35:03 DEBUG 88.177.222.91 sql=SELECT MAX(te.ref) FROM llx_product as te WHERE te.ref < 'FL-BL-316-DN20-150-RF-AT' AND fk_product_type = 0 AND te.entity IN (1) 2018-12-01 14:35:03 DEBUG 88.177.222.91 sql=SELECT MIN(te.ref) FROM llx_product as te WHERE te.ref > 'FL-BL-316-DN20-150-RF-AT' AND fk_product_type = 0 AND te.entity IN (1) 2018-12-01 14:35:03 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key 'KeyboardShortcut' in /erpnew/htdocs/product/card.php 2018-12-01 14:35:03 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key 'KeyboardShortcut' in /erpnew/htdocs/product/card.php 2018-12-01 14:35:03 DEBUG 88.177.222.91 Translate::getTradFromKey missing translation for key 'ShowAccountingAccount' in /erpnew/htdocs/product/card.php 2018-12-01 14:35:03 INFO 88.177.222.91 --- End access to /erpnew/htdocs/product/card.php

je ne vois pas ce qui peut coincer …

peut-être que la prochaine mise à jour pourra régler le problème ?

Bonjour,

Le log montre que des clés de traductions sont manquantes.
De plus la saisie d’écran indique que l’affichage s’arrête au code comptable de vente, le libellé « code comptable d’achat » n’est pas trouvé.

Soit une mauvaise copie de certains fichier lang pose problème, soit le module comptabilité ou comptabilité avancée bloque.

Avez-vous vérifié l’intégrité des fichiers copiés pendant la mise à jour ? J’essaierai peut-être de copier / écraser les fichiers de mise à jour au cas ou la copie d’origine c’est mal passé(uniquement le contenu de ‹ htdocs › et ormis le répertoire ‹ conf › et custom’).

Cordialement,
Sylvain Legrand.

1 « J'aime »

Merci pour les pistes (très bonnes)
mais j’ai tout recommencé à zéro en repartant d’un autre serveur et en retransférant ma base de prod
désormais tout est ok, et je referai plus tard et avec précaution la manip dans l’autre sens
merci pour le support