FusionAuth
    • Home
    • Categories
    • Recent
    • Popular
    • Pricing
    • Contact us
    • Docs
    • Login
    1. Home
    2. traperwaze
    T
    • Profile
    • Following 0
    • Followers 0
    • Topics 1
    • Posts 1
    • Best 0
    • Controversial 0
    • Groups 0

    traperwaze

    @traperwaze

    0
    Reputation
    1
    Profile views
    1
    Posts
    0
    Followers
    0
    Following
    Joined Last Online
    traperwaze Unfollow Follow

    Latest posts made by traperwaze

    • Error getting list application due to sql error (mysql)

      When accessing app list in admin, it says.

      FusionAuth encountered an unexpected error. Please review the troubleshooting guide found in the documentation for assistance and the available support channels.

      here's the trace:

      org.apache.ibatis.exceptions.PersistenceException: 
fusionauth-fusionauth-1     | ### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '>> '$.state' = 'Active'' at line 8
fusionauth-fusionauth-1     | ### The error may exist in io/fusionauth/api/domain/ApplicationMapper.xml
fusionauth-fusionauth-1     | ### The error may involve defaultParameterMap
fusionauth-fusionauth-1     | ### The error occurred while setting parameters
fusionauth-fusionauth-1     | ### SQL: SELECT COUNT(*)     FROM applications AS a      WHERE  LOWER(a.name) LIKE ?                                         AND a.data ->> '$.state' = ?
fusionauth-fusionauth-1     | ### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '>> '$.state' = 'Active'' at line 8
fusionauth-fusionauth-1     |   at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
fusionauth-fusionauth-1     |   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:156)
fusionauth-fusionauth-1     |   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
fusionauth-fusionauth-1     |   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)
fusionauth-fusionauth-1     |   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:75)
fusionauth-fusionauth-1     |   at jdk.internal.reflect.GeneratedMethodAccessor19.invoke(Unknown Source)
fusionauth-fusionauth-1     |   at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
fusionauth-fusionauth-1     |   at java.base/java.lang.reflect.Method.invoke(Method.java:568)
fusionauth-fusionauth-1     |   at org.apache.ibatis.session.SqlSessionManager$SqlSessionInterceptor.invoke(SqlSessionManager.java:355)
fusionauth-fusionauth-1     |   at jdk.proxy2/jdk.proxy2.$Proxy99.selectOne(Unknown Source)
fusionauth-fusionauth-1     |   at org.apache.ibatis.session.SqlSessionManager.selectOne(SqlSessionManager.java:164)
fusionauth-fusionauth-1     |   at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:87)
fusionauth-fusionauth-1     |   at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:142)
fusionauth-fusionauth-1     |   at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
fusionauth-fusionauth-1     |   at jdk.proxy2/jdk.proxy2.$Proxy118.retrieveCountByCriteria(Unknown Source)
fusionauth-fusionauth-1     |   at io.fusionauth.api.service.system.DefaultApplicationReaderService.search(DefaultApplicationReaderService.java:107)
fusionauth-fusionauth-1     |   at io.fusionauth.app.action.api.application.SearchAction.search(SearchAction.java:79)
fusionauth-fusionauth-1     |   at io.fusionauth.app.action.api.BaseSearchAPIAction.post(BaseSearchAPIAction.java:56)
fusionauth-fusionauth-1     |   at jdk.internal.reflect.GeneratedMethodAccessor67.invoke(Unknown Source)
fusionauth-fusionauth-1     |   at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
fusionauth-fusionauth-1     |   at java.base/java.lang.reflect.Method.invoke(Method.java:568)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.util.ReflectionUtils.invoke(ReflectionUtils.java:443)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.action.DefaultActionInvocationWorkflow.execute(DefaultActionInvocationWorkflow.java:77)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.action.DefaultActionInvocationWorkflow.perform(DefaultActionInvocationWorkflow.java:60)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.workflow.SubWorkflowChain.continueWorkflow(SubWorkflowChain.java:50)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.message.DefaultMessageWorkflow.perform(DefaultMessageWorkflow.java:50)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.workflow.SubWorkflowChain.continueWorkflow(SubWorkflowChain.java:50)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.validation.DefaultValidationWorkflow.perform(DefaultValidationWorkflow.java:45)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.workflow.SubWorkflowChain.continueWorkflow(SubWorkflowChain.java:50)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.security.DefaultSecurityWorkflow.perform(DefaultSecurityWorkflow.java:79)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.workflow.SubWorkflowChain.continueWorkflow(SubWorkflowChain.java:50)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.parameter.DefaultPostParameterWorkflow.perform(DefaultPostParameterWorkflow.java:49)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.workflow.SubWorkflowChain.continueWorkflow(SubWorkflowChain.java:50)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.content.DefaultContentWorkflow.perform(DefaultContentWorkflow.java:74)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.workflow.SubWorkflowChain.continueWorkflow(SubWorkflowChain.java:50)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.parameter.DefaultParameterWorkflow.perform(DefaultParameterWorkflow.java:58)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.workflow.SubWorkflowChain.continueWorkflow(SubWorkflowChain.java:50)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.parameter.DefaultURIParameterWorkflow.perform(DefaultURIParameterWorkflow.java:92)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.workflow.SubWorkflowChain.continueWorkflow(SubWorkflowChain.java:50)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.scope.DefaultScopeRetrievalWorkflow.perform(DefaultScopeRetrievalWorkflow.java:50)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.workflow.SubWorkflowChain.continueWorkflow(SubWorkflowChain.java:50)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.action.DefaultActionMappingWorkflow.perform(DefaultActionMappingWorkflow.java:119)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.workflow.SubWorkflowChain.continueWorkflow(SubWorkflowChain.java:50)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.security.DefaultSavedRequestWorkflow.perform(DefaultSavedRequestWorkflow.java:65)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.workflow.SubWorkflowChain.continueWorkflow(SubWorkflowChain.java:50)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.cors.CORSRequestWorkflow.perform(CORSRequestWorkflow.java:65)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.workflow.SubWorkflowChain.continueWorkflow(SubWorkflowChain.java:50)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.workflow.DefaultMVCWorkflow.perform(DefaultMVCWorkflow.java:108)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.PrimeMVCRequestHandler.handle(PrimeMVCRequestHandler.java:73)
fusionauth-fusionauth-1     |   at io.fusionauth.http.server.HTTPWorker.run(HTTPWorker.java:50)
fusionauth-fusionauth-1     |   at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
fusionauth-fusionauth-1     |   at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
fusionauth-fusionauth-1     |   at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
fusionauth-fusionauth-1     |   at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
fusionauth-fusionauth-1     |   at java.base/java.lang.Thread.run(Thread.java:833)
fusionauth-fusionauth-1     | Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '>> '$.state' = 'Active'' at line 8
fusionauth-fusionauth-1     |   at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
fusionauth-fusionauth-1     |   at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
fusionauth-fusionauth-1     |   at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:912)
fusionauth-fusionauth-1     |   at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354)
fusionauth-fusionauth-1     |   at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
fusionauth-fusionauth-1     |   at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
fusionauth-fusionauth-1     |   at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:65)
fusionauth-fusionauth-1     |   at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:80)
fusionauth-fusionauth-1     |   at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:65)
fusionauth-fusionauth-1     |   at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:333)
fusionauth-fusionauth-1     |   at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158)
fusionauth-fusionauth-1     |   at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110)
fusionauth-fusionauth-1     |   at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90)
fusionauth-fusionauth-1     |   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154)
fusionauth-fusionauth-1     |   ... 53 common frames omitted
fusionauth-fusionauth-1     | 2024-02-13 02:47:44.565 AM ERROR io.fusionauth.app.primeframework.error.ExceptionExceptionHandler - An unhandled exception was thrown
fusionauth-fusionauth-1     | org.apache.ibatis.exceptions.PersistenceException: 
fusionauth-fusionauth-1     | ### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '>> '$.state' = 'Active'' at line 8
fusionauth-fusionauth-1     | ### The error may exist in io/fusionauth/api/domain/ApplicationMapper.xml
fusionauth-fusionauth-1     | ### The error may involve defaultParameterMap
fusionauth-fusionauth-1     | ### The error occurred while setting parameters
fusionauth-fusionauth-1     | ### SQL: SELECT COUNT(*)     FROM applications AS a      WHERE  LOWER(a.name) LIKE ?                                         AND a.data ->> '$.state' = ?
fusionauth-fusionauth-1     | ### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '>> '$.state' = 'Active'' at line 8
fusionauth-fusionauth-1     |   at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
fusionauth-fusionauth-1     |   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:156)
fusionauth-fusionauth-1     |   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
fusionauth-fusionauth-1     |   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)
fusionauth-fusionauth-1     |   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:75)
fusionauth-fusionauth-1     |   at jdk.internal.reflect.GeneratedMethodAccessor19.invoke(Unknown Source)
fusionauth-fusionauth-1     |   at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
fusionauth-fusionauth-1     |   at java.base/java.lang.reflect.Method.invoke(Method.java:568)
fusionauth-fusionauth-1     |   at org.apache.ibatis.session.SqlSessionManager$SqlSessionInterceptor.invoke(SqlSessionManager.java:355)
fusionauth-fusionauth-1     |   at jdk.proxy2/jdk.proxy2.$Proxy99.selectOne(Unknown Source)
fusionauth-fusionauth-1     |   at org.apache.ibatis.session.SqlSessionManager.selectOne(SqlSessionManager.java:164)
fusionauth-fusionauth-1     |   at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:87)
fusionauth-fusionauth-1     |   at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:142)
fusionauth-fusionauth-1     |   at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
fusionauth-fusionauth-1     |   at jdk.proxy2/jdk.proxy2.$Proxy118.retrieveCountByCriteria(Unknown Source)
fusionauth-fusionauth-1     |   at io.fusionauth.api.service.system.DefaultApplicationReaderService.search(DefaultApplicationReaderService.java:107)
fusionauth-fusionauth-1     |   at io.fusionauth.app.action.api.application.SearchAction.search(SearchAction.java:79)
fusionauth-fusionauth-1     |   at io.fusionauth.app.action.api.BaseSearchAPIAction.post(BaseSearchAPIAction.java:56)
fusionauth-fusionauth-1     |   at jdk.internal.reflect.GeneratedMethodAccessor67.invoke(Unknown Source)
fusionauth-fusionauth-1     |   at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
fusionauth-fusionauth-1     |   at java.base/java.lang.reflect.Method.invoke(Method.java:568)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.util.ReflectionUtils.invoke(ReflectionUtils.java:443)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.action.DefaultActionInvocationWorkflow.execute(DefaultActionInvocationWorkflow.java:77)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.action.DefaultActionInvocationWorkflow.perform(DefaultActionInvocationWorkflow.java:60)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.workflow.SubWorkflowChain.continueWorkflow(SubWorkflowChain.java:50)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.message.DefaultMessageWorkflow.perform(DefaultMessageWorkflow.java:50)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.workflow.SubWorkflowChain.continueWorkflow(SubWorkflowChain.java:50)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.validation.DefaultValidationWorkflow.perform(DefaultValidationWorkflow.java:45)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.workflow.SubWorkflowChain.continueWorkflow(SubWorkflowChain.java:50)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.security.DefaultSecurityWorkflow.perform(DefaultSecurityWorkflow.java:79)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.workflow.SubWorkflowChain.continueWorkflow(SubWorkflowChain.java:50)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.parameter.DefaultPostParameterWorkflow.perform(DefaultPostParameterWorkflow.java:49)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.workflow.SubWorkflowChain.continueWorkflow(SubWorkflowChain.java:50)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.content.DefaultContentWorkflow.perform(DefaultContentWorkflow.java:74)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.workflow.SubWorkflowChain.continueWorkflow(SubWorkflowChain.java:50)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.parameter.DefaultParameterWorkflow.perform(DefaultParameterWorkflow.java:58)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.workflow.SubWorkflowChain.continueWorkflow(SubWorkflowChain.java:50)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.parameter.DefaultURIParameterWorkflow.perform(DefaultURIParameterWorkflow.java:92)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.workflow.SubWorkflowChain.continueWorkflow(SubWorkflowChain.java:50)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.scope.DefaultScopeRetrievalWorkflow.perform(DefaultScopeRetrievalWorkflow.java:50)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.workflow.SubWorkflowChain.continueWorkflow(SubWorkflowChain.java:50)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.action.DefaultActionMappingWorkflow.perform(DefaultActionMappingWorkflow.java:119)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.workflow.SubWorkflowChain.continueWorkflow(SubWorkflowChain.java:50)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.security.DefaultSavedRequestWorkflow.perform(DefaultSavedRequestWorkflow.java:65)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.workflow.SubWorkflowChain.continueWorkflow(SubWorkflowChain.java:50)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.cors.CORSRequestWorkflow.perform(CORSRequestWorkflow.java:65)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.workflow.SubWorkflowChain.continueWorkflow(SubWorkflowChain.java:50)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.workflow.DefaultMVCWorkflow.perform(DefaultMVCWorkflow.java:108)
fusionauth-fusionauth-1     |   at org.primeframework.mvc.PrimeMVCRequestHandler.handle(PrimeMVCRequestHandler.java:73)
fusionauth-fusionauth-1     |   at io.fusionauth.http.server.HTTPWorker.run(HTTPWorker.java:50)
fusionauth-fusionauth-1     |   at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
fusionauth-fusionauth-1     |   at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
fusionauth-fusionauth-1     |   at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
fusionauth-fusionauth-1     |   at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
fusionauth-fusionauth-1     |   at java.base/java.lang.Thread.run(Thread.java:833)
fusionauth-fusionauth-1     | Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '>> '$.state' = 'Active'' at line 8
fusionauth-fusionauth-1     |   at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
fusionauth-fusionauth-1     |   at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
fusionauth-fusionauth-1     |   at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:912)
fusionauth-fusionauth-1     |   at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354)
fusionauth-fusionauth-1     |   at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
fusionauth-fusionauth-1     |   at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
fusionauth-fusionauth-1     |   at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:65)
fusionauth-fusionauth-1     |   at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:80)
fusionauth-fusionauth-1     |   at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:65)
fusionauth-fusionauth-1     |   at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:333)
fusionauth-fusionauth-1     |   at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158)
fusionauth-fusionauth-1     |   at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110)
fusionauth-fusionauth-1     |   at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90)
fusionauth-fusionauth-1     |   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154)
fusionauth-fusionauth-1     |   ... 53 common frames omitted

      I think this because - in a.data ->> '$.state' = ?.
      Any way to fix this?

      posted in Comments & Feedback
      T
      traperwaze