Linked Questions
13 questions linked to/from Getting this SQL Error: GROUP BY incompatible with sql_mode=only_full_group_by
0
votes
1
answer
265
views
Help with admin panel errors. Fresh install. Mysql version issue? [duplicate]
I get this on the admin panel:
CDbException
CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #18 of SELECT list is not in GROUP BY ...
- 23
8
votes
2
answers
3k
views
Does Craft have an installer error log I can check?
I've tried to install Craft on a variety of systems, and it seems that no matter what I try, I cannot get all the way through the installation process. In most cases, my install hangs on the "Oops" ...
- 121
1
vote
1
answer
3k
views
What is CDbException Error: SQLSTATE[42000]: Syntax error or access violation while moving a site to remote?
CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #28 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'site....
- 55
1
vote
2
answers
2k
views
Craft cannot finalise update - There was a problem updating your database
I've got an issue that following a server rebuild, I was prompted to update Craft, which I did by moving a brand new craft/app folder into place - then setting relevant permissions. I then tried to ...
- 33
1
vote
1
answer
1k
views
Migration Errors
We just started this process, and I'm having issues migrating. We have a server which we use to build up generic fields and sections, plugins, with dummy content and our developer accounts intact. The ...
- 379
2
votes
1
answer
496
views
Local DB SQL 'CDbException' Errors on Craft 2 site
Just tried to get a local site working again but getting all sorts of issues.
I have updated the website online and downloaded the database, installed locally. I have also the craft/app folder to my ...
- 343
8
votes
1
answer
938
views
Running Craft CMS 2 on MySQL 8.0+ (Any major considerations?)
Yes, that's not a typo. This is for a Craft 2 site (long story). Because MySQL 5.6 is EOL in a few weeks, I am validating how feasible it can be to run under MySQL 8.0, there's not really any option ...
- 1,191
1
vote
1
answer
263
views
Site loads funny
Finally after almost three weeks of trial and error, I have reached the promised land. Now that I am here, I notice that my site loads funny. By that I mean the following:
When going to my sites IP ...
1
vote
1
answer
801
views
What's the difference? SQL_MODE error in one site and not the other
I have 2 Craft sites that share the same Craft codebase. For both sites, i was getting the following error:
Internal Server Error CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: ...
- 176
2
votes
1
answer
461
views
Missing javascript .map files
When I view the browser console whilst viewing the Dashboard for instance, I get a whole load of 404s for Javascript .map files. For example on a fresh update to v2.3 I get this lot reported as ...
- 2,545
1
vote
1
answer
209
views
Craft Internal Server Error
I am getting the following error:
Internal Server Error
CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #34 of SELECT list is not in ...
- 131
2
votes
1
answer
185
views
Internal Server Error on Locale
This is my first multi locale Craft setup and everything is cool on my local/dev environment. However running into difficulty on the production server (Digital Ocean/ServerPilot). My default (EN) ...
- 894
1
vote
1
answer
109
views
Admin getElements 500 "unknown error"
I've duplicated a site into a new development environment, and everything works as it should other than the Entries section. It throws the AJAX-based "unknown error", originating from a 500 error on ...
- 419