Ok, dropdb universe; createdb universe; untar fresh copy of ACSpg. The data model load goes fine as I'm using PG7.0 (theres some stuff in general-permissions.sql which requires 7.0; the 6.5 stuff has been commented out).
I can log in as system with password changeme. However, when I try to create a new user, I get the following errors:
[19/Apr/2000:18:47:23][31937.7175][-conn1-] Notice: nsd.db:
sql(::universe): insert into users
(user_id,email,password,first_names,last_name,url,registration_date,re
gistration_ip, user_state, last_visit)
values
(3,'mailto:dstar@pele.cx';,'syncrad','Shalon','Wood','', sysdate(),
'63.68.137.42', 'authorized', sysdate())
[19/Apr/2000:18:47:23][31937.7175][-conn1-] Notice: Querying 'insert
into users_preferences (user_id) values (3);'
[19/Apr/2000:18:47:23][31937.7175][-conn1-] Error: Ns_PgExec: result
status: 7 message: ERROR: Cannot insert a duplicate key into unique
index users_preferences_pkey
[19/Apr/2000:18:47:23][31937.7175][-conn1-] Notice: nsd.db:
sql(::universe): insert into users_preferences (user_id) values (3)
[19/Apr/2000:18:47:23][31937.7175][-conn1-] Notice: Ns_PgResetHandle:
Rolling back transaction
[19/Apr/2000:18:47:23][31937.7175][-conn1-] Notice: Querying
'rollback;'
[19/Apr/2000:18:47:23][31937.7175][-conn1-] Notice: Ns_PgExec: Rolling
back transaction
I assume I missed something somwehere, but I don't know what.
