search

Dolibarr / dolibarr

Dolibarr ERP CRM is a modern software package to manage your company or foundation's activity (contacts, suppliers, invoices, orders, stocks, agenda, accounting, ...). it's an open source Web application (written in PHP) designed for businesses of any sizes, foundations and freelancers.
https://www.dolibarr.org
GNU General Public License v3.0
5.29k stars 2.74k forks source link

Unknown column 'XXX' in 'field list' #5208

Closed Max84 closed 8 years ago

Max84 commented 8 years ago

Hi Folks,

I've dolibarr 3.7. I added a few fields into a customer order. After, i updated Dolibarr to the last version 3.9.1. Now, i create an order and i try to deliver it.

I can't : order isn't validated and an error message is displayed : Unknown column 'XXX' in 'field list' is my added field.

Best regards, Maxime

Max84 commented 8 years ago

I've the same error with new field created with Dolibarr 3.9.1

altairis-tof commented 8 years ago

hello, is XXX the real name of your field ? because since some versions, uppercase letters are not authorized anymore in attribute codes (don't ask me why...)

Max84 commented 8 years ago

All my fields:

eldy commented 8 years ago

Can you enable module syslog, delete dolibarr.log file, run the error and paste log file

Max84 commented 8 years ago

Hi,

This is syslog:

2016-05-20 10:45:20 DEBUG 10.0.0.12 This is an already logged session. _SESSION['dol_login']=maxime 2016-05-20 10:45:20 DEBUG 10.0.0.12 User::fetch 2016-05-20 10:45:20 DEBUG 10.0.0.12 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.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.login = 'maxime' 2016-05-20 10:45:20 DEBUG 10.0.0.12 ExtraFields::fetch_name_optionals_label 2016-05-20 10:45:20 DEBUG 10.0.0.12 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2016-05-20 10:45:21 DEBUG 10.0.0.12 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2016-05-20 10:45:21 DEBUG 10.0.0.12 User::getrights 2016-05-20 10:45:21 DEBUG 10.0.0.12 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 r.entity IN (0,1) AND ur.fk_user= 1 AND r.perms IS NOT NULL 2016-05-20 10:45:21 DEBUG 10.0.0.12 User::getrights 2016-05-20 10:45:21 DEBUG 10.0.0.12 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 r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2016-05-20 10:45:21 INFO 10.0.0.12 --- Access to /dolibarr/htdocs/commande/card.php 2016-05-20 10:45:21 DEBUG 10.0.0.12 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' 2016-05-20 10:45:21 DEBUG 10.0.0.12 Menubase::menuLoad mymainmenu=home myleftmenu=setup type_user=0 menu_handler=eldy tabMenu size=0 2016-05-20 10:45:21 DEBUG 10.0.0.12 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 2016-05-20 10:45:21 DEBUG 10.0.0.12 ExtraFields::fetch_name_optionals_label 2016-05-20 10:45:21 DEBUG 10.0.0.12 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande' ORDER BY pos 2016-05-20 10:45:21 DEBUG 10.0.0.12 Commande::fetch 2016-05-20 10:45:21 DEBUG 10.0.0.12 sql=SELECT c.rowid, c.date_creation, c.ref, c.fk_soc, c.fk_user_author, c.fk_statut, c.amount_ht, c.total_ht, c.total_ttc, c.tva as total_tva, c.localtax1 as total_localtax1, c.localtax2 as total_localtax2, c.fk_cond_reglement, c.fk_mode_reglement, c.fk_availability, c.fk_input_reason, c.fk_account, c.date_commande, c.date_livraison, c.fk_shipping_method, c.fk_warehouse, c.fk_projet, c.remise_percent, c.remise, c.remise_absolue, c.source, c.facture as billed, c.note_private, c.note_public, c.ref_client, c.ref_ext, c.ref_int, c.model_pdf, c.fk_delivery_address, c.extraparams, c.fk_incoterms, c.location_incoterms, i.libelle as libelle_incoterms, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, cr.libelle_facture as cond_reglement_libelle_doc, ca.code as availability_code, ca.label as availability_label, dr.code as demand_reason_code FROM llx_commande 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_availability as ca ON (c.fk_availability = ca.rowid) LEFT JOIN llx_c_input_reason as dr ON (c.fk_input_reason = ca.rowid) LEFT JOIN llx_c_incoterms as i ON c.fk_incoterms = i.rowid WHERE c.entity IN (1) AND c.rowid=724 2016-05-20 10:45:21 DEBUG 10.0.0.12 ExtraFields::fetch_name_optionals_label 2016-05-20 10:45:21 DEBUG 10.0.0.12 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande' ORDER BY pos 2016-05-20 10:45:21 DEBUG 10.0.0.12 Commande::fetch_optionals 2016-05-20 10:45:21 DEBUG 10.0.0.12 sql=SELECT rowid, erp, com, cms, email, url FROM llx_commande_extrafields WHERE fk_object = 724 2016-05-20 10:45:21 DEBUG 10.0.0.12 Commande::fetch_lines 2016-05-20 10:45:21 DEBUG 10.0.0.12 sql=SELECT l.rowid, l.fk_product, l.fk_parent_line, l.product_type, l.fk_commande, l.label as custom_label, l.description, l.price, l.qty, l.tva_tx, l.localtax1_tx, l.localtax2_tx, l.fk_remise_except, l.remise_percent, l.subprice, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.rang, l.info_bits, l.special_code, l.total_ht, l.total_ttc, l.total_tva, l.total_localtax1, l.total_localtax2, l.date_start, l.date_end, l.fk_unit, p.ref as product_ref, p.description as product_desc, p.fk_product_type, p.label as product_label FROM llx_commandedet as l LEFT JOIN llx_product as p ON (p.rowid = l.fk_product) WHERE l.fk_commande = 724 ORDER BY l.rang, l.rowid 2016-05-20 10:45:21 DEBUG 10.0.0.12 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.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.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.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, 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 = 26 2016-05-20 10:45:21 INFO 10.0.0.12 Societe::fetch 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.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.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.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, 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 = 26 2016-05-20 10:45:21 DEBUG 10.0.0.12 ExtraFields::fetch_name_optionals_label 2016-05-20 10:45:21 DEBUG 10.0.0.12 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2016-05-20 10:45:21 DEBUG 10.0.0.12 Societe::fetch_optionals 2016-05-20 10:45:21 DEBUG 10.0.0.12 sql=SELECT rowid, rev, web, clirev, gestion, source, autresource FROM llx_societe_extrafields WHERE fk_object = 26 2016-05-20 10:45:21 DEBUG 10.0.0.12 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.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.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.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, 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 = 26 2016-05-20 10:45:21 INFO 10.0.0.12 Societe::fetch 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.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.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.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, 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 = 26 2016-05-20 10:45:21 DEBUG 10.0.0.12 ExtraFields::fetch_name_optionals_label 2016-05-20 10:45:21 DEBUG 10.0.0.12 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2016-05-20 10:45:21 DEBUG 10.0.0.12 Societe::fetch_optionals 2016-05-20 10:45:21 DEBUG 10.0.0.12 sql=SELECT rowid, rev, web, clirev, gestion, source, autresource FROM llx_societe_extrafields WHERE fk_object = 26 2016-05-20 10:45:21 DEBUG 10.0.0.12 User::fetch 2016-05-20 10:45:21 DEBUG 10.0.0.12 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.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 2016-05-20 10:45:21 DEBUG 10.0.0.12 ExtraFields::fetch_name_optionals_label 2016-05-20 10:45:21 DEBUG 10.0.0.12 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2016-05-20 10:45:21 DEBUG 10.0.0.12 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2016-05-20 10:45:21 DEBUG 10.0.0.12 Commande::fetch_optionals 2016-05-20 10:45:21 DEBUG 10.0.0.12 sql=SELECT rowid, erp, com, cms, email, url FROM llx_commande_extrafields WHERE fk_object = 724 2016-05-20 10:45:21 WARNING 10.0.0.12 Passing 5Â values in tabs module_parts is deprecated. Please update to 6 with permissions. 2016-05-20 10:45:21 INFO 10.0.0.12 files.lib.php::dol_dir_list path=/var/www/dolibarr/documents/commande/CO1605-0559 types=files recursive=0 filter= excludefilter="(.meta|_preview.png)$" 2016-05-20 10:45:21 DEBUG 10.0.0.12 sql=SELECT MAX(te.ref) FROM llx_commande as te WHERE te.ref < 'CO1605-0559' AND te.entity IN (1) 2016-05-20 10:45:21 DEBUG 10.0.0.12 sql=SELECT MIN(te.ref) FROM llx_commande as te WHERE te.ref > 'CO1605-0559' AND te.entity IN (1) 2016-05-20 10:45:21 DEBUG 10.0.0.12 DiscountAbsolute::getAvailableDiscounts 2016-05-20 10:45:21 DEBUG 10.0.0.12 sql=SELECT SUM(rc.amount_ttc) as amount FROM llx_societe_remise_except as rc WHERE (rc.fk_facture IS NULL AND rc.fk_facture_line IS NULL) AND rc.fk_soc = 26 AND (fk_facture_source IS NULL) 2016-05-20 10:45:21 DEBUG 10.0.0.12 DiscountAbsolute::getAvailableDiscounts 2016-05-20 10:45:21 DEBUG 10.0.0.12 sql=SELECT SUM(rc.amount_ttc) as amount FROM llx_societe_remise_except as rc WHERE (rc.fk_facture IS NULL AND rc.fk_facture_line IS NULL) AND rc.fk_soc = 26 AND (fk_facture_source IS NOT NULL) 2016-05-20 10:45:21 DEBUG 10.0.0.12 Translate::loadCacheCurrencies 2016-05-20 10:45:21 DEBUG 10.0.0.12 sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1 AND code_iso = 'EUR' 2016-05-20 10:45:21 DEBUG 10.0.0.12 Commande::fetch_lines 2016-05-20 10:45:21 DEBUG 10.0.0.12 sql=SELECT l.rowid, l.fk_product, l.fk_parent_line, l.product_type, l.fk_commande, l.label as custom_label, l.description, l.price, l.qty, l.tva_tx, l.localtax1_tx, l.localtax2_tx, l.fk_remise_except, l.remise_percent, l.subprice, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.rang, l.info_bits, l.special_code, l.total_ht, l.total_ttc, l.total_tva, l.total_localtax1, l.total_localtax2, l.date_start, l.date_end, l.fk_unit, p.ref as product_ref, p.description as product_desc, p.fk_product_type, p.label as product_label FROM llx_commandedet as l LEFT JOIN llx_product as p ON (p.rowid = l.fk_product) WHERE l.fk_commande = 724 ORDER BY l.rang, l.rowid 2016-05-20 10:45:21 DEBUG 10.0.0.12 ExtraFields::fetch_name_optionals_label 2016-05-20 10:45:21 DEBUG 10.0.0.12 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list FROM llxextrafields WHERE entity IN (0,1) AND elementtype = 'commandedet' ORDER BY pos 2016-05-20 10:45:21 DEBUG 10.0.0.12 sql=SELECT count() FROM llx_expedition as e, llx_element_element as el WHERE el.fk_source = 724 AND el.fk_target = e.rowid AND el.targettype = 'shipping' 2016-05-20 10:45:21 DEBUG 10.0.0.12 /core/lib/function2.lib.php::getListOfModels 2016-05-20 10:45:21 DEBUG 10.0.0.12 sql=SELECT nom as id, nom as lib, libelle as label, description as description FROM llx_document_model WHERE type = 'order' AND entity IN (0,1) ORDER BY description DESC 2016-05-20 10:45:21 INFO 10.0.0.12 files.lib.php::dol_dir_list path=/var/www/dolibarr/documents/commande/CO1605-0559 types=files recursive=0 filter= excludefilter="(.meta|_preview.png)$" 2016-05-20 10:45:21 DEBUG 10.0.0.12 Commande::fetchObjectLink 2016-05-20 10:45:21 DEBUG 10.0.0.12 sql=SELECT rowid, fk_source, sourcetype, fk_target, targettype FROM llx_element_element WHERE (fk_source = '724' AND sourcetype = 'commande') OR (fk_target = '724' AND targettype = 'commande') ORDER BY sourcetype 2016-05-20 10:45:21 DEBUG 10.0.0.12 ActionComm::getActions 2016-05-20 10:45:21 DEBUG 10.0.0.12 sql=SELECT a.id FROM llx_actioncomm as a WHERE a.entity IN (1) AND a.fk_element = 724 AND a.elementtype = 'order' 2016-05-20 10:45:21 DEBUG 10.0.0.12 ActionComm::fetch 2016-05-20 10:45:21 DEBUG 10.0.0.12 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, 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=14581 2016-05-20 10:45:21 INFO 10.0.0.12 --- End access to /dolibarr/htdocs/commande/card.php 2016-05-20 10:45:23 DEBUG 10.0.0.12 This is an already logged session. _SESSION['dol_login']=maxime 2016-05-20 10:45:23 DEBUG 10.0.0.12 User::fetch 2016-05-20 10:45:23 DEBUG 10.0.0.12 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.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.login = 'maxime' 2016-05-20 10:45:23 DEBUG 10.0.0.12 ExtraFields::fetch_name_optionals_label 2016-05-20 10:45:23 DEBUG 10.0.0.12 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2016-05-20 10:45:23 DEBUG 10.0.0.12 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2016-05-20 10:45:23 DEBUG 10.0.0.12 User::getrights 2016-05-20 10:45:23 DEBUG 10.0.0.12 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 r.entity IN (0,1) AND ur.fk_user= 1 AND r.perms IS NOT NULL 2016-05-20 10:45:23 DEBUG 10.0.0.12 User::getrights 2016-05-20 10:45:23 DEBUG 10.0.0.12 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 r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2016-05-20 10:45:23 INFO 10.0.0.12 --- Access to /dolibarr/htdocs/commande/card.php 2016-05-20 10:45:23 DEBUG 10.0.0.12 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' 2016-05-20 10:45:23 DEBUG 10.0.0.12 Menubase::menuLoad mymainmenu=home myleftmenu=setup type_user=0 menu_handler=eldy tabMenu size=0 2016-05-20 10:45:23 DEBUG 10.0.0.12 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 2016-05-20 10:45:23 DEBUG 10.0.0.12 ExtraFields::fetch_name_optionals_label 2016-05-20 10:45:23 DEBUG 10.0.0.12 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande' ORDER BY pos 2016-05-20 10:45:23 DEBUG 10.0.0.12 Commande::fetch 2016-05-20 10:45:23 DEBUG 10.0.0.12 sql=SELECT c.rowid, c.date_creation, c.ref, c.fk_soc, c.fk_user_author, c.fk_statut, c.amount_ht, c.total_ht, c.total_ttc, c.tva as total_tva, c.localtax1 as total_localtax1, c.localtax2 as total_localtax2, c.fk_cond_reglement, c.fk_mode_reglement, c.fk_availability, c.fk_input_reason, c.fk_account, c.date_commande, c.date_livraison, c.fk_shipping_method, c.fk_warehouse, c.fk_projet, c.remise_percent, c.remise, c.remise_absolue, c.source, c.facture as billed, c.note_private, c.note_public, c.ref_client, c.ref_ext, c.ref_int, c.model_pdf, c.fk_delivery_address, c.extraparams, c.fk_incoterms, c.location_incoterms, i.libelle as libelle_incoterms, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, cr.libelle_facture as cond_reglement_libelle_doc, ca.code as availability_code, ca.label as availability_label, dr.code as demand_reason_code FROM llx_commande 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_availability as ca ON (c.fk_availability = ca.rowid) LEFT JOIN llx_c_input_reason as dr ON (c.fk_input_reason = ca.rowid) LEFT JOIN llx_c_incoterms as i ON c.fk_incoterms = i.rowid WHERE c.entity IN (1) AND c.rowid=724 2016-05-20 10:45:23 DEBUG 10.0.0.12 ExtraFields::fetch_name_optionals_label 2016-05-20 10:45:23 DEBUG 10.0.0.12 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande' ORDER BY pos 2016-05-20 10:45:23 DEBUG 10.0.0.12 Commande::fetch_optionals 2016-05-20 10:45:23 DEBUG 10.0.0.12 sql=SELECT rowid, erp, com, cms, email, url FROM llx_commande_extrafields WHERE fk_object = 724 2016-05-20 10:45:23 DEBUG 10.0.0.12 Commande::fetch_lines 2016-05-20 10:45:23 DEBUG 10.0.0.12 sql=SELECT l.rowid, l.fk_product, l.fk_parent_line, l.product_type, l.fk_commande, l.label as custom_label, l.description, l.price, l.qty, l.tva_tx, l.localtax1_tx, l.localtax2_tx, l.fk_remise_except, l.remise_percent, l.subprice, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.rang, l.info_bits, l.special_code, l.total_ht, l.total_ttc, l.total_tva, l.total_localtax1, l.total_localtax2, l.date_start, l.date_end, l.fk_unit, p.ref as product_ref, p.description as product_desc, p.fk_product_type, p.label as product_label FROM llx_commandedet as l LEFT JOIN llx_product as p ON (p.rowid = l.fk_product) WHERE l.fk_commande = 724 ORDER BY l.rang, l.rowid 2016-05-20 10:45:23 DEBUG 10.0.0.12 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.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.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.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, 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 = 26 2016-05-20 10:45:23 INFO 10.0.0.12 Societe::fetch 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.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.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.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, 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 = 26 2016-05-20 10:45:23 DEBUG 10.0.0.12 ExtraFields::fetch_name_optionals_label 2016-05-20 10:45:23 DEBUG 10.0.0.12 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2016-05-20 10:45:23 DEBUG 10.0.0.12 Societe::fetch_optionals 2016-05-20 10:45:23 DEBUG 10.0.0.12 sql=SELECT rowid, rev, web, clirev, gestion, source, autresource FROM llx_societe_extrafields WHERE fk_object = 26 2016-05-20 10:45:23 DEBUG 10.0.0.12 BEGIN Transaction 2016-05-20 10:45:23 DEBUG 10.0.0.12 sql=UPDATE llx_commande SET fk_statut = 3, fk_user_cloture = 1, date_cloture = '20160520104523' WHERE rowid = 724 AND fk_statut > 0 2016-05-20 10:45:23 DEBUG 10.0.0.12 Interfaces::run_triggers action=ORDER_CLOSE Triggers for file 'interface_50_modNotification_Notification.class.php' need module to be enabled 2016-05-20 10:45:23 DEBUG 10.0.0.12 Interfaces::run_triggers action=ORDER_CLOSE Triggers for file 'interface_50_modLdap_Ldapsynchro.class.php' need module to be enabled 2016-05-20 10:45:23 DEBUG 10.0.0.12 Interfaces::run_triggers action=ORDER_CLOSE Triggers for file 'interface_20_modPaypal_PaypalWorkflow.class.php' need module to be enabled 2016-05-20 10:45:23 DEBUG 10.0.0.12 Interfaces::run_triggers action=ORDER_CLOSE Triggers for file 'interface_50_modMailmanspip_Mailmanspipsynchro.class.php' need module to be enabled 2016-05-20 10:45:23 INFO 10.0.0.12 Interfaces::run_triggers action=ORDER_CLOSE Launch runTrigger for file 'interface_20_all_Logevents.class.php' 2016-05-20 10:45:23 INFO 10.0.0.12 Interfaces::run_triggers action=ORDER_CLOSE Launch runTrigger for file 'interface_20_modWorkflow_WorkflowManager.class.php' 2016-05-20 10:45:23 INFO 10.0.0.12 Trigger 'WorkflowManager' for action 'ORDER_CLOSE' launched by /var/www/dolibarr/htdocs/core/triggers/interface_20_modWorkflow_WorkflowManager.class.php. id=724 2016-05-20 10:45:23 DEBUG 10.0.0.12 ExtraFields::fetch_name_optionals_label 2016-05-20 10:45:23 DEBUG 10.0.0.12 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commandedet' ORDER BY pos 2016-05-20 10:45:23 DEBUG 10.0.0.12 ExtraFields::fetch_name_optionals_label 2016-05-20 10:45:23 DEBUG 10.0.0.12 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande' ORDER BY pos 2016-05-20 10:45:23 DEBUG 10.0.0.12 Commande::fetch_optionals 2016-05-20 10:45:23 DEBUG 10.0.0.12 sql=SELECT rowid, erp, com, cms, email, url FROM llx_commande_extrafields WHERE fk_object = 724 2016-05-20 10:45:23 INFO 10.0.0.12 Facture::create user=1 2016-05-20 10:45:23 DEBUG 10.0.0.12 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.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.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.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, 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 = 26 2016-05-20 10:45:23 INFO 10.0.0.12 Societe::fetch 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.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.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.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, 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 = 26 2016-05-20 10:45:23 DEBUG 10.0.0.12 ExtraFields::fetch_name_optionals_label 2016-05-20 10:45:23 DEBUG 10.0.0.12 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2016-05-20 10:45:23 DEBUG 10.0.0.12 Societe::fetch_optionals 2016-05-20 10:45:23 DEBUG 10.0.0.12 sql=SELECT rowid, rev, web, clirev, gestion, source, autresource FROM llx_societe_extrafields WHERE fk_object = 26 2016-05-20 10:45:23 DEBUG 10.0.0.12 Facture::calculate_date_lim_reglement 2016-05-20 10:45:23 DEBUG 10.0.0.12 sql=SELECT c.fdm,c.nbjour,c.decalage FROM llx_c_payment_term as c WHERE c.rowid=0 2016-05-20 10:45:23 DEBUG 10.0.0.12 Facture::create 2016-05-20 10:45:23 DEBUG 10.0.0.12 sql=INSERT INTO llx_facture ( facnumber, entity, ref_ext, type, fk_soc, datec, remise_absolue, remise_percent, datef, note_private, note_public, ref_client, ref_int, fk_account, fk_facture_source, fk_user_author, fk_projet, fk_cond_reglement, fk_mode_reglement, date_lim_reglement, model_pdf, situation_cycle_ref, situation_counter, situation_final, fk_incoterms, location_incoterms) VALUES ('(PROV)', 1, null, '0', '26', '20160520104523', NULL, NULL, '20160520104523', null, null, null, null, NULL, null, '1', null, 0, 0, '20160520104523', '', null, null, 0, 0, '') 2016-05-20 10:45:23 DEBUG 10.0.0.12 Facture::create 2016-05-20 10:45:23 DEBUG 10.0.0.12 sql=UPDATE llx_facture SET facnumber='(PROV1874)' WHERE rowid=1874 2016-05-20 10:45:23 DEBUG 10.0.0.12 Facture::add_object_linked 2016-05-20 10:45:23 DEBUG 10.0.0.12 sql=INSERT INTO llx_element_element (fk_source, sourcetype, fk_target, targettype) VALUES (724, 'commande', 1874, 'facture') 2016-05-20 10:45:23 DEBUG 10.0.0.12 Commande::getIdContact 2016-05-20 10:45:23 DEBUG 10.0.0.12 sql=SELECT ec.fk_socpeople FROM llx_element_contact as ec, llx_user as c, llx_c_type_contact as tc WHERE ec.element_id = 724 AND ec.fk_socpeople = c.rowid AND c.entity IN (0,1) AND ec.fk_c_type_contact = tc.rowid AND tc.element = 'commande' AND tc.source = 'internal' AND tc.code = 'SALESREPFOLL' AND tc.active = 1 2016-05-20 10:45:23 DEBUG 10.0.0.12 Commande::getIdContact 2016-05-20 10:45:23 DEBUG 10.0.0.12 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 = 724 AND ec.fk_socpeople = c.rowid AND c.entity IN (1) AND ec.fk_c_type_contact = tc.rowid AND tc.element = 'commande' AND tc.source = 'external' AND tc.code = 'BILLING' AND tc.active = 1 2016-05-20 10:45:23 INFO 10.0.0.12 There is 1 lines that are invoice lines objects 2016-05-20 10:45:23 DEBUG 10.0.0.12 FactureLigne::insert rang=1 2016-05-20 10:45:23 DEBUG 10.0.0.12 FactureLigne::insert 2016-05-20 10:45:23 DEBUG 10.0.0.12 sql=INSERT INTO llx_facturedet (fk_facture, fk_parent_line, label, description, qty, tva_tx, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, fk_product, product_type, remise_percent, subprice, fk_remise_except, date_start, date_end, fk_code_ventilation, rang, special_code, fk_product_fournisseur_price, buy_price_ht, info_bits, total_ht, total_tva, total_ttc, total_localtax1, total_localtax2, situation_percent, fk_prev_id, fk_unit) VALUES (1874, null, null, 'test', 1, 20, 0, 0, '0', '0', null, 1, 0, 10, null, null, null, 0, 1, 0, null, 0, '0', 10, 2, 12, 0, 0, 100, null, NULL) 2016-05-20 10:45:23 DEBUG 10.0.0.12 Interfaces::run_triggers action=LINEBILL_INSERT Triggers for file 'interface_50_modNotification_Notification.class.php' need module to be enabled 2016-05-20 10:45:23 DEBUG 10.0.0.12 Interfaces::run_triggers action=LINEBILL_INSERT Triggers for file 'interface_50_modLdap_Ldapsynchro.class.php' need module to be enabled 2016-05-20 10:45:23 DEBUG 10.0.0.12 Interfaces::run_triggers action=LINEBILL_INSERT Triggers for file 'interface_20_modPaypal_PaypalWorkflow.class.php' need module to be enabled 2016-05-20 10:45:23 DEBUG 10.0.0.12 Interfaces::run_triggers action=LINEBILL_INSERT Triggers for file 'interface_50_modMailmanspip_Mailmanspipsynchro.class.php' need module to be enabled 2016-05-20 10:45:23 INFO 10.0.0.12 Interfaces::run_triggers action=LINEBILL_INSERT Launch runTrigger for file 'interface_20_all_Logevents.class.php' 2016-05-20 10:45:23 INFO 10.0.0.12 Interfaces::run_triggers action=LINEBILL_INSERT Launch runTrigger for file 'interface_20_modWorkflow_WorkflowManager.class.php' 2016-05-20 10:45:23 INFO 10.0.0.12 Interfaces::run_triggers action=LINEBILL_INSERT Launch runTrigger for file 'interface_50_modAgenda_ActionsAuto.class.php' 2016-05-20 10:45:23 INFO 10.0.0.12 Interfaces::run_triggers action=LINEBILL_INSERT Launch run_trigger for file 'interface_50_modGoogle_GoogleCalendarSynchro.class.php' 2016-05-20 10:45:23 INFO 10.0.0.12 Interfaces::run_triggers action=LINEBILL_INSERT Launch run_trigger for file 'interface_51_modGoogle_GoogleContactSynchro.class.php' 2016-05-20 10:45:23 INFO 10.0.0.12 Interfaces::run_triggers action=LINEBILL_INSERT Launch runTrigger for file 'interface_75_all_Licence.class.php' 2016-05-20 10:45:23 DEBUG 10.0.0.12 Facture::update_price 2016-05-20 10:45:23 DEBUG 10.0.0.12 sql=SELECT rowid, qty, subprice as up, remise_percent, total_ht, total_tva as total_tva, total_ttc, total_localtax1 as total_localtax1, total_localtax2 as total_localtax2, tva_tx as vatrate, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, info_bits, product_type FROM llx_facturedet WHERE fk_facture = 1874 AND product_type <> 9 ORDER by rowid 2016-05-20 10:45:23 DEBUG 10.0.0.12 Facture::update_price 2016-05-20 10:45:23 DEBUG 10.0.0.12 sql=UPDATE llx_facture SET total='10', tva='2', localtax1='0', localtax2='0', total_ttc='12' WHERE rowid = 1874 2016-05-20 10:45:23 DEBUG 10.0.0.12 ExtraFields::fetch_name_optionals_label 2016-05-20 10:45:23 DEBUG 10.0.0.12 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'facture' ORDER BY pos 2016-05-20 10:45:23 DEBUG 10.0.0.12 Facture::insertExtraFields delete 2016-05-20 10:45:23 DEBUG 10.0.0.12 sql=DELETE FROM llx_facture_extrafields WHERE fk_object = 1874 2016-05-20 10:45:23 DEBUG 10.0.0.12 Facture::insertExtraFields insert 2016-05-20 10:45:23 DEBUG 10.0.0.12 sql=INSERT INTO llx_facture_extrafields (fk_object,erp,com,cms,email,url) VALUES (1874,'test_erp',null,'prestashop',null,'toto') 2016-05-20 10:45:23 ERR 10.0.0.12 DoliDBMysql::query SQL Error message: DB_ERROR_NOSUCHFIELD Unknown column 'erp' in 'field list' 2016-05-20 10:45:23 DEBUG 10.0.0.12 Interfaces::run_triggers action=BILL_CREATE Triggers for file 'interface_50_modNotification_Notification.class.php' need module to be enabled 2016-05-20 10:45:23 DEBUG 10.0.0.12 Interfaces::run_triggers action=BILL_CREATE Triggers for file 'interface_50_modLdap_Ldapsynchro.class.php' need module to be enabled 2016-05-20 10:45:23 DEBUG 10.0.0.12 Interfaces::run_triggers action=BILL_CREATE Triggers for file 'interface_20_modPaypal_PaypalWorkflow.class.php' need module to be enabled 2016-05-20 10:45:23 DEBUG 10.0.0.12 Interfaces::run_triggers action=BILL_CREATE Triggers for file 'interface_50_modMailmanspip_Mailmanspipsynchro.class.php' need module to be enabled 2016-05-20 10:45:23 INFO 10.0.0.12 Interfaces::run_triggers action=BILL_CREATE Launch runTrigger for file 'interface_20_all_Logevents.class.php' 2016-05-20 10:45:23 INFO 10.0.0.12 Interfaces::run_triggers action=BILL_CREATE Launch runTrigger for file 'interface_20_modWorkflow_WorkflowManager.class.php' 2016-05-20 10:45:23 INFO 10.0.0.12 Interfaces::run_triggers action=BILL_CREATE Launch runTrigger for file 'interface_50_modAgenda_ActionsAuto.class.php' 2016-05-20 10:45:23 INFO 10.0.0.12 Interfaces::run_triggers action=BILL_CREATE Launch run_trigger for file 'interface_50_modGoogle_GoogleCalendarSynchro.class.php' 2016-05-20 10:45:23 INFO 10.0.0.12 Interfaces::run_triggers action=BILL_CREATE Launch run_trigger for file 'interface_51_modGoogle_GoogleContactSynchro.class.php' 2016-05-20 10:45:23 INFO 10.0.0.12 Interfaces::run_triggers action=BILL_CREATE Launch runTrigger for file 'interface_75_all_Licence.class.php' 2016-05-20 10:45:23 INFO 10.0.0.12 Interfaces::run_triggers action=ORDER_CLOSE Launch runTrigger for file 'interface_50_modAgenda_ActionsAuto.class.php' 2016-05-20 10:45:23 INFO 10.0.0.12 Interfaces::run_triggers action=ORDER_CLOSE Launch run_trigger for file 'interface_50_modGoogle_GoogleCalendarSynchro.class.php' 2016-05-20 10:45:23 INFO 10.0.0.12 Interfaces::run_triggers action=ORDER_CLOSE Launch run_trigger for file 'interface_51_modGoogle_GoogleContactSynchro.class.php' 2016-05-20 10:45:23 INFO 10.0.0.12 Interfaces::run_triggers action=ORDER_CLOSE Launch runTrigger for file 'interface_75_all_Licence.class.php' 2016-05-20 10:45:28 ERR 10.0.0.12 Interfaces::run_triggers action=ORDER_CLOSE Files found: 10, Files launched: 6, Done: 1, Failed: 1 2016-05-20 10:45:28 DEBUG 10.0.0.12 ROLLBACK Transaction 2016-05-20 10:45:28 DEBUG 10.0.0.12 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.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.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.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, 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 = 26 2016-05-20 10:45:28 INFO 10.0.0.12 Societe::fetch 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.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.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.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, 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 = 26 2016-05-20 10:45:28 DEBUG 10.0.0.12 ExtraFields::fetch_name_optionals_label 2016-05-20 10:45:28 DEBUG 10.0.0.12 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos 2016-05-20 10:45:28 DEBUG 10.0.0.12 Societe::fetch_optionals 2016-05-20 10:45:28 DEBUG 10.0.0.12 sql=SELECT rowid, rev, web, clirev, gestion, source, autresource FROM llx_societe_extrafields WHERE fk_object = 26 2016-05-20 10:45:28 DEBUG 10.0.0.12 User::fetch 2016-05-20 10:45:28 DEBUG 10.0.0.12 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.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 2016-05-20 10:45:28 DEBUG 10.0.0.12 ExtraFields::fetch_name_optionals_label 2016-05-20 10:45:28 DEBUG 10.0.0.12 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2016-05-20 10:45:28 DEBUG 10.0.0.12 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2016-05-20 10:45:28 DEBUG 10.0.0.12 Commande::fetch_optionals 2016-05-20 10:45:28 DEBUG 10.0.0.12 sql=SELECT rowid, erp, com, cms, email, url FROM llx_commande_extrafields WHERE fk_object = 724 2016-05-20 10:45:28 WARNING 10.0.0.12 Passing 5Â values in tabs module_parts is deprecated. Please update to 6 with permissions. 2016-05-20 10:45:28 INFO 10.0.0.12 files.lib.php::dol_dir_list path=/var/www/dolibarr/documents/commande/CO1605-0559 types=files recursive=0 filter= excludefilter="(.meta|_preview.png)$" 2016-05-20 10:45:28 DEBUG 10.0.0.12 sql=SELECT MAX(te.ref) FROM llx_commande as te WHERE te.ref < 'CO1605-0559' AND te.entity IN (1) 2016-05-20 10:45:28 DEBUG 10.0.0.12 sql=SELECT MIN(te.ref) FROM llx_commande as te WHERE te.ref > 'CO1605-0559' AND te.entity IN (1) 2016-05-20 10:45:28 DEBUG 10.0.0.12 DiscountAbsolute::getAvailableDiscounts 2016-05-20 10:45:28 DEBUG 10.0.0.12 sql=SELECT SUM(rc.amount_ttc) as amount FROM llx_societe_remise_except as rc WHERE (rc.fk_facture IS NULL AND rc.fk_facture_line IS NULL) AND rc.fk_soc = 26 AND (fk_facture_source IS NULL) 2016-05-20 10:45:28 DEBUG 10.0.0.12 DiscountAbsolute::getAvailableDiscounts 2016-05-20 10:45:28 DEBUG 10.0.0.12 sql=SELECT SUM(rc.amount_ttc) as amount FROM llx_societe_remise_except as rc WHERE (rc.fk_facture IS NULL AND rc.fk_facture_line IS NULL) AND rc.fk_soc = 26 AND (fk_facture_source IS NOT NULL) 2016-05-20 10:45:28 DEBUG 10.0.0.12 Translate::loadCacheCurrencies 2016-05-20 10:45:28 DEBUG 10.0.0.12 sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1 AND code_iso = 'EUR' 2016-05-20 10:45:28 DEBUG 10.0.0.12 Commande::fetch_lines 2016-05-20 10:45:28 DEBUG 10.0.0.12 sql=SELECT l.rowid, l.fk_product, l.fk_parent_line, l.product_type, l.fk_commande, l.label as custom_label, l.description, l.price, l.qty, l.tva_tx, l.localtax1_tx, l.localtax2_tx, l.fk_remise_except, l.remise_percent, l.subprice, l.fk_product_fournisseur_price as fk_fournprice, l.buy_price_ht as pa_ht, l.rang, l.info_bits, l.special_code, l.total_ht, l.total_ttc, l.total_tva, l.total_localtax1, l.total_localtax2, l.date_start, l.date_end, l.fk_unit, p.ref as product_ref, p.description as product_desc, p.fk_product_type, p.label as product_label FROM llx_commandedet as l LEFT JOIN llx_product as p ON (p.rowid = l.fk_product) WHERE l.fk_commande = 724 ORDER BY l.rang, l.rowid 2016-05-20 10:45:28 DEBUG 10.0.0.12 ExtraFields::fetch_name_optionals_label 2016-05-20 10:45:28 DEBUG 10.0.0.12 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list FROM llxextrafields WHERE entity IN (0,1) AND elementtype = 'commandedet' ORDER BY pos 2016-05-20 10:45:28 DEBUG 10.0.0.12 sql=SELECT count() FROM llx_expedition as e, llx_element_element as el WHERE el.fk_source = 724 AND el.fk_target = e.rowid AND el.targettype = 'shipping' 2016-05-20 10:45:28 DEBUG 10.0.0.12 /core/lib/function2.lib.php::getListOfModels 2016-05-20 10:45:28 DEBUG 10.0.0.12 sql=SELECT nom as id, nom as lib, libelle as label, description as description FROM llx_document_model WHERE type = 'order' AND entity IN (0,1) ORDER BY description DESC 2016-05-20 10:45:28 INFO 10.0.0.12 files.lib.php::dol_dir_list path=/var/www/dolibarr/documents/commande/CO1605-0559 types=files recursive=0 filter= excludefilter="(.meta|_preview.png)$" 2016-05-20 10:45:28 DEBUG 10.0.0.12 Commande::fetchObjectLink 2016-05-20 10:45:28 DEBUG 10.0.0.12 sql=SELECT rowid, fk_source, sourcetype, fk_target, targettype FROM llx_element_element WHERE (fk_source = '724' AND sourcetype = 'commande') OR (fk_target = '724' AND targettype = 'commande') ORDER BY sourcetype 2016-05-20 10:45:28 DEBUG 10.0.0.12 ActionComm::getActions 2016-05-20 10:45:28 DEBUG 10.0.0.12 sql=SELECT a.id FROM llx_actioncomm as a WHERE a.entity IN (1) AND a.fk_element = 724 AND a.elementtype = 'order' 2016-05-20 10:45:28 DEBUG 10.0.0.12 ActionComm::fetch 2016-05-20 10:45:28 DEBUG 10.0.0.12 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, 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=14581 2016-05-20 10:45:28 INFO 10.0.0.12 --- End access to /dolibarr/htdocs/commande/card.php

Thanks

atm-florian commented 8 years ago

It seems that columns llx_facture_extrafields.erp doesn't exist anymore. If you have a database backup before upgrade you can restore this backup on another database and play with SQL to restore this column data into your new install, if not delete this extrafields from module Invoice -> extrafields configuration, to restore invoice "standard' feature. By the way, it doesn't tell why this column is missing after migration. Did you done a "standard" migration from 3.7 to 3.9 ?

grandoc commented 8 years ago

Unknown column 'erp' that's personnal created column within extrafields, doesn't exist in standard.

Max84 commented 8 years ago

Hi,

Sorry, i'm not sure you've right. I can't replay data migration, so i did this: 1) i deleted all extrafield 2) i tested to deliver an order => no error 3) i add a new extra fields 4) i tested to deliver an order => error again with this new created field.

Best regards Maxime

Max84 commented 8 years ago

Hi Folks,

I found the way to reproduce it. It's not due to data migration, but it's a trigger module bug.

1) Add extra field onto order 2) Enable trigger module, and enable invoice create after closing order 3) Try to deliver order, you'll get this message.

I think you can reopen this bug.

Best regards,

EddTamuse commented 6 years ago

Hello all,

I've found the fix for my issue, thanks to lawrence in following link: https://www.dolibarr.org/forum/527-bugs-on-a-stable-version/27247-6-0-2-error-in-adding-note-to-project-task

My issue was the same from him: When attempting to add note to a task of a project, following error encountered: Unknown column 'fk_user_modif' in 'field list'

The reason, the column 'fk_user_modif' does not exist in the table 'llx_projet_task' or in other case yourdatabaseprefix=ydp or what you put in database prefix variable 'ydp_projet_task'.

Recommended fix add the column in mysql or phpmyadmin or whatever with this command: ALTER TABLE ydp_projet_task ADD COLUMN fk_user_modif integer;