Problem deleting an oxuser via soap webservice

[ox_user]

Hello,

I'm using oxappsuite v7.10.2 on a fresh debian stretch server.
We i want to manager users, i'm using SOAP webservices and have no problems with create user and change password services.

The only one which raise an error is the delete user one, with the following message :

2019-09-25T15:05:20,804+0200 ERROR [OXWorker-0000193] com.openexchange.admin.storage.mysqlStorage.OXUserMySQLStorage.delete(OXUserMySQLStorage.java:2384)                                                                                                                         
Storage Error                                                                                                                                                                                                                                                                     
 com.openexchange.database.schema=oxappsuite_5                                                                                                                                                                                                                                  
 com.openexchange.grizzly.method=POST                                                                                                                                                                                                                                             
 com.openexchange.grizzly.pathInfo=/OXUserService                                                                                                                                                                                                                                 
 com.openexchange.grizzly.queryString=<none>                                                                                                                                                                                                                                                                                   
 com.openexchange.grizzly.remoteAddress=ip                                                                                                                                                                                                                          
 com.openexchange.grizzly.remotePort=40518                                                                                                                                                                                                                                        
 com.openexchange.grizzly.requestURI=/webservices/OXUserService                                                                                                                                                                                                                   
 com.openexchange.grizzly.serverName=host                                                                                                                                                                                                                                                        
 com.openexchange.grizzly.servletPath=/webservices                                                                                                                                                                                                                                
 com.openexchange.grizzly.threadName=OXWorker-0000193                                                                                                                                                                                                                             
 com.openexchange.grizzly.userAgent=python-requests/2.8.1                                                                                                                                                                                                                         
 com.openexchange.localhost.ipAddress=ip                                                                                                                                                                                                                                                                          
 com.openexchange.localhost.version=7.10.2-Rev9                                                                                                                                                                                                                                                                                
 com.openexchange.request.trackingId=920137076-460070448                                                                                                                                                                                                                                                                       
com.openexchange.admin.rmi.exceptions.StorageException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 'oxappsuite_5.ot.type' isn't in GROUP BY                                                                                                                                                                    
        at com.openexchange.admin.storage.mysqlStorage.OXUserMySQLStorage.delete(OXUserMySQLStorage.java:2318)                                                                                                                                                                                                                 
        at com.openexchange.admin.storage.mysqlStorage.OXUserMySQLStorage.delete(OXUserMySQLStorage.java:2367)                                                                                                                                                                                                                 
        at com.openexchange.admin.rmi.impl.OXUser.delete(OXUser.java:1931)                                                               
        at com.openexchange.admin.rmi.impl.OXUser.delete(OXUser.java:1784)                                                               
        at com.openexchange.admin.soap.user.soap.OXUserServicePortTypeImpl.delete(OXUserServicePortTypeImpl.java:814)                                                                                                                                                                                                          
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)                                                                   
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)                                                                       
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)                                                               
        at java.lang.reflect.Method.invoke(Method.java:498)                                                                                                    
        at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:179)                                                          
        at org.apache.cxf.jaxws.JAXWSMethodInvoker.performInvocation(JAXWSMethodInvoker.java:66)                                                               
        at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:96)                                                                      
        at org.apache.cxf.jaxws.AbstractJAXWSMethodInvoker.invoke(AbstractJAXWSMethodInvoker.java:232)                                                         
        at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMethodInvoker.java:85)                                                                          
        at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:74)                                                                      
        at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:59)                                                       
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)                                                                             
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)                                                                                            
        at org.apache.cxf.interceptor.ServiceInvokerInterceptor$2.run(ServiceInvokerInterceptor.java:126)                                                      
        at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)                                                                   
        at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:131)                                                                                                                                                                                                              
        at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:308)                                                              
        at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)                                                        
        at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:267)                                                      
        at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:234)                                                                                                                                                                                                                    
        at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:208)                                                               
        at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:160)                                                               
        at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:216)                                                           
        at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:301)                                                                                                                                                                                                                    
        at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:220)                                                           
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:706)                                                                                        
        at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:276)                                                          
        at org.glassfish.grizzly.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:124)                                                                    
        at fr.capc.openexchange.cas.CasAbstractTicketValidationFilter.doFilter(CasAbstractTicketValidationFilter.java:209)                                                                                                                                                                                                     
        at org.glassfish.grizzly.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:114)                                                                    
        at fr.capc.openexchange.cas.CasAbstractAuthenticationFilter.doFilter(CasAbstractAuthenticationFilter.java:160)                                                                                                                                                                                                         
        at org.glassfish.grizzly.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:114)                                                                    
        at com.openexchange.http.grizzly.servletfilter.RequestReportingFilter.doFilter(RequestReportingFilter.java:138)                                                                                                                                                                                                        
        at org.glassfish.grizzly.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:114)                                                                    
        at com.openexchange.http.grizzly.servletfilter.WrappingFilter.doFilter(WrappingFilter.java:223)                                                        
        at org.glassfish.grizzly.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:114)                                                                    
        at com.openexchange.http.grizzly.service.http.OSGiAuthFilter.doFilter(OSGiAuthFilter.java:139)                                                         
        at org.glassfish.grizzly.servlet.FilterChainImpl.doFilter(FilterChainImpl.java:114)                                                                    
        at org.glassfish.grizzly.servlet.FilterChainImpl.invokeFilterChain(FilterChainImpl.java:83)                                                            
        at org.glassfish.grizzly.servlet.ServletHandler.doServletService(ServletHandler.java:202)                                                              
        at org.glassfish.grizzly.servlet.ServletHandler.service(ServletHandler.java:154)                                                                       
        at com.openexchange.http.grizzly.service.http.OSGiMainHandler.service(OSGiMainHandler.java:302)                                                        
        at org.glassfish.grizzly.http.server.HttpHandler$1.run(HttpHandler.java:200)                                                                           
        at com.openexchange.threadpool.internal.CustomThreadPoolExecutor$MDCProvidingRunnable.run(CustomThreadPoolExecutor.java:2615)                                                                                                                                                                                          
        at com.openexchange.threadpool.internal.CustomThreadPoolExecutor$Worker.runTask(CustomThreadPoolExecutor.java:841)                                                                                                                                                                                                     
        at com.openexchange.threadpool.internal.CustomThreadPoolExecutor$Worker.run(CustomThreadPoolExecutor.java:868)                                                                                                                                                                                                         
        at java.lang.Thread.run(Thread.java:748)

Do you know if this is caused by a bug or by a bad configuration of our ox??

Thanks.

Jérôme.

[Wolfgang Rosenauer]

Not really sure but what MySQL (or similar) version do you run?
GROUP BY rings a bell for the configurations requirements we have published under https://oxpedia.org/wiki/index.php?t...QL_mode_matrix

[ox_user]

Oh, i just read again that matrix and figured out the problem : i have done my mysql configuration using the example file given but i'm using mariadb 10.1.41.
When i changed the sql_mode option, the user delete works well.

Thanks for your help and sorry for my missreading

Jérôme.