Supplier product reference do not display

futurehousestore · October 11, 2017, 12:05pm

Hi,
For some reason, supplier product references do not show up in supplier’s proposals/invoices. If someone can have a look at my log and tell me where is the problem (it is a fresh install of Dolibarr 6.0.3 but I had it before on other versions 5.0 and 6.0 as well)

2017-10-11 13:51:17 DEBUG 81.105.86.182 - This is an already logged session. _SESSION['dol_login']=Future House Store _SESSION['dol_entity']=1 2017-10-11 13:51:17 DEBUG 81.105.86.182 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.email, u.job, u.skype, u.signature, u.office_phone, u.office_fax, u.user_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.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.ref_int, u.ref_ext, 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 = 'Future House Store' ORDER BY u.entity ASC 2017-10-11 13:51:17 INFO 81.105.86.182 fetch_name_optionals_label elementtype=user 2017-10-11 13:51:17 DEBUG 81.105.86.182 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden,fielddefault,fieldcomputed FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2017-10-11 13:51:17 DEBUG 81.105.86.182 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2017-10-11 13:51:17 DEBUG 81.105.86.182 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (0,1) AND user_id IN (0, 1) 2017-10-11 13:51:17 DEBUG 81.105.86.182 sql=SELECT 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 2017-10-11 13:51:17 DEBUG 81.105.86.182 sql=SELECT 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 2017-10-11 13:51:17 INFO 81.105.86.182 --- Access to /htdocs/fourn/commande/card.php - action=builddoc, massaction= 2017-10-11 13:51:17 DEBUG 81.105.86.182 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='en_GB' 2017-10-11 13:51:17 DEBUG 81.105.86.182 Menubase::menuLoad mymainmenu=commercial myleftmenu= type_user=0 menu_handler=auguria tabMenu size=0 2017-10-11 13:51:17 DEBUG 81.105.86.182 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 ('auguria','all') AND m.usertype IN (0,2) ORDER BY m.position, m.rowid 2017-10-11 13:51:17 INFO 81.105.86.182 Loading hook:actions_ultimatepdf.class.php 2017-10-11 13:51:17 INFO 81.105.86.182 fetch_name_optionals_label elementtype=commande_fournisseur 2017-10-11 13:51:17 DEBUG 81.105.86.182 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden,fielddefault,fieldcomputed FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande_fournisseur' ORDER BY pos 2017-10-11 13:51:17 DEBUG 81.105.86.182 CommandeFournisseur::fetch 2017-10-11 13:51:17 DEBUG 81.105.86.182 sql=SELECT c.rowid, c.ref, ref_supplier, c.fk_soc, c.fk_statut, c.amount_ht, c.total_ht, c.total_ttc, c.tva as total_vat, c.localtax1, c.localtax2, c.date_creation, c.date_valid, c.date_approve, c.date_approve2, c.fk_user_author, c.fk_user_valid, c.fk_user_approve, c.fk_user_approve2, c.date_commande as date_commande, c.date_livraison as date_livraison, c.fk_cond_reglement, c.fk_mode_reglement, c.fk_projet as fk_project, c.remise_percent, c.source, c.fk_input_method, c.fk_account, c.note_private, c.note_public, c.model_pdf, c.extraparams, c.billed, c.fk_multicurrency, c.multicurrency_code, c.multicurrency_tx, c.multicurrency_total_ht, c.multicurrency_total_tva, c.multicurrency_total_ttc, cm.libelle as methode_commande, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, c.fk_incoterms, c.location_incoterms, i.libelle as libelle_incoterms FROM llx_commande_fournisseur as c LEFT JOIN llx_c_payment_term as cr ON (c.fk_cond_reglement = cr.rowid) LEFT JOIN llx_c_paiement as p ON (c.fk_mode_reglement = p.id) LEFT JOIN llx_c_input_method as cm ON cm.rowid = c.fk_input_method LEFT JOIN llx_c_incoterms as i ON c.fk_incoterms = i.rowid WHERE c.entity = 1 AND c.rowid=15 2017-10-11 13:51:17 INFO 81.105.86.182 fetch_name_optionals_label elementtype=commande_fournisseur 2017-10-11 13:51:17 DEBUG 81.105.86.182 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden,fielddefault,fieldcomputed FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande_fournisseur' ORDER BY pos 2017-10-11 13:51:17 DEBUG 81.105.86.182 CommandeFournisseur::fetchObjectLink 2017-10-11 13:51:17 DEBUG 81.105.86.182 sql=SELECT rowid, fk_source, sourcetype, fk_target, targettype FROM llx_element_element WHERE (fk_source = 15 AND sourcetype = 'order_supplier') OR (fk_target = 15 AND targettype = 'order_supplier') ORDER BY sourcetype 2017-10-11 13:51:17 DEBUG 81.105.86.182 CommandeFournisseur::fetch get lines 2017-10-11 13:51:17 DEBUG 81.105.86.182 sql=SELECT l.rowid, l.ref as ref_supplier, l.fk_product, l.product_type, l.label, l.description, l.qty, l.vat_src_code, l.tva_tx, l.remise_percent, l.subprice, l.localtax1_tx, l. localtax2_tx, l.localtax1_type, l. localtax2_type, l.total_localtax1, l.total_localtax2, l.total_ht, l.total_tva, l.total_ttc, l.special_code, l.fk_parent_line, l.rang, p.rowid as product_id, p.ref as product_ref, p.label as product_label, p.description as product_desc, l.fk_unit, l.date_start, l.date_end, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc FROM llx_commande_fournisseurdet as l LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE l.fk_commande = 15 ORDER BY l.rang, l.rowid 2017-10-11 13:51:17 DEBUG 81.105.86.182 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.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, s.fk_pays as country_id, s.fk_stcomm, s.remise_client, 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.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 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 WHERE s.rowid = 3 2017-10-11 13:51:17 INFO 81.105.86.182 fetch_name_optionals_label elementtype=societe 2017-10-11 13:51:17 DEBUG 81.105.86.182 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden,fielddefault,fieldcomputed FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2017-10-11 13:51:17 INFO 81.105.86.182 HookManager::executeHooks a qualified hook was found for method=doActions module=ultimatepdf action=builddoc context=ordersuppliercard 2017-10-11 13:51:17 DEBUG 81.105.86.182 Call method doActions of class ActionsUltimatepdf, module=ultimatepdf, hooktype=addreplace 2017-10-11 13:51:17 DEBUG 81.105.86.182 ActionsUltimatepdf::doActions 2017-10-11 13:51:17 DEBUG 81.105.86.182 CommandeFournisseur::fetch 2017-10-11 13:51:17 DEBUG 81.105.86.182 sql=SELECT c.rowid, c.ref, ref_supplier, c.fk_soc, c.fk_statut, c.amount_ht, c.total_ht, c.total_ttc, c.tva as total_vat, c.localtax1, c.localtax2, c.date_creation, c.date_valid, c.date_approve, c.date_approve2, c.fk_user_author, c.fk_user_valid, c.fk_user_approve, c.fk_user_approve2, c.date_commande as date_commande, c.date_livraison as date_livraison, c.fk_cond_reglement, c.fk_mode_reglement, c.fk_projet as fk_project, c.remise_percent, c.source, c.fk_input_method, c.fk_account, c.note_private, c.note_public, c.model_pdf, c.extraparams, c.billed, c.fk_multicurrency, c.multicurrency_code, c.multicurrency_tx, c.multicurrency_total_ht, c.multicurrency_total_tva, c.multicurrency_total_ttc, cm.libelle as methode_commande, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, c.fk_incoterms, c.location_incoterms, i.libelle as libelle_incoterms FROM llx_commande_fournisseur as c LEFT JOIN llx_c_payment_term as cr ON (c.fk_cond_reglement = cr.rowid) LEFT JOIN llx_c_paiement as p ON (c.fk_mode_reglement = p.id) LEFT JOIN llx_c_input_method as cm ON cm.rowid = c.fk_input_method LEFT JOIN llx_c_incoterms as i ON c.fk_incoterms = i.rowid WHERE c.entity = 1 AND c.rowid=15 2017-10-11 13:51:17 INFO 81.105.86.182 fetch_name_optionals_label elementtype=commande_fournisseur 2017-10-11 13:51:17 DEBUG 81.105.86.182 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden,fielddefault,fieldcomputed FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande_fournisseur' ORDER BY pos 2017-10-11 13:51:17 DEBUG 81.105.86.182 CommandeFournisseur::fetchObjectLink 2017-10-11 13:51:17 DEBUG 81.105.86.182 sql=SELECT rowid, fk_source, sourcetype, fk_target, targettype FROM llx_element_element WHERE (fk_source = 15 AND sourcetype = 'order_supplier') OR (fk_target = 15 AND targettype = 'order_supplier') ORDER BY sourcetype 2017-10-11 13:51:17 DEBUG 81.105.86.182 CommandeFournisseur::fetch get lines 2017-10-11 13:51:17 DEBUG 81.105.86.182 sql=SELECT l.rowid, l.ref as ref_supplier, l.fk_product, l.product_type, l.label, l.description, l.qty, l.vat_src_code, l.tva_tx, l.remise_percent, l.subprice, l.localtax1_tx, l. localtax2_tx, l.localtax1_type, l. localtax2_type, l.total_localtax1, l.total_localtax2, l.total_ht, l.total_tva, l.total_ttc, l.special_code, l.fk_parent_line, l.rang, p.rowid as product_id, p.ref as product_ref, p.label as product_label, p.description as product_desc, l.fk_unit, l.date_start, l.date_end, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc FROM llx_commande_fournisseurdet as l LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE l.fk_commande = 15 ORDER BY l.rang, l.rowid 2017-10-11 13:51:17 DEBUG 81.105.86.182 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.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, s.fk_pays as country_id, s.fk_stcomm, s.remise_client, 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.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 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 WHERE s.rowid = 3 2017-10-11 13:51:17 INFO 81.105.86.182 fetch_name_optionals_label elementtype=societe 2017-10-11 13:51:17 DEBUG 81.105.86.182 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden,fielddefault,fieldcomputed FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2017-10-11 13:51:17 DEBUG 81.105.86.182 CommandeFournisseur::setDocModel 2017-10-11 13:51:17 DEBUG 81.105.86.182 sql=UPDATE llx_commande_fournisseur SET model_pdf = 'muscadet' WHERE rowid = 15 2017-10-11 13:51:17 DEBUG 81.105.86.182 sql=SELECT code, label, width, height, unit FROM llx_c_paper_format WHERE code = 'EUA4' 2017-10-11 13:51:17 DEBUG 81.105.86.182 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='en_GB' 2017-10-11 13:51:17 DEBUG 81.105.86.182 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.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, s.fk_pays as country_id, s.fk_stcomm, s.remise_client, 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.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 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 WHERE s.rowid = 3 2017-10-11 13:51:17 INFO 81.105.86.182 fetch_name_optionals_label elementtype=societe 2017-10-11 13:51:17 DEBUG 81.105.86.182 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden,fielddefault,fieldcomputed FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2017-10-11 13:51:17 INFO 81.105.86.182 Loading hook:actions_ultimatepdf.class.php 2017-10-11 13:51:17 INFO 81.105.86.182 functions.lib::dol_mkdir: dir=/home/*******/domains/*******/public_html/workflow/documents/admin/temp/ 2017-10-11 13:51:21 DEBUG 81.105.86.182 CommandeFournisseur::fetchObjectLink 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT rowid, fk_source, sourcetype, fk_target, targettype FROM llx_element_element WHERE (fk_source = 15 AND sourcetype = 'order_supplier') OR (fk_target = 15 AND targettype = 'order_supplier') ORDER BY sourcetype 2017-10-11 13:51:21 DEBUG 81.105.86.182 Company.lib::getState 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT rowid, code_departement as code, nom as label FROM llx_c_departements WHERE rowid=1310 2017-10-11 13:51:21 DEBUG 81.105.86.182 Company.lib::getState 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT rowid, code_departement as code, nom as label FROM llx_c_departements WHERE rowid=1310 2017-10-11 13:51:21 DEBUG 81.105.86.182 Company.lib::getState 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT rowid, code_departement as code, nom as label FROM llx_c_departements WHERE rowid=7955 2017-10-11 13:51:21 DEBUG 81.105.86.182 CommandeFournisseur::getIdContact 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT ec.fk_socpeople FROM llx_element_contact as ec, llx_socpeople as c, llx_c_type_contact as tc WHERE ec.element_id = 15 AND ec.fk_socpeople = c.rowid AND c.entity IN (1) AND ec.fk_c_type_contact = tc.rowid AND tc.element = 'order_supplier' AND tc.source = 'external' AND tc.code = 'BILLING' AND tc.active = 1 2017-10-11 13:51:21 INFO 81.105.86.182 ProductFournisseur::fetch id=34 ref= ref_ext= 2017-10-11 13:51:21 DEBUG 81.105.86.182 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, 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, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 34 2017-10-11 13:51:21 INFO 81.105.86.182 fetch_name_optionals_label elementtype=product 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden,fielddefault,fieldcomputed FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'product' ORDER BY pos 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT lang, label, description, note as other FROM llx_product_lang WHERE fk_product=34 2017-10-11 13:51:21 INFO 81.105.86.182 Loading hook:actions_ultimatepdf.class.php 2017-10-11 13:51:21 INFO 81.105.86.182 HookManager::executeHooks a qualified hook was found for method=afterPDFCreation module=ultimatepdf action=builddoc context=ordersuppliercard 2017-10-11 13:51:21 ERR 81.105.86.182 Error: Bug into hook afterPDFCreation of module class ActionsUltimatepdf. Method must not return a string but an int (0=OK, 1=Replace, -1=KO) and set string into ->resprints 2017-10-11 13:51:21 INFO 81.105.86.182 --- End access to /htdocs/fourn/commande/card.php 2017-10-11 13:51:21 DEBUG 81.105.86.182 - This is an already logged session. _SESSION['dol_login']=Future House Store _SESSION['dol_entity']=1 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.email, u.job, u.skype, u.signature, u.office_phone, u.office_fax, u.user_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.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.ref_int, u.ref_ext, 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 = 'Future House Store' ORDER BY u.entity ASC 2017-10-11 13:51:21 INFO 81.105.86.182 fetch_name_optionals_label elementtype=user 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden,fielddefault,fieldcomputed FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (0,1) AND user_id IN (0, 1) 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT 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 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT 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 2017-10-11 13:51:21 INFO 81.105.86.182 --- Access to /htdocs/fourn/commande/card.php - action=, massaction= 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='en_GB' 2017-10-11 13:51:21 DEBUG 81.105.86.182 Menubase::menuLoad mymainmenu=commercial myleftmenu= type_user=0 menu_handler=auguria tabMenu size=0 2017-10-11 13:51:21 DEBUG 81.105.86.182 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 ('auguria','all') AND m.usertype IN (0,2) ORDER BY m.position, m.rowid 2017-10-11 13:51:21 INFO 81.105.86.182 Loading hook:actions_ultimatepdf.class.php 2017-10-11 13:51:21 INFO 81.105.86.182 fetch_name_optionals_label elementtype=commande_fournisseur 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden,fielddefault,fieldcomputed FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande_fournisseur' ORDER BY pos 2017-10-11 13:51:21 DEBUG 81.105.86.182 CommandeFournisseur::fetch 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT c.rowid, c.ref, ref_supplier, c.fk_soc, c.fk_statut, c.amount_ht, c.total_ht, c.total_ttc, c.tva as total_vat, c.localtax1, c.localtax2, c.date_creation, c.date_valid, c.date_approve, c.date_approve2, c.fk_user_author, c.fk_user_valid, c.fk_user_approve, c.fk_user_approve2, c.date_commande as date_commande, c.date_livraison as date_livraison, c.fk_cond_reglement, c.fk_mode_reglement, c.fk_projet as fk_project, c.remise_percent, c.source, c.fk_input_method, c.fk_account, c.note_private, c.note_public, c.model_pdf, c.extraparams, c.billed, c.fk_multicurrency, c.multicurrency_code, c.multicurrency_tx, c.multicurrency_total_ht, c.multicurrency_total_tva, c.multicurrency_total_ttc, cm.libelle as methode_commande, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, c.fk_incoterms, c.location_incoterms, i.libelle as libelle_incoterms FROM llx_commande_fournisseur as c LEFT JOIN llx_c_payment_term as cr ON (c.fk_cond_reglement = cr.rowid) LEFT JOIN llx_c_paiement as p ON (c.fk_mode_reglement = p.id) LEFT JOIN llx_c_input_method as cm ON cm.rowid = c.fk_input_method LEFT JOIN llx_c_incoterms as i ON c.fk_incoterms = i.rowid WHERE c.entity = 1 AND c.rowid=15 2017-10-11 13:51:21 INFO 81.105.86.182 fetch_name_optionals_label elementtype=commande_fournisseur 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden,fielddefault,fieldcomputed FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande_fournisseur' ORDER BY pos 2017-10-11 13:51:21 DEBUG 81.105.86.182 CommandeFournisseur::fetchObjectLink 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT rowid, fk_source, sourcetype, fk_target, targettype FROM llx_element_element WHERE (fk_source = 15 AND sourcetype = 'order_supplier') OR (fk_target = 15 AND targettype = 'order_supplier') ORDER BY sourcetype 2017-10-11 13:51:21 DEBUG 81.105.86.182 CommandeFournisseur::fetch get lines 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT l.rowid, l.ref as ref_supplier, l.fk_product, l.product_type, l.label, l.description, l.qty, l.vat_src_code, l.tva_tx, l.remise_percent, l.subprice, l.localtax1_tx, l. localtax2_tx, l.localtax1_type, l. localtax2_type, l.total_localtax1, l.total_localtax2, l.total_ht, l.total_tva, l.total_ttc, l.special_code, l.fk_parent_line, l.rang, p.rowid as product_id, p.ref as product_ref, p.label as product_label, p.description as product_desc, l.fk_unit, l.date_start, l.date_end, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc FROM llx_commande_fournisseurdet as l LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE l.fk_commande = 15 ORDER BY l.rang, l.rowid 2017-10-11 13:51:21 DEBUG 81.105.86.182 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.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, s.fk_pays as country_id, s.fk_stcomm, s.remise_client, 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.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 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 WHERE s.rowid = 3 2017-10-11 13:51:21 INFO 81.105.86.182 fetch_name_optionals_label elementtype=societe 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden,fielddefault,fieldcomputed FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2017-10-11 13:51:21 INFO 81.105.86.182 HookManager::executeHooks a qualified hook was found for method=doActions module=ultimatepdf action= context=ordersuppliercard 2017-10-11 13:51:21 DEBUG 81.105.86.182 Call method doActions of class ActionsUltimatepdf, module=ultimatepdf, hooktype=addreplace 2017-10-11 13:51:21 DEBUG 81.105.86.182 ActionsUltimatepdf::doActions 2017-10-11 13:51:21 INFO 81.105.86.182 Loading hook:actions_ultimatepdf.class.php 2017-10-11 13:51:21 INFO 81.105.86.182 HookManager::executeHooks a qualified hook was found for method=printTopRightMenu module=ultimatepdf action= context=ordersuppliercard 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT rowid, label, description, options, active FROM llx_ultimatepdf WHERE rowid = 1 2017-10-11 13:51:21 DEBUG 81.105.86.182 DaoUltimatepdf::getDesigns sql=SELECT rowid FROM llx_ultimatepdf ORDER by rowid 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT rowid FROM llx_ultimatepdf ORDER by rowid 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT rowid, label, description, options, active FROM llx_ultimatepdf WHERE rowid = 1 2017-10-11 13:51:21 DEBUG 81.105.86.182 DaoUltimatepdf::getDesigns sql=SELECT rowid FROM llx_ultimatepdf ORDER by rowid 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT rowid FROM llx_ultimatepdf ORDER by rowid 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT rowid, label, description, options, active FROM llx_ultimatepdf WHERE rowid = 1 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT rowid, title, url, target FROM llx_bookmark WHERE (fk_user = 1 OR fk_user is NULL OR fk_user = 0) AND entity IN (1) ORDER BY position 2017-10-11 13:51:21 DEBUG 81.105.86.182 CommandeFournisseur::fetch 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT c.rowid, c.ref, ref_supplier, c.fk_soc, c.fk_statut, c.amount_ht, c.total_ht, c.total_ttc, c.tva as total_vat, c.localtax1, c.localtax2, c.date_creation, c.date_valid, c.date_approve, c.date_approve2, c.fk_user_author, c.fk_user_valid, c.fk_user_approve, c.fk_user_approve2, c.date_commande as date_commande, c.date_livraison as date_livraison, c.fk_cond_reglement, c.fk_mode_reglement, c.fk_projet as fk_project, c.remise_percent, c.source, c.fk_input_method, c.fk_account, c.note_private, c.note_public, c.model_pdf, c.extraparams, c.billed, c.fk_multicurrency, c.multicurrency_code, c.multicurrency_tx, c.multicurrency_total_ht, c.multicurrency_total_tva, c.multicurrency_total_ttc, cm.libelle as methode_commande, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, c.fk_incoterms, c.location_incoterms, i.libelle as libelle_incoterms FROM llx_commande_fournisseur as c LEFT JOIN llx_c_payment_term as cr ON (c.fk_cond_reglement = cr.rowid) LEFT JOIN llx_c_paiement as p ON (c.fk_mode_reglement = p.id) LEFT JOIN llx_c_input_method as cm ON cm.rowid = c.fk_input_method LEFT JOIN llx_c_incoterms as i ON c.fk_incoterms = i.rowid WHERE c.entity = 1 AND c.rowid=15 2017-10-11 13:51:21 INFO 81.105.86.182 fetch_name_optionals_label elementtype=commande_fournisseur 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden,fielddefault,fieldcomputed FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande_fournisseur' ORDER BY pos 2017-10-11 13:51:21 DEBUG 81.105.86.182 CommandeFournisseur::fetchObjectLink 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT rowid, fk_source, sourcetype, fk_target, targettype FROM llx_element_element WHERE (fk_source = 15 AND sourcetype = 'order_supplier') OR (fk_target = 15 AND targettype = 'order_supplier') ORDER BY sourcetype 2017-10-11 13:51:21 DEBUG 81.105.86.182 CommandeFournisseur::fetch get lines 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT l.rowid, l.ref as ref_supplier, l.fk_product, l.product_type, l.label, l.description, l.qty, l.vat_src_code, l.tva_tx, l.remise_percent, l.subprice, l.localtax1_tx, l. localtax2_tx, l.localtax1_type, l. localtax2_type, l.total_localtax1, l.total_localtax2, l.total_ht, l.total_tva, l.total_ttc, l.special_code, l.fk_parent_line, l.rang, p.rowid as product_id, p.ref as product_ref, p.label as product_label, p.description as product_desc, l.fk_unit, l.date_start, l.date_end, l.fk_multicurrency, l.multicurrency_code, l.multicurrency_subprice, l.multicurrency_total_ht, l.multicurrency_total_tva, l.multicurrency_total_ttc FROM llx_commande_fournisseurdet as l LEFT JOIN llx_product as p ON l.fk_product = p.rowid WHERE l.fk_commande = 15 ORDER BY l.rang, l.rowid 2017-10-11 13:51:21 DEBUG 81.105.86.182 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.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, s.fk_pays as country_id, s.fk_stcomm, s.remise_client, 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.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 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 WHERE s.rowid = 3 2017-10-11 13:51:21 INFO 81.105.86.182 fetch_name_optionals_label elementtype=societe 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden,fielddefault,fieldcomputed FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.email, u.job, u.skype, u.signature, u.office_phone, u.office_fax, u.user_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.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.ref_int, u.ref_ext, 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 = 1 ORDER BY u.entity ASC 2017-10-11 13:51:21 INFO 81.105.86.182 fetch_name_optionals_label elementtype=user 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden,fielddefault,fieldcomputed FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2017-10-11 13:51:21 DEBUG 81.105.86.182 CommandeFournisseur::liste_contact 2017-10-11 13:51:21 DEBUG 81.105.86.182 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 =15 AND ec.fk_c_type_contact=tc.rowid AND tc.element='order_supplier' AND tc.source = 'internal' AND tc.active=1 ORDER BY t.lastname ASC 2017-10-11 13:51:21 DEBUG 81.105.86.182 CommandeFournisseur::liste_contact 2017-10-11 13:51:21 DEBUG 81.105.86.182 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 =15 AND ec.fk_c_type_contact=tc.rowid AND tc.element='order_supplier' AND tc.source = 'external' AND tc.active=1 ORDER BY t.lastname ASC 2017-10-11 13:51:21 INFO 81.105.86.182 files.lib.php::dol_dir_list path=/home/*******/domains/*******/public_html/workflow/documents/fournisseur/commande/(PROV15) types=files recursive=0 filter= excludefilter="(\.meta|_preview.*\.png)$" 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT COUNT(rowid) as nb FROM llx_links WHERE objecttype = 'order_supplier' AND objectid = 15 AND entity = 1 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT MAX(te.ref) FROM llx_commande_fournisseur as te WHERE te.ref < '(PROV15)' AND te.entity IN (1) 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT MIN(te.ref) FROM llx_commande_fournisseur as te WHERE te.ref > '(PROV15)' AND te.entity IN (1) 2017-10-11 13:51:21 DEBUG 81.105.86.182 Form::load_cache_conditions_paiements 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT rowid, code, libelle as label FROM llx_c_payment_term WHERE active > 0 ORDER BY sortorder 2017-10-11 13:51:21 DEBUG 81.105.86.182 ProductFournisseur::find_min_price_product_fournisseur 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT s.nom as supplier_name, s.rowid as fourn_id, pfp.rowid as product_fourn_price_id, pfp.ref_fourn, pfp.price, pfp.quantity, pfp.unitprice, pfp.tva_tx, pfp.charges, pfp.unitcharges, pfp.remise, pfp.remise_percent, pfp.fk_supplier_price_expression, pfp.delivery_time_days FROM llx_societe as s, llx_product_fournisseur_price as pfp WHERE s.entity IN (1) AND pfp.fk_product = 34 AND pfp.fk_soc = s.rowid AND s.status = 1 AND pfp.quantity <= 1 2017-10-11 13:51:21 INFO 81.105.86.182 ProductFournisseur::fetch id=1 ref= ref_ext= 2017-10-11 13:51:21 DEBUG 81.105.86.182 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, 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, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 1 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT rowid, code, label FROM llx_c_country WHERE rowid=9 2017-10-11 13:51:21 INFO 81.105.86.182 fetch_name_optionals_label elementtype=product 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden,fielddefault,fieldcomputed FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'product' ORDER BY pos 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT lang, label, description, note as other FROM llx_product_lang WHERE fk_product=1 2017-10-11 13:51:21 INFO 81.105.86.182 HookManager::executeHooks a qualified hook was found for method=formObjectOptions module=ultimatepdf action= context=ordersuppliercard 2017-10-11 13:51:21 DEBUG 81.105.86.182 Call method formObjectOptions of class ActionsUltimatepdf, module=ultimatepdf, hooktype=addreplace 2017-10-11 13:51:21 DEBUG 81.105.86.182 ActionsUltimatepdf::formObjectOptions 2017-10-11 13:51:21 DEBUG 81.105.86.182 Supplierordermergedpdf::fetch_by_supplierorder sql=SELECT t.rowid, t.fk_commande, t.file_name, t.fk_user_author, t.fk_user_mod, t.datec, t.tms, t.import_key FROM llx_ultimatepdf_supplierorder_merged_pdf as t WHERE t.fk_commande = 15 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT t.rowid, t.fk_commande, t.file_name, t.fk_user_author, t.fk_user_mod, t.datec, t.tms, t.import_key FROM llx_ultimatepdf_supplierorder_merged_pdf as t WHERE t.fk_commande = 15 2017-10-11 13:51:21 INFO 81.105.86.182 files.lib.php::dol_dir_list path=/home/*******/domains/*******/public_html/workflow/documents/fournisseur/commande/(PROV15) types=files recursive=0 filter= excludefilter="\.meta$" 2017-10-11 13:51:21 DEBUG 81.105.86.182 Translate::loadCacheCurrencies 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1 AND code_iso = 'GBP' 2017-10-11 13:51:21 DEBUG 81.105.86.182 Translate::loadCacheCurrencies 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1 AND code_iso = 'PLN' 2017-10-11 13:51:21 DEBUG 81.105.86.182 Translate::getLabelFromKey 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'PLN' 2017-10-11 13:51:21 INFO 81.105.86.182 fetch_name_optionals_label elementtype=commande_fournisseurdet 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden,fielddefault,fieldcomputed FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande_fournisseurdet' ORDER BY pos 2017-10-11 13:51:21 INFO 81.105.86.182 Product::fetch id=34 ref= ref_ext= 2017-10-11 13:51:21 DEBUG 81.105.86.182 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, 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, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 34 2017-10-11 13:51:21 INFO 81.105.86.182 fetch_name_optionals_label elementtype=product 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden,fielddefault,fieldcomputed FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'product' ORDER BY pos 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT lang, label, description, note as other FROM llx_product_lang WHERE fk_product=34 2017-10-11 13:51:21 INFO 81.105.86.182 files.lib.php::dol_dir_list path=/home/*******/domains/*******/public_html/workflow/documents/produit/P0033/ types=files recursive=0 filter= excludefilter="(\.meta|_preview.*\.png)$" 2017-10-11 13:51:21 DEBUG 81.105.86.182 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 FROM llx_ecm_files WHERE filepath = 'produit/P0033' AND entity = 1 2017-10-11 13:51:21 INFO 81.105.86.182 Product::fetch id=34 ref= ref_ext= 2017-10-11 13:51:21 DEBUG 81.105.86.182 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, 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, stock, pmp, datec, tms, import_key, entity, desiredstock, tobatch, fk_unit, fk_price_expression, price_autogen FROM llx_product WHERE rowid = 34 2017-10-11 13:51:21 INFO 81.105.86.182 fetch_name_optionals_label elementtype=product 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden,fielddefault,fieldcomputed FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'product' ORDER BY pos 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT lang, label, description, note as other FROM llx_product_lang WHERE fk_product=34 2017-10-11 13:51:21 INFO 81.105.86.182 fetch_name_optionals_label elementtype=commande_fournisseurdet 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden,fielddefault,fieldcomputed FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande_fournisseurdet' ORDER BY pos 2017-10-11 13:51:21 INFO 81.105.86.182 DolEditor::DolEditor htmlname=dp_desc width= height=100 toolbarname=dolibarr_details 2017-10-11 13:51:21 DEBUG 81.105.86.182 Form::load_cache_vatrates 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT DISTINCT t.rowid, t.code, t.taux, t.localtax1, t.localtax1_type, t.localtax2, t.localtax2_type, t.recuperableonly FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND t.active > 0 AND c.code IN ('PL') ORDER BY t.code ASC, t.taux ASC, t.recuperableonly ASC 2017-10-11 13:51:21 INFO 81.105.86.182 get_default_tva: seller use vat=1, seller country=PL, seller in cee=1, buyer country=GB, buyer in cee=1, idprod=0, idprodfournprice=0, SERVICE_ARE_ECOMMERCE_200238EC= 2017-10-11 13:51:21 DEBUG 81.105.86.182 /core/lib/function2.lib.php::getListOfModels 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT nom as id, nom as lib, libelle as label, description as description FROM llx_document_model WHERE type = 'order_supplier' AND entity IN (0,1) ORDER BY description DESC 2017-10-11 13:51:21 INFO 81.105.86.182 HookManager::executeHooks a qualified hook was found for method=formBuilddocOptions module=ultimatepdf action= context=ordersuppliercard 2017-10-11 13:51:21 INFO 81.105.86.182 files.lib.php::dol_dir_list path=/home/*******/domains/*******/public_html/workflow/documents/fournisseur/commande/(PROV15) types=files recursive=0 filter= excludefilter="(\.meta|_preview.*.*\.png)$" 2017-10-11 13:51:21 DEBUG 81.105.86.182 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 (3) AND t.entity IN (1) 2017-10-11 13:51:21 DEBUG 81.105.86.182 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 (3) AND t.entity IN (1) 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.facnumber as 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 (3) AND t.entity IN (1) 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref, t.ref_supplier, '' as total_ht FROM llx_societe as s, llx_contrat as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (3) AND t.entity IN (1) 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT s.rowid as socid, s.nom as name, s.client, t.rowid, t.ref FROM llx_societe as s, llx_fichinter as t WHERE t.fk_soc = s.rowid AND t.fk_soc IN (3) AND t.entity IN (1) 2017-10-11 13:51:21 DEBUG 81.105.86.182 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 (3) AND t.entity IN (1) 2017-10-11 13:51:21 DEBUG 81.105.86.182 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 (3) AND t.entity IN (1) 2017-10-11 13:51:21 DEBUG 81.105.86.182 CommandeFournisseur::fetchObjectLink 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT rowid, fk_source, sourcetype, fk_target, targettype FROM llx_element_element WHERE (fk_source = 15 AND sourcetype = 'order_supplier') OR (fk_target = 15 AND targettype = 'order_supplier') ORDER BY sourcetype 2017-10-11 13:51:21 DEBUG 81.105.86.182 ActionComm::getActions 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT a.id FROM llx_actioncomm as a WHERE a.entity IN (1) AND a.fk_element = 15 AND a.elementtype = 'order_supplier' 2017-10-11 13:51:21 DEBUG 81.105.86.182 ActionComm::fetch 2017-10-11 13:51:21 DEBUG 81.105.86.182 sql=SELECT a.id, a.id as ref, a.ref_ext, a.datep, a.datep2, a.durationp, a.datec, a.tms as datem, a.code, a.label, a.note, 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, a.elementtype, a.priority, a.fulldayevent, a.location, a.punctual, a.transparency, c.id as type_id, 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 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=1764 2017-10-11 13:51:21 INFO 81.105.86.182 --- End access to /htdocs/fourn/commande/card.php
Any help will be much appreceated.

