Bug with invoice module: PHP error message on /compta/facture/card.php

[LesCarnets]

Dolibarr version : tested in 10.0.2 and 10.0.4
PHP Version : tested in 7.2 and 7.3

Hello,

In Home ► Setup ► Other, I added "FACTURE_DEPOSITS_ARE_JUST_PAYMENTS".

Unfortunatly, this change is breacking the invoice module: we are no more able to create a new invoice based on a proposal.
Here is the URL generated when I clik on « Create a new invoice »: /compta/facture/card.php?action=create&origin=propal&originid=19&socid=2
And, when I clik on it, I have following PHP error:

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

I tried to remove the variable "FACTURE_DEPOSITS_ARE_JUST_PAYMENTS" but the bug is persistent.
(I I can confirm the problem was not there before, I was able to create invoices based on a proposal: I event try to restore a backup to make sure I had not issue on this Dolibarr)

Thank you very much for your help.

Best regards,

[LesCarnets]

Hello,

A workorround has been found: remove the extrafield I created on PROPOSAL.

dolibarr.log file generated when I clik on "Create new invoice" once the module syslog is enabled (level 7):

2019-12-10 10:48:17 DEBUG - This is an already logged session. _SESSION[‹ dol_login ›]=user _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 /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//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//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//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 /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 /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 /compta/facture/card.php

[eldy]

What was the content / definition of the extrafield ? is it a "computed" field ? if yes what was the function ?

[dpriskorn]

Please upgrade to the latest version and reopen this if the problem persists.