On 29-Oct-04, at 3:28 PM, Michael Parker wrote:
On Fri, Oct 29, 2004 at 02:31:59PM -0400, Jason Lixfeld wrote:debug: Conf::SQL: executing SQL: SELECT preference, value FROM userpref
WHERE username = 'jason-at-lixfeld.ca' OR username = '$GLOBAL' OR
username = CONCAT('%','lixfeld.ca') ORDER BY username ASC
Run this query in the command line tool and see what it returns.
(NOTE: sanitized with @ changed to -at-)
mysql> SELECT preference, value FROM userpref WHERE username = 'jason-at-lixfeld.ca' OR username = '$GLOBAL' OR username = CONCAT('%','lixfeld.ca') ORDER BY username ASC;
+-------------------------+----------------------------+
| preference | value |
+-------------------------+----------------------------+
| required_hits | 5.0 |
| whitelist_from | plixfeld-at-andromedas.com |
| score USER_IN_WHITELIST | -10 |
+-------------------------+----------------------------+
3 rows in set (0.00 sec)
mysql>
Michael
