Image du projet 'Socle K-Sup' téléversée
  1. Socle K-Sup
  2. CORE-4957

Chinois : impossible de créer une fiche si le titre est trop long

    XMLWordImprimable

Informations

    • Bug
    • Résolution: Résolu
    • Mineur
    • 6.07.29, 6.08.00
    • 6.08.00-BETA-02
    • Aucune
    • Aucune

    Description

      Lorsqu'on créé une fiche en chinois avec un titre assez long, une erreur peut survenir à l'enregistrement car lors de la création du slug, les caractères sont transformés et dépassent alors la limite de 255 caractères :

      Voici la stack :

      2020-02-06_11:29:00.399 [ajp-nio-8009-exec-10] [5EFC61304D017B2B9FA1BE848B87DEFA.ksup1] ERROR c.u.o.processus.SaisieFiche - erreur dans le processus de saisie de fiche
      com.jsbsoft.jtf.datasource.exceptions.UpdateToDataSourceException: Unable to update ACTUALITE with id 1000021
      	at com.jsbsoft.jtf.datasource.dao.impl.mysql.AbstractCommonDAO.update(AbstractCommonDAO.java:168)
      	at com.univ.objetspartages.om.AbstractOm.update(AbstractOm.java:90)
      	at com.univ.utils.FicheUnivMgr.enregistrer(FicheUnivMgr.java:428)
      	at com.univ.objetspartages.processus.ControleurUniv.traiterActionEnregistrer(ControleurUniv.java:1780)
      	at com.univ.objetspartages.processus.ControleurUniv.traiterActionTraitement(ControleurUniv.java:1034)
      	at com.univ.objetspartages.processus.ControleurUniv.traiterPRINCIPAL(ControleurUniv.java:978)
      	at com.univ.objetspartages.processus.SaisieActualite.traiterPRINCIPAL(SaisieActualite.java:207)
      	at com.univ.objetspartages.processus.SaisieFiche.traiterActionParDefaut(SaisieFiche.java:412)
      	at com.univ.objetspartages.processus.SaisieActualite.traiterAction(SaisieActualite.java:76)
      	at com.jsbsoft.jtf.core.ProcessusManager.traiterAction(ProcessusManager.java:241)
      	at com.jsbsoft.jtf.core.ProcedureBean.descriptifFluxProcessus(ProcedureBean.java:500)
      	at com.jsbsoft.jtf.core.ProcedureBean.descriptifFluxRetour(ProcedureBean.java:210)
      	at com.jsbsoft.jtf.core.ProcedureBean.descriptifFluxRetour(ProcedureBean.java:238)
      	at com.jsbsoft.jtf.core.TraitementRequeteHTTP.traiterRequeteHTTP(TraitementRequeteHTTP.java:489)
      	at com.kosmos.controllers.SGController.doSg(SGController.java:39)
      	at sun.reflect.GeneratedMethodAccessor608.invoke(Unknown Source)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:498)
      	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
      	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
      	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
      	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
      	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
      	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
      	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
      	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
      	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
      	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
      	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      	at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:232)
      	at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:209)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      	at com.kosmos.log.MDCFilter.doFilter(MDCFilter.java:59)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      	at com.jsbsoft.jtf.core.LogAppFilter.doFilter(LogAppFilter.java:123)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      	at ro.isdc.wro.http.WroContextFilter.doFilter(WroContextFilter.java:64)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      	at com.kportal.pdf.PDFFilter.doFilter(PDFFilter.java:125)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      	at com.univ.url.filter.SiteAliasResolutionFilter.doFilter(SiteAliasResolutionFilter.java:58)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      	at com.univ.multisites.filter.HttpsRedirectFilter.doFilter(HttpsRedirectFilter.java:69)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      	at com.univ.utils.filter.ContexteFilter.doFilter(ContexteFilter.java:58)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      	at com.univ.utils.filter.HoneyPotFilter.doFilter(HoneyPotFilter.java:68)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
      	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
      	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
      	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543)
      	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
      	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
      	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678)
      	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
      	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
      	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:482)
      	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
      	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:810)
      	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1623)
      	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
      	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
      	at java.lang.Thread.run(Thread.java:748)
      Caused by: org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [UPDATE ACTUALITE SET CODE=?, CODE_RATTACHEMENT=?, CODE_REDACTEUR=?, CODE_RUBRIQUE=?, CODE_VALIDATION=?, COMPLEMENT_DATE=?, CONTENU_ENCADRE=?, DATE_ALERTE=?, DATE_ARCHIVAGE=?, DATE_CREATION=?, DATE_DECLENCHEMENT=?, DATE_EVENEMENT=?, DATE_FIN_EVENEMENT=?, DATE_MODIFICATION=?, DATE_PROPOSITION=?, DATE_SUPPRESSION=?, DATE_VALIDATION=?, DESCRIPTION=?, DIFFUSION_MODE_RESTRICTION=?, DIFFUSION_PUBLIC_VISE=?, DIFFUSION_PUBLIC_VISE_RESTRICTION=?, EMAIL_RESPONSABLE_EVENEMENT=?, ENCADRE_RECHERCHE=?, ENCADRE_RECHERCHE_BIS=?, ETAT_OBJET=?, ID_PLAN_ACCES=?, ID_VIGNETTE=?, INSERTION_AGENDA=?, LANGUE=?, LIEU=?, MESSAGE_ALERTE=?, META_DESCRIPTION=?, META_KEYWORDS=?, NB_HITS=?, PARTENAIRES=?, RATTACHEMENT_BANDEAU=?, RESPONSABLE_EVENEMENT=?, RESUME=?, SITE_EVENEMENT=?, SLUG=?, THEMATIQUE=?, TITRE=?, TITRE_ENCADRE=?, TYPE_EVENEMENT=? WHERE ID_ACTUALITE = ?]; Data truncation: Data too long for column 'SLUG' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'SLUG' at row 1
      	at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:102)
      	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
      	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
      	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
      	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:649)
      	at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:870)
      	at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:894)
      	at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.update(NamedParameterJdbcTemplate.java:287)
      	at com.jsbsoft.jtf.datasource.dao.impl.mysql.AbstractCommonDAO.update(AbstractCommonDAO.java:166)
      	... 84 common frames omitted
      Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'SLUG' at row 1
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3971)
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
      	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
      	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
      	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2501)
      	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
      	at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2079)
      	at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2013)
      	at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5104)
      	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1998)
      	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
      	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
      	at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:877)
      	at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:870)
      	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:633)
      	... 88 common frames omitted
      

      Pièces jointes

        Liens des tickets

          Activité

            Personnes

              alice.ark Alice ARK [X] (Inactif)
              alice.ark Alice ARK [X] (Inactif)
              Votes:
              0 Voter pour ce ticket
              Gérer les observateurs:
              1 Démarre l'observation de ce ticket

              Dates

                Création:
                Mise à jour:
                Résolue: