MySQL: How to Count Duplicated Records
The following query can be used to count duplicated records in MySQL: SELECT count(*) AS duplicate_count FROM ( SELECT column_name FROM table GROUP BY column_name HAVING COUNT(column_name) > 1 ) AS t
MySQL: How to Strip HTML Tags
The following regular expression function can be used to strip HTML tags: SELECT REGEXP_REPLACE(field, ‘<[^>]*>+’, ”) FROM table 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. $ sudo apt install libqt5multimedia5-plugins Restart Kdenlive and go to Settings => Configure Kdenlive => Capture => Audio tab. Audio device list will be shown and…
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 editorFind the following line: # Windows Alias /phpmyadmin “C:/xampp/phpMyAdmin/” <Directory “C:/xampp/phpMyAdmin”> AllowOverride AuthConfig Require local ErrorDocument 403 /error/XAMPP_FORBIDDEN.html.var </Directory> # Linux…
Ubuntu: How to Install RTL8192EU Driver
First, we install all packages required for the installation of the driver using this command: sudo apt-get install linux-headers-generic build-essential dkms git Now clone the git repository: git clone https://github.com/clnhub/rtl8192eu-linux.git Move to the new folder created: cd rtl8192eu-linux Remove current drivers (check with dkms status or sudo lshw -C network what drivers are available): sudo rmmod rtl8xxxu Blacklist the…
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 Example Let’s…
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 $ sudo apt-key list Warning: apt-key is deprecated. Manage keyring files in trusted.gpg.d instead (see apt-key(8)). /etc/apt/trusted.gpg ——————– pub rsa4096 2017-05-08 [SCEA] 1EDD E2CD FC02 5D17 F6DA 9EC0 ADAE 6AD2 8A8F 901A uid [ unknown] Sublime HQ…
Git Error When Clone Repository: chmod on config.lock failed
Cloning into ‘<repo>’… error: chmod on /mnt/c/<repo>/.git/config.lock failed: Operation not permitted fatal: could not set ‘core.filemode’ to ‘false’ 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…
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…