This is becoming a little off topic. It appears I may have come across
a problem with MySQL. When I run the query:
"SELECT wb
FROM wblist
LEFT JOIN mailaddr ON wblist.sid = mailaddr.id
WHERE (
wblist.rid =1
)
AND (
mailaddr.email
IN (
'webmaster', 'yachtworld', 'com'
)
)
ORDER BY mailaddr.priority DESC
LIMIT 0 , 30;"
The following error is generated:
#1271 - Illegal mix of collations for operation ' IN '
I'm running 4.1.9. Has anyone seen this before. I've started doing some
googling and it appears to have something to do with character sets and
collation. But, I'm not sure how to resolve the problem.
/Paul
On Aug 26, 2005, at 3:06 PM, Alan Munday wrote:
Paul
My reading of your logs is that the RID matches but you don't get a
SID match when tested against the query keys.
Hence no WBlist adjustment.
Can you add an explicit record in your wblist table for this explicit
sender and retest, or check for typo's in your existing data?
HTH
Alan
-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
_______________________________________________
AMaViS-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/
