Forum OpenACS Q&A: Error in http://iig.org.in/admin/users/one.tcl?user_id=3

I get an error like "

21/Dec/2000:17:13:16]
    Error: Ns_PgExec: result status: 7 message: ERROR:  parse error at
or near "ELSE"

[21/Dec/2000:17:13:16]
    Error: dbinit: error(localhost::iigfdb,ERROR:  parse error at or
near "ELSE"
    ): 'select users.*,
      case when screen_name is null then '&lt none set up &gt' else
screen_name end as screen_name,
      user_demographics_summary(user_id) as demographics_summary from
users where user_id=3'

[21/Dec/2000:17:13:16]
    Error: Database operation "0or1row" failed (exception NSDB, "Query
was not a statement returning rows.")
    Database operation "0or1row" failed (exception NSDB, "Query was
not a statement returning rows.")
        while executing
    "ns_db 0or1row $db "select users.*,
      case when screen_name is null then '&lt none set up &gt' else
screen_name end as screen_name,
      user_demographics ..."
        invoked from within
    "set selection [ns_db 0or1row $db "select users.*,
      case when screen_name is null then '&lt none set up &gt' else
screen_name end as screen_name,
      us ..."
        (file "/web/iig.org.in/www/admin/users/one.tcl" line 20)
        invoked from within
    "source $script"
        invoked from within
    "if ![file exists $script] {
                ns_returnnotfound $conn
        } else {
                source $script
        }"
        (procedure "ns_sourceproc" line 3)
        invoked from within
    "ns_sourceproc cns102 {}"
    Notice: Querying 'select ad_group_member_p(1,
system_administrator_group_id()) from dual;'

When i try to access the one.tcl file after i upgraded to the CVS
version. Early Help Please.

Was able to fix it with mod-user-data.sql
OK, my first update two days ago messed up this PL/pgSQL - I found the
bug doing further testing on the airplane ride back east, but wasn't
able to update until yesterday AM.  You picked up the bogus version.

Sorry 'bout that.  I posted about this bogus update and my subsequent
fix to it in another thread yesterday...