[qmailadmin-devel] [PATCH] Mail robots don't always display properly

[John P. <jpe...@ro...>]

At least with MySQL, sometimes a mail robot will not display the 
forwarded address in qmailadmin (it will show the vacation line 
instead).  It seems that qmailadmin expects that the records will be 
returned in original insertion order and MySQL isn't always consistent 
about that.

I finally got sick of this and patched valias_select() in vpopmail itself:

==================================================================
--- vmysql.c  (revision 9)
+++ vmysql.c  (local)
@@ -1209,7 +1209,8 @@
      }

      qnprintf( SqlBufRead, SQL_BUF_SIZE, "select valias_line from valias \
-where alias = '%s' and domain = '%s'", alias, domain );
+where alias = '%s' and domain = '%s' \
+order by valias_line desc", alias, domain );

      if (mysql_query(&mysql_read,SqlBufRead)) {
          vcreate_valias_table();


HTH

John

-- 
John Peacock
Director of Information Research and Technology
Rowman & Littlefield Publishing Group
4501 Forbes Boulevard
Suite H
Lanham, MD  20706
301-459-3366 x.5010
fax 301-429-5748