[ic] cannot create account on public side
Stuart Lowe
stuart at stuartlowe.com
Fri Apr 28 09:45:19 EDT 2006
On Thu, Apr 27, 2006 at 02:13:49PM -0700, Peter wrote:
> 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
OK: when I manually set the default to '' for column password (and the sql was verbatim btw)
as well as adding the corresponding default to catroot/dbconf/pgsql/userdb.pgsql:
Database userdb COLUMN_DEF "password=varchar(64) NOT NULL DEFAULT = ''" (is this correct??)
I was immediately able to create a new account and log in to it. I was also able to log out,
send orders etc. If I tried to create an account without a password, it wouldn't let me
('Must enter at least 4 characters for password.') which is good.
All the correct user info was also reflected in the userdb table.
This is good. But why?
Can anyone offer any insight into why I had to do this to get it to work?
Thanks for all you suggestions.
Stu.
--
Stuart Lowe | Toronto, CAN | key ID on keyserver | Skype stuart.lowe
Fedora Core release 4 (Stentz) GNU/Linux kernel 2.6.11-1.1369_FC4 on i686 localhost3.localdomain
09:39:52 up 15 days, 16:56, 4 users, load average: 1.58, 1.47, 1.34
More information about the interchange-users
mailing list