Error: failed retrieving file 'community.db' (SOLVED)
Posted by Alex On March 10, 2025
Starting from March 2025, during a normal system update, for example, using the following command: sudo pacman -Syu The error may appear: error: failed retrieving file 'community.db' from mirror.cyberbits.asia : The requested URL returned error: 404 In fact, the error is not critical and you can continue the update. However, let's figure out why this […]
What do dots mean in MySQL and MariaDB SQL queries. How to refer from a table to a column in another table
Posted by Alex On March 1, 2025
Contents What do dots mean in MySQL and MariaDB SQL queries Identifier qualifiers in MySQL and MariaDB When to qualify a column name and when not to “ERROR 1046 (3D000): No database selected” / “#1046 - No database selected” even if qualified column names are used Conclusion Sources What do dots mean in MySQL and […]
Error “PHP Startup: session.sid_length INI setting is deprecated” (SOLVED)
Posted by Alex On February 13, 2025
After upgrading to PHP 8.4, you may have encountered the following error: PHP Deprecated: PHP Startup: session.sid_length INI setting is deprecated in Unknown on line 0 Deprecated: PHP Startup: session.sid_length INI setting is deprecated in Unknown on line 0 PHP Deprecated: PHP Startup: session.sid_bits_per_character INI setting is deprecated in Unknown on line 0 Deprecated: PHP […]
How to install (or remove) packages using a regular expression in pacman
Posted by Alex On January 27, 2025
How to install packages with a wildcard (or a regular expression) in pacman If you try to use wildcards in the pacman command to install multiple packages at once, you won't be able to do it. For example, I want to install all packages whose names start with “kodi-addon-” with one command. Let's try to […]
Easy way to create and convert AVIF (lossless and lossy) in Windows
Posted by Alex On January 15, 2025
Contents AVIF image format: How to create AVIF lossless and lossy and convert to JPG Why AVIF is better Examples of AVIF files Utility for converting to AVIF format and from AVIF format to other formats How to convert an image to AVIF How to convert an image from AVIF format to JPG and any […]
AVIF image format: converting between format, AVIF lossless and lossy, how to view AVIF file properties in Linux
Posted by Alex On January 15, 2025
Contents AVIF image format: How to create AVIF lossless and lossy and convert to JPG Why AVIF is better Examples of AVIF files Utility for converting to AVIF format and from AVIF format to other formats How to convert an image to AVIF How to convert an image from AVIF format to JPG and any […]
How to open AVIF files on Windows
Posted by Alex On January 11, 2025
Why AVIF is better than other formats The AVIF format is the newest and most technically advanced photo format. AVIF files take up less space than JPG and even HEIC while maintaining the same quality. AVIF will be the format that will replace HEIC (after HEIC replaces JPG). AVIF supports both high dynamic range (HDR) […]
Easy way to create and convert WebP (lossless and lossy) in Windows
Posted by Alex On January 10, 2025
Contents WebP image format: how to create WebP lossless and lossy and convert to JPG Why is WebP better Utility for converting to WebP format and from WebP format to other formats How to convert an image to WebP format How to convert an image from WebP format to JPG and any other format How […]
How to install and use ImageMagick on Windows
Posted by Alex On January 10, 2025
Contents 1. What is ImageMagick. What is ImageMagick for 2. Where to download ImageMagick for Windows. How to install ImageMagick on Windows 3. How to run ImageMagick in Windows 4. How to run ImageMagick commands in Windows 5. How to convert images with ImageMagick in Windows 6. How to reduce the size of photos in […]
WebP image format: converting between formats, WebP lossless and lossy creation and verification in Linux
Posted by Alex On January 7, 2025
Contents WebP image format: how to create WebP lossless and lossy and convert to JPG Why is WebP better Utility for converting to WebP format and from WebP format to other formats How to convert an image to WebP format How to convert an image from WebP format to JPG and any other format How […]