Fix ‘Another Update in Process’ error in WordPress

I recently stumbled upon an issue with updating WordPress.  A brand new install without content, I couldn’t see why I was facing the issue of updating WordPress.  All plugins had updated just fine, but when I went to update WordPress, I saw an ‘Internal Server Error’ message.  Trying the core update again, I was then … Continued

The easiest way to export WordPress comments into another site

Recently, during a website makeover, I began working on a new site and while developing it, new comments had been added to the live site.  As I had already made a copy of the site to work on at the start of the project, the latest comments wouldn’t have been included in my copy when … Continued

Set stored address as default for Shipping or Billing in Magento

A current project I’m working on with a client required to import 20k customers with address, contacts and profile data – a tricky task in itself. I managed it import this successfully, but noted that the addresses were set to Shipping and not Billing.  This meant that customers could not be searched or filtered from … Continued

Add new admin user in WordPress from PHPMyAdmin

Similar to another post which does the same thing in OpenCart, here’s how to add a new admin-level user to WordPress – without any access to the wp-admin area. I find this useful when I’m called in to finish off an abandoned website and have no idea what the login credentials are – I’ll simply … Continued

Add new admin user in OpenCart from PHPMyAdmin

A new client project I’m working on requires I duplicate their website, install it on my development server and work on it before transferring it back onto their server once complete. To do this, I need access to the OpenCart admin panel, but I want to keep the existing admin users where they are and … Continued

Magento: Fixing Cannot add or update a child row: a foreign key constraint fails

I’m currently completing a rather large project for a client. While I regularly make backups before installing any major extensions or conducting core work, yesterday I needed to make my first restore on this particular database. While Magento has a great tool for backups and restores, I always prefer to do it manually from either … Continued

Check WordPress Database Queries

Here’s a little snippet which I sometimes use in my footer during development. It basically checks how many db queries are made when the page loads and how long those queries took to retrieve and display. Very handy if you are performance-oriented and need to check performance of 3rd-party plugins. Once added, refresh the page … Continued