[SOLUCIONADO] Error al validar un envio

[Juan Brillo]

Hola a todos, el error sucede al hacer clic en validar un envio. El error es el siguiente:

Dolibarr ha detectado un error técnico.
He aquí la información que podrá ayudar al diagnóstico:
Fecha: 20140814094203
Dolibarr: 3.5.4
Nivel de funciones: 0
PHP: 5.3.0
Server: Apache/2.2.11 (Win32) PHP/5.3.0

URL solicitada: /dolibarr/expedition/fiche.php?id=3&action=confirm_valid&confirm=yes
Referer: http://ip.ip.ip.ip/dolibarr/expedition/ ... tion=valid
Gestor de menú: eldy_menu.php

Tipo de gestor de base de datos: mysqli
Petición último acceso a la base de datos erróneo: Ninguna petición en error
Código devuelto último acceso a la base de datos erróneo: Ninguna petición en error
Información sobre el último acceso a la base de datos erróneo: Ninguna petición en error

¿A alguien se le ocurre que puede pasar y como solucionarlo?


PD.: por razones de seguridad pongo ip.ip.ip.ip donde deberia ir el numero de la ip del servidor.

[marcosgdf]

Hola Juan:

Ese trozo que nos pegas no nos proporciona información suficiente para el diagnóstico. ¿Podrías pegarnos el contenido de dolibarr.log cuando sucede el error?

Saludos.

[Juan Brillo]

Hola Marcos, utilizo doliwamp, que log es el que necesitas ¿dolibarr.log o doliwamp.log? es que me aparecen los dos. ¿Te copio TODO el log aquí o solo una parte?


Muchísimas gracias

Juan Brillo

[marcosgdf]

Hola Juan:

El dolibarr.log. Tan solo me interesa la parte que se genera cuando sucede el problema. Puedes hacer lo siguiente:
1. Situarte en la pantalla de validación (justo antes del fallo)
2. Borrar el dolibarr.log
3. Provocar el fallo

Si no quisieras borrar el archivo podrías simplemente renombrarlo.

Saludos.

[Juan Brillo]

Muchas gracias por la respuesta, tal y como me respondes, te copio y pego el resultado:

Código: Seleccionar todo

