From 54f5ccd50b75a8627445efc60b1e283b09ccef3d Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Mon, 19 Jan 2009 00:19:22 +0100 Subject: [PATCH] Fixes SQL error in event's alias creation. --- modules/xnetevents/xnetevents.inc.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/modules/xnetevents/xnetevents.inc.php b/modules/xnetevents/xnetevents.inc.php index cae7848..0454be5 100644 --- a/modules/xnetevents/xnetevents.inc.php +++ b/modules/xnetevents/xnetevents.inc.php @@ -317,7 +317,7 @@ function event_change_shortname(&$page, $eid, $old, $new) $new.'-absents@'.$globals->xnet->evts_domain); $lastid = XDB::insertId(); - XDB::execute("INSERT INTO virtual_redirect ( + XDB::execute("INSERT IGNORE INTO virtual_redirect ( SELECT {?} AS vid, IF(a.alias IS NULL, m.email, CONCAT(a.alias, {?})) AS redirect FROM groupex.membres AS m LEFT JOIN groupex.evenements_participants AS ep ON (ep.uid = m.uid AND ep.eid = {?}) -- 2.1.4