Skip to main content
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
Andrew Hahn's 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: ...
Tim Knight's 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,...
Juan Gabriel's user avatar
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 ...
andrew.welch's user avatar
  • 11.6k
10 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
Matt E's user avatar
  • 101
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....
Philip Jones's 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 ...
Jason McCallister's 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 ...
Matt Wilcox's user avatar
  • 3,209
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 ...
Tim Knight's 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-...
andrew.welch's user avatar
  • 11.6k
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 ...
noregt's user avatar
  • 1,062
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 ...
andrew.welch's user avatar
  • 11.6k
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 ...
glenn's user avatar
  • 61
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 ...
Ian Young's 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 ...
Jeremy Daalder's 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 ...
Jalen Davenport's user avatar
  • 3,045
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!
Trajektorijus's user avatar
3 votes
Accepted

Help with admin panel errors. Fresh install. Mysql version issue?

You need to tweak your MySQL 5.7.5+ config for it to play nicely with Craft. MySQL 5.7.5 changed the behaviour of the GROUP_BY statement, affecting some of the core Craft queries. The preferred ...
Stephen Lewis's user avatar
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/...
scoffin's user avatar
  • 93
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 ...
Alex Roper's user avatar
  • 2,642
3 votes

PHP version issue when installing Craft 3 using Composer

You are running PHP 5.6.30 on the command line (read the error message), which you can also verify with php -v. To swap the PHP, you should add the path to your preferred PHP executable to your shell’...
carlcs's user avatar
  • 36.3k
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 ...
Tom's user avatar
  • 31
3 votes
Accepted

Error on Craft 3 install

In order to install under MAMP with PHP7 we added the MAMP PHP7 path with the following command: export PATH="/Applications/MAMP/bin/php/php7.0.15/bin:$PATH" After achieving a successful Craft 3 ...
PhilR's user avatar
  • 418
3 votes

Craft CLI RC1 Connectivity Issues with MAMP Pro

Jason Mayo's strategy of changing localhost to 127.0.0.1 in .env file worked for me as well 👍🏻 (MAMP Pro v6 on Mac OS 11.4 Big Sur)
Roger Glenn's user avatar
3 votes
Accepted

Plugin Installation Error in Craft 3 / PHP Version

Usually when you see that error, Craft was composer install/update'd on one environment with say, PHP 7.2. Composer then pulls in the highest supported dependencies for that environment. The ...
Brad Bell's user avatar
  • 67.5k
3 votes
Accepted

Craft 3 upload path on webserver

Only upload the /web folder to the /public_html folder. All other folders should be one level lower so they're not publicly accessible. Personally, I'm also wondering why not everything resides in ...
tom's user avatar
  • 465
3 votes
Accepted

Automated Craft 3 installation

The command line syntax for install without user input should be: ./craft install --interactive=0 There's a great article describing just such an automated approach here.
Piaras Hoban's user avatar
3 votes
Accepted

HappyLager Demo Site Forcing 'https://' on XAMPP

The issue here is actually the use of the TLD .dev. Google now owns that extension and in Chrome (which later, other browsers including Safari and Firefox enforced) it now forces the URL to go over ...
Tim Knight's user avatar
  • 1,022
3 votes

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

For those creating a fresh install using Craft CMS Nitro and its nitro create command, don't forget to run the the Setup Wizard as a final step, as described in Step 6: Run the Setup Wizard, from the ...
Natetronn's user avatar
  • 1,375
3 votes
Accepted

Craft "Unsupported DB driver" error after resetting Windows

Found the problem. I had to remove putenv from the disabled functions in php.ini
Jim's user avatar
  • 139

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