Kopano-Core MySQL-Error when opening addressbook after adding users and groups
-
Good Morning,
I have installed Kopano 8.7.80.27 on Ubuntu 16.04, amd64.
Everything was running fine, I had created two test-accounts and groups which were visible in my addressbook.
Then I added some more users and groups.
Now I see this error, when opening up the addressbook: “Could not load contents of this folder” and I have the following mysql-error in my logfile. Can anybody help me? Did I mess up something or is this a bug?Mon Nov 12 07:55:44 2018: [error ] KDatabase::DoSelect(): query failed: "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 ') ORDER BY o.externid, op.orderid' at line 1", query: SELECT op.propname, op.value, o.externid, o.objectclass FROM object AS o JOIN objectmvproperty AS op ON op.objectid=o.id WHERE () ORDER BY o.externid, op.orderid Mon Nov 12 07:55:44 2018: [warning] K-1501: Unable to retrieve details from external user source: db_query: Unknown error -2147483641This Code seems to be part of kopanocore/provider/plugins/DBBase.cpp
Thank you!
Best,
Jonas -
I have now executed “kopano-cli --purge-softdelete=5” and suddenly it worked again.
If I add some more users now, the address book does not work any longer - but when I execute kopano-cli --purge-softdelete=5 again, it works again.
This is really strange. Can anybody help? -