aljawaid · October 11, 2017, 10:12pm

did you check the hidden options to make sure it is set correctly?

futurehousestore · October 12, 2017, 1:50am

I was playing with the hidden option to display external/internal product reference but this didn’t help. Below are the hidden options that I use.

aljawaid · October 14, 2017, 9:37am

incomplete message?

futurehousestore · October 14, 2017, 10:20am

Cheers aljawaid. I don’t know why it posted without the attachment. My hidden options are listed below

MAILING_LIMIT_SENDBYWEB 25 MAIN_ENABLE_LOG_TO_HTML 0 MAIN_FEATURES_LEVEL 0 MAIN_SECURITY_CSRF_WITH_TOKEN 1 FCKEDITOR_ENABLE_DETAILS_FULL 1 FTP_CONNECT_WITH_SFTP 0 FTP_CONNECT_WITH_SSL 0 MAIN_APPLICATION_TITLE Future House Store - Workflow MAIN_DISPLAY_FOLD_MARK 0 MAIN_FIX_FOR_BUGGED_MTA 1 MAIN_PRODUCT_DISABLE_CUSTOMCOUNTRYCODE 1 STOCK_ALLOW_NEGATIVE_TRANSFER 1 SUPPLIER_ORDER_EDIT_BUYINGPRICE_DURING_RECEIPT 0 SUPPLIER_ORDER_WITH_NOPRICEDEFINED 1

