Re: "Create New Account" doesn't work

Sven Richter Tue, 24 May 2005 06:35:02 -0700

Dear Stefano,

yes, the whole timestamp issue is also a problem for me (in my databasethere are also no entries for Creation Date). But my problem was lyingbefore that. In my case there was no user created at all and I got anerror message. And I found out why. The autoincrement mechanism for theuser_id isn't working, so the database is using the default ('0'). Andin my database table there was already an user with the user_id '0'.That's why I got this error message. But I don't know why autoincrementisn't working. I have a couple of other tables, where it's working justfine.By the way, I use the "idbroker"-option, where the next ID is store inthe table 'ID_TABLE'. The entry for TURBINE_USER is correct. So I haveno idea, why it's not working like for all the other tables (the tablescreated by myself).


Thanks a lot for your help,
Sven.

Stefano Bianchi wrote:

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]



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: "Create New Account" doesn't work

Reply via email to