Bienvenido a los foros %s

Foro comunidad hispana Dolibarr

Identificarse Registrarse

3.7 - Error al consolidar pedidos de proveedor en una fra.

Si cree que ha encontrado un error en la versión de desarrollo, siéntase libre de comunicarlo aquí.
retrocomp
Novato
Mensajes: 48
Registrado: Mar, 18/11/2014, 23:27

3.7 - Error al consolidar pedidos de proveedor en una fra.

Mensaje por retrocomp »

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.

Avatar de Usuario
marcosgdf
Jedi
Mensajes: 772
Registrado: Vie, 20/07/2012, 14:42
Ubicación: Valladolid, España

Mensaje por marcosgdf »

Hola retrocomp:

Gracias por informar del fallo.

Un saludo.
Desarrollador con categoría Almirante de Dolibarr.
¿Quiere soporte personalizado? Contacte conmigo.

retrocomp
Novato
Mensajes: 48
Registrado: Mar, 18/11/2014, 23:27

Mensaje por retrocomp »

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