My understanding is that user_scores_sql_custom_query is only needed if your table is not named "userprefs" and you do fancy things with the global name space... :-)

I just don't get it.. it doesn't seem to be logging anything at all in the debug output.. :(

I even went so far as to put in the user_scores_sql_custom_query, too. :)

-Rich


Dallas L. Engelken wrote:

Are you forgetting user_scores_sql_custom_query ??   My 3.0 config looks
like this...  My user_prefs is called sa_rules :)

# user_prefs (sa_rules) sql settings
user_scores_dsn  DBI:mysql:logs:localhost:3306
user_scores_sql_password         XXXXX
user_scores_sql_username         XXXXXXXXXXXXX
user_scores_sql_custom_query            SELECT preference, value FROM
sa_rules WHERE username = _USERNAME_ OR username = '$GLOBAL' OR username
= CONCAT('%',_DOMAIN_) ORDER BY username ASC






Reply via email to