Yours problems in MySql version.
Because you use may be can't change it - I not proposed reinstall yours host. Only may be change Provider
Can you give admin access to yours site and I will try adapt MySQL request for yours site
Admin account details you can send through OrdaSoft Contact form
Thanks,
OrdaSoft team