Me he descargado lo último que hay en el GitHub (https://github.com/Dolibarr/dolibarr/tree/3.7) y he actualizado sin problemas una 3.6.2. EL proceso ha ido perfecto.
Uso PostgreSQL 9.3.5 en CentOS 7.
"Proveedor" -> "Facturar Pedidos" -> Selecciono dos pedidos ya recibidos -> "Facturar" -> "Crear borrador" y me da el siguiente error:
ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block LOCATION: exec_simple_query, postgres.c:949 sql=SELECT c.rowid, c.ref, ref_supplier, c.fk_soc, c.fk_statut, c.amount_ht, c.total_ht, c.total_ttc, c.tva, c.localtax1, c.localtax2, c.date_creation, c.date_valid, c.date_approve, c.fk_user_author, c.fk_user_valid, c.fk_user_approve, c.date_commande as date_commande, c.date_livraison as date_livraison, c.fk_cond_reglement, c.fk_mode_reglement, c.fk_projet as fk_project, c.remise_percent, c.source, c.fk_input_method, c.fk_account, c.note_private, c.note_public, c.model_pdf, c.extraparams, cm.libelle as methode_commande, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle FROM llx_commande_fournisseur as c LEFT JOIN llx_c_payment_term as cr ON (c.fk_cond_reglement = cr.rowid) LEFT JOIN llx_c_paiement as p ON (c.fk_mode_reglement = p.id) LEFT JOIN llx_c_input_method as cm ON cm.rowid = c.fk_input_method WHERE c.entity = 1 AND c.rowid=193
ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block LOCATION: exec_simple_query, postgres.c:949 sql=SELECT c.rowid, c.ref, ref_supplier, c.fk_soc, c.fk_statut, c.amount_ht, c.total_ht, c.total_ttc, c.tva, c.localtax1, c.localtax2, c.date_creation, c.date_valid, c.date_approve, c.fk_user_author, c.fk_user_valid, c.fk_user_approve, c.date_commande as date_commande, c.date_livraison as date_livraison, c.fk_cond_reglement, c.fk_mode_reglement, c.fk_projet as fk_project, c.remise_percent, c.source, c.fk_input_method, c.fk_account, c.note_private, c.note_public, c.model_pdf, c.extraparams, cm.libelle as methode_commande, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle FROM llx_commande_fournisseur as c LEFT JOIN llx_c_payment_term as cr ON (c.fk_cond_reglement = cr.rowid) LEFT JOIN llx_c_paiement as p ON (c.fk_mode_reglement = p.id) LEFT JOIN llx_c_input_method as cm ON cm.rowid = c.fk_input_method WHERE c.entity = 1 AND c.rowid=162
¿Alguna idea?
Saludos.
3.7 - Error al consolidar pedidos de proveedor en una fra.
Hola retrocomp:
Gracias por informar del fallo.
Un saludo.
Gracias por informar del fallo.
Un saludo.
Desarrollador con categoría Almirante de Dolibarr.
¿Quiere soporte personalizado? Contacte conmigo.
¿Quiere soporte personalizado? Contacte conmigo.
Creo que puede ser por sintaxis no válida en PostgreSQL. ¿Veis algo raro?
SELECT
c.rowid, c.ref, ref_supplier, c.fk_soc, c.fk_statut,
c.amount_ht, c.total_ht, c.total_ttc, c.tva, c.localtax1,
c.localtax2, c.date_creation, c.date_valid, c.date_approve,
c.fk_user_author, c.fk_user_valid, c.fk_user_approve,
c.date_commande as date_commande,
c.date_livraison as date_livraison,
c.fk_cond_reglement, c.fk_mode_reglement,
c.fk_projet as fk_project,
c.remise_percent, c.source, c.fk_input_method, c.fk_account,
c.note_private, c.note_public, c.model_pdf, c.extraparams,
cm.libelle as methode_commande,
cr.code as cond_reglement_code,
cr.libelle as cond_reglement_libelle,
p.code as mode_reglement_code,
p.libelle as mode_reglement_libelle
FROM
llx_commande_fournisseur as c
LEFT JOIN
llx_c_payment_term as cr
ON (c.fk_cond_reglement = cr.rowid)
LEFT JOIN
llx_c_paiement as p
ON (c.fk_mode_reglement = p.id)
LEFT JOIN
llx_c_input_method as cm
ON cm.rowid = c.fk_input_method
WHERE
c.entity = 1 AND c.rowid=193
SELECT
c.rowid, c.ref, ref_supplier, c.fk_soc, c.fk_statut,
c.amount_ht, c.total_ht, c.total_ttc, c.tva, c.localtax1,
c.localtax2, c.date_creation, c.date_valid, c.date_approve,
c.fk_user_author, c.fk_user_valid, c.fk_user_approve,
c.date_commande as date_commande,
c.date_livraison as date_livraison,
c.fk_cond_reglement, c.fk_mode_reglement,
c.fk_projet as fk_project,
c.remise_percent, c.source, c.fk_input_method, c.fk_account,
c.note_private, c.note_public, c.model_pdf, c.extraparams,
cm.libelle as methode_commande,
cr.code as cond_reglement_code,
cr.libelle as cond_reglement_libelle,
p.code as mode_reglement_code,
p.libelle as mode_reglement_libelle
FROM
llx_commande_fournisseur as c
LEFT JOIN
llx_c_payment_term as cr
ON (c.fk_cond_reglement = cr.rowid)
LEFT JOIN
llx_c_paiement as p
ON (c.fk_mode_reglement = p.id)
LEFT JOIN
llx_c_input_method as cm
ON cm.rowid = c.fk_input_method
WHERE
c.entity = 1 AND c.rowid=193