Lars Bilke
  • Member for 7 years, 7 months
  • Last seen more than 1 year ago
Getting this SQL Error: GROUP BY incompatible with sql_mode=only_full_group_by
19 votes

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,...

View answer
299US$ Upgrade for Pro is for 1 site or any domain with my License
Accepted answer
5 votes

It is per domain (excluding sub-domains), i.e. for one domain / website. domain.com and subdomain.domain.com can both run off of the same license. More info on how that is all enforced.

View answer
How to serve Craft with Caddy server
Accepted answer
4 votes

For local development the Caddyfile looks like this (assuming that php-fpm runs on port 9000, you may have to adapt root to point to your web root relative to the location of the Caddyfile): ...

View answer
Craft constantly logging out from admin area
4 votes

These are the steps that solved the problem for me (PHP 5.4 , Nginx): Delete the contents of craft/storage/runtime Set the correct file permissions Added 'overridePhpSessionLocation' => true, to ...

View answer
Multi-environment database config being ignored
2 votes

'localhost' is simply not recognized when using as a domain-specific db config block. You have to use the general '*'-block when serving your site via http://localhost/

View answer
How to display a tree view of all assets?
Accepted answer
1 votes

I have created the Assets Browser Plugin which allows to browse an asset source or a specific folder on the frontend. Although it is not a treeview it serves me well for outputting a download area on ...

View answer
Is it possible to have secure (private) assets?
Accepted answer
1 votes

There is now the Internal Assets Plugin which allows to place assets above the web root and works as expected.

View answer
Plugins wish list
1 votes

Private asset sources, see Dukt Safe Link

View answer
Obfuscation of an asset's file path?
0 votes

You can use the Internal Assets Plugin to have assets above your web root.

View answer
Craft Pro Adding Users no email is sent
0 votes

I had similar problem with some german email providers (web.de, gmx). PHP-Mail and Sendmail failed but the solution for me was to use a smtp server in the email configs of Craft.

View answer