Hi there, I'm thinking of doing the penpal thing, but, just to check, is this right?:
(line 910 in V2.5.1 of amavisd) 'sel_penpals_msgid' => # with a nonempty message-id references list "SELECT msgs.time_num, msgs.mail_id, subject, message_id, rid". " FROM msgs JOIN msgrcpt ON msgs.mail_id=msgrcpt.mail_id". " WHERE sid=? AND content!='V' AND ds='P' AND message_id IN (%m)". " AND rid!=sid". " ORDER BY rid=? DESC, msgs.time_num DESC LIMIT 1", That last line, "ORDER BY rid=?".. a condition inside the order clause? hmm. Looks wrong to me, but the evidence to the contrary is that nobody has reported sql errors yet! my regards, Riaan ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/