Announcement

Collapse
No announcement yet.

createcontext fails with 'configdb.filestore.max_context' isn't in GROUP BY

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • createcontext fails with 'configdb.filestore.max_context' isn't in GROUP BY

    Hi,

    I'm following installation of OX7 under CentOS7 with MariaDB 10.2 (https://oxpedia.org/wiki/index.php?t..._configuration).

    Everything goes fine (except I had to disable SELinux), but I'm currently failing in creating the default context.

    The createcontext command gives the following output.
    Code:
    context 1 could not be created: 
    Server response:
     com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 'configdb.filestore.max_context' isn't in GROUP BY
    	at com.openexchange.admin.storage.mysqlStorage.OXUtilMySQLStorage.findFilestoreForEntity(OXUtilMySQLStorage.java:1925)
    	at com.openexchange.admin.storage.mysqlStorage.OXUtilMySQLStorage.findFilestoreForContext(OXUtilMySQLStorage.java:1784)
    	at com.openexchange.admin.storage.mysqlStorage.OXContextMySQLStorage.create(OXContextMySQLStorage.java:1558)
    	at com.openexchange.admin.rmi.impl.OXContext.createmaincall(OXContext.java:1236)
    	at com.openexchange.admin.rmi.impl.OXContextCommonImpl.createcommon(OXContextCommonImpl.java:179)
    	at com.openexchange.admin.rmi.impl.OXContext.create(OXContext.java:453)
    	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 sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:357)
    	at sun.rmi.transport.Transport$1.run(Transport.java:200)
    	at sun.rmi.transport.Transport$1.run(Transport.java:197)
    	at java.security.AccessController.doPrivileged(Native Method)
    	at sun.rmi.transport.Transport.serviceCall(Transport.java:196)
    	at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:573)
    	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:834)
    	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$0(TCPTransport.java:688)
    	at java.security.AccessController.doPrivileged(Native Method)
    	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:687)
    	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    	at java.lang.Thread.run(Thread.java:748)
    	at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(StreamRemoteCall.java:283)
    	at sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:260)
    	at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:161)
    	at java.rmi.server.RemoteObjectInvocationHandler.invokeRemoteMethod(RemoteObjectInvocationHandler.java:227)
    	at java.rmi.server.RemoteObjectInvocationHandler.invoke(RemoteObjectInvocationHandler.java:179)
    	at com.sun.proxy.$Proxy0.create(Unknown Source)
    	at com.openexchange.admin.console.context.Create.maincall(Create.java:143)
    	at com.openexchange.admin.console.context.CreateCore.commonfunctions(CreateCore.java:147)
    	at com.openexchange.admin.console.context.Create.<init>(Create.java:80)
    	at com.openexchange.admin.console.context.Create.main(Create.java:84)

  • #2
    SOLVED

    After reading the installation manual again, I found the problem. I did not adapt the proper entry for "sql_mode" in tunings.cnf. I left a "ONLY_FULL_GROUP_BY" value in there...
    Now I can create the context!

    Comment

    Working...
    X