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(BaseTurbineUserPeer.java:241)
at 
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert(BaseTurbineUserPeer.java:214)
at 
org.apache.jetspeed.services.security.turbine.TurbineUserManagement.addUser(TurbineUserManagement.java:283)
at 
org.apache.jetspeed.services.JetspeedUserManagement.addUser(JetspeedUserManagement.java:95)
at 
org.apache.jetspeed.services.JetspeedSecurity.addUser(JetspeedSecurity.java:213)
at 
de.ixellence.portal.modules.actions.CreateNewUserAndConfirmIxellence.doPerform(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(ApplicationFilterChain.java:237)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at 
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at 
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at 
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.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(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at 
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.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(StandardValveContext.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.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java: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(BaseTurbineUserPeer.java:241)
at 
org.apache.jetspeed.om.security.turbine.BaseTurbineUserPeer.doInsert(BaseTurbineUserPeer.java:214)
at 
org.apache.jetspeed.services.security.turbine.TurbineUserManagement.addUser(TurbineUserManagement.java:283)
at 
org.apache.jetspeed.services.JetspeedUserManagement.addUser(JetspeedUserManagement.java:95)
at 
org.apache.jetspeed.services.JetspeedSecurity.addUser(JetspeedSecurity.java:213)
at 
de.ixellence.portal.modules.actions.CreateNewUserAndConfirmIxellence.doPerform(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(JetspeedUserManagement.java:95)
at 
org.apache.jetspeed.services.JetspeedSecurity.addUser(JetspeedSecurity.java:213)
at 
de.ixellence.portal.modules.actions.CreateNewUserAndConfirmIxellence.doPerform(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(ApplicationFilterChain.java:237)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at 
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at 
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at 
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.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(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at 
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.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(StandardValveContext.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.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java: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]

Reply via email to