[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [ic] cannot create account on public side


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
_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users


Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.