2014-08-27 09:43:01 DEBUG   192.168.1.37    This is an already logged session. _SESSION['dol_login']=Juan Brillo
2014-08-27 09:43:01 DEBUG   192.168.1.37    User::fetch sql=SELECT u.rowid, u.lastname, u.firstname, u.email, u.job, u.skype, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.admin, u.login, u.note, u.pass, u.pass_crypted, u.pass_temp, u.fk_societe, 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.ref_int, u.ref_ext FROM llx_user as u WHERE u.entity IS NOT NULL AND u.login = 'Juan Brillo'
2014-08-27 09:43:01 DEBUG   192.168.1.37    ExtraFields::fetch_name_optionals_label sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos
2014-08-27 09:43:01 DEBUG   192.168.1.37    User::getrights 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= 3 AND r.perms IS NOT NULL
2014-08-27 09:43:01 DEBUG   192.168.1.37    User::getrights 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 = 3 AND r.perms IS NOT NULL
2014-08-27 09:43:01 DEBUG   192.168.1.37    --- Access to /dolibarr/expedition/fiche.php
2014-08-27 09:43:01 DEBUG   192.168.1.37    Menubase::menuLoad mymainmenu=commercial myleftmenu=orders type_user=0 menu_handler=eldy tabMenu size=0 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
2014-08-27 09:43:01 DEBUG   192.168.1.37    Expedition::fetch sql=SELECT e.rowid, e.ref, e.fk_soc as socid, e.date_creation, e.ref_customer, e.ref_ext, e.ref_int, e.fk_user_author, e.fk_statut, e.weight, e.weight_units, e.size, e.size_units, e.width, e.height, e.date_expedition as date_expedition, e.model_pdf, e.fk_address, e.date_delivery, e.fk_shipping_method, e.tracking_number, el.fk_source as origin_id, el.sourcetype as origin, e.note_private, e.note_public FROM llx_expedition as e LEFT JOIN llx_element_element as el ON el.fk_target = e.rowid AND el.targettype = 'shipping' WHERE e.entity = 1 AND e.rowid=2
2014-08-27 09:43:01 DEBUG   192.168.1.37    Societe::fetch SELECT s.rowid, s.nom as name, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as datec, s.prefix_comm, s.status, s.price_level, s.tms as date_update, s.phone, s.fax, s.email, s.skype, s.url, s.zip, s.town, s.note_private, s.note_public, 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.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.localtax2_assuj, s.fk_prospectlevel, s.default_lang, s.logo, s.outstanding_limit, s.import_key, s.canvas, fj.libelle as forme_juridique, e.libelle as effectif, p.code as country_code, p.libelle as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_pays as p ON s.fk_pays = p.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 WHERE s.rowid = 46
2014-08-27 09:43:01 DEBUG   192.168.1.37    ExtraFields::fetch_name_optionals_label sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos
2014-08-27 09:43:01 DEBUG   192.168.1.37    Societe::fetch_optionals sql=SELECT rowid, comercialname, mailfactura FROM llx_societe_extrafields WHERE fk_object = 46
2014-08-27 09:43:01 DEBUG   192.168.1.37    Expedition::fetch_lines sql=SELECT cd.rowid, cd.fk_product, cd.label as custom_label, cd.description, cd.qty as qty_asked, cd.total_ht, cd.total_localtax1, cd.total_localtax2, cd.total_ttc, cd.total_tva, cd.tva_tx, cd.localtax1_tx, cd.localtax2_tx, cd.price, cd.subprice, cd.remise_percent, ed.qty as qty_shipped, ed.fk_origin_line, ed.fk_entrepot, p.ref as product_ref, p.label as product_label, p.fk_product_type, p.weight, p.weight_units, p.length, p.length_units, p.surface, p.surface_units, p.volume, p.volume_units FROM (llx_expeditiondet as ed, llx_commandedet as cd) LEFT JOIN llx_product as p ON p.rowid = cd.fk_product WHERE ed.fk_expedition = 2 AND ed.fk_origin_line = cd.rowid
2014-08-27 09:43:01 WARNING 192.168.1.37    calcul_price_total Warning: function is called with parameter seller that is missing
2014-08-27 09:43:01 WARNING 192.168.1.37    calcul_price_total Warning: function is called with parameter localtaxes_array that is missing
2014-08-27 09:43:01 DEBUG   192.168.1.37    calcul_price_total search vat information sql=SELECT taux, localtax1, localtax2, localtax1_type, localtax2_type FROM llx_c_tva as cv WHERE cv.taux = 21.000 AND cv.fk_pays = 4
2014-08-27 09:43:01 DEBUG   192.168.1.37    Commande::fetch 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.date_commande, c.date_livraison, 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, 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, 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) WHERE c.entity = 1 AND c.rowid=2
2014-08-27 09:43:01 DEBUG   192.168.1.37    ExtraFields::fetch_name_optionals_label sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande' ORDER BY pos
2014-08-27 09:43:01 DEBUG   192.168.1.37    Commande::fetch_lines 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, 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 = 2 ORDER BY l.rang
2014-08-27 09:43:01 DEBUG   192.168.1.37    Societe::fetch SELECT s.rowid, s.nom as name, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as datec, s.prefix_comm, s.status, s.price_level, s.tms as date_update, s.phone, s.fax, s.email, s.skype, s.url, s.zip, s.town, s.note_private, s.note_public, 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.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.localtax2_assuj, s.fk_prospectlevel, s.default_lang, s.logo, s.outstanding_limit, s.import_key, s.canvas, fj.libelle as forme_juridique, e.libelle as effectif, p.code as country_code, p.libelle as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_pays as p ON s.fk_pays = p.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 WHERE s.rowid = 46
2014-08-27 09:43:01 DEBUG   192.168.1.37    ExtraFields::fetch_name_optionals_label sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos
2014-08-27 09:43:01 DEBUG   192.168.1.37    Societe::fetch_optionals sql=SELECT rowid, comercialname, mailfactura FROM llx_societe_extrafields WHERE fk_object = 46
2014-08-27 09:43:01 DEBUG   192.168.1.37    functions2::get_next_value mode=next sql=SELECT MAX(SUBSTRING(ref, 8, 4)) as val FROM llx_expedition WHERE ref LIKE 'AV____-____' AND ref NOT LIKE '%PROV%' AND entity IN (1)
2014-08-27 09:43:01 DEBUG   192.168.1.37    functions2::get_next_value return AV1408-0001
2014-08-27 09:43:01 DEBUG   192.168.1.37    Commande::fetch 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.date_commande, c.date_livraison, 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, 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, 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) WHERE c.entity = 1 AND c.rowid=2
2014-08-27 09:43:01 DEBUG   192.168.1.37    ExtraFields::fetch_name_optionals_label sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande' ORDER BY pos
2014-08-27 09:43:01 DEBUG   192.168.1.37    Commande::fetch_lines 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, 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 = 2 ORDER BY l.rang
2014-08-27 09:43:01 DEBUG   192.168.1.37    Translate::getLabelFromKey sql=SELECT code as label FROM llx_c_shipment_mode WHERE rowid = '2'
2014-08-27 09:43:01 DEBUG   192.168.1.37    Entrepot::fetch sql=SELECT rowid, label, description, statut, lieu, address, zip, town, fk_pays as country_id FROM llx_entrepot WHERE rowid = '1'
2014-08-27 09:43:01 DEBUG   192.168.1.37    Company.lib::getCountry sql=SELECT rowid, code, libelle FROM llx_c_pays WHERE rowid=4
2014-08-27 09:43:01 DEBUG   192.168.1.37    Expedition::fetchObjectLink sql=SELECT fk_source, sourcetype, fk_target, targettype FROM llx_element_element WHERE fk_source = '2' AND sourcetype = 'shipping' ORDER BY sourcetype
2014-08-27 09:43:01 DEBUG   192.168.1.37    /core/lib/function2.lib.php::getListOfModels sql=SELECT nom as id, nom as lib, libelle as label, description as description FROM llx_document_model WHERE type = 'shipping' AND entity IN (0,1)
2014-08-27 09:43:01 DEBUG   192.168.1.37    files.lib.php::dol_dir_list path=c:/dolibarr/dolibarr_documents/doctemplates/shipment types=files recursive=0 filter=\.od(s|t)$ excludefilter=""
2014-08-27 09:43:01 DEBUG   192.168.1.37    files.lib.php::dol_dir_list path=c:/dolibarr/dolibarr_documents/expedition/sending/(PROV2) types=files recursive=0 filter= excludefilter="\\.meta$"
2014-08-27 09:43:01 DEBUG   192.168.1.37    Expedition::fetchObjectLink sql=SELECT fk_source, sourcetype, fk_target, targettype FROM llx_element_element WHERE (fk_source = '2' AND sourcetype = 'shipping') OR (fk_target = '2' AND targettype = 'shipping') ORDER BY sourcetype
2014-08-27 09:43:01 DEBUG   192.168.1.37    Commande::fetch 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.date_commande, c.date_livraison, 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, 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, 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) WHERE c.entity = 1 AND c.rowid=2
2014-08-27 09:43:01 DEBUG   192.168.1.37    ExtraFields::fetch_name_optionals_label sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande' ORDER BY pos
2014-08-27 09:43:01 DEBUG   192.168.1.37    Commande::fetch_lines 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, 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 = 2 ORDER BY l.rang
2014-08-27 09:43:01 DEBUG   192.168.1.37    ActionComm::getActions sql=SELECT a.id FROM llx_actioncomm as a WHERE a.entity = 1 AND a.fk_element = 2 AND a.elementtype = 'shipping'
2014-08-27 09:43:01 DEBUG   192.168.1.37    ActionComm::fetch sql=SELECT a.id, a.id as ref, a.ref_ext, a.datep, a.datep2, a.datec, a.durationp, 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.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_c_actioncomm as c, llx_actioncomm as a) 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=35 AND a.fk_action=c.id
2014-08-27 09:43:01 DEBUG   192.168.1.37    ActionComm::fetch sql=SELECT a.id, a.id as ref, a.ref_ext, a.datep, a.datep2, a.datec, a.durationp, 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.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_c_actioncomm as c, llx_actioncomm as a) 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=78 AND a.fk_action=c.id
2014-08-27 09:43:01 DEBUG   192.168.1.37    ActionComm::fetch sql=SELECT a.id, a.id as ref, a.ref_ext, a.datep, a.datep2, a.datec, a.durationp, 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.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_c_actioncomm as c, llx_actioncomm as a) 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=86 AND a.fk_action=c.id
2014-08-27 09:43:01 DEBUG   192.168.1.37    show_list_sending_receive sql=SELECT obj.rowid, obj.fk_product, obj.label, obj.description, obj.product_type as fk_product_type, obj.qty as qty_asked, obj.date_start, obj.date_end, ed.qty as qty_shipped, ed.fk_expedition as expedition_id, ed.fk_origin_line, e.rowid as sendingid, e.ref as exp_ref, e.date_creation, e.date_delivery, e.date_expedition, p.label as product_label, p.ref, p.fk_product_type, p.rowid as prodid, p.description as product_desc FROM llx_expeditiondet as ed, llx_expedition as e, llx_commandedet as obj LEFT JOIN llx_product as p ON obj.fk_product = p.rowid WHERE e.entity = 1 AND obj.fk_commande = 2 AND obj.rowid = ed.fk_origin_line AND ed.fk_expedition = e.rowid ORDER BY obj.fk_product
2014-08-27 09:43:01 DEBUG   192.168.1.37    --- End access to /dolibarr/expedition/fiche.php
2014-08-27 09:43:04 DEBUG   192.168.1.37    This is an already logged session. _SESSION['dol_login']=Juan Brillo
2014-08-27 09:43:04 DEBUG   192.168.1.37    User::fetch sql=SELECT u.rowid, u.lastname, u.firstname, u.email, u.job, u.skype, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.admin, u.login, u.note, u.pass, u.pass_crypted, u.pass_temp, u.fk_societe, 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.ref_int, u.ref_ext FROM llx_user as u WHERE u.entity IS NOT NULL AND u.login = 'Juan Brillo'
2014-08-27 09:43:04 DEBUG   192.168.1.37    ExtraFields::fetch_name_optionals_label sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos
2014-08-27 09:43:04 DEBUG   192.168.1.37    User::getrights 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= 3 AND r.perms IS NOT NULL
2014-08-27 09:43:04 DEBUG   192.168.1.37    User::getrights 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 = 3 AND r.perms IS NOT NULL
2014-08-27 09:43:04 DEBUG   192.168.1.37    --- Access to /dolibarr/expedition/fiche.php
2014-08-27 09:43:04 DEBUG   192.168.1.37    Menubase::menuLoad mymainmenu=commercial myleftmenu=orders type_user=0 menu_handler=eldy tabMenu size=0 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
2014-08-27 09:43:04 DEBUG   192.168.1.37    Expedition::fetch sql=SELECT e.rowid, e.ref, e.fk_soc as socid, e.date_creation, e.ref_customer, e.ref_ext, e.ref_int, e.fk_user_author, e.fk_statut, e.weight, e.weight_units, e.size, e.size_units, e.width, e.height, e.date_expedition as date_expedition, e.model_pdf, e.fk_address, e.date_delivery, e.fk_shipping_method, e.tracking_number, el.fk_source as origin_id, el.sourcetype as origin, e.note_private, e.note_public FROM llx_expedition as e LEFT JOIN llx_element_element as el ON el.fk_target = e.rowid AND el.targettype = 'shipping' WHERE e.entity = 1 AND e.rowid=2
2014-08-27 09:43:04 DEBUG   192.168.1.37    Societe::fetch SELECT s.rowid, s.nom as name, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as datec, s.prefix_comm, s.status, s.price_level, s.tms as date_update, s.phone, s.fax, s.email, s.skype, s.url, s.zip, s.town, s.note_private, s.note_public, 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.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.localtax2_assuj, s.fk_prospectlevel, s.default_lang, s.logo, s.outstanding_limit, s.import_key, s.canvas, fj.libelle as forme_juridique, e.libelle as effectif, p.code as country_code, p.libelle as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_pays as p ON s.fk_pays = p.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 WHERE s.rowid = 46
2014-08-27 09:43:04 DEBUG   192.168.1.37    ExtraFields::fetch_name_optionals_label sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos
2014-08-27 09:43:04 DEBUG   192.168.1.37    Societe::fetch_optionals sql=SELECT rowid, comercialname, mailfactura FROM llx_societe_extrafields WHERE fk_object = 46
2014-08-27 09:43:04 DEBUG   192.168.1.37    Expedition::fetch_lines sql=SELECT cd.rowid, cd.fk_product, cd.label as custom_label, cd.description, cd.qty as qty_asked, cd.total_ht, cd.total_localtax1, cd.total_localtax2, cd.total_ttc, cd.total_tva, cd.tva_tx, cd.localtax1_tx, cd.localtax2_tx, cd.price, cd.subprice, cd.remise_percent, ed.qty as qty_shipped, ed.fk_origin_line, ed.fk_entrepot, p.ref as product_ref, p.label as product_label, p.fk_product_type, p.weight, p.weight_units, p.length, p.length_units, p.surface, p.surface_units, p.volume, p.volume_units FROM (llx_expeditiondet as ed, llx_commandedet as cd) LEFT JOIN llx_product as p ON p.rowid = cd.fk_product WHERE ed.fk_expedition = 2 AND ed.fk_origin_line = cd.rowid
2014-08-27 09:43:04 WARNING 192.168.1.37    calcul_price_total Warning: function is called with parameter seller that is missing
2014-08-27 09:43:04 WARNING 192.168.1.37    calcul_price_total Warning: function is called with parameter localtaxes_array that is missing
2014-08-27 09:43:04 DEBUG   192.168.1.37    calcul_price_total search vat information sql=SELECT taux, localtax1, localtax2, localtax1_type, localtax2_type FROM llx_c_tva as cv WHERE cv.taux = 21.000 AND cv.fk_pays = 4
2014-08-27 09:43:04 DEBUG   192.168.1.37    Societe::fetch SELECT s.rowid, s.nom as name, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as datec, s.prefix_comm, s.status, s.price_level, s.tms as date_update, s.phone, s.fax, s.email, s.skype, s.url, s.zip, s.town, s.note_private, s.note_public, 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.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.localtax2_assuj, s.fk_prospectlevel, s.default_lang, s.logo, s.outstanding_limit, s.import_key, s.canvas, fj.libelle as forme_juridique, e.libelle as effectif, p.code as country_code, p.libelle as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_pays as p ON s.fk_pays = p.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 WHERE s.rowid = 46
2014-08-27 09:43:04 DEBUG   192.168.1.37    ExtraFields::fetch_name_optionals_label sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos
2014-08-27 09:43:04 DEBUG   192.168.1.37    Societe::fetch_optionals sql=SELECT rowid, comercialname, mailfactura FROM llx_societe_extrafields WHERE fk_object = 46
2014-08-27 09:43:04 DEBUG   192.168.1.37    Expedition::valid
2014-08-27 09:43:04 DEBUG   192.168.1.37    BEGIN Transaction
2014-08-27 09:43:04 DEBUG   192.168.1.37     Societe::fetch SELECT s.rowid, s.nom as name, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as datec, s.prefix_comm, s.status, s.price_level, s.tms as date_update, s.phone, s.fax, s.email, s.skype, s.url, s.zip, s.town, s.note_private, s.note_public, 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.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.localtax2_assuj, s.fk_prospectlevel, s.default_lang, s.logo, s.outstanding_limit, s.import_key, s.canvas, fj.libelle as forme_juridique, e.libelle as effectif, p.code as country_code, p.libelle as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_pays as p ON s.fk_pays = p.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 WHERE s.rowid = 46
2014-08-27 09:43:04 DEBUG   192.168.1.37     ExtraFields::fetch_name_optionals_label sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos
2014-08-27 09:43:04 DEBUG   192.168.1.37     Societe::fetch_optionals sql=SELECT rowid, comercialname, mailfactura FROM llx_societe_extrafields WHERE fk_object = 46
2014-08-27 09:43:04 DEBUG   192.168.1.37     functions2::get_next_value mode=next sql=SELECT MAX(SUBSTRING(ref, 8, 4)) as val FROM llx_expedition WHERE ref LIKE 'AV____-____' AND ref NOT LIKE '%PROV%' AND entity IN (1)
2014-08-27 09:43:04 DEBUG   192.168.1.37     functions2::get_next_value return AV1408-0001
2014-08-27 09:43:04 DEBUG   192.168.1.37     Expedition::valid update expedition sql=UPDATE llx_expedition SET ref='AV1408-0001', fk_statut = 1, date_valid = '20140827094304', fk_user_valid = 3 WHERE rowid = 2
2014-08-27 09:43:04 DEBUG   192.168.1.37     Interfaces::run_triggers action=SHIPPING_VALIDATE Triggers for file 'interface_20_modPaypal_PaypalWorkflow.class.php' need module to be enabled
2014-08-27 09:43:04 DEBUG   192.168.1.37     Interfaces::run_triggers action=SHIPPING_VALIDATE Triggers for file 'interface_50_modLdap_Ldapsynchro.class.php' need module to be enabled
2014-08-27 09:43:04 DEBUG   192.168.1.37     Interfaces::run_triggers action=SHIPPING_VALIDATE Triggers for file 'interface_50_modMailmanspip_Mailmanspipsynchro.class.php' need module to be enabled
2014-08-27 09:43:04 DEBUG   192.168.1.37     Interfaces::run_triggers action=SHIPPING_VALIDATE Triggers for file 'interface_50_modNotification_Notification.class.php' need module to be enabled
2014-08-27 09:43:04 DEBUG   192.168.1.37     Interfaces::run_triggers action=SHIPPING_VALIDATE Launch triggers for file 'interface_20_all_Logevents.class.php'
2014-08-27 09:43:04 DEBUG   192.168.1.37     Interfaces::run_triggers action=SHIPPING_VALIDATE Launch triggers for file 'interface_20_modWorkflow_WorkflowManager.class.php'
2014-08-27 09:43:04 DEBUG   192.168.1.37     Interfaces::run_triggers action=SHIPPING_VALIDATE Launch triggers for file 'interface_50_modAgenda_ActionsAuto.class.php'
2014-08-27 09:43:04 DEBUG   192.168.1.37     Trigger 'ActionsAuto' for action 'SHIPPING_VALIDATE' launched by C:\dolibarr\www\dolibarr\htdocs\core\triggers\interface_50_modAgenda_ActionsAuto.class.php. id=2
2014-08-27 09:43:04 DEBUG   192.168.1.37     Societe::fetch SELECT s.rowid, s.nom as name, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as datec, s.prefix_comm, s.status, s.price_level, s.tms as date_update, s.phone, s.fax, s.email, s.skype, s.url, s.zip, s.town, s.note_private, s.note_public, 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.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.localtax2_assuj, s.fk_prospectlevel, s.default_lang, s.logo, s.outstanding_limit, s.import_key, s.canvas, fj.libelle as forme_juridique, e.libelle as effectif, p.code as country_code, p.libelle as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_pays as p ON s.fk_pays = p.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 WHERE s.rowid = 46
2014-08-27 09:43:04 DEBUG   192.168.1.37     ExtraFields::fetch_name_optionals_label sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos
2014-08-27 09:43:04 DEBUG   192.168.1.37     Societe::fetch_optionals sql=SELECT rowid, comercialname, mailfactura FROM llx_societe_extrafields WHERE fk_object = 46
2014-08-27 09:43:04 DEBUG   192.168.1.37     CActionComm::fetch sql=SELECT id, code, type, libelle, active FROM llx_c_actioncomm WHERE code='AC_OTH_AUTO'
2014-08-27 09:43:04 DEBUG   192.168.1.37      ActionComm::add sql=INSERT INTO llx_actioncomm(datec,datep,datep2,durationp,fk_action,code,fk_soc,fk_project,note,fk_contact,fk_user_author,fk_user_action,fk_user_done,label,percent,priority,fulldayevent,location,punctual,transparency,fk_element,elementtype,entity) VALUES ('20140827094304','20140827094304','20140827094304',null,40, 'AC_SHIPPING_VALIDATE', '46',null, 'Expedición AV1408-0001 validada
Autor: Juan Brillo',null,'3',null,'3','Expedición AV1408-0001 validada','-1','0','0','','1','0',2,'shipping',1)
2014-08-27 09:43:04 DEBUG   192.168.1.37      Interfaces::run_triggers action=ACTION_CREATE Triggers for file 'interface_20_modPaypal_PaypalWorkflow.class.php' need module to be enabled
2014-08-27 09:43:04 DEBUG   192.168.1.37      Interfaces::run_triggers action=ACTION_CREATE Triggers for file 'interface_50_modLdap_Ldapsynchro.class.php' need module to be enabled
2014-08-27 09:43:04 DEBUG   192.168.1.37      Interfaces::run_triggers action=ACTION_CREATE Triggers for file 'interface_50_modMailmanspip_Mailmanspipsynchro.class.php' need module to be enabled
2014-08-27 09:43:04 DEBUG   192.168.1.37      Interfaces::run_triggers action=ACTION_CREATE Triggers for file 'interface_50_modNotification_Notification.class.php' need module to be enabled
2014-08-27 09:43:04 DEBUG   192.168.1.37      Interfaces::run_triggers action=ACTION_CREATE Launch triggers for file 'interface_20_all_Logevents.class.php'
2014-08-27 09:43:04 DEBUG   192.168.1.37      Interfaces::run_triggers action=ACTION_CREATE Launch triggers for file 'interface_20_modWorkflow_WorkflowManager.class.php'
2014-08-27 09:43:04 DEBUG   192.168.1.37      Interfaces::run_triggers action=ACTION_CREATE Launch triggers for file 'interface_50_modAgenda_ActionsAuto.class.php'
2014-08-27 09:43:04 DEBUG   192.168.1.37    COMMIT Transaction
2014-08-27 09:43:04 DEBUG   192.168.1.37    Expedition::fetch sql=SELECT e.rowid, e.ref, e.fk_soc as socid, e.date_creation, e.ref_customer, e.ref_ext, e.ref_int, e.fk_user_author, e.fk_statut, e.weight, e.weight_units, e.size, e.size_units, e.width, e.height, e.date_expedition as date_expedition, e.model_pdf, e.fk_address, e.date_delivery, e.fk_shipping_method, e.tracking_number, el.fk_source as origin_id, el.sourcetype as origin, e.note_private, e.note_public FROM llx_expedition as e LEFT JOIN llx_element_element as el ON el.fk_target = e.rowid AND el.targettype = 'shipping' WHERE e.entity = 1 AND e.rowid=2
2014-08-27 09:43:04 DEBUG   192.168.1.37    Societe::fetch SELECT s.rowid, s.nom as name, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as datec, s.prefix_comm, s.status, s.price_level, s.tms as date_update, s.phone, s.fax, s.email, s.skype, s.url, s.zip, s.town, s.note_private, s.note_public, 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.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.localtax2_assuj, s.fk_prospectlevel, s.default_lang, s.logo, s.outstanding_limit, s.import_key, s.canvas, fj.libelle as forme_juridique, e.libelle as effectif, p.code as country_code, p.libelle as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_pays as p ON s.fk_pays = p.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 WHERE s.rowid = 46
2014-08-27 09:43:04 DEBUG   192.168.1.37    ExtraFields::fetch_name_optionals_label sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos
2014-08-27 09:43:04 DEBUG   192.168.1.37    Societe::fetch_optionals sql=SELECT rowid, comercialname, mailfactura FROM llx_societe_extrafields WHERE fk_object = 46
2014-08-27 09:43:04 DEBUG   192.168.1.37    Expedition::fetch_lines sql=SELECT cd.rowid, cd.fk_product, cd.label as custom_label, cd.description, cd.qty as qty_asked, cd.total_ht, cd.total_localtax1, cd.total_localtax2, cd.total_ttc, cd.total_tva, cd.tva_tx, cd.localtax1_tx, cd.localtax2_tx, cd.price, cd.subprice, cd.remise_percent, ed.qty as qty_shipped, ed.fk_origin_line, ed.fk_entrepot, p.ref as product_ref, p.label as product_label, p.fk_product_type, p.weight, p.weight_units, p.length, p.length_units, p.surface, p.surface_units, p.volume, p.volume_units FROM (llx_expeditiondet as ed, llx_commandedet as cd) LEFT JOIN llx_product as p ON p.rowid = cd.fk_product WHERE ed.fk_expedition = 2 AND ed.fk_origin_line = cd.rowid
2014-08-27 09:43:04 WARNING 192.168.1.37    calcul_price_total Warning: function is called with parameter seller that is missing
2014-08-27 09:43:04 WARNING 192.168.1.37    calcul_price_total Warning: function is called with parameter localtaxes_array that is missing
2014-08-27 09:43:04 DEBUG   192.168.1.37    calcul_price_total search vat information sql=SELECT taux, localtax1, localtax2, localtax1_type, localtax2_type FROM llx_c_tva as cv WHERE cv.taux = 21.000 AND cv.fk_pays = 4
2014-08-27 09:43:04 DEBUG   192.168.1.37    Commande::fetch 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.date_commande, c.date_livraison, 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, 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, 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) WHERE c.entity = 1 AND c.rowid=2
2014-08-27 09:43:04 DEBUG   192.168.1.37    ExtraFields::fetch_name_optionals_label sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande' ORDER BY pos
2014-08-27 09:43:04 DEBUG   192.168.1.37    Commande::fetch_lines 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, 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 = 2 ORDER BY l.rang
2014-08-27 09:43:04 WARNING 192.168.1.37    doc_generic_odt::write_file parameter srctemplatepath empty
2014-08-27 09:43:04 DEBUG   192.168.1.37    Erreur dans expedition_pdf_create
2014-08-27 09:43:04 ERR     192.168.1.37    Error url=/dolibarr/expedition/fiche.php?id=2&action=confirm_valid&confirm=yes, query_string=id=2&action=confirm_valid&confirm=yes, 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, 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 = 2 ORDER BY l.rang, db_error=
2014-08-27 09:43:04 DEBUG   192.168.1.37    Commande::fetch 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.date_commande, c.date_livraison, 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, 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, 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) WHERE c.entity = 1 AND c.rowid=2
2014-08-27 09:43:04 DEBUG   192.168.1.37    ExtraFields::fetch_name_optionals_label sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande' ORDER BY pos
2014-08-27 09:43:04 DEBUG   192.168.1.37    Commande::fetch_lines 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, 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 = 2 ORDER BY l.rang
2014-08-27 09:43:04 DEBUG   192.168.1.37    Societe::fetch SELECT s.rowid, s.nom as name, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as datec, s.prefix_comm, s.status, s.price_level, s.tms as date_update, s.phone, s.fax, s.email, s.skype, s.url, s.zip, s.town, s.note_private, s.note_public, 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.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.localtax2_assuj, s.fk_prospectlevel, s.default_lang, s.logo, s.outstanding_limit, s.import_key, s.canvas, fj.libelle as forme_juridique, e.libelle as effectif, p.code as country_code, p.libelle as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_pays as p ON s.fk_pays = p.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 WHERE s.rowid = 46
2014-08-27 09:43:04 DEBUG   192.168.1.37    ExtraFields::fetch_name_optionals_label sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos
2014-08-27 09:43:04 DEBUG   192.168.1.37    Societe::fetch_optionals sql=SELECT rowid, comercialname, mailfactura FROM llx_societe_extrafields WHERE fk_object = 46
2014-08-27 09:43:04 DEBUG   192.168.1.37    Commande::fetch 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.date_commande, c.date_livraison, 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, 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, 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) WHERE c.entity = 1 AND c.rowid=2
2014-08-27 09:43:04 DEBUG   192.168.1.37    ExtraFields::fetch_name_optionals_label sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande' ORDER BY pos
2014-08-27 09:43:04 DEBUG   192.168.1.37    Commande::fetch_lines 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, 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 = 2 ORDER BY l.rang
2014-08-27 09:43:04 DEBUG   192.168.1.37    Translate::getLabelFromKey sql=SELECT code as label FROM llx_c_shipment_mode WHERE rowid = '2'
2014-08-27 09:43:04 DEBUG   192.168.1.37    Entrepot::fetch sql=SELECT rowid, label, description, statut, lieu, address, zip, town, fk_pays as country_id FROM llx_entrepot WHERE rowid = '1'
2014-08-27 09:43:04 DEBUG   192.168.1.37    Company.lib::getCountry sql=SELECT rowid, code, libelle FROM llx_c_pays WHERE rowid=4
2014-08-27 09:43:04 DEBUG   192.168.1.37    Expedition::fetchObjectLink sql=SELECT fk_source, sourcetype, fk_target, targettype FROM llx_element_element WHERE fk_source = '2' AND sourcetype = 'shipping' ORDER BY sourcetype
2014-08-27 09:43:04 DEBUG   192.168.1.37    /core/lib/function2.lib.php::getListOfModels sql=SELECT nom as id, nom as lib, libelle as label, description as description FROM llx_document_model WHERE type = 'shipping' AND entity IN (0,1)
2014-08-27 09:43:04 DEBUG   192.168.1.37    files.lib.php::dol_dir_list path=c:/dolibarr/dolibarr_documents/doctemplates/shipment types=files recursive=0 filter=\.od(s|t)$ excludefilter=""
2014-08-27 09:43:04 DEBUG   192.168.1.37    files.lib.php::dol_dir_list path=c:/dolibarr/dolibarr_documents/expedition/sending/AV1408-0001 types=files recursive=0 filter= excludefilter="\\.meta$"
2014-08-27 09:43:04 DEBUG   192.168.1.37    Expedition::fetchObjectLink sql=SELECT fk_source, sourcetype, fk_target, targettype FROM llx_element_element WHERE (fk_source = '2' AND sourcetype = 'shipping') OR (fk_target = '2' AND targettype = 'shipping') ORDER BY sourcetype
2014-08-27 09:43:04 DEBUG   192.168.1.37    Commande::fetch 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.date_commande, c.date_livraison, 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, 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, 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) WHERE c.entity = 1 AND c.rowid=2
2014-08-27 09:43:04 DEBUG   192.168.1.37    ExtraFields::fetch_name_optionals_label sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'commande' ORDER BY pos
2014-08-27 09:43:04 DEBUG   192.168.1.37    Commande::fetch_lines 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, 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 = 2 ORDER BY l.rang
2014-08-27 09:43:04 DEBUG   192.168.1.37    ActionComm::getActions sql=SELECT a.id FROM llx_actioncomm as a WHERE a.entity = 1 AND a.fk_element = 2 AND a.elementtype = 'shipping'
2014-08-27 09:43:04 DEBUG   192.168.1.37    ActionComm::fetch sql=SELECT a.id, a.id as ref, a.ref_ext, a.datep, a.datep2, a.datec, a.durationp, 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.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_c_actioncomm as c, llx_actioncomm as a) 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=35 AND a.fk_action=c.id
2014-08-27 09:43:04 DEBUG   192.168.1.37    ActionComm::fetch sql=SELECT a.id, a.id as ref, a.ref_ext, a.datep, a.datep2, a.datec, a.durationp, 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.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_c_actioncomm as c, llx_actioncomm as a) 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=78 AND a.fk_action=c.id
2014-08-27 09:43:04 DEBUG   192.168.1.37    ActionComm::fetch sql=SELECT a.id, a.id as ref, a.ref_ext, a.datep, a.datep2, a.datec, a.durationp, 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.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_c_actioncomm as c, llx_actioncomm as a) 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=86 AND a.fk_action=c.id
2014-08-27 09:43:04 DEBUG   192.168.1.37    ActionComm::fetch sql=SELECT a.id, a.id as ref, a.ref_ext, a.datep, a.datep2, a.datec, a.durationp, 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.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_c_actioncomm as c, llx_actioncomm as a) 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=94 AND a.fk_action=c.id
2014-08-27 09:43:04 DEBUG   192.168.1.37    show_list_sending_receive sql=SELECT obj.rowid, obj.fk_product, obj.label, obj.description, obj.product_type as fk_product_type, obj.qty as qty_asked, obj.date_start, obj.date_end, ed.qty as qty_shipped, ed.fk_expedition as expedition_id, ed.fk_origin_line, e.rowid as sendingid, e.ref as exp_ref, e.date_creation, e.date_delivery, e.date_expedition, p.label as product_label, p.ref, p.fk_product_type, p.rowid as prodid, p.description as product_desc FROM llx_expeditiondet as ed, llx_expedition as e, llx_commandedet as obj LEFT JOIN llx_product as p ON obj.fk_product = p.rowid WHERE e.entity = 1 AND obj.fk_commande = 2 AND obj.rowid = ed.fk_origin_line AND ed.fk_expedition = e.rowid ORDER BY obj.fk_product
2014-08-27 09:43:04 DEBUG   192.168.1.37    --- End access to /dolibarr/expedition/fiche.php

Muchas gracias, y siento lo del tochazo del log

[marcosgdf]

Hola Juan:

Según el log parece un error al intentar detectar la plantilla de envío. Intenta deshabilitarla y habilitarla de nuevo para refrescar la configuración y prueba entonces a ver si funciona.

Saludos.

[Juan Brillo]

Efectivamente, cambiando de plantilla a la que incluye por defecto funciona a la perfección.

[econtec]

Buenas noches,

Por favor, tengo el mismo problema y, ¿podéis indicarme como puedo hacer eso de deshabilitar la pantalla de envío? . Gracias de antemano y un saludo.

[econtec]

Perdón... Plantilla.
Ya lo he localizado y mi problema no se ha solucionado así.
Miraré otras maneras.

Gracias de todos modos.

[marcosgdf]

Hola econtec:

Abre un nuevo mensaje y miramos tu caso, porque puede no ser exactamente lo mismo que al otro usuario.

Un saludo.