Index: openacs-4/packages/acs-tcl/tcl/community-core-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/community-core-procs.xql,v
diff -u -r1.29 -r1.30
--- openacs-4/packages/acs-tcl/tcl/community-core-procs.xql	21 Feb 2018 14:00:56 -0000	1.29
+++ openacs-4/packages/acs-tcl/tcl/community-core-procs.xql	25 May 2018 08:43:17 -0000	1.30
@@ -187,43 +187,6 @@
           where  user_id = :user_id
 
       </querytext>
-   </fullquery>
- 
-   <fullquery name="acs_user::get_from_username_not_cached.select_user_info">
-      <querytext>
+   </fullquery> 
 
-          select user_id, 
-                 username,
-                 authority_id,
-                 first_names, 
-                 last_name, 
-                 first_names || ' ' || last_name as name,
-                 email, 
-                 url, 
-                 screen_name,
-                 priv_name,  
-                 priv_email,
-                 email_verified_p,
-                 email_bouncing_p,
-                 no_alerts_until,
-                 last_visit,
-                 to_char(last_visit, 'YYYY-MM-DD HH24:MI:SS') as last_visit_ansi, 
-                 second_to_last_visit,
-                 to_char(second_to_last_visit, 'YYYY-MM-DD HH24:MI:SS') as second_to_last_visit_ansi, 
-                 n_sessions,
-                 password_question,
-                 password_answer,
-                 password_changed_date,
-                 member_state,
-                 rel_id,
-                 extract(day from current_date - password_changed_date) as password_age_days,
-                 creation_date,
-                 creation_ip
-          from   cc_users 
-          where  authority_id = :authority_id
-          and    lower(username) = lower(:username)
-
-     </querytext>
-   </fullquery>
-
 </queryset>