user_scores_sql_custom_query SELECT IF(type = 'WHITE', 'whitelist_from', 'blacklist_from') AS preference, IF(INSTR(email, '@'),email,CONCAT('*@', email)) AS value FROM lists WHERE uid = _USERNAME_ ORDER BY preference ASC I'm getting lots of errors like those at the bottom of this message in my logs. In my SpamAssassin configuration I have the above query which gives output like the following when run against my account: +----------------+---------------------------------------+ | preference | value | +----------------+---------------------------------------+ | blacklist_from | jenny@videonow.com | | whitelist_from | russell@coker.com.au | [...] +----------------+---------------------------------------+ 115 rows in set (0.00 sec) Do the below errors indicate that SpamAssassin received a preference without a value? If so why might that happen? None of the accounts in question have a null value for the email column. Apr 2 06:42:05 foo2 spamd[8123]: config: SpamAssassin failed to parse line, no value provided for "whitelist_from", skipping: whitelist_from Apr 2 06:45:54 foo2 spamd[8161]: config: SpamAssassin failed to parse line, no value provided for "blacklist_from", skipping: blacklist_from -- My Main Blog http://etbe.coker.com.au/ My Documents Blog http://doc.coker.com.au/