Uploaded image for project: 'Runtime'
  1. Runtime
  2. RUNTIME-3203

Mysql table at login : table name is not protected

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Major Major
    • 4.9.6, 4.10.0
    • 4.2.2
    • Général
    • None

      2019-07-02 14:54:35,046 ERROR [org.ametys.plugins.core.impl.group.directory.jdbc.JdbcGroupDirectory] (http-nio-8080-exec-2;/atd31/index.html) Error communication with database
      com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '- WHERE Login = 'damien' AND UserPopulation_Id = 'utilisateursbo-admin_atd'' at line 1
              at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
              at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
              at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
              at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
              at com.mysql.jdbc.Util.getInstance(Util.java:408)
              at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
              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:2490)
              at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
              at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966)
              at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
              at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
              at org.ametys.plugins.core.impl.group.directory.jdbc.JdbcGroupDirectory._executeSqlForUserGroups(JdbcGroupDirectory.java:384)
              at org.ametys.plugins.core.impl.group.directory.jdbc.JdbcGroupDirectory.getUserGroups(JdbcGroupDirectory.java:345)
              at org.ametys.core.group.GroupManager.getUserGroups(GroupManager.java:195)
              at org.ametys.core.group.GroupManager.getUserGroups(GroupManager.java:178)
              at org.ametys.core.right.RightManager.getUserRights(RightManager.java:645)
              at org.ametys.web.repository.site.SiteManager.isGrantedSite(SiteManager.java:218)
              at org.ametys.web.repository.IsASiteAction.act(IsASiteAction.java:55)
      

            Unassigned Unassigned
            fravetier Frederic Ravetier (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: