Can't Load Pics or Access File Manager

Permalink
Hi, It has only been in the last 2 months i have not been able to fully edit a website I am in charge of for a non profit org. (http://curlyrescue.com)
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 5.6.0.2, my website goes down.

I have cleared the cache, and tried different browsers and computers. Nothing changes.

Any suggestions?

View Replies:
hutman replied on at Permalink Reply
hutman
Did your server recently update to MySQL 5.7? This appears to be an issue with that version's rules.

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 5.6.3.5, not just jump directly to 5.6.3.5

You can download in-between versions here -http://www.concrete5.org/developers/developer-downloads/...
deedeec replied on at Permalink Reply
I don't know if my host is using that version. Are there any developers that could help me do this and get it fixed?
hutman replied on at Permalink Reply
hutman
I can help you. I'll send you a PM.
mnakalay replied on at Permalink Reply
mnakalay
When you go to your file manager and see your list of files, is the column showing the date the files were added visible? If not ; can you click on "advanced search" at the top then on "customize results" then make sure "Added" is checked. Save, and see if it makes any difference.

Also what version of PHP are you using?
deedeec replied on at Permalink Reply
I can go to the file manager through my host site. And yes, I can see the date. I have no idea what version of php I am using. How do I know?
mnakalay replied on at Permalink Reply
mnakalay
@hutman seems to know something I don't know so I suggest you PM him first so he can check your install and if that doesn't do it we can try to look elsewhere