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 Move a Domain Between BlueHost Accounts

Save yourself the trouble and don’t bother asking BlueHost support when you run into a problem trying to assign a domain from one BlueHost account to another. They misinformed us about more than a few aspects and the notices displayed on the page when the assignment encounters a problem is not very intuitive.

First things first: If you are using BlueHost for email and have your email program configured for IMAP, you have a bit of work ahead of you.

Continue reading How to Move a Domain Between BlueHost Accounts

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 How to Uninstall a Program on Windows 7 (with pictures)

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 Modules and extensions developed for all versions of OpenCart

AST Refurbished Computers and Internet Explorer Crashing

Just a quick heads-up for anyone who purchases AST refurbished computers (ours came from Staples.com). 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 AST Refurbished Computers and Internet Explorer Crashing

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 Installing Updates for Older Adobe CS Suites

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 Disable Windows 10 Upgrades and Hide GWX (for Good)