[ic] cannot create account on public side

[Peter]

On 04/27/2006 06:52 AM, Stuart Lowe wrote:
> (Customer record creation): There was an error adding you to the
> customer table.
> (table userdb): set_row error as called by Vend::Table::DBI:
> DBD::Pg::db do failed: ERROR: null value in column "password"
> violates not-null constraint fields=username,inactive
> values='U00003',''''''

Try this from the psql backend (SQL syntax from memory, not positive if 
it is correct):
alter table userdb alter password set default '';

...and also add the corresponding default to your 
catroot/dbconf/pgsql/userdb.pgsql file.

Peter