Word - Lutece

[LUTECE-462] plugin-document : new document type: impossible to create
attribut "liste de valeurs" Created: 31/Oct/07 Updated: 10/Sep/08 Resolved: 07/Nov/07
Status:
Closed
Project:
LUTECE
Component/s:
plugin-document
Affects
Version/s:
2.1.0-b4
Fix Version/s:
2.1.0 Sinnamary
Type:
Bug
Priority:
Major
Reporter:
Pascal Kuczynski
Assignee:
ILE
Resolution:
Cannot Reproduce
Votes:
0
Labels:
None
Remaining
Estimate:
Not Specified
Time Spent:
Not Specified
Original
Estimate:
Not Specified
Environment:
linux firefox
Description
Je suis entrain de créer un nouveau type de document, j'ajoute un attribut "liste de valeurs", je remplis les champs et la liste de valeur, je
clique sur "créer" et j'obtiens l'erreur suivante:
Une erreur s'est produite dans l'application
Le message d'erreur est : DAOUtil error : Duplicate entry '56-items-0' for key 1 - SQL statement : - Plugin : lutece Initial error print stack
: java.sql.SQLException: Duplicate entry '56-items-0' for key 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975) at
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600) at
com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1125) at
com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:677) at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1357) at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1274) at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1259) at
fr.paris.lutece.util.sql.DAOUtil.executeUpdate(DAOUtil.java:176) at
fr.paris.lutece.plugins.document.business.attributes.DocumentAttributeDAO.insertAttributeParameters(DocumentAttributeDAO.java:263)
at fr.paris.lutece.plugins.document.business.attributes.DocumentAttributeDAO.insert(DocumentAttributeDAO.java:116) at
fr.paris.lutece.plugins.document.business.attributes.DocumentAttributeHome.create(DocumentAttributeHome.java:69) at
fr.paris.lutece.plugins.document.web.DocumentTypeJspBean.doAddAttribute(DocumentTypeJspBean.java:271) at
org.apache.jsp.jsp.admin.plugins.document.DoAddDocumentTypeAttribute_jsp._jspService(DoAddDocumentTypeAttribute_jsp.java:56)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334) at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314) at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at
fr.paris.lutece.portal.web.upload.UploadFilter.doFilter(UploadFilter.java:138) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at
fr.paris.lutece.portal.web.upload.DosGuardFilter.doFilter(DosGuardFilter.java:134) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at
fr.paris.lutece.portal.web.user.AuthenticationFilter.doFilter(AuthenticationFilter.java:130) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at
fr.paris.lutece.portal.web.encoding.EncodingFilter.doFilter(EncodingFilter.java:70) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199) at
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282) at
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767) at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697) at
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889) at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595)
Le tracé de pile est :
fr.paris.lutece.portal.service.util.AppException: DAOUtil error : Duplicate entry '56-items-0' for key 1 - SQL statement : - Plugin : lutece
Initial error print stack :
java.sql.SQLException: Duplicate entry '56-items-0' for key 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1125)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:677)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1357)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1274)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1259)
at fr.paris.lutece.util.sql.DAOUtil.executeUpdate(DAOUtil.java:176)
at
fr.paris.lutece.plugins.document.business.attributes.DocumentAttributeDAO.insertAttributeParameters(DocumentAttributeDAO.java:263)
at fr.paris.lutece.plugins.document.business.attributes.DocumentAttributeDAO.insert(DocumentAttributeDAO.java:116)
at fr.paris.lutece.plugins.document.business.attributes.DocumentAttributeHome.create(DocumentAttributeHome.java:69)

at fr.paris.lutece.plugins.document.web.DocumentTypeJspBean.doAddAttribute(DocumentTypeJspBean.java:271)
at
org.apache.jsp.jsp.admin.plugins.document.DoAddDocumentTypeAttribute_jsp._jspService(DoAddDocumentTypeAttribute_jsp.java:56)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at fr.paris.lutece.portal.web.upload.UploadFilter.doFilter(UploadFilter.java:138)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at fr.paris.lutece.portal.web.upload.DosGuardFilter.doFilter(DosGuardFilter.java:134)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at fr.paris.lutece.portal.web.user.AuthenticationFilter.doFilter(AuthenticationFilter.java:130)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at fr.paris.lutece.portal.web.encoding.EncodingFilter.doFilter(EncodingFilter.java:70)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
at fr.paris.lutece.util.sql.DAOUtil.executeUpdate(DAOUtil.java:181)
at
fr.paris.lutece.plugins.document.business.attributes.DocumentAttributeDAO.insertAttributeParameters(DocumentAttributeDAO.java:263)
at fr.paris.lutece.plugins.document.business.attributes.DocumentAttributeDAO.insert(DocumentAttributeDAO.java:116)
at fr.paris.lutece.plugins.document.business.attributes.DocumentAttributeHome.create(DocumentAttributeHome.java:69)
at fr.paris.lutece.plugins.document.web.DocumentTypeJspBean.doAddAttribute(DocumentTypeJspBean.java:271)
at
org.apache.jsp.jsp.admin.plugins.document.DoAddDocumentTypeAttribute_jsp._jspService(DoAddDocumentTypeAttribute_jsp.java:56)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at fr.paris.lutece.portal.web.upload.UploadFilter.doFilter(UploadFilter.java:138)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at fr.paris.lutece.portal.web.upload.DosGuardFilter.doFilter(DosGuardFilter.java:134)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at fr.paris.lutece.portal.web.user.AuthenticationFilter.doFilter(AuthenticationFilter.java:130)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at fr.paris.lutece.portal.web.encoding.EncodingFilter.doFilter(EncodingFilter.java:70)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Comments
Comment by ILE [ 07/Nov/07 ]
Seems due to an inconsistency database: not reproducible
Comment by ILE [ 07/Nov/07 ]
Seems due to an inconsistency database: not reproducible
Generated at Sun Apr 16 00:55:12 CEST 2017 using JIRA 6.2.7#6265-
sha1:91604a8de81892a3e362e0afee505432f29579b0.