new server - old sites won't work properly...
The new server is a WHM CentOS 6.10 runnunbg cPanel v80.0.13 (if that helps)
I uploaded all of the files for a site and eventually got it all running after rolling back the php version to 5.6. At this point I was very happy and I decided to the same for all the other sites...
However, I went into File Manager to upload anew image and it was broken. The error message was as follows:
mysqlt error: [3065: Expression #1 of ORDER BY clause is not in SELECT list, references column 'drillitl_db.f.fDateAdded' which is not in SELECT list; this is incompatible with DISTINCT] in EXECUTE("SELECT DISTINCT f.fID, u.uName as fvAuthorName FROM Files f INNER JOIN FileVersions fv ON f.fID = fv.fID LEFT JOIN Users u on u.uID = fv.fvAuthorUID left join FileSearchIndexAttributes on (fv.fID = FileSearchIndexAttributes.fID) where 1=1 and fvIsApproved = '1' order by fDateAdded desc limit 0,10 ")
Everything else on the site works fine except File Manager... They are all built with Concrete 188.8.131.52
Is this something to do with the MySql on the server? I don't know too much about back-end stuff, but it's doing my head in...
What can I do?
If you can point me in the right direction, I'd be eternally grateful
On this version, the File Manager page shows up fine, but as soon as you try to upload a file it comes up with this error:
Fatal error: Call to undefined function iconv_get_encoding() in /home/bluecustard/public_html/concrete/libraries/3rdparty/Zend/Locale/Format.php on line 310
I'm thinking it must have something to do with the MySQL version... I am very new to cPanel and it has taken me over a week to get to this point... I do not know what version of MySQL is running
Would you have any idea where I would do that within cPanel? I'm not used to this server system yet
Thanks for your help mate
"ONLY_FULL_GROUP_BY" setting within mysql needed to be turned off
Now everything works a treat
Thanks for your help ConcreteOwl :)