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, …
To install the Microsoft SQL server under Debian 11 we have to use some small tricks. However, the installation is quite possible. If you have problems with the following steps – especially with securing the server – I can offer you my services at reasonable hourly rates (to the contact form). This article contains protected …
I took some time again and worked on a script for hourly MySQL/MariaDB database backups. The script is based on the PHP programming language and can therefore be used for almost all web applications (including the JTL store, of course). Additionally, the script has already been optimized for WordPress and Gambio. Update: With the PHP …
Your MariaDB server does not start? Then you should switch to recovery mode and backup your databases. For this you should first switch off nginx and Apache: We open the MariaDB configuration file with and add the following settings under “[mysqld]”: To be on the safe side, we can also make a backup of the …
Under certain circumstances, it could happen that your web server is no longer accessible and the browser displays the error code 502. This error occurs especially with Shopware. If a look into the logs of the web server shows you the error Do I have a quick solution to fix the problem. Open the nginx …