[AMaViS-user] bad syntax for sql lookup--please help

[Aaron P. M. <ml...@pr...>]

I'm using amavisd-new -20030616p9, RH 3.0 ES and mysql 3.23.58-1 trying
to do sql lookups for user prefs.  I've done this before and have
compared my sql statements and can't figure out the problem. 

When i start amavisd-new with the debug switch, here's what i get:

# /usr/local/sbin/amavisd debug
Error in config file /etc/amavisd.conf: syntax error at
/etc/amavisd.conf line 829, near "' ORDER BY users.priority DESC ';"

Here are the lines from my /etc/amavisd.conf file:

$sql_select_policy = 'SELECT *,users.vuid FROM users,policy_names'.
  ' WHERE (users.policy=policy_names.id) AND (users.username IN (%k))'.
  ' ORDER BY users.priority DESC ';

Please help even point me in the right direction.anything!!!!!

Thanks in advance,

Aaron