Soucis réception commande fournisseur Dolibarr 12.0.3

Bonjour, j’espère que je post dans les régles du Forum :slight_smile:
J’ai fait la mise à jour de mon Dolibarr en 12.0.3 dans le menu commande fournisseurs, impossible de classer la réception. Quand je clic dessus il me demande l’heure la date de la réception et si la commande et complète puis je valide, la page s’actualise et la commande n’a pas changé de statut…
Help me please :slight_smile:

Anthony

Parfois, ce type de souci peut être dû à un module externe. Je vous conseillerais bien de les désactiver puis de refaire un essai : si ça ne marche toujours pas, on aura au moins éliminé cette hypothèse.

Je vous recommande de faitre une sauvegarde de votre base de données avant, on n’est jamais trop prudent.

Bien sûr, c’est peut-être autre chose (un problème de procédure par exemple).

Bonjour,
Éventuellement, activé le module debug bar et poster ici si il a des erreurs SQL qui remonte

1 « J'aime »

Bonjour, merci pour vos réponses :slight_smile: . J’ai donc essayé de désactiver le module « fournisseurs »
puis le module ''Pack Rubis" qui est un module externe => Toujours même problème.
J’ai activé le module debug voici les traces: (J’ai essayé de comprendre quelque chose mais …pas compris ahah :smiley: )

    2020-11-26 07:29:04 DEBUG   192.168.1.100   - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1
