I found a temporary fix by specifying the character set in the query:
ELECT wb
FROM wblist
LEFT JOIN mailaddr ON wblist.sid = mailaddr.id
WHERE (
wblist.rid =1
)
AND (
mailaddr.email
IN (
_latin1 '[EMAIL PROTECTED]', _latin1 'webmaster@', _latin1
'yachtworld.com', _latin1 '.yachtworld.com', _latin1 '.com', _latin1
'.'
)
)
ORDER BY mailaddr.priority DESC
LIMIT 0 , 30
/Paul
On Aug 26, 2005, at 6:57 PM, Paul Wolstenholme wrote:
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
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/
-------------------------------------------------------
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
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/