News & Blog

WordPress Plugin Activated

Debugging Why WordPress Won’t Create Plugin Tables On Activation

July 11th, 2013 - Posted by Steve Marks to MySQL, PHP, Web Development.
I’ve wrote small-ish WordPress plugins in the past, however at the moment I’m working on something a little more girthy (can a WordPress plugin be girthy?) where I’m getting to experiment with more of the advanced features. One of these features I’m getting to play ...

Resolving MySQL Error – FUNCTION CONCAT does not exist

January 8th, 2013 - Posted by Steve Marks to MySQL, Web Development.
Before I begin it’s worth nothing that this error is only a problem on certain versions of MySQL. The error in question is as follows: [Err] 1305 - FUNCTION databasename.CONCAT does not exist Let’s take a look at a very simple query that would result in this error appearing: SE...

MySQL Error Resolved – Subquery Returns More Than 1 Row

July 26th, 2012 - Posted by Steve Marks to MySQL, Web Development.
If you’ve found this post you’re probably trying to find out why your MySQL query is returning the following error: Subquery returns more than 1 row To allow me to explain the problem let me show you an example of a query that might throw this kind of error: SELECT `col1` FROM ...

MySQL ‘Column X cannot be null’ When Performing UNION ALL

July 18th, 2012 - Posted by Steve Marks to MySQL, Web Development.
Whilst recently trying to run a query that involved a UNION ALL, I got an error claiming that a column could not be NULL. Running each of the queries individually worked fine so I knew I had to dig a bit deeper. Here’s a simplified version of my query: SELECT `amount1` AS amount FROM...