MySQL: How to Count Duplicated Records
The following query can be used to count duplicated records in MySQL:
2022
Read More
MySQL: How to Strip HTML Tags
The following regular expression function can be used to strip HTML tags: It is very simple.
Kdenlive: How to Fix Audio Record Device
I unable to do audio recording in Kdenlive. Audio device does not show in Settings => Configure Kdenlive => Capture => Audio tab. To fix this issue, install libqt5multimedia5-plugins. Restart Kdenlive and go to Settings => Configure Kdenlive => Capture => Audio tab. Audio device list will be shown and audio recording can be used…
XAMPP: How to Open Phpmyadmin Access
XAMPP’s Phpmyadmin folder is forbidden as default if accessed from internet. To open access this folder we have to edit /xampp/apache/conf/extra/httpd-xampp.conf file in Windows or /opt/lampp/etc/extra/httpd-xampp.conf file in Linux. Open httpd-xampp.conf file in text editor Find the following line: Change to the following line: Restart Apache and phpmyadmin can be accessed from internet.
Ubuntu: How to Install RTL8192EU Driver
First, we install all packages required for the installation of the driver using this command: Now clone the git repository: Move to the new folder created: Remove current drivers (check with dkms status or sudo lshw -C network what drivers are available): Blacklist the current driver: And finally install the driver: Reboot or load the driver by doing sudo modprobe…
MySQL: How to Fix “Field Doesn’t Have A Default Value” Error
MySQL or MariaDB install has default value of sql mode named STRICT_TRANS_TABLES. The MySQL docs for STRICT_TRANS_TABLES state: Strict mode controls how MySQL handles input values that are invalid or missing. A value can be invalid for several reasons. For example, it might have the wrong data type for the column, or it might be…
Moving Averages and Stochastic: Simple Indicators for a Simple Trading Strategy
Strategies help traders avoid common mistakes by providing a strict and understandable analysis system. By following it, you get closer to success and understanding market patterns. Here’s a simple strategy that both beginners and professionals can use. Required indicators: Short-term moving average (50-period MA) Long-term moving average (100-period MA) Classic Stochastic (14, 3, 3) Instructions…
Ubuntu: How to Fix “Key is stored in legacy trusted.gpg keyring (/etc/apt/trusted.gpg)”
To resolve this issue, we have to export GPG key from deprecated keyring. Get list of existing keys Export the key Key BE1229CF is the last 8 digit taken from key list. The following message will appear: Now we can update our apt source file for the repository (e.g., /etc/apt/sources.list.d/microsoft.list), adding a signed-by tag: Update apt to make…
Git Error When Clone Repository: chmod on config.lock failed
Above error message shown when Git tried to clone repository in mounting file system in Linux. To solve this issue, we have to edit /etc/fstab file and change uid and guid options. My uid and guid is 1000. It can be checked from /etc/passwd file. After edit /etc/fstab file, restart the system. Now git able…
How to Create Shortcut of File or Folder in Ubuntu
For Windows user, it is very easy to create shortcut of file. Right click on the file, and choose Create Shortcut menu. For Ubuntu, we have to do a little bit effort. For example we want to create shortcut of file and put into Desktop. Open two windows of File Manager / Nautilus. One window…
- 1
- 2