Hi Lee,
you should contact your service provider asking for what kind of permission your MySQL account is running with.
HTH,
Matteo
Thanks for this, will keep you posted. I can't identify from the above which exact files are causing issues so that I can manually change the permissions?
Hi Lee,
it's not a file permission issue but a database user permission issue: ask for the complete list of permissions granted to your database user on that Moodle instance database => expected: you can't create temporary tables.
HTH,
Matteo
Thanks for this, all sorted!