From e848335b6da4f080c2c51e75122945ddc8d00e1f Mon Sep 17 00:00:00 2001 From: =?utf8?q?Rapha=C3=ABl=20Barrois?= Date: Wed, 27 Oct 2010 00:07:31 +0200 Subject: [PATCH] Fix MySQL query on payment (uid became ambiguous) MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Raphaël Barrois --- modules/payment.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/modules/payment.php b/modules/payment.php index b4abfd6..8804a4f 100644 --- a/modules/payment.php +++ b/modules/payment.php @@ -522,7 +522,7 @@ class PaymentModule extends PLModule } $res = XDB::iterRow("SELECT e.eid, e.short_name, e.intitule, ep.nb, ei.montant, ep.paid FROM group_events AS e - LEFT JOIN group_event_participants AS ep ON (ep.eid = e.eid AND uid = {?}) + LEFT JOIN group_event_participants AS ep ON (ep.eid = e.eid AND ep.uid = {?}) INNER JOIN group_event_items AS ei ON (ep.eid = ei.eid AND ep.item_id = ei.item_id) WHERE e.paiement_id = {?}", S::v('uid'), $pid); -- 2.1.4