Technology Insights

Change the Table Prefix of WordPress Blog MySQL Database from wp_

The directions below will provide simple instructions on changing the prefix to your WordPress blog’s MySQL database from wp_ to whatever you choose. Its a good idea to change this prefix to prevent zero-day SQL injection attacks from being performed against your WordPress installation since your database tables will be known to everyone if you use the default prefix. So follow the below directions to make the change that should only cause minimal downtime if the steps are followed properly.

  1. MySQL Database Backup:Use the CLI or backup your database from phpMyAdmin. If using phpMyAdmin use the export feature to export a SQL version of your database and download it to the PC you are working on. Your backup should be something similar to mydb_DATE.sql.
Details
Technology Insights

Install a Ruby Gem From Your Local Linux Server

Installing a gem locally is extremelly easy if you follow the steps below. I was recently in a situation where I had to upgrade a gem quickly to resolve a bug but the latest version of the gem located on http://gems.rubyforge.org was older than what was necessary. You need to locate the .gem file for the gem that needs to be installed and get a copy on the local server. In my case I happened to have a gem server that had ben installed but the web access was down at the moment so I SCP’d (secure copy) it to the local server and placed it in /usr/local/src.

Once you have the gem moved onto the local server issue the below command to install.

Details
Technology Insights

Remove the Website Field For Comment Posting on WordPress Using Mandingo Theme

In an attempt to promote as much community as possible I would suggest removing the Website field for when people post comments to your WordPress blog. In this scenario below the Mandingo Theme is being used however it is just as easy to remove the Website field from the default field as well. If people still want to post their web site when making a comment they can do so in the body of the comment.

If you are using the Mandingo Theme then you will need to modify two files but if using the default WordPress Theme you should only need to modify one file. The lines to remove should be the same or very similar no matter what Theme you are using.

In Mandingo follow the below directions to remove the Website field from the comments form when people are not logged in.

Details
Technology Insights

Creating remote branches from local ones in Git

I had an existing local branch that I had done some commits to and wanted to create a remote branch on origin so that I could check it out to other local branches on different machines. The current version of Git (1.6.1.x at the time of this writing), doesn’t seem to have an elegant way of doing this, but still I was able to do it fairly simply by manually editing Git’s “config” file (inside of the “.git” folder of a working directory).

Details
Technology Errors

Business Objects gives error “class com.businessobjects.wp.tc.TCMain not found”

When upgrading from SAP Business Objects XI R2 service pack 1 to service pack 2, I got the following error in the Java runtime console when trying to create new or use existing Web Intelligence reports: load: class com.businessobjects.wp.tc.TCMain not found. java.lang.ClassNotFoundException: com.businessobjects.wp.tc.TCMain at sun.applet.AppletClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.applet.AppletClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source)…

Details