Category Archives: General

If I don’t know where else to put something or don’t think a post warrants a new category, it will just end up here.

How to Uninstall a Program on Windows 7 (with pictures)

Most applications for Windows 7 use an installation program such as Windows Installer to install the application in the system.

Windows Installer ensures that installed programs can be easily removed from the system. Under no circumstances should you simply delete the program folder of the application. Doing so would leave numerous files and registry entries in the system, which could compromise operating system stability. Continue reading

Split fields by characters in MySQL

I have a project where the geographical coordinates for records are stored in a single field separated by a comma. While this may suit general display purposes, it eliminates the capability to search by distance.

Sample data: 34.7451738,-86.5941693

My solution was to add two new FLOAT(10, 6) fields named “lat” and “lng” to the database table. Then I ran this query to populate the two new fields with the existing “coordinates” data.

UPDATE `locations` SET `lat` = SUBSTRING_INDEX(SUBSTRING_INDEX(`coordinates`, ',', 1) , ',', -1), `lng` = SUBSTRING_INDEX(SUBSTRING_INDEX(`coordinates`, ',', 2), ',', -1);

Who doesn’t love one-liners for mass-updates in a table 😉

Modules and extensions developed for all versions of OpenCart

Module & Extension Development

Whether you need a new payment gateway, changes to existing modules or extensions, or a new extension developed from scratch… rest assured it will be developed for your version of Open Cart and guaranteed¹ to be free of programming errors.

Check out our list of commercial (and free) extensions developed for Open Cart 1.4.x, 1.5.x and 2.x. Some were created for clients upon request, while others were added simply because we noticed the need in the Open Cart community. Continue reading

AST Refurbished Computers and Internet Explorer Crashing

Just a quick heads-up for anyone who purchases AST refurbished computers (ours came from The last few we received were “Revived by AST” and each came with unexpected issues.

The first unit had memory problems. Which is still sitting here waiting (nearly two weeks) for a call-tag to be issued so we can send it back.

On 2 out of 3 so far, Internet Explorer (IE) crashed every time you tried to load most pages. This prompted a memory diagnostics check on the first one which luckily pointed to a more serious issue.

On the second one, we decided to scan memory for faults before getting to far into the initial setup (eg: installing programs). No errors, so we figured this one was probably fine. That is until we tried opening the IE browser. Same issue as the first machine.

Without a glaring memory problem this time, we had to dig further to figure out why IE keeps crashing. So I downloaded Chrome installer to flash drive and installed so I could started searching from the machine in question.

Here is how to find and fix the problem if you are encountering the same issue… Continue reading

Installing Updates for Older Adobe CS Suites

If you’re like me, every once in a while you decide to reset  your computer (format & reinstall everything). This means downloading the updates for all your (new and old) software.

Some software like Adobe Application Updates however, simply refuse to install with little or no explanation for older versions of the applications.

The cause? An internally coded expiration date. That is the only thing keeping your updates from installing. Continue reading

Disable Windows 10 Upgrades and Hide GWX (for Good)

I recently wrote a guide for removing GWX (Get Windows 10) and preventing the update from downloading again. Microsoft is however being very persistent and pushing the upgrade again via higher-priority updates.

Microsoft labeled another update (which includes the GWX.exe) as a recommended update which means most of us end up downloading it without even knowing (convenient for most, annoying for many).

The easiest way to get rid of the latest nag screen/icon is to apply the following registry patch (save text as “DisableWIN10.reg” then open the file)… Continue reading

UltraTax by Thomson Reuters Finally Working With Latest Internet Explorer

I finally decided to try again and installed the latest updates and patches for IE… with my fingers crossed, I opened UltraTax. Low and behold, it finally works as expected! I can finally roll out office-wide security updates and version upgrades for Internet Explorer. I’m not exactly sure which UltraTax update finally fixed the problem or when, but rest assured, it works now 🙂 Continue reading

Get Windows 10 (gwx.exe) Uninstall / Removal

Many are plagued by Microsoft’s shameless promotion using their own distributed adware disguised as an important Windows update. package

Many are not anxious to jump on the subscription-based software band-wagon and be forced to pay annual fees later (most don’t read that far).

Don’t be fooled by that “free upgrade” offer. It’s only free for the first year, after which you are paying as long as you continue using the software. They are giving it free for the first year to saturate the user-base thereby increasing profit margins exponentially the following years.

Follow these simple steps to remove the “Get Windows 10” task-bar icon… Continue reading