News & Blog

Comments Disappeared From WordPress Site

April 12th, 2015 - Posted by Steve Marks to MySQL, Web Development.
Something odd happened today; A WordPress site of ours that had been operational for many years suddenly stopped showing comments. Not only that, but when trying to submit a comment the following error was shown: “ERROR: The comment could not be saved. Please try again later.” ...

Solving Error “ERROR 1 (HY000): Can’t create/write to file ‘/tmp/#sql_9f3_0.MYI’ (Errcode: 17)”

March 31st, 2015 - Posted by Steve Marks to MySQL, PHP, Web Development.
Recently a site that we manage stopped working all of a sudden. The error being returned from the MySQL query was as follows: ERROR 1 (HY000): Can't create/write to file '/tmp/#sql_9f3_0.MYI' (Errcode: 17) The error states that a file in the ‘/tmp/’ folder can’t be writte...

Get Currently Selected MySQL Database with PHP

July 1st, 2014 - Posted by Steve Marks to MySQL, PHP, Web Development.
When debugging a PHP script, or when your site contains multiple MySQL connections, it can be useful to know which database your PHP script is currently connected to. In MySQL you can simply run the following query: SELECT DATABASE(); Pretty easy right? We can do exactly the same thing in ...
phpMyAdmin

Perform Search For String Across Entire Database in phpMyAdmin

June 16th, 2014 - Posted by Steve Marks to MySQL, Web Development.
Searching for a word or phrase within one MySQL table can be easily achieved with an SQL query. Doing a search across a whole database becomes a little bit more complex should you wish to do this with a query. Thankfully, if you use phpMyAdmin there is a built-in feature that enables you d...

How To Bulk Delete Product Variations in WooCommerce

June 3rd, 2014 - Posted by Steve Marks to MySQL, PHP, Software, Web Development.
When building any kind of E-Commerce site in WordPress I always have, and will for the foreseeable future, use the fantastic WooCommerce plugin. I’ve blogged about WooCommerce a few times in the past as I’ve come across various special requirements. Today is no different as I d...

Taking Your WordPress Development To The Next Level

April 16th, 2014 - Posted by Steve Marks to Miscellaneous, MySQL, PHP, Software, Web Development.
Having been an avid web developer for over 10 years now I’ve seen a lot of change during this time. One of which is the explosion in the use of WordPress Content Management System. About 90% of sites we design and build today are based on WordPress, and I’d probably be right in...

Performing a Radial Search with WP_Query in WordPress

January 27th, 2014 - Posted by Steve Marks to MySQL, PHP, Web Development.
If you’re building a site in WordPress that performs some kind of radial search, it can be difficult to know how to do this using the standard functionality included through use of the built-in WP_Query class. I found myself in this exact scenario recently on a site I was developing,...

MySQL CONCAT() Returning NULL Even Though Values Exist

January 24th, 2014 - Posted by Steve Marks to MySQL, Web Development.
The MySQL CONCAT() function is used to concatenate two or more columns or strings together. I had a scenario earlier today where, when concatenating a few columns together the outcome would always be NULL. An example of this query was as follows where I was concatenating a series of addres...

How to Install Two Versions of XAMPP Side-by-Side

October 18th, 2013 - Posted by Steve Marks to MySQL, PHP, Web Development.
I’ve used XAMPP for as long as I can remember. I used it originally so I could learn and practice PHP without having to purchase hosting, however I use it now-a-days to develop sites locally before putting them into the public domain. Each version of XAMPP comes by default with a spe...

WordPress Plugin – Property Portal BLM Export – WP-Property Add-On

July 15th, 2013 - Posted by Steve Marks to (X)HTML / CSS, MySQL, PHP, Software, Web Development.
UPDATE 5th December 2015: This plugin is no longer supported. However, good news! We’ve since developed PropertyHive. PropertyHive is a plugin for WordPress that handles property listings, as well as a much improved BLM export and real-time data feeds to property portals. Check it ou...