Author Archives: Robert

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 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

Stop Annoying favicon.ico 404 errors

If you’re like me, you don’t like cluttering your main folder with unnecessary files. This is why I hate that some browsers are still looking for ‘favicon.ico’ in the main folder even when you indicate in <head> that’s not where the agent should be looking…

Here is a way to eliminate those PITA 404’s from your error logs… 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

OpenCart Option Value Limits (imposed by server)

If you’re like me you have an OpenCart site with thousands of possible option values for individual product options. Mine resulted from a large import of data. After which, I was no longer able to remove or add more option values (eg: too many fields in the form).

Many people think this is a limitation of OpenCart, which is not the case… the issue resides in your server’s PHP configuration. Specifically with PHP’s max_input_vars and post_max_size directives. Continue reading

New Open Cart 2.0 Module: Allowed by Country, State / Region or Geo Zone

This new access-restriction module is intended to allow only visitors from desired regions access to your storefront.

Now, if you want to block a specific country or zone, try our zone blocking module instead.

Both modules are limited to 1,000 unique IP requests per day or less. We have taken measures to ensure unnecessary geo-location requests do not occur for the same IP/browser-session. Once geo data has been obtained, it will not be checked again for the same browser/device for 30 days.

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