Error: failed to commit transaction (conflicting files) (SOLVED)

When performing updates on Arch Linux and derivative distributions (Manjaro, BlackArch), several checks are performed before directly installing new versions of packages: checking if all necessary dependencies are present checking if there are conflicting packages The previous two checks are performed before the installation files are downloaded. Immediately after downloading the installation files (but, of […]

ERROR 1114 (HY000) at line 19894: The table ‘en’ is full (SOLVED)

Why does the “ERROR 1114 (HY000)” occur When adding information to a database, for example, when using an “INSERT” statement, or when importing tables or databases into MySQL (MariaDB), error number 1114 may occur: ERROR 1114 (HY000) at line 19894: The table 'en' is full After the error there is an explanation: the specified table […]

How to translate subtitles into any language. Where to download subtitles for any language

Why watch movies with subtitles A movie with original dubbing, with the original voices and intonations of the actors, is usually a little better than the same movie translated and dubbed for localization. If you are learning a foreign language, then watching a film in this language is simultaneously a combination of business and pleasure […]

How to fix LibreOffice stopped starting. Resetting LibreOffice without launching (SOLVED)

LibreOffice won't start LibreOffice is a free office document editor. In terms of functions, LibreOffice is similar to MS Office, but LibreOffice is open source and this office suite works on all major operating systems, including Linux. I have been using LibreOffice extensively almost every day for several hours for many years now. I am […]

PHP Fatal error: Uncaught mysqli_sql_exception: No database selected (SOLVED)

Let's look at a small PHP code that tries to connect to a MySQL or MariaDB DBMS and execute a query with a “SELECT” statement: <?php $db_user = "root"; $db_password = ""; $mysqli = new mysqli("localhost", $db_user, $db_password); if ($mysqli->connect_errno) { printf("Somehow we failed: %s\n", $mysqli->connect_error); exit(); } $query = "SELECT * FROM TestTABLE;"; $result […]

“ERROR 1046 (3D000): No database selected” in MySQL and MariaDB (SOLVED)

How to fix “ERROR 1046 (3D000): No database selected” The error “ERROR 1046 (3D000): No database selected” occurs most often due to haste – of course, before performing actions with tables and the information stored in them, you must specify (that is, select to use) database. This simple mistake is a good reason to tell […]

How to change the command line prompt for MySQL (MariaDB)

The MySQL (MariaDB) client, when connected to a DBMS server, displays the database selected to use and the name of the DBMS (such as MariaDB or MySQL) at the default command prompt. Perhaps you want to add to this information the username, the hostname on which the MySQL (MariaDB) server is running, the port number, […]

How to determine the location and name of the MySQL (MariaDB) configuration file. How to find the group name for MySQL and MariaDB configuration files

MySQL and MariaDB config files Some useful settings that improve productivity or solve problems that have arisen should be saved in configuration files. But you may encounter a situation where some online guide recommends saving the settings to a file located in a certain directory, but in your Linux this file or even the entire […]

How to quickly clear a command line in the MySQL (MariaDB) client

How to quickly clear the MySQL (MariaDB) command line prompt When actively working with the DBMS at the command line prompt, from time to time anyone makes mistakes. For example, an invalid query expression was entered: in the wrong terminal window, or before selecting a database, or some other error. In the Linux terminal, this […]

How to enable 10-bit color depth on Linux (and whether to enable 30-bit color)

Table of contents 1. Does my monitor (TV) use 10-bit color depth 2. Why enable 10-bit color support on Linux 3. How 10-bit color support is implemented in Windows 4. How 10-bit color support is implemented in Linux 5. How to know if my monitor (TV) supports 10-bit color depth 6. How to determine the […]