Tips and Tricks
MySQL: How to Count Duplicated Records
The following query can be used to count duplicated records in MySQL:
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…
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…
How to Fix Let’s Encrypt ACME v1 Disabled
Let’s Encrypt is popular free SSL service. My VPS which is using Virtualmin was unable to use Let’s Encrypt and throw an error “ACME v1 disabled”. To fix this problem, execute the following line in terminal: After that, complete the register with a valid e-mail address and try to request new Let’s Encrypt certificate via…