Error using MySQL

[Stefan Wagner <wa...@ixtern.de>]

Hi!

I changed the used database to MySQL and at first it all worked fine because 
I only had one user. If I want to add another using the form I get the 
following error:

  There has been an Error!

  Reason: 

          java.sql.SQLException: Invalid argument value: Duplicate entry '0' 
for key 1
          at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java)
          at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java)
          at org.gjt.mm.mysql.Connection.execSQL(Connection.java)
          at 
org.gjt.mm.mysql.PreparedStatement.executeUpdate(PreparedStatement.java)
          at com.workingdogs.village.Record.saveWithInsert(Record.java:328)
          at com.workingdogs.village.Record.save(Record.java:185)
          at com.workingdogs.village.Record.save(Record.java:166)
          at 
org.apache.jetspeed.modules.actions.CreateNewUserAndConfirm.doPerform(CreateNewUserAndConfirm.java:188)
          at org.apache.turbine.modules.Action.perform(Action.java:89)
          at 
org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122)
          at 
org.apache.turbine.modules.pages.DefaultPage.doBuild(DefaultPage.java:148)
          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:414)
          at org.apache.turbine.Turbine.doPost(Turbine.java:505)
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
          at 
org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
          at org.apache.tomcat.core.Handler.service(Handler.java:286)
          at 
org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
          at 
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
          at 
org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
          at 
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:210)
          at 
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
          at 
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
          at java.lang.Thread.run(Thread.java:475)

What's the reason?

Thanks and ciao
Stefan

---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org