Ne pas afficher les factures d'avoir comme ligne de facturation sur la facture définitive

LesCarnets · Décembre 7, 2019, 2:35

Bonjour,

J’aurais besoin de votre aide sur Dolibarr 10.0.2

Nous vendons un services dont le tarif peut légèrement évoluer entre le devis accepté par le client et la facture finale quelques mois après (ex: prestation supplémentaire demandée par le client). La facture n’est donc pas validée dès le début et reste en draft. Afin de pouvoir enregistrer le règlement de l’acompte nous faisons donc une facture d’acompte.

Quelques mois après, lorsque vient la facture définitive, nous ajustons le montant et la facture générée tient bien compte des acomptes précédemment enregistrés. Cependant le document généré ne correspond pas à notre besoin : en effet, les acomptes n’apparaissent pas dans les paiements (en bas dans le modèle « crabe ») mais comme ligne de facturation. Nos clients ont besoin d’une facture unique avec le montant total, hors sur le facture générée, les acomptes apparaissant avec un montant négatif, le total de la facture ne correspond pas au montant total de la prestation…

@cmaconception parlait ici d’une fonction « deposits are just paiements » qui pourrait correspondre à notre besoin, mais je ne l’ai pas trouvée dans l’admin Dolibarr et Google n’a pas été très amicale avec moi sur ce sujet.

Merci d’avance à ceux qui voudrons bien m’aider !

Cordialement,

pm17 · Décembre 7, 2019, 2:48

Slt
Ce n est pas une fonction …mais une variable
FACTURE_DEPOSITS_ARE_JUST_PAYMENTS
Config>divers
https://wiki.dolibarr.org/index.php/Setup_Other

amipc07 · Décembre 7, 2019, 3:43

Bjr,
J’ajouterai que le lien ci dessus est à mettre dans les favoris du navigateur.
Impératif !!

Frédéric

LesCarnets · Décembre 7, 2019, 6:15

Bonsoir,

Merci beaucoup ! Par contre, lorsque que créé une nouvelle facture à partir d’une proposition commerciale acceptée, j’ai une erreur PHP que je n’avais pas avant d’activer le « FACTURE_DEPOSITS_ARE_JUST_PAYMENTS » (en value, j’ai mis « 1 »), je suis en Dolibarr 10.0.2 et en PHP 7.2.

URL générée par l’appui sur le bouton « Créer une facture ou un avoir » : /compta/facture/card.php?action=create&origin=propal&originid=19&socid=2

Fatal error : Uncaught Error: Call to undefined method Facture::getInvoiceArrayList() in /htdocs/dolibarr-test/core/lib/functions.lib.php(6801) : eval()'d code:1 Stack trace: #0 /htdocs/dolibarr-test/core/lib/functions.lib.php(6801): eval() #1 /htdocs/dolibarr-test/core/class/commonobject.class.php(4920): dol_eval(‹ array_sum( \tarr… ›, 1, 0) #2 /htdocs/dolibarr-test/comm/propal/class/propal.class.php(1491): CommonObject->fetch_optionals() #3 /htdocs/dolibarr-test/compta/facture/card.php(2608): Propal->fetch(‹ 19 ›) #4 {main} thrown in /htdocs/dolibarr-test/core/lib/functions.lib.php(6801) : eval()'d code on line 1

Pour information « /htdocs/dolibarr-test/ » correspond au root de mon Dolibarr de test.

