MySQL: How to Count Duplicated Records
The following query can be used to count duplicated records in MySQL:
August 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…