Redirection on Github

Redirection is now being developed on Github. I’ve been running it there for a few months now and have already received several pull requests and fixes. It’s a good place for other people to contribute.

It’s also the best place to report any bugs or feature suggestions (anything sent to me by email tends to disappear into a black hole, and patrolling the WordPress.org forums is very time-consuming).

If you’d like to run with the latest version of the plugin then please do use the Github repo as the canonical ‘trunk’ version. The more people that do this, the less likely I am to release something that breaks sites.

I’ve yet to put a working git-to-SVN system together so I’ll manually sync things over to the WordPress.org SVN repository when ready for release.

That all-important link:

https://github.com/johngodley/redirection

I look forward to seeing how it develops!

Redirection – seven years old

Many people have contacted me to say that Redirection is broken with the latest versions of WordPress, outputting this message:

PHP Warning: Missing argument 2 for wpdb::prepare()

I’ve known about this for a long while, it’s a very easy fix, and in fact it’s been fixed for a long while – Redirection 2.3.2 has been available in SVN for many months. However, it was accompanied by some other structural changes in the plugin that may have actually, for real, broken things and so I’ve held off releasing it as a general update.

In the intervening time I’ve had my hands busy with other things, but have finally finished the release for public consumption, and the message is no more. Hurrah!

All this to say that if you nag me long enough I’ll eventually remember to do something.

For the pedants like me, it wasn’t actually broken – it’s a warning – and if you were seeing this on a production website then I’d very much advise disabling error messages.

While writing this release post I noticed that the plugin is over seven years old. Seven!

Sequel Pro Tips: table filters and auto-suggest

Sequel Pro is great, and there are a few tricks to make it even greater. If you have a database with a lot of tables then the table filter field is useful:

A neat tip is that you can use the pipe character as a logical OR operator, so you can show tables that match several conditions. Below is post|comment – tables that match post or comment:

Very handy if you have to swap between tables that are lost in a big list. You can chain together many filters in this way.

Another nice feature is the SQL auto-suggest. From the query tab, press escape as you are typing out a table or column name:

A box appears with matching suggestions. You can use cursor up/down to move between suggestions, and enter to select.

Finding bad and out-of-date passwords in 1password

I use 1password to keep track of all my passwords. Over the years I’ve built up a lot of logins and a lot of passwords, and for various reasons some of them are not so good.

With the recent news about LinkedIn and Last.fm password leaks, it’s worth keeping an eye on your passwords. 1password has a nice feature called smart folders. You can use these to quickly find susceptible passwords.

Click the cog button in the bottom left of the 1password screen and pick ‘New Smart Folder‘:

At the top of the data area, configure a set of rules to be ‘kind is login‘ and ‘password strength is less than or equal to 60‘ (you can change the minimum password strength to suit).

Save the folder and it appears in the folders section on the left on the 1password window. Clicking on this folder will show all your bad passwords. Time to get updating!

You can also create a smart folder that shows passwords that you haven’t updated in over a year by setting the smart rule to ‘modified before date’.

MAMP Slow Queries

Ever wanted to track down slow SQL queries while developing with MAMP on OS X? From the MAMP control panel edit the my.cnf template:

Track down the section starting with [mysqld] and add the following highlighted lines:

# The MySQL server
[mysqld]
log_slow_queries=/Applications/MAMP/logs/mysql_slow.log
long_query_time=1

Restart MAMP and any slow queries (queries over 1 second, configurable via the long_query_time option above) will be logged to /Applications/MAMP/logs/mysql_slow.log.

Now I have no excuse to forget this.