Avant de changer ce paramètre le bouton fonctionnait bien (j’ai fait un restore et je confirme que je ne reproduis pas le problème avant d’introduire le « FACTURE_DEPOSITS_ARE_JUST_PAYMENTS ».

Sauriez-vous ce qu’il se passe ?

Merci d’avance pour votre aide.

LesCarnets · Décembre 7, 2019, 10:28

PS : J’ai tenté des upgrades, mais ça n’a rien corrigé. Mon système de test est désormais en :

Dolibarr 10.0.4
PHP 7.3 (.12)

Philazerty · Décembre 8, 2019, 7:07

Bonjour
Si vous enlevez la constante, est ce que ça fonctionne à nouveau ?
Et en mettant à zéro ?
@+

LesCarnets · Décembre 8, 2019, 9:08

Bonjour,
Non, en la mettant à 0 ou en la supprimant, le problème persiste.
Pour faire disparaitre le problème, il m’a fallu faire un restore.
Merci d’avance pour votre aide.

Philazerty · Décembre 9, 2019, 5:15

Alors il y a une autre raison car pas logique.
Réessayez peut être y avait il une coquille quelque part ?
@+

LesCarnets · Décembre 9, 2019, 6:32

Bonsoir @Philazerty,
Je vous remercie mais malheureusement, j’ai toujours le problème. Cela fonctionne pour la première facture, puis Dolibarr est cassé et je ne peux plus en créer une seule.
Merci,

amipc07 · Décembre 9, 2019, 7:17

@LesCarnets,
Avez-vous des modules externes ? Si oui, lesquels ?

Frédéric

LesCarnets · Décembre 9, 2019, 7:43

Bonsoir Frédéric,

Non, je n’utilise que des modules standards de Dolibarr, je n’utilise pas de modules supplémentaires issus du Dolistore.

Merci d’avance pour votre aide,

yves57 · Décembre 10, 2019, 7:39

As-tu modifié le modèle de numérotation ?

LesCarnets · Décembre 10, 2019, 8:55

Non, j’utilise « Terre » comme « Modèle de numérotation des factures et avoirs ». Pas de modification faite.
(Avant l’ajout du « FACTURE_DEPOSITS_ARE_JUST_PAYMENTS », j’arrivait bien à générer des factures.)

yves57 · Décembre 10, 2019, 9:03

On ne pourra pas jouer à la devinette longtemps.
Il faut activer et inspecter les logs de Dolibarr (module syslog) pour comprendre ce qui peut clocher.

LesCarnets · Décembre 10, 2019, 10:07

@yves57: voici le log. Merci d’avance pour votre aide

dolibarr.log généré lors de l'appui sur le bouton 'Créer une facture ou un avoir' après activation du module syslog (Niveau 7):

2019-12-10 10:48:17 DEBUG - This is an already logged session. _SESSION[‹ dol_login ›]=admin _SESSION[‹ dol_entity ›]=1
2019-12-10 10:48:17 DEBUG sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.skype, u.twitter, u.facebook, u.linkedin, 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, 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
2019-12-10 10:48:17 INFO fetch_name_optionals_label elementtype=user
2019-12-10 10:48:17 DEBUG 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
2019-12-10 10:48:17 DEBUG sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1
2019-12-10 10:48:17 DEBUG sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1)
2019-12-10 10:48:17 DEBUG 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
2019-12-10 10:48:17 DEBUG 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 r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
2019-12-10 10:48:17 INFO — Access to /dolibarr-test/comm/propal/card.php - action=, massaction=
2019-12-10 10:48:17 DEBUG 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
2019-12-10 10:48:18 DEBUG Menubase::menuLoad mymainmenu=commercial myleftmenu=propals type_user=0 menu_handler=eldy tabMenu size=0
2019-12-10 10:48:18 DEBUG 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
2019-12-10 10:48:18 INFO fetch_name_optionals_label elementtype=propal
2019-12-10 10:48:18 DEBUG 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 = ‹ propal › ORDER BY pos
2019-12-10 10:48:18 DEBUG Propal::fetch
2019-12-10 10:48:18 DEBUG sql=SELECT p.rowid, p.ref, p.entity, p.remise, p.remise_percent, p.remise_absolue, p.fk_soc, p.total, p.tva, p.localtax1, p.localtax2, p.total_ht, p.datec, p.date_valid as datev, p.datep as dp, p.fin_validite as dfv, p.date_livraison as date_livraison, p.model_pdf, p.last_main_doc, p.ref_client, p.extraparams, p.note_private, p.note_public, p.fk_projet as fk_project, p.fk_statut, p.fk_user_author, p.fk_user_valid, p.fk_user_cloture, p.fk_delivery_address, p.fk_availability, p.fk_input_reason, p.fk_cond_reglement, p.fk_mode_reglement, p.fk_account, p.fk_shipping_method, p.fk_incoterms, p.location_incoterms, p.fk_multicurrency, p.multicurrency_code, p.multicurrency_tx, p.multicurrency_total_ht, p.multicurrency_total_tva, p.multicurrency_total_ttc, p.tms as date_modification, i.libelle as libelle_incoterms, c.label as statut_label, ca.code as availability_code, ca.label as availability, dr.code as demand_reason_code, dr.label as demand_reason, cr.code as cond_reglement_code, cr.libelle as cond_reglement, cr.libelle_facture as cond_reglement_libelle_doc, cp.code as mode_reglement_code, cp.libelle as mode_reglement FROM llx_propal as p LEFT JOIN llx_c_propalst as c ON p.fk_statut = c.id LEFT JOIN llx_c_paiement as cp ON p.fk_mode_reglement = cp.id AND cp.entity IN (1) LEFT JOIN llx_c_payment_term as cr ON p.fk_cond_reglement = cr.rowid AND cr.entity IN (1) LEFT JOIN llx_c_availability as ca ON p.fk_availability = ca.rowid LEFT JOIN llx_c_input_reason as dr ON p.fk_input_reason = dr.rowid LEFT JOIN llx_c_incoterms as i ON p.fk_incoterms = i.rowid WHERE p.rowid=19
2019-12-10 10:48:18 INFO fetch_name_optionals_label elementtype=propal
2019-12-10 10:48:18 DEBUG 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 = ‹ propal › ORDER BY pos
2019-12-10 10:48:18 DEBUG sql=SELECT rowid, test FROM llx_propal_extrafields WHERE fk_object = 19
2019-12-10 10:48:18 DEBUG Propal::fetchObjectLink
2019-12-10 10:48:18 DEBUG sql=SELECT rowid, fk_source, sourcetype, fk_target, targettype FROM llx_element_element WHERE fk_source = 19 AND sourcetype = ‹ propal › ORDER BY sourcetype
2019-12-10 10:48:18 DEBUG Propal::fetch_lines
2019-12-10 10:48:18 DEBUG sql=SELECT d.rowid, d.fk_propal, d.fk_parent_line, d.label as custom_label, d.description, d.price, d.vat_src_code, d.tva_tx, d.localtax1_tx, d.localtax2_tx, d.localtax1_type, d.localtax2_type, d.qty, d.fk_remise_except, d.remise_percent, d.subprice, d.fk_product, d.info_bits, d.total_ht, d.total_tva, d.total_localtax1, d.total_localtax2, d.total_ttc, d.fk_product_fournisseur_price as fk_fournprice, d.buy_price_ht as pa_ht, d.special_code, d.rang, d.product_type, d.fk_unit, p.ref as product_ref, p.description as product_desc, p.fk_product_type, p.label as product_label, p.tobatch as product_batch, p.weight, p.weight_units, p.volume, p.volume_units, d.date_start, d.date_end, d.fk_multicurrency, d.multicurrency_code, d.multicurrency_subprice, d.multicurrency_total_ht, d.multicurrency_total_tva, d.multicurrency_total_ttc FROM llx_propaldet as d LEFT JOIN llx_product as p ON (d.fk_product = p.rowid) WHERE d.fk_propal = 19 ORDER by d.rang
2019-12-10 10:48:18 INFO fetch_name_optionals_label elementtype=propaldet
2019-12-10 10:48:18 DEBUG 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 = ‹ propaldet › ORDER BY pos
2019-12-10 10:48:18 INFO fetch_name_optionals_label elementtype=propaldet
2019-12-10 10:48:18 DEBUG 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 = ‹ propaldet › ORDER BY pos
2019-12-10 10:48:18 DEBUG 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.skype, s.twitter, s.facebook, s.linkedin, 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.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 libelle_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 = 1) WHERE s.entity IN (1) AND s.rowid = 117
2019-12-10 10:48:18 INFO fetch_name_optionals_label elementtype=societe
2019-12-10 10:48:18 DEBUG 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
2019-12-10 10:48:18 DEBUG sql=SELECT rowid, phone2 FROM llx_societe_extrafields WHERE fk_object = 117
2019-12-10 10:48:18 DEBUG 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.skype, s.twitter, s.facebook, s.linkedin, 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.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 libelle_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 = 1) WHERE s.entity IN (1) AND s.rowid = 117
2019-12-10 10:48:18 INFO fetch_name_optionals_label elementtype=societe
2019-12-10 10:48:18 DEBUG 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
2019-12-10 10:48:18 DEBUG sql=SELECT rowid, phone2 FROM llx_societe_extrafields WHERE fk_object = 117
2019-12-10 10:48:18 DEBUG Propal::liste_contact
2019-12-10 10:48:18 DEBUG 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 =19 AND ec.fk_c_type_contact=tc.rowid AND tc.element=‹ propal › AND tc.source = ‹ internal › AND tc.active=1 ORDER BY t.lastname ASC
2019-12-10 10:48:18 DEBUG Propal::liste_contact
2019-12-10 10:48:18 DEBUG 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 =19 AND ec.fk_c_type_contact=tc.rowid AND tc.element=‹ propal › AND tc.source = ‹ external › AND tc.active=1 ORDER BY t.lastname ASC
2019-12-10 10:48:18 INFO files.lib.php::dol_dir_list path=/var/www/htdocs/dolibarr-test//documents/propale/PR1912-0010 types=files recursive=0 filter= excludefilter=« (\.meta|_preview.\.png)$"
2019-12-10 10:48:18 DEBUG sql=SELECT COUNT(rowid) as nb FROM llx_links WHERE objecttype = ‹ propal › AND objectid = 19 AND entity = 1
2019-12-10 10:48:18 WARNING Failed to read image using Imagick (Try to install package ‹ apt-get install php-imagick ghostscript › and check there is no policy to disable pdf convertion in /etc/ImageMagick/policy.xml): UnableToOpenConfigureFile `delegates.xml’ @ warning/configure.c/GetConfigureOptions/712
2019-12-10 10:48:18 DEBUG sql=SELECT MAX(te.ref) FROM llx_propal as te WHERE te.ref < ‹ PR1912-0010 › AND te.entity IN (1)
2019-12-10 10:48:18 DEBUG sql=SELECT MIN(te.ref) FROM llx_propal as te WHERE te.ref > ‹ PR1912-0010 › AND te.entity IN (1)
2019-12-10 10:48:18 DEBUG DiscountAbsolute::getAvailableDiscounts discount_type=0
2019-12-10 10:48:18 DEBUG sql=SELECT SUM(rc.amount_ttc) as amount FROM llx_societe_remise_except as rc WHERE rc.entity = 1 AND rc.discount_type=0 AND (rc.fk_facture IS NULL AND rc.fk_facture_line IS NULL) AND rc.fk_soc = 117 AND (fk_facture_source IS NULL OR (description LIKE ‹ (DEPOSIT)% › AND description NOT LIKE ‹ (EXCESS RECEIVED)% ›))
2019-12-10 10:48:18 DEBUG DiscountAbsolute::getAvailableDiscounts discount_type=0
2019-12-10 10:48:18 DEBUG sql=SELECT SUM(rc.amount_ttc) as amount FROM llx_societe_remise_except as rc WHERE rc.entity = 1 AND rc.discount_type=0 AND (rc.fk_facture IS NULL AND rc.fk_facture_line IS NULL) AND rc.fk_soc = 117 AND (fk_facture_source IS NOT NULL AND (description NOT LIKE ‹ (DEPOSIT)% › OR description LIKE ‹ (EXCESS RECEIVED)% ›))
2019-12-10 10:48:18 DEBUG Translate::loadCacheCurrencies
2019-12-10 10:48:18 DEBUG sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1 AND code_iso = ‹ EUR ›
2019-12-10 10:48:18 DEBUG Propal::fetch_lines
2019-12-10 10:48:18 DEBUG sql=SELECT d.rowid, d.fk_propal, d.fk_parent_line, d.label as custom_label, d.description, d.price, d.vat_src_code, d.tva_tx, d.localtax1_tx, d.localtax2_tx, d.localtax1_type, d.localtax2_type, d.qty, d.fk_remise_except, d.remise_percent, d.subprice, d.fk_product, d.info_bits, d.total_ht, d.total_tva, d.total_localtax1, d.total_localtax2, d.total_ttc, d.fk_product_fournisseur_price as fk_fournprice, d.buy_price_ht as pa_ht, d.special_code, d.rang, d.product_type, d.fk_unit, p.ref as product_ref, p.description as product_desc, p.fk_product_type, p.label as product_label, p.tobatch as product_batch, p.weight, p.weight_units, p.volume, p.volume_units, d.date_start, d.date_end, d.fk_multicurrency, d.multicurrency_code, d.multicurrency_subprice, d.multicurrency_total_ht, d.multicurrency_total_tva, d.multicurrency_total_ttc FROM llx_propaldet as d LEFT JOIN llx_product as p ON (d.fk_product = p.rowid) WHERE d.fk_propal = 19 ORDER by d.rang
2019-12-10 10:48:18 INFO fetch_name_optionals_label elementtype=propaldet
2019-12-10 10:48:18 DEBUG 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 = ‹ propaldet › ORDER BY pos
2019-12-10 10:48:18 INFO fetch_name_optionals_label elementtype=propaldet
2019-12-10 10:48:18 DEBUG 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 = ‹ propaldet › ORDER BY pos
2019-12-10 10:48:18 INFO fetch_name_optionals_label elementtype=propaldet
2019-12-10 10:48:18 DEBUG 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 = ‹ propaldet › ORDER BY pos
2019-12-10 10:48:18 INFO fetch_name_optionals_label elementtype=propaldet
2019-12-10 10:48:18 DEBUG 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 = ‹ propaldet › ORDER BY pos
2019-12-10 10:48:18 INFO Product::fetch id=61 ref= ref_ext=
2019-12-10 10:48:18 DEBUG 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, fk_default_warehouse, 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 = 61
2019-12-10 10:48:18 INFO fetch_name_optionals_label elementtype=product
2019-12-10 10:48:18 DEBUG 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 = ‹ product › ORDER BY pos
2019-12-10 10:48:18 DEBUG sql=SELECT rowid, user, country, start, end, status, pax_min FROM llx_product_extrafields WHERE fk_object = 61
2019-12-10 10:48:18 INFO files.lib.php::dol_dir_list path=/var/www/htdocs/dolibarr-test//documents/produit/PRG000004/ types=files recursive=0 filter= excludefilter= »(\.meta|_preview.\.png)$"
2019-12-10 10:48:18 DEBUG sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM llx_ecm_files WHERE filepath = ‹ produit/PRG000004 › AND entity = 1
2019-12-10 10:48:18 INFO fetch_name_optionals_label elementtype=propaldet
2019-12-10 10:48:18 DEBUG 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 = ‹ propaldet › ORDER BY pos
2019-12-10 10:48:18 DEBUG Propal::fetchObjectLink
2019-12-10 10:48:18 DEBUG sql=SELECT rowid, fk_source, sourcetype, fk_target, targettype FROM llx_element_element WHERE fk_source = 19 AND sourcetype = ‹ propal › ORDER BY sourcetype
2019-12-10 10:48:18 INFO files.lib.php::dol_dir_list path=/var/www/htdocs/dolibarr-test//documents/propale/PR1912-0010 types=files recursive=0 filter= excludefilter="(\.meta|_preview..*\.png)$"
2019-12-10 10:48:18 DEBUG /core/lib/function2.lib.php::getListOfModels
2019-12-10 10:48:18 DEBUG sql=SELECT nom as id, nom as lib, libelle as label, description as description FROM llx_document_model WHERE type = ‹ propal › AND entity IN (0,1) ORDER BY description DESC
2019-12-10 10:48:18 DEBUG Link::fetchAll
2019-12-10 10:48:18 DEBUG sql=SELECT rowid, entity, datea, url, label, objecttype, objectid FROM llx_links WHERE objecttype = ‹ propal › AND objectid = 19 AND entity = 1
2019-12-10 10:48:18 DEBUG Link::fetchAll 0records
2019-12-10 10:48:18 DEBUG sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref, t.ref_client, t.total as total_ht FROM llx_societe as s, llx_facture as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (117) AND t.entity IN (1)
2019-12-10 10:48:18 DEBUG sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.titre as ref, t.total as total_ht FROM llx_societe as s, llx_facture_rec as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (117) AND t.entity IN (1)
2019-12-10 10:48:18 DEBUG 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_commande_fournisseur as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (117) AND t.entity IN (1)
2019-12-10 10:48:18 DEBUG 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 (117) AND t.entity IN (1)
2019-12-10 10:48:18 DEBUG Propal::fetchObjectLink
2019-12-10 10:48:18 DEBUG sql=SELECT rowid, fk_source, sourcetype, fk_target, targettype FROM llx_element_element WHERE (fk_source = 19 AND sourcetype = ‹ propal ›) OR (fk_target = 19 AND targettype = ‹ propal ›) ORDER BY sourcetype
2019-12-10 10:48:18 DEBUG ActionComm::getActions
2019-12-10 10:48:18 DEBUG sql=SELECT a.id FROM llx_actioncomm as a WHERE a.entity IN (1) AND a.fk_element = 19 AND a.elementtype = ‹ propal › ORDER BY a.datep DESC, a.id DESC
2019-12-10 10:48:18 INFO — End access to /dolibarr-test/comm/propal/card.php
2019-12-10 10:48:22 DEBUG - This is an already logged session. _SESSION[‹ dol_login ›]=admin _SESSION[‹ dol_entity ›]=1
2019-12-10 10:48:22 DEBUG sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.skype, u.twitter, u.facebook, u.linkedin, 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, 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
2019-12-10 10:48:22 INFO fetch_name_optionals_label elementtype=user
2019-12-10 10:48:22 DEBUG 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
2019-12-10 10:48:22 DEBUG sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1
2019-12-10 10:48:22 DEBUG sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1)
2019-12-10 10:48:22 DEBUG 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
2019-12-10 10:48:22 DEBUG 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 r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
2019-12-10 10:48:22 INFO — Access to /dolibarr-test/compta/facture/card.php - action=create, massaction=
2019-12-10 10:48:22 DEBUG 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
2019-12-10 10:48:22 DEBUG Menubase::menuLoad mymainmenu=commercial myleftmenu=propals type_user=0 menu_handler=eldy tabMenu size=0
2019-12-10 10:48:22 DEBUG 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
2019-12-10 10:48:23 INFO fetch_name_optionals_label elementtype=facture
2019-12-10 10:48:23 DEBUG 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 = ‹ facture › ORDER BY pos
2019-12-10 10:48:23 DEBUG 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.skype, s.twitter, s.facebook, s.linkedin, 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.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 libelle_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 = 1) WHERE s.entity IN (1) AND s.rowid = 117
2019-12-10 10:48:23 INFO fetch_name_optionals_label elementtype=societe
2019-12-10 10:48:23 DEBUG 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
2019-12-10 10:48:23 DEBUG sql=SELECT rowid, phone2 FROM llx_societe_extrafields WHERE fk_object = 117
2019-12-10 10:48:23 DEBUG Propal::fetch
2019-12-10 10:48:23 DEBUG sql=SELECT p.rowid, p.ref, p.entity, p.remise, p.remise_percent, p.remise_absolue, p.fk_soc, p.total, p.tva, p.localtax1, p.localtax2, p.total_ht, p.datec, p.date_valid as datev, p.datep as dp, p.fin_validite as dfv, p.date_livraison as date_livraison, p.model_pdf, p.last_main_doc, p.ref_client, p.extraparams, p.note_private, p.note_public, p.fk_projet as fk_project, p.fk_statut, p.fk_user_author, p.fk_user_valid, p.fk_user_cloture, p.fk_delivery_address, p.fk_availability, p.fk_input_reason, p.fk_cond_reglement, p.fk_mode_reglement, p.fk_account, p.fk_shipping_method, p.fk_incoterms, p.location_incoterms, p.fk_multicurrency, p.multicurrency_code, p.multicurrency_tx, p.multicurrency_total_ht, p.multicurrency_total_tva, p.multicurrency_total_ttc, p.tms as date_modification, i.libelle as libelle_incoterms, c.label as statut_label, ca.code as availability_code, ca.label as availability, dr.code as demand_reason_code, dr.label as demand_reason, cr.code as cond_reglement_code, cr.libelle as cond_reglement, cr.libelle_facture as cond_reglement_libelle_doc, cp.code as mode_reglement_code, cp.libelle as mode_reglement FROM llx_propal as p LEFT JOIN llx_c_propalst as c ON p.fk_statut = c.id LEFT JOIN llx_c_paiement as cp ON p.fk_mode_reglement = cp.id AND cp.entity IN (1) LEFT JOIN llx_c_payment_term as cr ON p.fk_cond_reglement = cr.rowid AND cr.entity IN (1) LEFT JOIN llx_c_availability as ca ON p.fk_availability = ca.rowid LEFT JOIN llx_c_input_reason as dr ON p.fk_input_reason = dr.rowid LEFT JOIN llx_c_incoterms as i ON p.fk_incoterms = i.rowid WHERE p.rowid=19
2019-12-10 10:48:23 INFO fetch_name_optionals_label elementtype=propal
2019-12-10 10:48:23 DEBUG 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 = ‹ propal › ORDER BY pos
2019-12-10 10:48:23 DEBUG sql=SELECT rowid, test FROM llx_propal_extrafields WHERE fk_object = 19
2019-12-10 10:48:23 INFO — End access to /dolibarr-test/compta/facture/card.php

yves57 · Décembre 10, 2019, 10:54

Que se passe-t-il au niveau de l’affichage ?
Au départ, tu mentionnais une erreur, mais maintenant ? Tu nous dis simplement

je ne peux plus en créer une seule.

ksar · Décembre 10, 2019, 11:04

Bonjour,

Il y a plusieurs petite choses étranges dans votre log :

Le chemin vers le répertoire document est suspect (il y a un // dedans) :

dol_dir_list path=/var/www/htdocs/dolibarr-test//documents/propale/PR1912-001

Vérifier votre conf.php

Vous n’avez pas la librairie php Imagick

WARNING Failed to read image using Imagick (Try to install package ‹ apt-get install php-imagick ghostscript › and check there is no policy to disable pdf convertion in /etc/ImageMagick*/policy.xml): UnableToOpenConfigureFile `delegates.xml’

