Good idea to look for errors in the logs.
Anyway, when I modified the Postgresql database to process sequences
correctly, the problem was fixed.
Added to the SQL in security-schema.sql
ALTER TABLE TURBINE_USER ALTER USER_ID SET DEFAULT
NEXTVAL('TURBINE_USER_SEQ');
Now, I have noticed that I had to modify several pieces of the database
creation to make this work.
- security-schema.sql and turbine-postgres.sql had overlapping table
creations. I had to comment out the entries in turbine-postgres.sql since
the definitions were incorrect.
- had to add the "default nextval" statements for every table that have
sequence keys
It seems the Postgresql definitions need to be fixed. Do I need to give any
more details for someone to add the fixes to this part of the install?
Robert
-----Original Message-----
From: Robert Keith [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 28, 2003 3:37 PM
To: Jetspeed Developers List
Subject: RE: DBPSML bug for User Browser - adduser
The Postgres DB log show this error when the Adduser link is pressed:
ERROR: turbine_user_seq.currval is not yet defined in this session
Robert
-----Original Message-----
From: Sandeep Dixit [mailto:[EMAIL PROTECTED]
Sent: Friday, June 27, 2003 9:09 AM
To: 'Jetspeed Developers List'
Subject: RE: DBPSML bug for User Browser - adduser
Is anything in the log?
----------
From: Robert Keith
Sent: Thursday, June 26, 2003 10:08 PM
To: Jetspeed Developers List
Subject: DBPSML bug for User Browser - adduser
Tried this on User's list, is this list more appropriate?
Just installed a fresh copy of Jetspeed-1.4.b4, connected this to fresh
PostGreSQL v7.3.3 install.
The ant builds work OK.
The "ant import" worked OK, and the system looks OK.
Just - when adding a new user using the Admin User Browser screen, the new
user record gets added to the TURBINE_USER table OK, but does not get added
to the JETSPEED_USER_PROFILE table. If I copy a record for "turbine" to the
new user record in JETSPEED_USER_PROFILE table, the system works fine.
The "Remove" function works OK and removes the record from the
JETSPEED_USER_PROFILE table.
Any maintenance done to the JETSPEED_USER_PROFILE via user
maintenance/customize functions work OK and update the JETSPEED_USER_PROFILE
data OK.
Is there something I missed? Is this a known bug? I could not find it in
the archives.
Regards,
Robert Keith
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.488 / Virus Database: 287 - Release Date: 6/5/03
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.488 / Virus Database: 287 - Release Date: 6/5/03
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
