software errors / problem solutions

Case sensitive search in phpMyAdmin

Posted by Alex On February 12, 2024

Table of contents 1. Case sensitive search in phpMyAdmin 2. How to create a request with “BINARY” in phpMyAdmin 3. How can I make SQL case sensitive string search in phpMyAdmin 4. Video on how to find a case-sensitive string in phpMyAdmin Case sensitive search in phpMyAdmin Let’s try to find rows in the table that contain the word “test”....

Case sensitive search in MySQL/MariaDB

Posted by Alex On February 12, 2024

Table of contents 1. MySQL/MariaDB search for strings not case sensitive 2. How to make search case sensitive in MySQL/MariaDB 3. Why do MySQL/MariaDB look for strings that are not case sensitive? 4. Why does adding “BINARY” make string searches case sensitive? 5. It is correct to put “BINARY” before the search string or before the column name 6. Optimizing...

Menu buttons (toolbar) and status bar are missing in SMPlayer (SOLVED)

Posted by Alex On February 10, 2024

SMPlayer is a popular cross-platform video player. SMPlayer has many useful functions (crop video to fit the screen, fine-tune the appearance and location of subtitles, select the number of audio output channels) and many other settings, including those related to performance optimization and hardware acceleration of video decoding. Separately, I would like to note such a function as saving playback...

Error “ModuleNotFoundError: No module named ‘manimpango’” (SOLVED)

Posted by Alex On September 25, 2023

When starting one of the programs the following error occurred: Traceback (most recent call last): File "/usr/bin/emote", line 33, in <module> sys.exit(load_entry_point('Emote==0.0.0', 'gui_scripts', 'emote')()) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/bin/emote", line 25, in importlib_load_entry_point return next(matches).load() ^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3.11/importlib/metadata/__init__.py", line 202, in load module = import_module(match.group('module')) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/lib/python3.11/importlib/__init__.py", line 126, in import_module return _bootstrap._gcd_import(name[level:], package, level) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "<frozen importlib._bootstrap>", line 1206,...

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

Posted by Alex On September 24, 2023

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 course, even before installing them),...

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

Posted by Alex On September 24, 2023

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 is completely occupied. The problem...

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

Posted by Alex On September 6, 2023

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 satisfied with the functionality of...

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

Posted by Alex On September 6, 2023

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 = $mysqli->query($query); while ($row =...

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

Posted by Alex On September 3, 2023

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 you about at least 5...

How to fix Linux booting to black screen (SOLVED)

Posted by Alex On August 27, 2023

Pretty harmless video card settings (for example, installing drivers, choosing a video card for video output on a laptop, enabling 10-bit color depth) can lead to a serious problem for beginners: the Linux operating system boots into a black screen. Since this problem cannot be solved by the usual methods in the graphical interface, novice Linux users often come to...