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?
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?
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?
I can help you. I'll send you a PM.
Huntman,
I think I have the same issue. The database was recently updated to 5.7 and now I can't access the file manager. I just get an error.
Suggestions on how to fix this?
I think I have the same issue. The database was recently updated to 5.7 and now I can't access the file manager. I just get an error.
Suggestions on how to fix this?
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?
Also what version of PHP are you using?
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?
@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
Adding a more public response here:
We've run into this issue in several cases. MySQL 5.7 puts some restrictions on grouping in queries.
To resolve it - I've edited /etc/mysql/mysql.conf.d/mysqld.cnf
and added this to the server section of the file (putting at the end of the file should be fine)
sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
This is for an Ubuntu/Debian server - so if you're using Centos or Redhat the config file might be in a different place but the sql_mode setting should do the trick.
We've run into this issue in several cases. MySQL 5.7 puts some restrictions on grouping in queries.
To resolve it - I've edited /etc/mysql/mysql.conf.d/mysqld.cnf
and added this to the server section of the file (putting at the end of the file should be fine)
sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
This is for an Ubuntu/Debian server - so if you're using Centos or Redhat the config file might be in a different place but the sql_mode setting should do the trick.
That did it
I had
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
Getting rid of "only_full_group_by" solved the problem.
Thanks much for your help (FYI I was using CENTOS)
I had
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
Getting rid of "only_full_group_by" solved the problem.
Thanks much for your help (FYI I was using CENTOS)
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/...