2020-11-26 07:29:04 DEBUG   192.168.1.100   sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, 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.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
2020-11-26 07:29:04 DEBUG   192.168.1.100   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
2020-11-26 07:29:04 DEBUG   192.168.1.100   sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1
2020-11-26 07:29:04 DEBUG   192.168.1.100   sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1)
2020-11-26 07:29:04 DEBUG   192.168.1.100   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 ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
2020-11-26 07:29:04 DEBUG   192.168.1.100   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 = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
2020-11-26 07:29:04 DEBUG   192.168.1.100   --- Access to /dolibarr/fourn/commande/card.php - action=livraison, massaction=
2020-11-26 07:29:04 DEBUG   192.168.1.100   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
2020-11-26 07:29:04 DEBUG   192.168.1.100   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
2020-11-26 07:29:04 DEBUG   192.168.1.100   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 = 'commande_fournisseur' ORDER BY pos
2020-11-26 07:29:04 DEBUG   192.168.1.100   CommandeFournisseur::fetch
2020-11-26 07:29:04 DEBUG   192.168.1.100   sql=SELECT c.rowid, c.entity, c.ref, ref_supplier, c.fk_soc, c.fk_statut, c.amount_ht, c.total_ht, c.total_ttc, c.tva as total_vat, c.localtax1, c.localtax2,  c.date_creation, c.date_valid, c.date_approve, c.date_approve2, c.fk_user_author, c.fk_user_valid, c.fk_user_approve, c.fk_user_approve2, c.date_commande as date_commande, c.date_livraison as date_livraison, c.fk_cond_reglement, c.fk_mode_reglement, c.fk_projet as fk_project, c.remise_percent, c.source, c.fk_input_method, c.fk_account, c.note_private, c.note_public, c.model_pdf, c.extraparams, c.billed, c.fk_multicurrency, c.multicurrency_code, c.multicurrency_tx, c.multicurrency_total_ht, c.multicurrency_total_tva, c.multicurrency_total_ttc, cm.libelle as methode_commande, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, cr.libelle_facture as cond_reglement_libelle_doc, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, c.fk_incoterms, c.location_incoterms, i.libelle as label_incoterms FROM llx_commande_fournisseur as c LEFT JOIN llx_c_payment_term as cr ON c.fk_cond_reglement = cr.rowid LEFT JOIN llx_c_paiement as p ON c.fk_mode_reglement = p.id LEFT JOIN llx_c_input_method as cm ON cm.rowid = c.fk_input_method LEFT JOIN llx_c_incoterms as i ON c.fk_incoterms = i.rowid WHERE c.rowid=60
2020-11-26 07:29:04 DEBUG   192.168.1.100   CommandeFournisseur::fetch get lines
2020-11-26 07:29:04 DEBUG   192.168.1.100   sql=SELECT l.rowid, l.ref as ref_supplier, l.fk_product, l.product_type, l.label, l.description, l.qty, l.vat_src_code, l.tva_tx, l.remise_percent, l.subprice, l.localtax1_tx, l. localtax2_tx, l.localtax1_type, l. localtax2_type, l.total_localtax1, l.total_localtax2, l.total_ht, l.total_tva, l.total_ttc, l.special_code, l.fk_parent_line, l.rang, p.rowid as product_id, p.ref as product_ref, p.label as product_label, p.description as product_desc, l.fk_unit, l.date_start, l.date_end, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc FROM llx_commande_fournisseurdet	as l LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE l.fk_commande = 60 ORDER BY l.rang, l.rowid
2020-11-26 07:29:04 DEBUG   192.168.1.100   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 = 'commande_fournisseurdet' ORDER BY pos
2020-11-26 07:29:04 DEBUG   192.168.1.100   sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.price_level, s.tms as date_modification, s.fk_user_creat, s.fk_user_modif, s.phone, s.fax, s.email, s.socialnetworks, s.url, s.zip, s.town, s.note_private, s.note_public, s.model_pdf, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.webservices_url, s.webservices_key, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.parent, s.barcode, s.fk_departement as state_id, s.fk_pays as country_id, s.fk_stcomm, s.remise_supplier, s.mode_reglement, s.cond_reglement, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code, i.libelle as label_incoterms, sr.remise_client FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid LEFT JOIN llx_societe_remise as sr ON sr.rowid = (SELECT MAX(rowid) FROM llx_societe_remise WHERE fk_soc = s.rowid AND entity IN (1)) WHERE s.entity IN (1) AND s.rowid = 16
2020-11-26 07:29:04 DEBUG   192.168.1.100   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
2020-11-26 07:29:04 DEBUG   192.168.1.100   BEGIN Transaction
2020-11-26 07:29:04 DEBUG   192.168.1.100    CommandeFournisseur::Livraison
2020-11-26 07:29:04 DEBUG   192.168.1.100     CommandeFournisseur::Livraison
2020-11-26 07:29:04 DEBUG   192.168.1.100     sql=UPDATE llx_commande_fournisseur SET fk_statut = 5 WHERE rowid = 60 AND fk_statut IN (3,4)
2020-11-26 07:29:04 WARNING 192.168.1.100    Try to add a message in stack with empty message
2020-11-26 07:29:04 DEBUG   192.168.1.100   ROLLBACK Transaction
2020-11-26 07:29:04 DEBUG   192.168.1.100   CommandeFournisseur::fetch
2020-11-26 07:29:04 DEBUG   192.168.1.100   sql=SELECT c.rowid, c.entity, c.ref, ref_supplier, c.fk_soc, c.fk_statut, c.amount_ht, c.total_ht, c.total_ttc, c.tva as total_vat, c.localtax1, c.localtax2,  c.date_creation, c.date_valid, c.date_approve, c.date_approve2, c.fk_user_author, c.fk_user_valid, c.fk_user_approve, c.fk_user_approve2, c.date_commande as date_commande, c.date_livraison as date_livraison, c.fk_cond_reglement, c.fk_mode_reglement, c.fk_projet as fk_project, c.remise_percent, c.source, c.fk_input_method, c.fk_account, c.note_private, c.note_public, c.model_pdf, c.extraparams, c.billed, c.fk_multicurrency, c.multicurrency_code, c.multicurrency_tx, c.multicurrency_total_ht, c.multicurrency_total_tva, c.multicurrency_total_ttc, cm.libelle as methode_commande, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, cr.libelle_facture as cond_reglement_libelle_doc, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, c.fk_incoterms, c.location_incoterms, i.libelle as label_incoterms FROM llx_commande_fournisseur as c LEFT JOIN llx_c_payment_term as cr ON c.fk_cond_reglement = cr.rowid LEFT JOIN llx_c_paiement as p ON c.fk_mode_reglement = p.id LEFT JOIN llx_c_input_method as cm ON cm.rowid = c.fk_input_method LEFT JOIN llx_c_incoterms as i ON c.fk_incoterms = i.rowid WHERE c.rowid=60
2020-11-26 07:29:04 DEBUG   192.168.1.100   CommandeFournisseur::fetch get lines
2020-11-26 07:29:04 DEBUG   192.168.1.100   sql=SELECT l.rowid, l.ref as ref_supplier, l.fk_product, l.product_type, l.label, l.description, l.qty, l.vat_src_code, l.tva_tx, l.remise_percent, l.subprice, l.localtax1_tx, l. localtax2_tx, l.localtax1_type, l. localtax2_type, l.total_localtax1, l.total_localtax2, l.total_ht, l.total_tva, l.total_ttc, l.special_code, l.fk_parent_line, l.rang, p.rowid as product_id, p.ref as product_ref, p.label as product_label, p.description as product_desc, l.fk_unit, l.date_start, l.date_end, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc FROM llx_commande_fournisseurdet	as l LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE l.fk_commande = 60 ORDER BY l.rang, l.rowid
2020-11-26 07:29:04 DEBUG   192.168.1.100   sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.price_level, s.tms as date_modification, s.fk_user_creat, s.fk_user_modif, s.phone, s.fax, s.email, s.socialnetworks, s.url, s.zip, s.town, s.note_private, s.note_public, s.model_pdf, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.webservices_url, s.webservices_key, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.parent, s.barcode, s.fk_departement as state_id, s.fk_pays as country_id, s.fk_stcomm, s.remise_supplier, s.mode_reglement, s.cond_reglement, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code, i.libelle as label_incoterms, sr.remise_client FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid LEFT JOIN llx_societe_remise as sr ON sr.rowid = (SELECT MAX(rowid) FROM llx_societe_remise WHERE fk_soc = s.rowid AND entity IN (1)) WHERE s.entity IN (1) AND s.rowid = 16
2020-11-26 07:29:04 DEBUG   192.168.1.100   sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, 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.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 IS NOT NULL AND u.rowid = 2 ORDER BY u.entity ASC
2020-11-26 07:29:04 DEBUG   192.168.1.100   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
2020-11-26 07:29:04 DEBUG   192.168.1.100   CommandeFournisseur::liste_contact
2020-11-26 07:29:04 DEBUG   192.168.1.100   sql=SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, '-1' as socid, t.statut as statuscontact, t.login, t.photo, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle FROM llx_c_type_contact tc, llx_element_contact ec LEFT JOIN llx_user t on ec.fk_socpeople = t.rowid WHERE ec.element_id =60 AND ec.fk_c_type_contact=tc.rowid AND tc.element='order_supplier' AND tc.source = 'internal' AND tc.active=1 ORDER BY t.lastname ASC
2020-11-26 07:29:04 DEBUG   192.168.1.100   CommandeFournisseur::liste_contact
2020-11-26 07:29:04 DEBUG   192.168.1.100   sql=SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, t.fk_soc as socid, t.statut as statuscontact, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle FROM llx_c_type_contact tc, llx_element_contact ec LEFT JOIN llx_socpeople t on ec.fk_socpeople = t.rowid WHERE ec.element_id =60 AND ec.fk_c_type_contact=tc.rowid AND tc.element='order_supplier' AND tc.source = 'external' AND tc.active=1 ORDER BY t.lastname ASC
2020-11-26 07:29:04 DEBUG   192.168.1.100   files.lib.php::dol_dir_list path=C:/dolibarr/documents/fournisseur/commande/PO2011-0059 types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$"
2020-11-26 07:29:04 DEBUG   192.168.1.100   sql=SELECT COUNT(rowid) as nb FROM llx_links WHERE objecttype = 'order_supplier' AND objectid = 60 AND entity = 1
2020-11-26 07:29:04 DEBUG   192.168.1.100   sql=SELECT MAX(te.ref) FROM llx_commande_fournisseur as te WHERE te.ref < 'PO2011-0059' AND te.entity IN (1)
2020-11-26 07:29:04 DEBUG   192.168.1.100   sql=SELECT MIN(te.ref) FROM llx_commande_fournisseur as te WHERE te.ref > 'PO2011-0059' AND te.entity IN (1)
2020-11-26 07:29:04 DEBUG   192.168.1.100   sql=SELECT rowid, code, libelle as label FROM llx_c_input_method WHERE active=1 AND rowid = 5
2020-11-26 07:29:04 DEBUG   192.168.1.100   DiscountAbsolute::getAvailableDiscounts discount_type=1
2020-11-26 07:29:04 DEBUG   192.168.1.100   sql=SELECT SUM(rc.amount_ttc) as amount, SUM(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llx_societe_remise_except as rc WHERE rc.entity = 1 AND rc.discount_type=1 AND (rc.fk_invoice_supplier IS NULL AND rc.fk_invoice_supplier_line IS NULL) AND rc.fk_soc = 16 AND (fk_invoice_supplier_source IS NULL OR (description LIKE '(DEPOSIT)%' AND description NOT LIKE '(EXCESS PAID)%'))
2020-11-26 07:29:04 DEBUG   192.168.1.100   DiscountAbsolute::getAvailableDiscounts discount_type=1
2020-11-26 07:29:04 DEBUG   192.168.1.100   sql=SELECT SUM(rc.amount_ttc) as amount, SUM(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llx_societe_remise_except as rc WHERE rc.entity = 1 AND rc.discount_type=1 AND (rc.fk_invoice_supplier IS NULL AND rc.fk_invoice_supplier_line IS NULL) AND rc.fk_soc = 16 AND (fk_invoice_supplier_source IS NOT NULL AND (description NOT LIKE '(DEPOSIT)%' OR description LIKE '(EXCESS PAID)%'))
2020-11-26 07:29:04 DEBUG   192.168.1.100   Form::load_cache_conditions_paiements
2020-11-26 07:29:04 DEBUG   192.168.1.100   sql=SELECT rowid, code, libelle as label FROM llx_c_payment_term WHERE entity IN (1) AND active > 0 ORDER BY sortorder
2020-11-26 07:29:04 DEBUG   192.168.1.100   Form::load_cache_types_paiements
2020-11-26 07:29:04 DEBUG   192.168.1.100   sql=SELECT id, code, libelle as label, type, active FROM llx_c_paiement WHERE entity IN (1)
2020-11-26 07:29:04 DEBUG   192.168.1.100   Translate::getLabelFromKey
2020-11-26 07:29:04 DEBUG   192.168.1.100   sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'LCR' AND entity IN (1)
2020-11-26 07:29:04 DEBUG   192.168.1.100   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 = 'commande_fournisseurdet' ORDER BY pos
2020-11-26 07:29:04 DEBUG   192.168.1.100   CommandeFournisseur::fetchObjectLink
2020-11-26 07:29:04 DEBUG   192.168.1.100   sql=SELECT rowid, fk_source, sourcetype, fk_target, targettype FROM llx_element_element WHERE (fk_source = 60 AND sourcetype = 'order_supplier') OR (fk_target = 60 AND targettype = 'order_supplier') ORDER BY sourcetype
2020-11-26 07:29:04 DEBUG   192.168.1.100   files.lib.php::dol_dir_list path=C:/dolibarr/documents/fournisseur/commande/PO2011-0059 types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*.*\\.png)$"
2020-11-26 07:29:04 DEBUG   192.168.1.100   /core/lib/function2.lib.php::getListOfModels
2020-11-26 07:29:04 DEBUG   192.168.1.100   sql=SELECT nom as id, nom as doc_template_name, libelle as label, description as description FROM llx_document_model WHERE type = 'order_supplier' AND entity IN (0,1) ORDER BY description DESC
2020-11-26 07:29:04 DEBUG   192.168.1.100   sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref, t.ref_client, t.total_ht FROM llx_societe as s, llx_propal as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (16) AND t.entity IN (1)
2020-11-26 07:29:04 DEBUG   192.168.1.100   sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref, t.ref_customer as ref_client, t.ref_supplier, '' as total_ht FROM llx_societe as s, llx_contrat as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (16) AND t.entity IN (1)
2020-11-26 07:29:04 DEBUG   192.168.1.100   sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref FROM llx_societe as s, llx_fichinter as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (16) AND t.entity IN (1)
2020-11-26 07:29:04 DEBUG   192.168.1.100   sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref, t.ref_supplier, t.total_ht FROM llx_societe as s, llx_facture_fourn as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (16) AND t.entity IN (1)
2020-11-26 07:29:04 DEBUG   192.168.1.100   CommandeFournisseur::fetchObjectLink
2020-11-26 07:29:04 DEBUG   192.168.1.100   sql=SELECT rowid, fk_source, sourcetype, fk_target, targettype FROM llx_element_element WHERE (fk_source = 60 AND sourcetype = 'order_supplier') OR (fk_target = 60 AND targettype = 'order_supplier') ORDER BY sourcetype
2020-11-26 07:29:04 DEBUG   192.168.1.100   ActionComm::getActions
2020-11-26 07:29:04 DEBUG   192.168.1.100   sql=SELECT a.id FROM llx_actioncomm as a WHERE a.entity IN (1) AND a.fk_element = 60 AND a.elementtype = 'order_supplier' ORDER BY a.datep DESC, a.id DESC
2020-11-26 07:29:04 DEBUG   192.168.1.100   --- End access to /dolibarr/fourn/commande/card.php
2020-11-26 07:29:13 DEBUG   192.168.1.100   - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1
2020-11-26 07:29:13 DEBUG   192.168.1.100   sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, 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.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
2020-11-26 07:29:13 DEBUG   192.168.1.100   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
2020-11-26 07:29:13 DEBUG   192.168.1.100   sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1
2020-11-26 07:29:13 DEBUG   192.168.1.100   sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1)
2020-11-26 07:29:13 DEBUG   192.168.1.100   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 ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
2020-11-26 07:29:13 DEBUG   192.168.1.100   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 = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
2020-11-26 07:29:13 DEBUG   192.168.1.100   --- Access to /dolibarr/document.php - action=, massaction=
2020-11-26 07:29:13 DEBUG   192.168.1.100   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
2020-11-26 07:29:13 DEBUG   192.168.1.100   modulepart=logs original_file=dolibarr.log entity=1
2020-11-26 07:29:13 DEBUG   192.168.1.100   document.php download C:/dolibarr/documents/dolibarr.log filename=dolibarr.log content-type=text/plain

