[ic] Postgres + Debian error

Mike Heins mike at perusion.com
Tue Jan 2 11:57:31 EST 2007


Quoting Rene Hertell (interchange at hertell.com):
> Hi All,
> 
> First i want to wish everyone a happy new(er) year to everybody :-)
> 
> Then to my problem.
> 
> I have a fresh Interchange CVS-installation running on Debian Sarge,
> Postgres and an unthreaded local perl. I installed IC-kitchensink
> CPAN-packages, and I now have the demo shop running fine,
> 
> except for one thing: I can't create an account using the new_account
> page. i get the following error after hitting Create account "Cannot log
> in after new account creation: Invalid user name or password.", and in
> the catalogs error-log i get this error:
> 
> set_row error as called by Vend::Table::DBI: DBD::Pg::db do failed:
> ERROR:  null value in column "password" violates not-null constraint
> 
> Any hint in any direction would be apreciated :-)

Restart IC and the Postgres server a couple of times and see
if it persists. For some reason, there are some DBD::Pg anomalies
that exist early in the creation cycle for a database; I have never
figured out what the heck they are.

-- 
Mike Heins
Perusion -- Expert Interchange Consulting    http://www.perusion.com/
phone +1.765.647.1295  tollfree 800-949-1889 <mike at perusion.com>

Prove you aren't stupid.  Say NO to Passport.


More information about the interchange-users mailing list