Linked Questions

0
votes
1answer
248 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 ...
8
votes
3answers
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" ...
1
vote
2answers
1k 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 ...
1
vote
1answer
599 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 ...
1
vote
1answer
812 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....
1
vote
1answer
196 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 ...
2
votes
1answer
353 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 ...
1
vote
1answer
546 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]: ...
1
vote
1answer
153 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 ...
2
votes
1answer
131 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) ...
1
vote
1answer
75 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 ...
1
vote
1answer
26 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 ...