C’est pas très joli comment j’ai affiché les traces non?

J’ai rajouté une balise pour la mise en forme

Pour moi, la partie qui nous intéresse est le : ROLLBACK Transaction et le warning juste avant.

Je pense qu’il faudrait regarder s’il n’y a pas un module qui intercepte le trigger ORDER_SUPPLIER_RECEIVE et retourne une valeur négative… ça pourrait peut-être expliquer le rollback sans message d’erreur (cf. la ligne $this->error = $this->db->lasterror(); dans le bout de code qui gère le trigger :

$result = $this->call_trigger('ORDER_SUPPLIER_RECEIVE', $user);
if ($result < 0) $error++;
// End call triggers

if (!$error) {
	$this->db->commit();
} else {
	$this->statut = $old_statut;
	$this->db->rollback();
	$this->error = $this->db->lasterror();
	$result = -1;
}

Si c’est bien ce trigger, il faudrait voir lesquels de vos modules actifs réagissent à ce trigger.

Bonjour, tout d’abord merci beaucoup d’avoir pris de votre temps pour regarder mon soucis :slight_smile:
J’ai essayé de désactiver quelques modules mais rien ne change.
(pour info j’ai fais une installation manuelle de Dolibarr) pour la V12 avant j’étais sur la version 10 installé en automatique avec Doliwamp)
Voici les modules qui sont actifs dans mon dolibarr:
-Utilisateurs et groupes
-Tiers
-Propositions commerciales
-Contrats/Abonnements
-Interventions
-Fournisseurs
-Produits
-Services
-GED
-Imports de données
-Exports de données
-Journaux et traces de Debug
-PACK RUBIS

