To allow large file uploads with Plesk some changes are necessary. If you use Cloudflare there is also an upload restriction directly from Cloudflare. In this case you would have to bypass Cloudflare for your own IP. We need to adjust the Apache and nginx configuration. In the example below, we assume that the file …
In the following we will install Redis, Memcache, APCU and GnuPG for Plesk. The instructions can basically be applied to any PHP version. First, of course, we need the appropriate PHP version of Plesk After that we have to install some basics Then we create the appropriate PHP modules with the following commands: For the …
The instructions on the Plesk page simply do not work and the process is far too complicated. The whole procedure can be done more easily with the following steps: I assume that you can already perform steps 1 and 2 to remove Plesk we run the command off. In fact, the removal command sometimes needs …
Shopware shows you numerous errors for “UNION ALL” and “SQLSTATE[42000]: Syntax error or access violation: 1064 memory exhausted near”? Then you probably have quite a lot of items in your online store which is pushing Shopware to its limits. First of all you can try to execute PHP with to allocate more memory: If this …
I like to work on database optimization every now and then, so I wanted to take a look at creating an INDEX for the wordpress database. In the graphic below we see the starting point: After I created an INDEX for each of the tables in the WordPress database, the result changed as follows: Of …
There can be numerous reasons for this, ranging from incorrect file permissions to incorrect path specifications to corrupt image files. To at least check the image data for integrity the package “feh” can be used: ffmpeg is executed via PHP using shell_exec, so in the next step I tried the output to a log file, …
Today I was additionally occupied with how I could create a Twitter bot for a project. Once again Python and the package tweepy are the best choice. The basic framework is quickly created with installed. For my Twitter bot I then only had to write the appropriate Python script and put it into a *.py …
WooCommerce passes the prices to Google only net. The reason for this is simply because the JSON block prepared for Google contains the net price. To prevent this we need to change the file file accordingly. For the array of type Offer there are two hits that can be adjusted as follows: This article contains …
Should you encounter the error the first step is to analyze your MariaDB log files. You can find the location of the log files with the command and then open the log. In my case this error occurred several times: The reason might be too short execution times, so we increase the maximum execution time …
Sometimes it may be necessary to allow access to a single file in a password protected directory (e.g. WordPress). This is easily possible with some additional code within the corresponding .htaccess file. For this purpose, the following code can be used as an example: The above code will output the “filei.php” file without a password, …