Technical Discussions

  • By fredilan
  • Posted May 10, 2018
  • In reset email, wordpress
  • 0 likes

WordPress Password Reset Link Not Displaying or Missing in Emails

A client emailed me once complaining that the Reset Email password she got from her WordPress site didn’t contain the actual link to reset her password. Turns out that the server blocks characters ‘‘ in the message which is contained in that email and appears on the link. The way to get around it is […]
0
  • By fredilan
  • Posted July 12, 2017
  • In pulseaudio, sound problem, ubuntu sound
  • 0 likes

No Sound on Ubuntu 16.04 LTS

Recently after installing and reinstalling several Desktop Managers for my Ubuntu workstation and upgrading its version, I had an issue with sound adapters not running hence no sound. There were several procedures to troubleshoot the problem, you can read further on the steps here: https://help.ubuntu.com/community/SoundTroubleshootingProcedure For me, I was able to make sound work again […]
0
  • By fredilan
  • Posted February 1, 2017
  • In git, rename branch
  • 0 likes

Renaming Local and Remote Git Branches

Here is an instruction on how to rename a branch in Git $ git branch -m old_branch new_branch # Rename branch locally $ git push origin :old_branch # Delete the old branch $ git push –set-upstream origin new_branch # Push the new branch, set local branch to track the new remote
0
  • By fredilan
  • Posted December 9, 2016
  • In deleting identical rows, MySQL, sql
  • 0 likes

Deleting rows with identical values in MySQL

Here is an SQL statement you can use to delete identical rows. In this example query below, we are deleting rows with identical column1 and column2 values. We test the ID if it is greater than the previous to leave 1 entry undeleted: DELETE FROM tableName USING tableA,tableName as tempTableA WHERE (tableA.id > tempTableA.id) AND (tableA.column1 = […]
0
  • By fredilan
  • Posted December 9, 2016
  • In centos, centos 7 language, centos language, centos language support, centos locale, korean language support, Linux, locale
  • 0 likes

Configuring CentOS7 Locale

This is how to check the current locale settings: [root@localhost ~]# localctl System Locale: LANG=en_US.UTF-8 VC Keymap: us X11 Layout: us This is how we list the available locales: [root@localhost ~]# localectl list-locales aa_DJ aa_DJ.iso88591 aa_DJ.utf8 aa_ER aa_ER.utf8 aa_ER.utf8@saaho aa_ER@saaho ... ... ... zh_TW zh_TW.big5 zh_TW.euctw zh_TW.utf8 zu_ZA zu_ZA.iso88591 zu_ZA.utf8 If we want to set locale […]
0
  • By fredilan
  • Posted September 2, 2016
  • In copy rows, MySQL
  • 0 likes

Copy Rows and Insert to Same Table

There was a need in my current project of duplicating rows and just replacing a certain value of a column. Since there were thousands of records to copy, I needed to use query to automate it. There were suggestions from several forums to copy the rows in to a temporary new table and then copy back to […]
0
  • By fredilan
  • Posted July 15, 2016
  • 0 likes

The new Vivace site

Welcome to the new Vivace site. I also have imported my blog site (Pinoy Linux Discussions) to this site, rather than maintaining 2. Feel free to browse our pages, and check out the services we offer. Of course, as an Open Source advocate, we use Open Source solutions from development to deployment of our products.
0
  • By fredilan
  • Posted August 26, 2015
  • 0 likes

Welcome to MultiPurpose

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam aliquam massa quis mauris sollicitudin commodo venenatis ligula commodo. Sed blandit convallis dignissim. Pellentesque pharetra velit eu velit elementum et convallis erat vulputate. Sed in nulla ut elit mollis posuere. Praesent a felis accumsan neque interdum molestie ut id massa. In hac habitasse platea dictumst. Nulla […]
0
  • By fredilan
  • Posted August 23, 2015
  • 0 likes

Hello world!

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam aliquam massa quis mauris sollicitudin commodo venenatis ligula commodo. Sed blandit convallis dignissim. Pellentesque pharetra velit eu velit elementum et convallis erat vulputate. Sed in nulla ut elit mollis posuere. Praesent a felis accumsan neque interdum molestie ut id massa. In hac habitasse platea dictumst. Nulla […]
1