À part « PACK RUBIS » (que je ne connais pas du tout), vos modules font partie du standard et ne posent en principe pas de problèmes, donc mon hypothèse est probablement fausse ou partiellement fausse.

Si vous avez des connaissances en programmation, je vous conseillerais bien d’aller dans le fichier htdocs/fourn/class/fournisseur.commande.class, dans la fonction Livraison, juste après la ligne $resql = $this->db->query($sql); pour ajouter soit des points d’arrêt, soit des var_dump pour savoir à quel endroit l’interpréteur passe (:warning: en faisant une sauvegarde du fichier avant pour être sûr de pouvoir le remettre dans son état d’origine).

Bonjour :slight_smile: non je n’ai pas de connaissances en programmation je vais essayer de retrograder Dolibarr car avant je n’avais pas le soucis.

Je me pose une question j’ai suivi un tuto pour l’installation de Dolibarr manuellement, dans ce tuto on modifie le fichier php.ini en activant les lignes suivantes:
;extension=curl, ;extension=gd2, ;extension=intl, ;extension=mysqli.

Est ce que qu’il n’y aurait pas d’autres lignes à activer?

Pour info j’ai essayé de réinstaller en 12.0.3 toujours même problème
Puis tentative de revenir sur 11.0.5 la réception des commandes fournisseurs fonctionnent de nouveau.

