Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take survey.
98 votes

Getting this SQL Error: GROUP BY incompatible with sql_mode=only_full_group_by

MySQL 5.7.5+ changed the way GROUP BY behaved in order to be SQL99 compliant (where in previous versions it was not). There is a good overview of the changes here. Unfortunately, this affects some ...
user avatar
  • 66.4k
41 votes

Getting this SQL Error: GROUP BY incompatible with sql_mode=only_full_group_by

Updated 05/03/16: I had a struggle getting this to work with Homestead 5.2. The MySQL error everyone else is seeing, as well as mcrypt error, as mycrypt is not installed by default in Vagrant box ...
user avatar
  • 865
19 votes

Getting this SQL Error: GROUP BY incompatible with sql_mode=only_full_group_by

To fix this I have created a .my.cnf in my home-directory with the following content: [mysqld] sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,...
user avatar
16 votes

Craft CLI RC1 Connectivity Issues with MAMP Pro

I gave everything a try, but the only thing that worked for me was ensuring "Allow network access to MySQL" was ticked in MAMP. Screenshot: http://c42.co/Ur30EJ
user avatar
14 votes
Accepted

500 error on installation since version 2.3

I might be shooting in the sky, but make sure that in your in your .htaccess you have RewriteBase / after RewriteEngine On
user avatar
14 votes
Accepted

Craft CLI RC1 Connectivity Issues with MAMP Pro

After playing with this a little further it seems the unixSocket setting is necessary to get this working so I added: 'unixSocket' => getenv('DB_SOCKET') To config/db.php and then added: ...
user avatar
  • 1,022
11 votes

Getting this SQL Error: GROUP BY incompatible with sql_mode=only_full_group_by

For UBUNTU 16.04 LTS commands: cd /etc/mysql sudo nano my.cnf add these two lines: [mysqld] sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,...
user avatar
9 votes
Accepted

HTTP 503 – Service Unavailable – craft\web\ServiceUnavailableHttpException [installation]

Very likely it cannot connect to the database; that's typically what the 503 error is about: https://httpstatuses.com/503 ...so check the credentials in your .env file, and make sure that the ...
user avatar
  • 10.9k
8 votes

Getting this SQL Error: GROUP BY incompatible with sql_mode=only_full_group_by

We have the same problem. MySQL version (Ver 14.14 Distrib 5.7.9, for osx10.11 (x86_64) using EditLine wrapper) Had problems SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1055 ...
user avatar
7 votes

HTTP 503 – Service Unavailable – craft\web\ServiceUnavailableHttpException [installation]

If you've just imported a database, it could mean your project.yaml is out of sync in your environment. I fixed this by running the CLI command: ./craft project-config/sync
user avatar
  • 71
6 votes

Getting this SQL Error: GROUP BY incompatible with sql_mode=only_full_group_by

Here are some fairly specific instructions if you happen to be hosted on a server configured through ServerPilot. https://serverpilot.io/community/articles/how-to-disable-strict-mode-in-mysql-5-7....
user avatar
5 votes

How can I populate some records after my plugin is installed?

On the main MyPluginPlugin class, there is a method you can override called onAfterInstall(). Which will run after your plugin is installed. To create those records, you can place the following code ...
user avatar
5 votes
Accepted

Site is "Temporarily Unavailable"

Others have said what the problem is, but in the interest of clarity for future readers... Cause: The database is expecting a newer version of Craft's filesystem than you have. Solution: Replace the ...
user avatar
  • 3,084
5 votes

Craft 3 Command setup failing

I was just confronted with this too. You most likely need to specify the unixSocket attribute for the MAMP Pro database. Take a look at my problem and solution at Craft CLI RC1 Connectivity Issues ...
user avatar
  • 1,022
5 votes
Accepted

Development – deployment environment

So the way I'd recommend doing it is that you use .gitignore to exclude your /vendor directory from the repo; a good starter .gitignore file can be found here: https://github.com/nystudio107/craft-...
user avatar
  • 10.9k
