Okay, was definitely to do with the only_full_group_by setting.
I removed it using:
SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
However this resets with every SQL restart, any idea how to make it permanent?
So now my windows laptop can fully access the NFS shares and the MySQL DB.
Having issues getting my AFTVs to access the DB though, they access NFS fine as I can play files, I'll post a log when I get back. I'll also do my OpenELEC box tonight too.
This was all so much easier using windows server! Haha.
edit:
Okay, just read here (
http://forum.kodi.tv/showthread.php?tid=247907) that I can add;
sql-mode="STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
To my .cnf which should sort it out at start up, will test later.