Bonjour,
Sur un nouveau serveur Ubuntu 20.04, avec le gestionnaire de sites ISPConfig (site paramétré en PHP-FPM), j’ai importé les fichiers d’un site Dolibarr (14.0.4) et sa base de données.
Jusqu’ici tout va bien. J’arrive à accéder à l’outil, tout l’historique est là …
Néanmoins, lors de la génération d’une facture PDF, un écran blanc s’affiche et rien ne se passe.
Quelqu’un a t-il une idée ?
D’avance merci pour votre aide.
Gilles
Bonsoir @swissdolibarr et bienvenue
Écran blanc = erreur Apache/PHP
Il faut regarder les logs de ton hébergement
Cordialement
Eric
Merci Eric,
Quel fichier log, dois-je regarder ? Son emplacement ?
Merci d’avance.
Les logs Apache
/var/log/apache2/
Les logs Dolibarr si le module est activé
dolibarr.log dans le dossier des documents Dolibarr
/var/apache2/error.log
[ 2022-05-12 20:26:02.8462 6732/7fc8c22afe40 age/Cor/CoreMain.cpp:982 ]: Starting Passenger core...
[ 2022-05-12 20:26:02.8462 6732/7fc8c22afe40 age/Cor/CoreMain.cpp:235 ]: Passenger core running in multi-application mode.
[ 2022-05-12 20:26:02.8473 6732/7fc8c22afe40 age/Cor/CoreMain.cpp:732 ]: Passenger core online, PID 6732
[ 2022-05-12 20:26:02.8548 6742/7f10f3b67e40 age/Ust/UstRouterMain.cpp:529 ]: Starting Passenger UstRouter...
[ 2022-05-12 20:26:02.8553 6742/7f10f3b67e40 age/Ust/UstRouterMain.cpp:342 ]: Passenger UstRouter online, PID 6742
[Thu May 12 20:26:02.855609 2022] [:error] [pid 6725:tid 140366986275904] python_init: Python version mismatch, expected '2.7.17', found '2.7.18'.
[Thu May 12 20:26:02.855656 2022] [:error] [pid 6725:tid 140366986275904] python_init: Python executable found ''.
[Thu May 12 20:26:02.855659 2022] [:error] [pid 6725:tid 140366986275904] python_init: Python path being used '/lib/python2.7:/lib/python2.7/plat-x86_64-linux-gnu:/lib/python2.7/lib-tk:/lib/python2.7/lib-old:/lib/python2.7/lib-dynload'.
[Thu May 12 20:26:02.855686 2022] [:notice] [pid 6725:tid 140366986275904] mod_python: Creating 8 session mutexes based on 6 max processes and 25 max threads.
[Thu May 12 20:26:02.855689 2022] [:notice] [pid 6725:tid 140366986275904] mod_python: using mutex_directory /tmp
[Thu May 12 20:26:02.862403 2022] [mpm_event:notice] [pid 6725:tid 140366986275904] AH00489: Apache/2.4.41 (Ubuntu) mod_fcgid/2.3.9 OpenSSL/1.1.1f Phusion_Passenger/5.0.30 mod_python/3.3.1 Python/2.7.18 configured -- resuming normal operations
[Thu May 12 20:26:02.862415 2022] [core:notice] [pid 6725:tid 140366986275904] AH00094: Command line: '/usr/sbin/apache2'
[ 2022-05-12 20:26:02.8730 6697/7fdf4212de40 age/Cor/CoreMain.cpp:967 ]: Passenger core shutdown finished
[Thu May 12 21:59:31.780178 2022] [core:error] [pid 6760:tid 140366460163840] [client 193.118.53.210:40746] AH00126: Invalid URI in request HEAD /icons/.%2e/%2e%2e/apache2/icons/sphere1.png HTTP/1.1
[Thu May 12 22:24:59.933009 2022] [proxy_fcgi:error] [pid 6759:tid 140366485341952] [client 45.9.20.101:48900] AH01071: Got error 'Primary script unknown'
[Fri May 13 01:51:43.088031 2022] [core:error] [pid 6760:tid 140366493734656] [client 45.9.20.101:52732] AH00126: Invalid URI in request POST /cgi-bin/.%2e/.%2e/.%2e/.%2e/bin/sh HTTP/1.1
[Fri May 13 03:16:28.857063 2022] [autoindex:error] [pid 6760:tid 140366468556544] [client 192.241.214.54:38758] AH01276: Cannot serve directory /var/www/apps/: No matching DirectoryIndex (index.html,index.cgi,index.pl,index.php,index.xhtml,index.htm,index.html,index.cgi,index.pl,index.php,index.xhtml,index.htm,standard_index.html) found, and server-generated directory index forbidden by Options directive
Et visiblement je n’ai pas de fichier dolibarr.log
Bonjour,
Il faut activer les logs Dolibarr dans les modules.
Quelle version de php ?
PHP version 7.4.29
J’ai pas réussi à trouver comment activer les log Dolibarr. Comment faire ?
Il faut aller dans Configuration puis Modules, et chercher ‹ Activer log Dolibarr › ou quelque chose de similaire
Lorsque je veux activer le module de log Dolibarr, j’ai le message d’erreur en rouge :
Impossible d’ouvrir le fichier /var/www/nicoledevals.ch/web/dolibarr-pro/documents/dolibarr.log
Bonjour,
Cela ressemble à un problème de droits. Vérifiez les permissions du serveur Web sur le dossier documents.
Bonne journée
Voici ce que le fichier dolibarr.log dit
2022-05-13 12:39:41 DEBUG 178.192.34.142 Facture::fetch_lines
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT l.rowid, l.fk_facture, l.fk_product, l.fk_parent_line, l.label as custom_label, l.description, l.product_type, l.price, l.qty, l.vat_src_code, l.tva_tx, l.localtax1_tx, l.localtax2_tx, l.localtax1_type, l.localtax2_type, l.remise_percent, l.fk_remise_except, l.subprice, l.ref_ext, l.situation_percent, l.fk_prev_id, l.rang, l.special_code, l.date_start as date_start, l.date_end as date_end, l.info_bits, l.total_ht, l.total_tva, l.total_localtax1, l.total_localtax2, l.total_ttc, l.fk_code_ventilation, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.fk_product_type as fk_product_type, p.label as product_label, p.description as product_desc FROM llx_facturedet as l LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE l.fk_facture = 45 ORDER BY l.rang, l.rowid
2022-05-13 12:39:41 DEBUG 178.192.34.142 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 = 'facturedet' ORDER BY pos
2022-05-13 12:39:41 DEBUG 178.192.34.142 HookManager::initHooks Loading hooks: context=invoicecard-path=/swissbanking/class/actions_swissbanking.class.php
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'CH' AND t.active = 1 AND t.localtax1_type <> '0'
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'CH' AND t.active = 1 AND t.localtax2_type <> '0'
2022-05-13 12:39:41 DEBUG 178.192.34.142 Facture::fetch
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT f.rowid,f.entity,f.ref,f.ref_client,f.ref_ext,f.ref_int,f.type,f.fk_soc, f.total_tva, f.localtax1, f.localtax2, f.total_ht, f.total_ttc, f.revenuestamp, f.remise_percent, f.remise_absolue, f.remise, f.datef as df, f.date_pointoftax, f.date_lim_reglement as dlr, f.datec as datec, f.date_valid as datev, f.tms as datem, f.note_private, f.note_public, f.fk_statut, f.paye, f.close_code, f.close_note, f.fk_user_author, f.fk_user_valid, f.model_pdf, f.last_main_doc, f.fk_facture_source, f.fk_fac_rec_source, f.fk_mode_reglement, f.fk_cond_reglement, f.fk_projet as fk_project, f.extraparams, f.situation_cycle_ref, f.situation_counter, f.situation_final, f.fk_account, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_tx, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, c.code as cond_reglement_code, c.libelle as cond_reglement_libelle, c.libelle_facture as cond_reglement_libelle_doc, f.fk_incoterms, f.location_incoterms, f.module_source, f.pos_source, i.libelle as label_incoterms, f.retained_warranty as retained_warranty, f.retained_warranty_date_limit as retained_warranty_date_limit, f.retained_warranty_fk_cond_reglement as retained_warranty_fk_cond_reglement FROM llx_facture as f LEFT JOIN llx_c_payment_term as c ON f.fk_cond_reglement = c.rowid LEFT JOIN llx_c_paiement as p ON f.fk_mode_reglement = p.id LEFT JOIN llx_c_incoterms as i ON f.fk_incoterms = i.rowid WHERE f.rowid=45
2022-05-13 12:39:41 DEBUG 178.192.34.142 Facture::fetch_lines
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT l.rowid, l.fk_facture, l.fk_product, l.fk_parent_line, l.label as custom_label, l.description, l.product_type, l.price, l.qty, l.vat_src_code, l.tva_tx, l.localtax1_tx, l.localtax2_tx, l.localtax1_type, l.localtax2_type, l.remise_percent, l.fk_remise_except, l.subprice, l.ref_ext, l.situation_percent, l.fk_prev_id, l.rang, l.special_code, l.date_start as date_start, l.date_end as date_end, l.info_bits, l.total_ht, l.total_tva, l.total_localtax1, l.total_localtax2, l.total_ttc, l.fk_code_ventilation, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.fk_product_type as fk_product_type, p.label as product_label, p.description as product_desc FROM llx_facturedet as l LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE l.fk_facture = 45 ORDER BY l.rang, l.rowid
2022-05-13 12:39:41 DEBUG 178.192.34.142 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 = 'facture' ORDER BY pos
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.fk_warehouse, 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.model_pdf, s.accountancy_code_buy, s.accountancy_code_sell, 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.mode_reglement, s.cond_reglement, s.transport_mode, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.transport_mode_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, r.rowid as region_id, r.code_region as region_code, st.libelle as stcomm, st.picto as stcomm_picto, te.code as typent_code, i.libelle as label_incoterms, s.remise_client, s.remise_supplier 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_regions as r ON d.fk_region = r.code_region 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 WHERE s.entity IN (1) AND s.rowid = 30
2022-05-13 12:39:41 DEBUG 178.192.34.142 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
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.fk_warehouse, 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.model_pdf, s.accountancy_code_buy, s.accountancy_code_sell, 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.mode_reglement, s.cond_reglement, s.transport_mode, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.transport_mode_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, r.rowid as region_id, r.code_region as region_code, st.libelle as stcomm, st.picto as stcomm_picto, te.code as typent_code, i.libelle as label_incoterms, s.remise_client, s.remise_supplier 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_regions as r ON d.fk_region = r.code_region 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 WHERE s.entity IN (1) AND s.rowid = 30
2022-05-13 12:39:41 DEBUG 178.192.34.142 useRevenueStamp
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT COUNT(*) as nb FROM llx_c_revenuestamp as r, llx_c_country as c WHERE r.fk_pays = c.rowid AND c.code = 'CH' AND r.active = 1
2022-05-13 12:39:41 DEBUG 178.192.34.142 Facture::getSommePaiement
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiement_facture WHERE fk_facture = 45
2022-05-13 12:39:41 DEBUG 178.192.34.142 DiscountAbsolute::getSumCreditNotesUsed
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT sum(rc.amount_ttc) as amount, sum(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llx_societe_remise_except as rc, llx_facture as f WHERE rc.fk_facture_source=f.rowid AND rc.fk_facture = 45 AND f.type IN (0,2,5)
2022-05-13 12:39:41 DEBUG 178.192.34.142 DiscountAbsolute::getSumDepositsUsed
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT sum(rc.amount_ttc) as amount, sum(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llx_societe_remise_except as rc, llx_facture as f WHERE rc.fk_facture_source=f.rowid AND rc.fk_facture = 45 AND f.type = 3
2022-05-13 12:39:41 DEBUG 178.192.34.142 Facture::getSommePaiement
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiement_facture WHERE fk_facture = 45
2022-05-13 12:39:41 DEBUG 178.192.34.142 DiscountAbsolute::getSumCreditNotesUsed
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT sum(rc.amount_ttc) as amount, sum(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llx_societe_remise_except as rc, llx_facture as f WHERE rc.fk_facture_source=f.rowid AND rc.fk_facture = 45 AND f.type IN (0,2,5)
2022-05-13 12:39:41 DEBUG 178.192.34.142 DiscountAbsolute::getSumDepositsUsed
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT sum(rc.amount_ttc) as amount, sum(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llx_societe_remise_except as rc, llx_facture as f WHERE rc.fk_facture_source=f.rowid AND rc.fk_facture = 45 AND f.type = 3
2022-05-13 12:39:41 DEBUG 178.192.34.142 DiscountAbsolute::getAvailableDiscounts discount_type=0
2022-05-13 12:39:41 DEBUG 178.192.34.142 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=0 AND (rc.fk_facture IS NULL AND rc.fk_facture_line IS NULL) AND rc.fk_soc = 30 AND (fk_facture_source IS NULL OR (description LIKE '(DEPOSIT)%' AND description NOT LIKE '(EXCESS RECEIVED)%'))
2022-05-13 12:39:41 DEBUG 178.192.34.142 DiscountAbsolute::getAvailableDiscounts discount_type=0
2022-05-13 12:39:41 DEBUG 178.192.34.142 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=0 AND (rc.fk_facture IS NULL AND rc.fk_facture_line IS NULL) AND rc.fk_soc = 30 AND (fk_facture_source IS NOT NULL AND (description NOT LIKE '(DEPOSIT)%' OR description LIKE '(EXCESS RECEIVED)%'))
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.civility as civility_code, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.datelastpassvalidation, u.datestartvalidity, u.dateendvalidity, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IS NOT NULL AND u.rowid = 3 ORDER BY u.entity ASC
2022-05-13 12:39:41 DEBUG 178.192.34.142 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
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT rowid FROM llx_facture WHERE fk_facture_source = 45 AND type < 2 ORDER BY fk_statut DESC
2022-05-13 12:39:41 DEBUG 178.192.34.142 Facture::liste_contact
2022-05-13 12:39:41 DEBUG 178.192.34.142 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 =45 AND ec.fk_c_type_contact=tc.rowid AND tc.element='facture' AND tc.source = 'internal' AND tc.active=1 ORDER BY t.lastname ASC
2022-05-13 12:39:41 DEBUG 178.192.34.142 Facture::liste_contact
2022-05-13 12:39:41 DEBUG 178.192.34.142 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 =45 AND ec.fk_c_type_contact=tc.rowid AND tc.element='facture' AND tc.source = 'external' AND tc.active=1 ORDER BY t.lastname ASC
2022-05-13 12:39:41 INFO 178.192.34.142 files.lib.php::dol_dir_list path=/var/www/nicoledevals.ch/web/dolibarr-perso/documents/facture/FA2204-0046 types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$"
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT COUNT(rowid) as nb FROM llx_links WHERE objecttype = 'facture' AND objectid = 45 AND entity = 1
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT COUNT(ab.rowid) as nb FROM llx_accounting_bookkeeping as ab WHERE ab.doc_type='customer_invoice' AND ab.fk_doc = 45
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT MAX(te.ref) FROM llx_facture as te WHERE te.ref < 'FA2204-0046' AND te.entity IN (1)
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT MIN(te.ref) FROM llx_facture as te WHERE te.ref > 'FA2204-0046' AND te.entity IN (1)
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT rowid FROM llx_facture WHERE fk_facture_source = 45 AND type = 2
2022-05-13 12:39:41 DEBUG 178.192.34.142 Form::load_cache_conditions_paiements
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT rowid, code, libelle as label FROM llx_c_payment_term WHERE entity IN (1) AND active > 0 ORDER BY sortorder
2022-05-13 12:39:41 DEBUG 178.192.34.142 Form::load_cache_types_paiements
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT id, code, libelle as label, type, active FROM llx_c_paiement WHERE entity IN (1)
2022-05-13 12:39:41 DEBUG 178.192.34.142 Translate::getLabelFromKey
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'LCR' AND entity IN (1)
2022-05-13 12:39:41 DEBUG 178.192.34.142 Account::fetch
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT ba.rowid, ba.ref, ba.label, ba.bank, ba.number, ba.courant, ba.clos, ba.rappro, ba.url, ba.code_banque, ba.code_guichet, ba.cle_rib, ba.bic, ba.iban_prefix as iban, ba.domiciliation, ba.proprio, ba.owner_address, ba.state_id, ba.fk_pays as country_id, ba.account_number, ba.fk_accountancy_journal, ba.currency_code, ba.min_allowed, ba.min_desired, ba.comment, ba.datec as date_creation, ba.tms as date_update, ba.ics, ba.ics_transfer, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state , aj.code as accountancy_journal FROM llx_bank_account as ba LEFT JOIN llx_c_country as c ON ba.fk_pays = c.rowid LEFT JOIN llx_c_departements as d ON ba.state_id = d.rowid LEFT JOIN llx_accounting_journal as aj ON aj.rowid=ba.fk_accountancy_journal WHERE ba.entity IN (1) AND ba.rowid = 1
2022-05-13 12:39:41 DEBUG 178.192.34.142 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 = 'bank_account' ORDER BY pos
2022-05-13 12:39:41 DEBUG 178.192.34.142 Translate::loadCacheCurrencies
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1 AND code_iso = 'CHF'
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT p.datep as dp, p.ref, p.num_paiement as num_payment, p.rowid, p.fk_bank, c.code as payment_code, c.libelle as payment_label, pf.amount, ba.rowid as baid, ba.ref as baref, ba.label, ba.number as banumber, ba.account_number, ba.fk_accountancy_journal FROM llx_paiement_facture as pf, llx_paiement as p LEFT JOIN llx_c_paiement as c ON p.fk_paiement = c.id LEFT JOIN llx_bank as b ON p.fk_bank = b.rowid LEFT JOIN llx_bank_account as ba ON b.fk_account = ba.rowid WHERE pf.fk_facture = 45 AND pf.fk_paiement = p.rowid AND p.entity IN (1) ORDER BY p.datep, p.tms
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT re.rowid, re.amount_ht, re.amount_tva, re.amount_ttc, re.description, re.fk_facture_source FROM llx_societe_remise_except as re WHERE fk_facture = 45
2022-05-13 12:39:41 DEBUG 178.192.34.142 Facture::fetch_lines
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT l.rowid, l.fk_facture, l.fk_product, l.fk_parent_line, l.label as custom_label, l.description, l.product_type, l.price, l.qty, l.vat_src_code, l.tva_tx, l.localtax1_tx, l.localtax2_tx, l.localtax1_type, l.localtax2_type, l.remise_percent, l.fk_remise_except, l.subprice, l.ref_ext, l.situation_percent, l.fk_prev_id, l.rang, l.special_code, l.date_start as date_start, l.date_end as date_end, l.info_bits, l.total_ht, l.total_tva, l.total_localtax1, l.total_localtax2, l.total_ttc, l.fk_code_ventilation, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.fk_unit, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc, p.ref as product_ref, p.fk_product_type as fk_product_type, p.label as product_label, p.description as product_desc FROM llx_facturedet as l LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE l.fk_facture = 45 ORDER BY l.rang, l.rowid
2022-05-13 12:39:41 DEBUG 178.192.34.142 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 = 'facturedet' ORDER BY pos
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'CH' AND t.active = 1 AND t.localtax1_type <> '0'
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'CH' AND t.active = 1 AND t.localtax2_type <> '0'
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'CH' AND t.active = 1 AND t.localtax1_type <> '0'
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'CH' AND t.active = 1 AND t.localtax2_type <> '0'
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'CH' AND t.active = 1 AND t.localtax1_type <> '0'
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'CH' AND t.active = 1 AND t.localtax2_type <> '0'
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'CH' AND t.active = 1 AND t.localtax1_type <> '0'
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'CH' AND t.active = 1 AND t.localtax2_type <> '0'
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT COUNT(ab.rowid) as nb FROM llx_accounting_bookkeeping as ab WHERE ab.doc_type='customer_invoice' AND ab.fk_doc = 45
2022-05-13 12:39:41 DEBUG 178.192.34.142 DiscountAbsolute::fetch
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT sr.rowid, sr.fk_soc, sr.discount_type, sr.fk_user, sr.amount_ht, sr.amount_tva, sr.amount_ttc, sr.tva_tx, sr.vat_src_code, sr.multicurrency_amount_ht, sr.multicurrency_amount_tva, sr.multicurrency_amount_ttc, sr.fk_facture_line, sr.fk_facture, sr.fk_facture_source, sr.fk_invoice_supplier_line, sr.fk_invoice_supplier, sr.fk_invoice_supplier_source, sr.description, sr.datec, f.ref as ref_facture_source, f.type as type_facture_source, fsup.ref as ref_invoice_supplier_source, fsup.type as type_invoice_supplier_source FROM llx_societe_remise_except as sr LEFT JOIN llx_facture as f ON sr.fk_facture_source = f.rowid LEFT JOIN llx_facture_fourn as fsup ON sr.fk_invoice_supplier_source = fsup.rowid WHERE sr.entity IN (1) AND sr.fk_facture_source = 45
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT COUNT(ab.rowid) as nb FROM llx_accounting_bookkeeping as ab WHERE ab.doc_type='customer_invoice' AND ab.fk_doc = 45
2022-05-13 12:39:41 DEBUG 178.192.34.142 Call getNextNumRef with FACTURE_ADDON = mod_facture_terre, thirdparty=CVE Baulmes, type=
2022-05-13 12:39:41 DEBUG 178.192.34.142 mod_facture_terre::getNextValue mode=last
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT MAX(CAST(SUBSTRING(ref FROM 8) AS SIGNED)) as max FROM llx_facture WHERE ref LIKE 'FA____-%' AND entity IN (1)
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT ref as ref FROM llx_facture WHERE ref LIKE 'FA____-0046' AND entity IN (1) ORDER BY ref DESC
2022-05-13 12:39:41 DEBUG 178.192.34.142 Facture::getSommePaiement
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiement_facture WHERE fk_facture = 45
2022-05-13 12:39:41 INFO 178.192.34.142 files.lib.php::dol_dir_list path=/var/www/nicoledevals.ch/web/dolibarr-perso/documents/facture/FA2204-0046 types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*.*\\.png)$"
2022-05-13 12:39:41 DEBUG 178.192.34.142 /core/lib/function2.lib.php::getListOfModels
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT nom as id, nom as doc_template_name, libelle as label, description as description FROM llx_document_model WHERE type = 'invoice' AND entity IN (0,1) ORDER BY description DESC
2022-05-13 12:39:41 DEBUG 178.192.34.142 HookManager::executeHooks Qualified hook found (hooktype=output). We call method ActionsSwissBanking->formBuilddocOptions, context=invoicecard, module=swissbanking, action=, objectid=45
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT * FROM llx_swissbanking_accounts WHERE NOT rowid='0' AND entity='1' ORDER BY isdefault DESC, label ASC
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT * FROM llx_swissbanking WHERE invoiceid='45' AND entity='1' LIMIT 1
2022-05-13 12:39:41 DEBUG 178.192.34.142 Link::fetchAll
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT rowid, entity, datea, url, label, objecttype, objectid FROM llx_links WHERE objecttype = 'facture' AND objectid = 45 AND entity = 1
2022-05-13 12:39:41 DEBUG 178.192.34.142 Link::fetchAll 0records
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, tms as date_m, fk_user_c, fk_user_m, acl, position, share FROM llx_ecm_files WHERE entity = 1 AND filepath = 'facture/FA2204-0046'
2022-05-13 12:39:41 DEBUG 178.192.34.142 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 (30) AND t.entity IN (1)
2022-05-13 12:39:41 DEBUG 178.192.34.142 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_commande as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (30) AND t.entity IN (1)
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.titre as ref, t.total_ht FROM llx_societe as s, llx_facture_rec as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (30) AND t.entity IN (1)
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref, '' as ref_supplier, t.total_ht FROM llx_societe as s, llx_supplier_proposal as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (30) AND t.entity IN (1)
2022-05-13 12:39:41 DEBUG 178.192.34.142 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 (30) AND t.entity IN (1)
2022-05-13 12:39:41 DEBUG 178.192.34.142 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 (30) AND t.entity IN (1)
2022-05-13 12:39:41 DEBUG 178.192.34.142 Facture::fetchObjectLink
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT rowid, fk_source, sourcetype, fk_target, targettype FROM llx_element_element WHERE (fk_source = 45 AND sourcetype = 'facture') OR (fk_target = 45 AND targettype = 'facture') ORDER BY sourcetype
2022-05-13 12:39:41 DEBUG 178.192.34.142 ActionComm::getActions
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT a.id FROM llx_actioncomm as a WHERE a.entity IN (1) AND a.fk_element = 45 AND a.elementtype = 'invoice' ORDER BY a.datep DESC, a.id DESC
2022-05-13 12:39:41 DEBUG 178.192.34.142 ActionComm::fetch
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT a.id, a.ref as ref, a.entity, a.ref_ext, a.datep, a.datep2, a.durationp, a.datec, a.tms as datem, a.code, a.label, a.note as note_private, a.fk_soc, a.fk_project, a.fk_user_author, a.fk_user_mod, a.fk_user_action, a.fk_user_done, a.fk_contact, a.percent as percentage, a.fk_element as elementid, a.elementtype, a.priority, a.fulldayevent, a.location, a.transparency, a.email_msgid, a.email_subject, a.email_from, a.email_to, a.email_tocc, a.email_tobcc, a.errors_to, c.id as type_id, c.type as type_type, c.code as type_code, c.libelle as type_label, c.color as type_color, c.picto as type_picto, s.nom as socname, u.firstname, u.lastname as lastname, num_vote, event_paid, a.status FROM llx_actioncomm as a LEFT JOIN llx_c_actioncomm as c ON a.fk_action=c.id LEFT JOIN llx_user as u on u.rowid = a.fk_user_author LEFT JOIN llx_societe as s on s.rowid = a.fk_soc WHERE a.id = 109
2022-05-13 12:39:41 DEBUG 178.192.34.142 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 = 'actioncomm' ORDER BY pos
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT fk_actioncomm, element_type, fk_element, answer_status, mandatory, transparency FROM llx_actioncomm_resources WHERE fk_actioncomm = 109 AND element_type IN ('user', 'socpeople')
2022-05-13 12:39:41 DEBUG 178.192.34.142 CActionComm::liste_array
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT id, code, libelle as label, module, type, color, picto FROM llx_c_actioncomm WHERE 1=1 AND active=1 ORDER BY type, position, module
2022-05-13 12:39:41 DEBUG 178.192.34.142 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.civility as civility_code, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.datelastpassvalidation, u.datestartvalidity, u.dateendvalidity, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IS NOT NULL AND u.rowid = 3 ORDER BY u.entity ASC
2022-05-13 12:39:41 INFO 178.192.34.142 --- End access to /htdocs/compta/facture/card.php
J’ai mis les dernières lignes car le fichier est assez volumineux et comme je suis « nouveau » je ne peux pas l’uploader.
Bonjour,
Il semblerait que vous ayiez le module swissbanking. Désactivez le temporairement pour voir si cela change quelque chose. Pensez à re-générer la facture.
Bonne journée
