From 77fcaa3f00dcbba0813a18a4cba0be0f18444e70 Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Mon, 15 Jun 2009 23:22:04 +0200 Subject: [PATCH] Fixes a SQL error: postfix delayed. --- modules/admin.php | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/modules/admin.php b/modules/admin.php index 847fb32..73ae584 100644 --- a/modules/admin.php +++ b/modules/admin.php @@ -80,11 +80,11 @@ class AdminModule extends PLModule $sql = XDB::iterator( "SELECT crc, nb, update_time, create_time, - FIND_IN_SET('del', release) AS del, - FIND_IN_SET('ok', release) AS ok - FROM postfix_mailseen + FIND_IN_SET('del', p.release) AS del, + FIND_IN_SET('ok', p.release) AS ok + FROM postfix_mailseen AS p WHERE nb >= 30 - ORDER BY release != ''"); + ORDER BY p.release != ''"); $page->assign_by_ref('mails', $sql); } -- 2.1.4