WP CLI Error: Error establishing a database connection.

Appearance: Issue commands via WP CLI, but WordPress in the browser works. This error often occurs when the WP CL interpreter cannot correctly interpret the database connection in wp-config.php.

Solution:

In 99% of all cases, change the value of the DB_HOST constant from "localhost" to "127.0.0.1".

Background: "localhost" is not a fixed IP address. The system now has several options for interpretation. In some cases, "localhost" is interpreted as an alias for a socket connection instead of the TCP network protocol. The socket connection does not work via the command line.

See also

More techdoks and snippets

Tag filter

Ternary Operator ?: versus Null Coalescing Operator ?? versus Null Coalescing Assignment Operator ??= explained by cats

In short, PHP provides two useful operators to simplify condition checks: the ternary operator (?:) and the null coalescing operator (??). Both operators are used to tighten up the code and improve readability, but...

Shortcode E-Mail Obfuscator

The following shortcode snippet is useful for disguising emails to protect them from SPAM. Please note that this method only works if Javascript is activated. In addition, there is no 100%igen protection against bots,...

TranslatePress renders individual language selector for default language incorrectly

Problem When creating a customised language selector for TranslatePress, $arr returns a multidimensional array with all necessary parameters to render a customised language selector within a loop. In the frontend, however, when activating the language...

How to search only for specific content types with the Elementor search form?

Elementor Pro has a widget called "Search form". This is suitable for the attractive design of search forms. Unfortunately, this search form is limited in its programming. Question: How can you modify the Elementor search form so that you can...

Elementor posts widget fill with ACF relationship field

With the posts widget in Elementor, you can easily display other posts, pages, products or custom post types (CPT) (= user-defined content types) on a page in a loop. Then it gets tricky...

Elementor popup / flyout menu no longer closes for mobile view

Elementor: Version 3.72 Behaviour: An Elementor popup opens, but no longer closes (when clicking on icon or Esc or other triggers). If you look in the source code, you will find the Javascript error message: "Elementor t.entrance_animation_duration is undefined" Cause:...

PHPStorm: Local Changelist in Git Tool disappeared

Problem: Local Change List under PHPStorm is missing in the Git Tool Solution: From time to time I had the phenomenon that the Local Changelist (the files in my version control) were not visible as tabs in the Git tool....

Variable not available in blade component

Problem: The parameter transfer of a blade attribute does not work, the variable in the component is empty. There is no error message, but the variable does not appear to have been passed. Solution: The error may lie in the usage...

Tailwind Autocomplete with PHPStorm (WebStorm) does not work

Problem: If you are creating a Laravel app, for example, and are wondering why PHPStorm or WebStorm is not performing autocompletion for your CSS classes in blade templates or HTML files, it is most likely due to the fact that the...

Convert Px to SEM / EM very quickly with Alfred

There is a wonderful Alfred workflow on the Mac that converts Px to Rem: Download direct link: https://raw.githubusercontent.com/vitorgalvao/requested-alfred-workflows/master/Workflows/PxRemEm.alfredworkflow Simply install, then type CMD-Space: Alfred Bar "pxrem" and enter the number in pixels. The conversion to REM will...

A Git tutorial that makes it easy to understand GIT.

A documentation of GIT version control that can be grasped very quickly through visualisation: http://marklodato.github.io/visual-git-guide/index-en.html  

Setting up XDebug with PHPStorm and Valet Development Environment

Preparation: Homebrew should be installed Valet should be installed and running: https://laravel.com/docs/7.x/valet Browser extension for PHPSTORM should be installed: https://www.jetbrains.com/help/phpstorm/browser-debugging-extensions.html gerry@webgarten ~ % brew install pecl gerry@webgarten ~ % pecl install xdebug In case of error message: Warning:...

Installing Redmine on Ubuntu Linux (LAMP stack), all steps in the console

Installation of redmine on Ubuntu Linux system. All steps from the history. Wherever "ERROR" appears, additional installation steps were necessary.

Shortcode for a copyright sign with current year date

This shortcode writes the copyright sign with the current year and other info. Useful for the footer of a website.