SrPeter Do you know if your host uses MariaDB? Found some reference to your error in this Github Issue flarum/core1211
Though, it seems if you host does use MariaDB 10+ you are stuck waiting for Beta 8 :/
Maybe someone else can confirm or prove me wrong