I think I had this one too. When using 1.4b1, did you use the following script instead of using the one generated by ANT : jetspeed-1.4b1-release-src\src\sql\external\turbine-oracle.sql ?
Cause if you did, this one created a ID_TABLE in your database, and it was a mistake. Instead of using a proper sequence to increase ids, it used the id_table If you want to keep your datas, David Sean Taylor point me to a solution : DROP the ID_TABLE CREATE SEQUENCE TURBINE_USER_SEQ INCREMENT BY 1 START WITH 1000 NOMAXVALUE NOCYCLE NOCACHE ORDER; ............................................................^ set higher than your highest id, which you can find by SELECT MAX(USER_ID) FORM TURBINE_USER; You'll have to do the same I think for Profile, if you stored them in DB too. For more details : http://www.mail-archive.com/[EMAIL PROTECTED]/msg06936.html Danny a �crit : > Hello folks, (please try to help me) > > I still have problems with DB after uptading jetspeed from > 1.4 b1 to 1.4 b3. > > After adding the missing column in the TURBINE_USER table, i thought > everything works fin, but now I tried to create a new user, and get > the following: > > There has been an Error! > Reason: > ... > > So here comes the question: > > Are there any other changes, I have to pay attention to? > I noticed that the DB scripts changed, but I'm no DB expert. We want > to keep the information in our DB ( I assume that cleanig DB and > re-populate would fix the problem), is there any way to do so? > > Thanks Danny > > ========================================== > T-Systems Multimedia Solutions GmbH > Danny Gehl > Authorized Java Center (AJC) > Hausanschrift: Riesaer Stra�e 5, 01029 Dresden > Tel.: (0351) 8505 845 > Fax.: (in Arbeit) > E-Mail: mailto:[EMAIL PROTECTED] > http://www.T-Systems-MMS.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
