I did a code review along with Brad Williams yesterday and today we combined our results. The problem was, our spreadsheet columns didn’t match. He’d combined path and filename into one column and I’d split them out into two columns. We...
This is a fairly common error and a bit of a head smacker… Before you look any further, ask yourself one question.. Are you trying to use a git client to check out an SVN repository? Try using svn client...
Installing memcached on a server for use with W3Total cache can seem daunting if you haven’t done it before. Once you’ve done it enough to work out a method and know the speed bumps you can come across, you can ...
A customer wanted a piece of code that allowed a page to be refreshed once the client has remained on the page after a certain amount of time. They’d used a refresh command previously, but the problem was that this interrupted...
When doing exports of large databases using mysqldump, it is common to get errors that are along the lines of: mysqldump: Got error: 1016: Can’t open file: ‘./databasename/tablename.frm’ (errno: 24) when using LOCK TABLES or maybe mysqldump: Got error: 23: Out...
First – Breathe. “notty” stands for “no teletypewriter”. Programs that connect to the server but don’t want the output displayed any where use a “No TTY” connection. So if you see “ssh: *@notty” on a task list somewhere, it just means...
Unfortunately there are lots of registrars that don’t allow you full access to your DNS settings. 1and1.com is one of these. If you host your site with 1and1.com and you want to add a TXT record to your domain for verification...
I’ve improved my earlier random string generation procedures to better suit my needs. So I created a Random Name Generator for MySQL. I’ve created two new procedures. They pick from the 100 most popular first names (well actually the 50 most...
There are lots of quick and dirty ways to create a random strings in mysql. If you want letters and numbers, just do this: SELECT LOWER( SUBSTRING( md5( RAND( 4 ) ) , FLOOR ( 7 + ( RAND( ) *...
For my own copy and paste pleasures, here are some wpdb error handling examples. It will grow over time: A very simple non-failing method for in a function: if ($wpdb->query($query) === FALSE) { return FALSE; } else { return $wpdb->get_results($query); }...