Can't Load Pics or Access File Manager
Anytime I want to edit, I can sign in, hit "edit page" and even get the dialog box to open up as if to change the content, add a file or image etc., but when I click on "add a file or image" I get the error message below. Same when I try to go to file manager. I can change text with no problem though.
This is the error message I get:
mysql error: [3065: Expression #1 of ORDER BY clause is not in SELECT list, references column 'db63126_aps79.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 ")
I tried updating and when I try to go higher than the 220.127.116.11, my website goes down.
I have cleared the cache, and tried different browsers and computers. Nothing changes.
Also, you should be able to upgrade using the Manual Upgrade methods described here -https://legacy-documentation.concrete5.org/tutorials/manually-upgrad... but you will need to upgrade first to 5.6.3 and then to 18.104.22.168, not just jump directly to 22.214.171.124
You can download in-between versions here -http://www.concrete5.org/developers/developer-downloads/...
Also what version of PHP are you using?