new server - old sites won't work properly...

Permalink
Hi there, I'm having a rather frustrating time... I have a very old server which my server company will no longer support. I have got a *new* vps server and I am trying desperately to migrate website from the old to the new. It is not easy!

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 5.6.2.1

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

Rob

rc255
View Replies:
rc255 replied on at Permalink Reply
rc255
As a side note, I have 1 site which was built on Concrete 5.6.4.0 as a 'blank template'

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
ConcreteOwl replied on at Permalink Reply
ConcreteOwl
rc255 replied on at Permalink Reply
rc255
Does that imply that I need to add

extension=iconv.so

to php.ini?

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
ConcreteOwl replied on at Permalink Reply
ConcreteOwl
Tell your server admin to do it for you,,
rc255 replied on at Permalink Reply
rc255
I discovered what it was!

"ONLY_FULL_GROUP_BY" setting within mysql needed to be turned off

Now everything works a treat

Thanks for your help ConcreteOwl :)
ConcreteOwl replied on at Permalink Reply
ConcreteOwl
Your Welcome..