99
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 ...
- 67.2k
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 ...
- 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,...
- 754
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
- 321
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:
...
- 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,...
- 111
10
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 ...
- 11.4k
9
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
- 91
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 ...
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....
- 476
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 ...
- 2,336
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 ...
- 3,149
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 ...
- 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-...
- 11.4k
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 ...
- 1,062
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 ...
- 61
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 ...
- 11.4k
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 ...
- 41
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]
- 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 ...
- 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 ...
- 7,622
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 ...
- 3,011
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!
3
votes
Accepted
White screen during installation
Whenever I've had a completely white screen from Craft I've traced it to a syntax error in one of the files in craft/config, so I'd double-check your db.php and general.php if they've been edited.
- 4,391
3
votes
Twig Error Runtime Local Dev Environment
The problem is that you're using an entry variable in the layout template without it having actually been defined.
You can be defensive about it everywhere you're using it:
{% if entry is defined ...
- 67.2k
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=""' |...
- 612
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 ...
- 4,706
3
votes
Class 'Craft\DbCommand' not found
Even thought this is an old thread, I recently ran in to the same problem. It turned out to be a PHP version issue. I was running MAMP with PHP 7.0.0, once I switched that host to 5.6.10 it worked ...
- 31
3
votes
Installing Craft without MAMP
Out of the box, macOS comes with tools to run a website locally. But depending on your needs, you may find it limiting or daunting to get started.
You can Google pretty good guides for how to run a ...
- 2,622
3
votes
Accepted
Got an "Oops" Screen While in Installer, Exited to Try Again, and Now I Can't Get Back to Installer
I feel silly posting an answer to my own question, but I wanted to post the solution in case anyone else ran across this, instead of just deleting the question.
I was using the URL http: //localhost/...
- 93
Only top scored, non community-wiki answers of a minimum length are eligible