[Openinteract-help] Problem with INCREMENT in postgresql

[Wijnand W. <wi...@ne...>]

Hi List,

I am trying to explere OpenInteract but when setting up a example
website I am getting stuck.

The problem seems to be the handling of increments.
When oi2_manage install_sql --package=SYSTEM starts adding users I get
following error in my log:
18:50:25 ERROR OI2.INITIALIZE OpenInteract2::SQLInstall::User (99)
Failed to create superuser: DBD::Pg::st execute failed: ERROR:  null
value in column "user_id" violates not-null constraint
at /usr/local/libdata/perl5/site_perl/SPOPS/SQLInterface.pm line 297.

This same things happenes with other tables with an id field.
When I manually try to add the sequence I get an error saying the
sequence already exists.

Anyone knows what is wrong here?

Wijnand