Well that sorted it! Thanks guys for all your help, the solution - in my case:
update mysql to a new version.
MariaDB 5.5.46 -> 10.0
no further action was needed and everything works as expected.
thanks again - gotta love Discourse and the community!
Cheers