Encryption is not working consistently so it is abandoned for now password: #form.user_password#
encrypted with ' ': #variables.encrypted_password#xxx
encrypted none : #variables.encrypted_none#xxx
encrypted pounds : #variables.encrypted_pound#xxx
---> SELECT DBA.t_user.name_first, DBA.t_user.name_last, DBA.t_user.user_id, DBA.t_user.user_class_id FROM DBA.t_user WHERE (DBA.t_user.login_id = '#form.login_id#') AND (DBA.t_user.user_password = '#form.user_Password#') SELECT DBA.t_merch__user_a.merch_id FROM DBA.t_merch__user_a WHERE DBA.t_merch__user_a.user_id = #client.user_id# SELECT t_plan_user_role.plan_id, t_plan_user_role.role_id, t_plan.plan_name FROM t_plan_user_role, t_plan WHERE user_id = #client.user_id# AND t_plan_user_role.plan_id = t_plan.plan_id Bad UserType.

The usertype '#form.UserType#' is not valid for Logging in.