Uploaded image for project: 'Offre de formation'
  1. Offre de formation
  2. ODF-3701

Problème sur la BD des données de démo ODF

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major Major
    • 4.8.0
    • 4.8.0
    • None
    • None
    • 4.8.0 M11

      Pour le détecter : 

      • Se connecter à l'_admin du front 
      • Il n'est pas demandé de changer le mot de passe. 

      L'erreur suivante est présente : 

       

      Date : 06/06 15:06:45.601
      ThreadThread[http-nio-8080-exec-2,5,main]
      Niveau : ERROR
      Catégorie : org.ametys.plugins.core.user.management.UserPasswordManager
      URI de la requête : /_admin/index.html
      Message : 
      
      Failed to build reset password URI for user UserIdentity [login=admin, population=admin_population]
      
      Emplacement : org.ametys.plugins.core.user.management.UserPasswordManager.getChangePasswordURI(UserPasswordManager.java:237)
      
      Pile d'appels :
      
      org.ametys.plugins.core.user.UserManagementException: Database error while inserting a password change token for UserIdentity [login=admin, population=admin_population]
      at org.ametys.plugins.core.user.management.UserPasswordManager#_generateChangePasswordToken:309
      at org.ametys.plugins.core.user.management.UserPasswordManager#getChangePasswordURI:217
      at org.ametys.core.authentication.AuthenticateAction#_getWeakPasswordURI:762
      at org.ametys.core.authentication.AuthenticateAction#_handleWeakPassword:739
      at org.ametys.core.authentication.AuthenticateAction#_doProcess:690
      at org.ametys.core.authentication.AuthenticateAction#_process:648
      at org.ametys.core.authentication.AuthenticateAction#act:263
      at org.apache.cocoon.components.treeprocessor.sitemap.ActTypeNode#invoke:120
      at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode#invokeNodes:47
      at org.apache.cocoon.components.treeprocessor.sitemap.MatchNode#invoke:108
      at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode#invokeNodes:69
      at org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode#invoke:143
      at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode#invokeNodes:69
      at org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode#invoke:93
      at org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor#process:236
      at org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor#process:178
      at org.apache.cocoon.components.treeprocessor.TreeProcessor#process:254
      at org.apache.cocoon.components.treeprocessor.sitemap.MountNode#invoke:118
      at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode#invokeNodes:47
      at org.apache.cocoon.components.treeprocessor.sitemap.MatchNode#invoke:108
      at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode#invokeNodes:69
      at org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode#invoke:143
      at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode#invokeNodes:69
      at org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode#invoke:93
      at org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor#process:236
      at org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor#process:178
      at org.apache.cocoon.components.treeprocessor.TreeProcessor#process:254
      at org.apache.cocoon.Cocoon#process:699
      at org.ametys.runtime.servlet.RuntimeServlet#service:717
      at javax.servlet.http.HttpServlet#service:623
      at org.apache.catalina.core.ApplicationFilterChain#internalDoFilter:209
      at org.apache.catalina.core.ApplicationFilterChain#doFilter:153
      at org.apache.tomcat.websocket.server.WsFilter#doFilter:51
      at org.apache.catalina.core.ApplicationFilterChain#internalDoFilter:178
      at org.apache.catalina.core.ApplicationFilterChain#doFilter:153
      at org.apache.catalina.core.StandardWrapperValve#invoke:167
      at org.apache.catalina.core.StandardContextValve#invoke:90
      at org.apache.catalina.authenticator.AuthenticatorBase#invoke:481
      at org.apache.catalina.core.StandardHostValve#invoke:130
      at org.apache.catalina.valves.ErrorReportValve#invoke:93
      at org.apache.catalina.valves.AbstractAccessLogValve#invoke:673
      at org.apache.catalina.core.StandardEngineValve#invoke:74
      at org.apache.catalina.connector.CoyoteAdapter#service:343
      at org.apache.coyote.http11.Http11Processor#service:390
      at org.apache.coyote.AbstractProcessorLight#process:63
      at org.apache.coyote.AbstractProtocol$ConnectionHandler#process:926
      at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor#doRun:1791
      at org.apache.tomcat.util.net.SocketProcessorBase#run:52
      at org.apache.tomcat.util.threads.ThreadPoolExecutor#runWorker:1191
      at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker#run:659
      at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable#run:61
      at java.base/java.lang.Thread#run:833 Caused by: java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: 'CREATION_DATE' is not a column in table or VTI 'APP.AUTHENTICATION_TOKEN'.
      at org.ametys.core.authentication.token.AuthenticationTokenManager#_generateToken:402
      at org.ametys.core.authentication.token.AuthenticationTokenManager#generateToken:271
      at org.ametys.plugins.core.user.management.UserPasswordManager#_generateChangePasswordToken:292
      ... 51 more Caused by: java.sql.SQLSyntaxErrorException: 'CREATION_DATE' is not a column in table or VTI 'APP.AUTHENTICATION_TOKEN'.
      at org.apache.derby.impl.jdbc.SQLExceptionFactory#getSQLException (Unknown Source)
      at org.apache.derby.impl.jdbc.Util#generateCsSQLException (Unknown Source)
      at org.apache.derby.impl.jdbc.TransactionResourceImpl#wrapInSQLException (Unknown Source)
      at org.apache.derby.impl.jdbc.TransactionResourceImpl#handleException (Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedConnection#handleException (Unknown Source)
      at org.apache.derby.impl.jdbc.ConnectionChild#handleException (Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedPreparedStatement#<init> (Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedPreparedStatement42#<init> (Unknown Source)
      at org.apache.derby.jdbc.Driver42#newEmbedPreparedStatement (Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedConnection#prepareStatement (Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedConnection#prepareStatement (Unknown Source)
      at org.apache.commons.dbcp2.DelegatingConnection#prepareStatement:696
      at org.apache.commons.dbcp2.DelegatingConnection#prepareStatement:696
      at org.ametys.core.authentication.token.AuthenticationTokenManager#_generateToken:356
      ... 53 more Caused by: ERROR 42X14: 'CREATION_DATE' is not a column in table or VTI 'APP.AUTHENTICATION_TOKEN'.
      at org.apache.derby.iapi.error.StandardException#newException (Unknown Source)
      at org.apache.derby.iapi.error.StandardException#newException (Unknown Source)
      at org.apache.derby.impl.sql.compile.ResultColumn#bindResultColumnByName (Unknown Source)
      at org.apache.derby.impl.sql.compile.ResultColumnList#bindResultColumnsByName (Unknown Source)
      at org.apache.derby.impl.sql.compile.InsertNode#bindStatement (Unknown Source)
      at org.apache.derby.impl.sql.GenericStatement#prepMinion (Unknown Source)
      at org.apache.derby.impl.sql.GenericStatement#prepare (Unknown Source)
      at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext#prepareInternalStatement (Unknown Source)
      ... 61 more 

       

            Unassigned Unassigned
            mfranchet Magali Franchet
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: