Bonjour,
depuis la version 11.0.2 je ne peux plus valider une intervention, si je créé une nouvelle intervention et que je clique en bas sur « créer brouillon » il ne se passe rien. Je suis actuellement obligé de cloner une ancienne intervention et de la modifier pour la créer.
Voici le log sur une création d’intervention, si quelqu’un peux m’aider?
Il y dans le log une erreur sur la date de création mais elle est bien bonne sur ma page.
merci pour vos retours
2020-03-27 17:41:30 DEBUG 192.168.0.100 - This is an already logged session. _SESSION[‹ dol_login ›]=admin _SESSION[‹ dol_entity ›]=1
2020-03-27 17:41:30 DEBUG 192.168.0.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_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 = ‹ admin › ORDER BY u.entity ASC
2020-03-27 17:41:30 DEBUG 192.168.0.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = ‹ user › ORDER BY pos
2020-03-27 17:41:30 DEBUG 192.168.0.100 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 2 AND entity = 1
2020-03-27 17:41:30 DEBUG 192.168.0.100 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 2)
2020-03-27 17:41:30 DEBUG 192.168.0.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= 2 AND r.perms IS NOT NULL
2020-03-27 17:41:30 DEBUG 192.168.0.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 = 2 AND r.perms IS NOT NULL
2020-03-27 17:41:30 DEBUG 192.168.0.100 — Access to /doli/fichinter/card.php - action=add, massaction=
2020-03-27 17:41:30 DEBUG 192.168.0.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-03-27 17:41:30 DEBUG 192.168.0.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-03-27 17:41:30 DEBUG 192.168.0.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = ‹ fichinter › ORDER BY pos
2020-03-27 17:41:30 DEBUG 192.168.0.100 Fichinter::create ref=
2020-03-27 17:41:30 DEBUG 192.168.0.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 = 24
2020-03-27 17:41:30 DEBUG 192.168.0.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = ‹ societe › ORDER BY pos
2020-03-27 17:41:30 DEBUG 192.168.0.100 BEGIN Transaction
2020-03-27 17:41:30 DEBUG 192.168.0.100 Fichinter::create
2020-03-27 17:41:30 DEBUG 192.168.0.100 sql=INSERT INTO llx_fichinter (fk_soc, datec, ref, entity, fk_user_author, fk_user_modif, description, model_pdf, fk_projet, fk_contrat, fk_statut, note_private, note_public) VALUES (24, ‹ 2020-03-27 17:41:30 ›, ‹ ›, 1, 2, 2, ‹ test ›, ‹ soleil ›, 0, 0, 0, null, ‹ test ›)
2020-03-27 17:41:30 DEBUG 192.168.0.100 Fichinter::create
2020-03-27 17:41:30 DEBUG 192.168.0.100 sql=UPDATE llx_fichinter SET ref=’(PROV1165)’ WHERE rowid=1165
2020-03-27 17:41:30 DEBUG 192.168.0.100 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = ‹ fichinter › ORDER BY pos
2020-03-27 17:41:30 DEBUG 192.168.0.100 Fichinter::insertExtraFields delete then insert
2020-03-27 17:41:30 DEBUG 192.168.0.100 sql=DELETE FROM llx_fichinter_extrafields WHERE fk_object = 1165
2020-03-27 17:41:30 DEBUG 192.168.0.100 sql=INSERT INTO llx_fichinter_extrafields (fk_object,nomcli,telclient,versionp,serie,garantie,sim,accessoires,defautcl,defautpc,nomsav) VALUES (1165,‹ test ›,null,‹ 6 ›,null,‹ 2 ›,‹ 1 ›,‹ 2 ›,‹ rien ›,‹ rien ›,‹ moi ›)
2020-03-27 17:41:30 ERR 192.168.0.100 DoliDBMysqli::query SQL Error message: DB_ERROR_1364 Field ‹ daterecep › doesn’t have a default value
2020-03-27 17:41:30 DEBUG 192.168.0.100 ROLLBACK Transaction
2020-03-27 17:41:30 ERR 192.168.0.100 Fichinter::create
2020-03-27 17:41:30 WARNING 192.168.0.100 Try to add a message in stack with empty message
2020-03-27 17:41:30 DEBUG 192.168.0.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 = 24
2020-03-27 17:41:30 DEBUG 192.168.0.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 = 24
2020-03-27 17:41:30 DEBUG 192.168.0.100 FormContract::select_contract
2020-03-27 17:41:30 DEBUG 192.168.0.100 sql=SELECT c.rowid, c.ref, c.fk_soc, c.statut FROM llx_contrat as c WHERE c.entity = 1 AND (c.fk_soc=24 OR c.fk_soc IS NULL) ORDER BY c.ref
2020-03-27 17:41:30 DEBUG 192.168.0.100 /core/lib/function2.lib.php::getListOfModels
2020-03-27 17:41:30 DEBUG 192.168.0.100 sql=SELECT nom as id, nom as doc_template_name, libelle as label, description as description FROM llx_document_model WHERE type = ‹ ficheinter › AND entity IN (0,1) ORDER BY description DESC
2020-03-27 17:41:30 DEBUG 192.168.0.100 DolEditor::DolEditor htmlname=note_public width= height=80 toolbarname=dolibarr_notes
2020-03-27 17:41:30 DEBUG 192.168.0.100 DolEditor::DolEditor htmlname=note_private width= height=80 toolbarname=dolibarr_notes
2020-03-27 17:41:30 DEBUG 192.168.0.100 DolEditor::DolEditor htmlname=options_defautcl width= height=200 toolbarname=dolibarr_notes
2020-03-27 17:41:30 DEBUG 192.168.0.100 DolEditor::DolEditor htmlname=options_defautpc width= height=200 toolbarname=dolibarr_notes
2020-03-27 17:41:30 DEBUG 192.168.0.100 — End access to /doli/fichinter/card.php