Mais sinon pas d’erreurs dans le fichier log

LesCarnets · Décembre 10, 2019, 11:27

@yves57: Au niveau de l’affichage, lorsque je clique sur ‹ Créer une facture ou un avoir › depuis une proposition commerciale, la page de création de facture n’arrive pas à s’afficher, j’ai le message suivant :

@ksar : Concernant le point 1, j’ai la même chose sur ma prod (où je n’ai pas activé le « FACTURE_DEPOSITS_ARE_JUST_PAYMENTS ») : « /var/www/htdocs/dolibarr//documents » et je n’ai pas de soucis lors de la création. (J’ai laissé l’assistant Dolibarr gérer, je n’ai pas touché au config.php)

/dolibarr-test/core/filemanagerdol/connectors/php/config.php:

<?php /* * FCKeditor - The text editor for Internet - http://www.fckeditor.net * Copyright (C) 2003-2010 Frederico Caldeira Knabben * * == BEGIN LICENSE == * * Licensed under the terms of any of the following licenses at your * choice: * * - GNU General Public License Version 2 or later (the "GPL") * http://www.gnu.org/licenses/gpl.html * * - GNU Lesser General Public License Version 2.1 or later (the "LGPL") * http://www.gnu.org/licenses/lgpl.html * * - Mozilla Public License Version 1.1 or later (the "MPL") * http://www.mozilla.org/MPL/MPL-1.1.html * * == END LICENSE == * * Configuration file for the File Manager Connector for PHP. */ global $Config ; global $website; define('NOTOKENRENEWAL', 1); // Disables token renewal // We must include the main because this page is // a web page that require security controls and // is a security hole if anybody can access without // being an authenticated user. require_once '../../../../main.inc.php'; $uri=preg_replace('/^http(s?):\/\//i', '', $dolibarr_main_url_root); $pos = strstr($uri, '/'); // $pos contient alors url sans nom domaine if ($pos == '/') $pos = ''; // si $pos vaut /, on le met a '' define('DOL_URL_ROOT', $pos); $entity = ((!empty($_SESSION['dol_entity']) && $_SESSION['dol_entity'] > 1) ? $_SESSION['dol_entity'] : null); // SECURITY: You must explicitly enable this "connector". (Set it to "true"). // WARNING: don't just set "$Config['Enabled'] = true ;", you must be sure that only // authenticated users can access this file or use some kind of session checking. $Config['Enabled'] = true ; // Path to user files relative to the document root. $extEntity=(empty($entity) ? 1 : $entity); // For multicompany with external access $Config['UserFilesPath'] = DOL_URL_ROOT.'/viewimage.php?modulepart=medias'.(empty($website)?'':'_'.$website).'&entity='.$extEntity.'&file=' ; $Config['UserFilesAbsolutePathRelative'] = (empty($website) ? ((!empty($entity) ? '/' . $entity : '') . '/medias/') : ('/website/'.$website)); // Fill the following value it you prefer to specify the absolute path for the // user files directory. Useful if you are using a virtual directory, symbolic // link or alias. Examples: 'C:\\MySite\\userfiles\\' or '/root/mysite/userfiles/'. // Attention: The above 'UserFilesPath' must point to the same directory. $Config['UserFilesAbsolutePath'] = $dolibarr_main_data_root . $Config['UserFilesAbsolutePathRelative']; // Due to security issues with Apache modules, it is recommended to leave the // following setting enabled. $Config['ForceSingleExtension'] = true ; // Perform additional checks for image files. // If set to true, validate image size (using getimagesize). $Config['SecureImageUploads'] = true; // What the user can do with this connector. $Config['ConfigAllowedCommands'] = array('QuickUpload', 'FileUpload', 'GetFolders', 'GetFoldersAndFiles', 'CreateFolder'); // Allowed Resource Types. $Config['ConfigAllowedTypes'] = array('File', 'Image', 'Media'); // For security, HTML is allowed in the first Kb of data for files having the // following extensions only. $Config['HtmlExtensions'] = array("html", "htm", "xml", "xsd", "txt", "js"); // After file is uploaded, sometimes it is required to change its permissions // so that it was possible to access it at the later time. // If possible, it is recommended to set more restrictive permissions, like 0755. // Set to 0 to disable this feature. // Note: not needed on Windows-based servers. $newmask = '0644'; if (! empty($conf->global->MAIN_UMASK)) $newmask=$conf->global->MAIN_UMASK; $Config['ChmodOnUpload'] = $newmask; // See comments above. // Used when creating folders that does not exist. $newmask = '0755'; $dirmaskdec=octdec($newmask); if (! empty($conf->global->MAIN_UMASK)) $dirmaskdec=octdec($conf->global->MAIN_UMASK); $dirmaskdec |= octdec('0200'); // Set w bit required to be able to create content for recursive subdirs files $newmask = decoct($dirmaskdec); $Config['ChmodOnFolderCreate'] = $newmask; /* Configuration settings for each Resource Type - AllowedExtensions: the possible extensions that can be allowed. If it is empty then any file type can be uploaded. - DeniedExtensions: The extensions that won't be allowed. If it is empty then no restrictions are done here. For a file to be uploaded it has to fulfill both the AllowedExtensions and DeniedExtensions (that's it: not being denied) conditions. - FileTypesPath: the virtual folder relative to the document root where these resources will be located. Attention: It must start and end with a slash: '/' - FileTypesAbsolutePath: the physical path to the above folder. It must be an absolute path. If it's an empty string then it will be autocalculated. Useful if you are using a virtual directory, symbolic link or alias. Examples: 'C:\\MySite\\userfiles\\' or '/root/mysite/userfiles/'. Attention: The above 'FileTypesPath' must point to the same directory. Attention: It must end with a slash: '/' - QuickUploadPath: the virtual folder relative to the document root where these resources will be uploaded using the Upload tab in the resources dialogs. Attention: It must start and end with a slash: '/' - QuickUploadAbsolutePath: the physical path to the above folder. It must be an absolute path. If it's an empty string then it will be autocalculated. Useful if you are using a virtual directory, symbolic link or alias. Examples: 'C:\\MySite\\userfiles\\' or '/root/mysite/userfiles/'. Attention: The above 'QuickUploadPath' must point to the same directory. Attention: It must end with a slash: '/' NOTE: by default, QuickUploadPath and QuickUploadAbsolutePath point to "userfiles" directory to maintain backwards compatibility with older versions of FCKeditor. This is fine, but you in some cases you will be not able to browse uploaded files using file browser. Example: if you click on "image button", select "Upload" tab and send image to the server, image will appear in FCKeditor correctly, but because it is placed directly in /userfiles/ directory, you'll be not able to see it in built-in file browser. The more expected behaviour would be to send images directly to "image" subfolder. To achieve that, simply change $Config['QuickUploadPath']['Image'] = $Config['UserFilesPath'] ; $Config['QuickUploadAbsolutePath']['Image'] = $Config['UserFilesAbsolutePath'] ; into: $Config['QuickUploadPath']['Image'] = $Config['FileTypesPath']['Image'] ; $Config['QuickUploadAbsolutePath']['Image'] = $Config['FileTypesAbsolutePath']['Image'] ; */ $Config['AllowedExtensions']['File'] = array('7z', 'aiff', 'asf', 'avi', 'bmp', 'csv', 'doc', 'fla', 'flv', 'gif', 'gz', 'gzip', 'jpeg', 'jpg', 'mid', 'mov', 'mp3', 'mp4', 'mpc', 'mpeg', 'mpg', 'ods', 'odt', 'pdf', 'png', 'ppt', 'pxd', 'qt', 'ram', 'rar', 'rm', 'rmi', 'rmvb', 'rtf', 'sdc', 'sitd', 'swf', 'sxc', 'sxw', 'tar', 'tgz', 'tif', 'tiff', 'txt', 'vsd', 'wav', 'wma', 'wmv', 'xls', 'xml', 'zip'); $Config['DeniedExtensions']['File'] = array(); $Config['FileTypesPath']['File'] = $Config['UserFilesPath'] . 'file/' ; $Config['FileTypesAbsolutePath']['File']= ($Config['UserFilesAbsolutePath'] == '') ? '' : $Config['UserFilesAbsolutePath'].'file/' ; $Config['QuickUploadPath']['File'] = $Config['UserFilesPath'] ; $Config['QuickUploadAbsolutePath']['File']= $Config['UserFilesAbsolutePath'] ; $Config['AllowedExtensions']['Image'] = array('bmp','gif','jpeg','jpg','png'); $Config['DeniedExtensions']['Image'] = array(); $Config['FileTypesPath']['Image'] = $Config['UserFilesPath'] . 'image/' ; $Config['FileTypesAbsolutePath']['Image']= ($Config['UserFilesAbsolutePath'] == '') ? '' : $Config['UserFilesAbsolutePath'].'image/' ; $Config['QuickUploadPath']['Image'] = $Config['UserFilesPath'] ; $Config['QuickUploadAbsolutePath']['Image']= $Config['UserFilesAbsolutePath'] ; $Config['AllowedExtensions']['Flash'] = array('swf','flv'); $Config['DeniedExtensions']['Flash'] = array(); $Config['FileTypesPath']['Flash'] = $Config['UserFilesPath'] . 'flash/' ; $Config['FileTypesAbsolutePath']['Flash']= ($Config['UserFilesAbsolutePath'] == '') ? '' : $Config['UserFilesAbsolutePath'].'flash/' ; $Config['QuickUploadPath']['Flash'] = $Config['UserFilesPath'] ; $Config['QuickUploadAbsolutePath']['Flash']= $Config['UserFilesAbsolutePath'] ; $Config['AllowedExtensions']['Media'] = array('aiff', 'asf', 'avi', 'bmp', 'fla', 'flv', 'gif', 'jpeg', 'jpg', 'mid', 'mov', 'mp3', 'mp4', 'mpc', 'mpeg', 'mpg', 'png', 'qt', 'ram', 'rm', 'rmi', 'rmvb', 'swf', 'tif', 'tiff', 'wav', 'wma', 'wmv'); $Config['DeniedExtensions']['Media'] = array(); $Config['FileTypesPath']['Media'] = $Config['UserFilesPath'] . 'media/' ; $Config['FileTypesAbsolutePath']['Media']= ($Config['UserFilesAbsolutePath'] == '') ? '' : $Config['UserFilesAbsolutePath'].'media/' ; $Config['QuickUploadPath']['Media'] = $Config['UserFilesPath'] ; $Config['QuickUploadAbsolutePath']['Media']= $Config['UserFilesAbsolutePath'] ;

Et concernant le point 2, j’avais vu le warning, mais comme vous le dites ce n’est qu’un Warning. Je n’utilise pas particulièrement d’image donc je ne pense pas qu’Imagick soit indispensable. (Etant en hébergement mutualisé, je n’ai pas la main pour faire un apt get install sur le serveur).

yves57 · Décembre 10, 2019, 12:09

Utilises-tu des extrafields pour les propales ?
C’est en tentant de les récupérer que l’erreur se produit.
Je soupçonne un bug, car il est fait appel à une fonction de la classe Facture, mais qui n’existe que dans la classe Propal

Call to undefined method Facture::getInvoiceArrayList()

Je dirais que la variable $extrafields utilisée dévrait contenir ceux de la Propal, mais en fait contiennent ceux de la Facture.

LesCarnets · Décembre 10, 2019, 2:20

En effet, lorsque je supprime l’extrafield des proposal, je n’ai plus de soucis. Merci beaucoup @yves57 !

Vu que d’un point de vue fonctionnel il ne nous sert plus, je vais le retirer. Ce workarround me permettra de contourner le bug.

Merci à tous pour votre aide.