Upgrading a Linksys WRT54G v5 wireless router is a bit more complicated than most of the other Linksys WRT54G wireless routers. It is not as easy as downloading a dd-wrt .bin file and uploading it via the router administration GUI. Instead you must first install some other bin files to wipe the wireless router clean…
Its really easy to configure ZenCart to show the credit cards that you are going to accept to customers during their checkout. Not only could you display the text of these images similar to the below example but its also very easy to display images of the credit card types you will be accepting. Example:…
Zencart has four default order status types which are Pending(1), Processing(2), Delivered(3), and Update(4). The number in parenthesis represents the order in which the order type will be located in the drop down so by default the first type in the drop down is Pending. To add a new order status type login to the…
Backing up and restoring PostgreSQL is fairly easy using pg_dump and psql. One more complicated scenario I have run into is doing a complete database backup with pg_dump and at some point down the road needing to just split out one table and restore it. This can be a pain because of how the pg_dump…
The pg_stat_activity table will show you what activity is currently happening on your PostgreSQL database server. The information will detail the database the activity is occuring on, the username initiating the activity, the length of time the acitivy has been occuring for, and much more. Below is example output from running a SELECT query against…
The Linux kill command is used to kill PID’s or process ID’s. This command is beneficial for numerous reasons typically for run away processes, processes caught in some sort of loop, to kick users from a system, or any other number of reasons. Typically kill is used in the below format with 12345 being the…
If you are having issues dropping a postgres database the issue is more than likely that a user is accessing the database you are attempting to drop. There isn’t technically a way to force drop the postgres database however there are steps you can take to prevent others from accessing the database and if needed…
This post will explain how to post notes from Microsoft OneNote into the WordPress admin. When you copy and paste from most Microsoft products into a visual editor such as TinyMCE that WordPress uses you will typically include a bunch of unwanted tags from the Microsoft application. These tags will make it complicated to format…
This issue came up the other day when explaining to someone how to format articles properly so they are uniform. The WordPress installation I am talking about has the TinyMCE plugin installed which basically takes the default visual editor tool bar and expands it by allowing you to add a lot more options. They wanted…