Bonjour
Rubis ne propose que des modèles d’édition avec cgv etc.
Pas de trigger intercepte donc pas de ce coté
@+

@philazerty OK, merci pour l’information !

@anthony.rob Concernant les extensions PHP à activer, normalement, l’installeur de Dolibarr vous informe s’il en manque. Je doute fort que ce soit ça le problème. C’est dommage de revenir à une version antérieure plutôt que de corriger le bug, mais je comprends que vous ayez besoin d’un Dolibarr qui fonctionne avant tout. N’hésitez pas si vous avez du nouveau concernant le problème !

Merci pour votre retour, je pense qu’il y a un beug avec la version 12 sur ce point car j’ai uniquement copié les fichiers de l’ancienne version 11.0.5 dans le dossier C:\Apache24\htdocs\Dolibarr et cela refonctionne quand je met les fichiers d’une version 12 cela ne fonctionne plus.

Bonjour @anthony.rob,

Doliwamp ?

Si c’est le cas :

et

Bonjour, non quand j’étais sur la version 10 oui j’étais avec Doliwamp mais maintenant je fais une installation manuelle, à priori tout fonctionne sur la version 12 sauf mon petit bouton réception commande :smiley:

Je vous invite à saisir une issue sur github.com/Dolibarr/dolibarr/issues pour décrire ce qui ne va pas avec votre réception fournisseur

Je dois créer un nouveau sujet?

Non, une issue sur github après avoir créé un compte