Mahara: Site unavailable

Mahara could not connect to the application database.

* If you are using Mahara, please wait a minute and try again
* If you are the administrator, please check your database settings and make sure your database is available

The error received was:
mysqli error: [1231: Variable 'sql_mode' can't be set to the value of 'POSTGRESQL'] in EXECUTE("SET SQL_MODE='POSTGRESQL'")