5 votes
Accepted

Set up Craft 3 when the craft folder is above public_html on shared hosting

Finally figured out how to edit this index.php file if you're not able to point your document root to the web folder, or if you are forced to put craft in the folder private_html that shared hosters ...
user avatar
  • 1,032
4 votes
Accepted

Title vs Heading in Fresh Install?

The short answer is, we should probably update that :) The long answer is: The homepage is a “Single” section, and originally, Singles couldn’t have dynamic Title fields like Channel and Structure ...
user avatar
4 votes

File robots.txt needed in Craft package?

The specific directive to disallow the /craft/ directory isn't necessary if your craft folder is below the webroot. However, it's good practice to have a robots.txt for each site, so I don't ...
user avatar
  • 3,390
4 votes

500 error on installation since version 2.3

In case it helps someone, my issue was the permissions for the root index.php file...It was 666 (writeable by group) and when I switched that file permissions to 644, the installation was able to move ...
user avatar
  • 61
4 votes

Getting this SQL Error: GROUP BY incompatible with sql_mode=only_full_group_by

MySQL 5.7.5+ changed the way GROUP BY behaved in order to be SQL99 compliant (where in previous versions it was not). Either modify the existing mysql queries to be compatible to the new mysql version ...
user avatar
4 votes

Getting this SQL Error: GROUP BY incompatible with sql_mode=only_full_group_by

The proper fixes have already been answered here; but I'd like to note that another fix is to use MariaDB instead of MySQL. It's a drop-in replacement for it, it's more performant for a number of ...
user avatar
  • 10.9k
4 votes
Accepted

Craft CMS Shows 404 Error on Admin Pages

Goodness, I figured out what was going on here. The cpTrigger had been changed from admin to a different name in the craft/config/general file. [Facepalm]
user avatar
  • 659
4 votes
Accepted

Installing Craft without MAMP

It depends what you are most comfortable with. PHP and Apache are shipped with macOS by standard but you'd still need to install and configure MySQL (or MariaDB etc), along with manual virtual host ...
user avatar
  • 584
4 votes

Can I use an IP address instead of a FQDN?

First, I can positively confirm I have Craft running on two not hosted, local servers - one a Ubuntu 14.04 (well, Mint) installation, and one a Windows box using Uniserver. Not sure quite what you're ...
user avatar
4 votes
Accepted

Having issues with Craft install on Laravel Valet.

Talked with Justin via DM on the Craft Slack. As per that discussion, here was the solution: The Valet docs are extremely misleading. When detailing how to use the park command, they list running ...
user avatar
4 votes

Craft 3 Command setup failing

Nothing worked mentioned here. But after these steps Enable "Allow network access to MySQL" -> "only from this Mac" Save Restart It worked!
user avatar
3 votes

Getting this SQL Error: GROUP BY incompatible with sql_mode=only_full_group_by

I faced this problem when I upgraded MySQL to version >= 5.7.5 and I'v fixed it by following these steps: SSH into your server. Add sql-mode="" to your MySQL config: echo -e '[mysqld]\nsql-mode=""' |...
user avatar
3 votes

Unix permissions for Craft

I'm not sure if this helps, but here is how I (attempt) to manage deployments/installs. I first create a user so I'm not using the root account. I tie that user to the apache user group. We'll call ...
user avatar
  • 4,696
3 votes
Accepted

File robots.txt needed in Craft package?

I think it's there to protect those who can't have craft/ below web root. In your case it can't be found by search engines, so you can delete it.
user avatar
  • 35.8k
3 votes

Can't install Craft on a GoDaddy shared hosting server

Thanks for the advice guys. It's helped me rule out the directories being an issue (sort of). Turns out that I was able to access the files in the craft directory all along. My issue related to the ...
user avatar
  • 2,265

Only top scored, non community-wiki answers of a minimum length are eligible