Dear Sven, I don't know if it is similar, but we experience a problem with J1.5 CreateNewAccount functionality. We had to modify the relative class since it did not write correctly the Creation Date in the DB (always '0000-00-00'). The user was created, but could not be retrieved immediately afterwards. Sorry if this does not apply to your case... Cheers Stefano
----- Original Message ----- From: "Sven Richter" <[EMAIL PROTECTED]> To: "'Jetspeed Users List'" <[email protected]> Sent: Monday, May 23, 2005 5:16 PM Subject: "Create New Account" doesn't work > Hello, > > I'm using Jetspeed 1.5 and I'm currently trying to use the "Create New > Account" option. But first of all, even if I set the option to enable in > the Jetspeed.properties, it doesn't show up in the top frame under the > login form. That's why I copied the link from the top.vm template into a > new template. But after I clicked on the sumit button of the form for > the new user, I get the following error message: > > There has been an *Error*! > Reason: > > org.apache.jetspeed.services.security.UserException: Failed to create account 'ttest': Duplicate key or integrity constraint violation message from server: "Duplicate entry '0' for key 1" > > > Get/Post Data: > action = CreateNewUserAndConfirmIxellence > user = anon > password_confirm = ttest > language = de > username = ttest > firstname = ttest > lastname = ttest > page = shop.psml > email = [EMAIL PROTECTED] > submit2 = Neue Registrierung > template = /html/ShowError.vm > password = ttest > media-type = html > > Stacktrace: > > > java.sql.SQLException: Duplicate key or integrity constraint violation message from server: "Duplicate entry '0' for key 1" > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278) > at com.mysql.jdbc.Connection.execSQL(*Connection*.java:2251) > at com.mysql.jdbc.PreparedStatement.executeUpdate(*PreparedStatement*.java:1772 ) > at com.mysql.jdbc.PreparedStatement.executeUpdate(*PreparedStatement*.java:1619 ) > at com.workingdogs.village.Record.saveWithInsert(Unknown *Source*) > at com.workingdogs.village.Record.save(Unknown *Source*) > at com.workingdogs.village.Record.save(Unknown *Source*) > at org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:899) > at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:742) > at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:639) > at org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert(BaseTur bineUserPeer.java:241) > at org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert(BaseTur bineUserPeer.java:214) > at org.apache.jetspeed.services.security.turbine.TurbineUserManagement.addUser( TurbineUserManagement.java:283) > at org.apache.jetspeed.services.JetspeedUserManagement.addUser(JetspeedUserMana gement.java:95) > at org.apache.jetspeed.services.JetspeedSecurity.addUser(JetspeedSecurity.java: 213) > at de.ixellence.portal.modules.actions.CreateNewUserAndConfirmIxellence.doPerfo rm(CreateNewUserAndConfirmIxellence.java:171) > at org.apache.turbine.modules.Action.perform(*Action*.java:87) > at org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122) > at org.apache.turbine.modules.pages.DefaultPage.doBuild(DefaultPage.java:143) > at org.apache.turbine.modules.Page.build(Page.java:90) > at org.apache.turbine.modules.PageLoader.exec(PageLoader.java:123) > at org.apache.turbine.Turbine.doGet(Turbine.java:563) > at org.apache.turbine.Turbine.doPost(Turbine.java:658) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:237) > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:157) > at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja va:214) > at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContex t.java:104) > at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) > at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContext Valve.java:198) > at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja va:152) > at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContex t.java:104) > at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) > at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137 ) > at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContex t.java:104) > at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118 ) > at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContex t.java:102) > at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) > at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java :109) > at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContex t.java:104) > at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) > at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) > at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) > at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) > at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne ction(Http11Protocol.java:705) > at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) > at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav a:683) > at java.lang.Thread.run(*Thread*.java:595) > rethrown as org.apache.torque.TorqueException: Duplicate key or integrity constraint violation message from server: "Duplicate entry '0' for key 1" > at org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:236) > at org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:903) > at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:742) > at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:639) > at org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert(BaseTur bineUserPeer.java:241) > at org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert(BaseTur bineUserPeer.java:214) > at org.apache.jetspeed.services.security.turbine.TurbineUserManagement.addUser( TurbineUserManagement.java:283) > at org.apache.jetspeed.services.JetspeedUserManagement.addUser(JetspeedUserMana gement.java:95) > at org.apache.jetspeed.services.JetspeedSecurity.addUser(JetspeedSecurity.java: 213) > at de.ixellence.portal.modules.actions.CreateNewUserAndConfirmIxellence.doPerfo rm(CreateNewUserAndConfirmIxellence.java:171) > at org.apache.turbine.modules.Action.perform(*Action*.java:87) > at org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122) > at org.apache.turbine.modules.pages.DefaultPage.doBuild(DefaultPage.java:143) > at org.apache.turbine.modules.Page.build(Page.java:90) > at org.apache.turbine.modules.PageLoader.exec(PageLoader.java:123) > at org.apache.turbine.Turbine.doGet(Turbine.java:563) > at org.apache.turbine.Turbine.doPost(Turbine.java:658) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > rethrown as org.apache.jetspeed.services.security.UserException: Failed to create account 'ttest': Duplicate key or integrity constraint violation message from server: "Duplicate entry '0' for key 1" > at org.apache.jetspeed.services.security.turbine.TurbineUserManagement.addUser( TurbineUserManagement.java:292) > at org.apache.jetspeed.services.JetspeedUserManagement.addUser(JetspeedUserMana gement.java:95) > at org.apache.jetspeed.services.JetspeedSecurity.addUser(JetspeedSecurity.java: 213) > at de.ixellence.portal.modules.actions.CreateNewUserAndConfirmIxellence.doPerfo rm(CreateNewUserAndConfirmIxellence.java:171) > at org.apache.turbine.modules.Action.perform(*Action*.java:87) > at org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122) > at org.apache.turbine.modules.pages.DefaultPage.doBuild(DefaultPage.java:143) > at org.apache.turbine.modules.Page.build(Page.java:90) > at org.apache.turbine.modules.PageLoader.exec(PageLoader.java:123) > at org.apache.turbine.Turbine.doGet(Turbine.java:563) > at org.apache.turbine.Turbine.doPost(Turbine.java:658) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:237) > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:157) > at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja va:214) > at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContex t.java:104) > at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) > at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContext Valve.java:198) > at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja va:152) > at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContex t.java:104) > at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) > at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137 ) > at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContex t.java:104) > at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118 ) > at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContex t.java:102) > at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) > at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java :109) > at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContex t.java:104) > at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) > at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) > at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) > at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) > at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne ction(Http11Protocol.java:705) > at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) > at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav a:683) > at java.lang.Thread.run(*Thread*.java:595) > > I didn't change anything in that template and it's action-class. And > there is no user with that loginname in the database. > > Does anyone have any idea, why that error appears? > > Best Regards, > Sven. > > > > > --------------------------------------------------------------------- > 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]
