webdev | wordpress | laravel
max_allowed_packetis a MySQL variable. If you wanto to increase max_allowed_packet, you can use the SQL statement below. First step is to check the current size of max_allowed_packet: Next step is to set max_allowed_packet – in this case to 16MB: Now, max_allowed_packet has been changed. … Read more
If you use the HTML package from LaravelCollective to generate your Laravel forms, you may encounter a problem, when you use form model binding. It may occur, that your input fields remain empty. The reason may be, that you’ve copied your creation form to your edit form and copied an empty string as default parameter. … Read more
If you want to debug / log WordPress database queries, you have to enable SAVEQUERIES in wp-config.php: After enabling SAVEQUERIES, add this code to your functions.php or a plugin: This method will create a file wp-content/sql.log and log all your database queries there. … Read more
By default, the WordPress backend search searches for post titles and the post content. If you have a lot of pages, it can be hard to find the correct page when you want to link pages or insert pages to a menu. If you want to change that, so that WordPress only searches for the … Read more
The default shell when using macOS is ZSH. If you want to add a directory to the PATH variable, you can create a file named ~/.zshenv: Now, you can use this file to add a directory to the path, in this case, ~/.composer/vendor/bin will be added to the PATH: … Read more
When trying to run npm install after setting up a new laravel project, I got these error message: Solution was, to remove the XCode Command Line Tools by running this command: Here you can find the official documentation. After removing the Command Line Tools, I had to setup them again by running: Next try to … Read more
By default, Easy Digital Downloads Updater caches the result of the update check for several hours. If you want to force EDD to check for updates again, you can use this SQL statement to delete the cached result: Replace my_wp_db by your WordPress database name and customize wp_options to match your table prefix settings. … Read more
There seems to be a bug when using MySQL in combination with the latest macOS release. After some time, MySQL stops working. I discovered the problem mostly when working with WordPress and Laravel Valet. You may discover the problem when you find something similar to “MySQL server has gone away” in MySQL logs or as … Read more
If you use macOS, you may use the following SQL statement to locate your MySQL logs: The output should be something like: Now you can use tail show old and new entries in the logs: Enable Logs If your logs are disabled, you can enable them by using these SQL statements: … Read more
If you want to add some custom CSS to your WordPress backend, you can add this to your functions.php: Now, you can add a backend-style.css to your (child) theme folder and start styling your WordPress backend. … Read more
If you are using macOS and want to reset PhpStorm to its default settings, you can use these commands (run them from a terminal): These commands remove configuration (in Preferences folder), caches (in Caches folder), plugins (in Application Support folder) and logs (in Logs folder). More information can be found here. … Read more
If you want to check the used version of Twig, you can enter this line to one of your template files: Another option is to check the file vendor/twig/twig/lib/Twig/Environment.php or vendor/twig/twig/src/Environment.php, depending of the version you use. In one of the two files, a there is a version constant: … Read more
If you want to add a custom WordPress menu item by code, you can use the code below: If $menu_item_id is 0, a new menu item will be created. If you specify a specific ID instead, the menu item with this ID will be updated. Add a Page to the Menu If you want to … Read more
To update all installed homebrew packages to its current release version, simply run this command from the command line: … Read more
By default, only Administrator users have access to the Ninja Forms backend pages. If you want to grant access to users with another permission level (e.g. Editor), you can change this by adding some of the following lines to a plugin or theme. To enable access to all forms, add: Have a look at this … Read more
Get a Form In this example we get a form by its ID: Get Form Fields In this example, we get all the fields from the form with ID 1: Get Field Keys In this example, we get all the field keys for the form with ID 1: Get Submission by ID In this example, … Read more
Disable XML-RPC in WordPress WordPress XML-RPC can be used to try several thousands passwords in a short time – great for hackers using brute force attacks. To avoid this, you can disable XML-RPC by adding this line of code to your WordPress installation: This line does not disable XML-RPC completly – but it disables all … Read more
If you want to disable the MySQL validate password plugin, you can run this command from the mysql command prompt: Result should be something like this: Now, the validate password plugin should be disabled. … Read more
To check the Ubuntu version from the command line, you can use this command: Output should be something like this: In this example, Ubuntu 16.04.6 LTS is used. … Read more
In this tutorial, I will show you how to setup Xdebug in Laravel Valet with PHP 7.3 and use it with the PHPStorm IDE. Prerequisite is a working Laravel Valet setup as described here. First step is to prepade PECL: Now, install Xdebug: Restart Valet: Now, check if Xdebug is installed: The output should be … Read more