aljawaid · October 16, 2017, 8:27pm

SUPPLIER_ORDER_WITH_NOPRICEDEFINED 1

change that to “2” and see what you get.

aljawaid · October 16, 2017, 8:29pm

then change back to “1” after you tested it (just in case the value never got saved properly (I had that issue before)

futurehousestore · October 17, 2017, 8:48am

Thanks aljawaid. I have changed it to 2,0,1 and even deleted the config file and reinstall doli but unfortunately, it hasn’t fixed the problem, anyway I think there is something wrong with the database as I’ve tested it on Dolibarr 5 and Dolibarr 6 with different settings. I also think that the issue is caused by “Module woocommerce EN” as I was trying to finally connect my doli with my woo store (unfortunately with no luck). I have removed the Module woocommerce EN files from my dolibarr server but the data in database still exist and I don’t even want to play with the database as I’ve got no clue about it whatsoever. Supplier product references display on a product card and in the order card search field but they do not show up on PDF files at all as well as on CSV files.

futurehousestore · October 28, 2017, 9:56pm

I think that is my problem

Loading hook:actions_ultimatepdf.class.php HookManager::executeHooks a qualified hook was found for method=afterPDFCreation module=ultimatepdf action=builddoc context=ordersuppliercard Error: Bug into hook afterPDFCreation of module class ActionsUltimatepdf. Method must not return a string but an int (0=OK, 1=Replace, -1=KO) and set string into ->resprints but how to sort it out?

aljawaid · October 29, 2017, 10:09am

You need to sort it out with the developer of the UltimatePDF module.