Entries tagged under ' mysql '

Get statistics on another users’ YouTube videos

Written October 17, 2008 in Note-To-Self

Post a Comment

To track cheating on the NapierLife Challenge, I wrote this script to take an hourly “snapshot” of the view-counts of all a users’ videos.

Continue Reading »

Create a fulltext index to keep aa_related_posts happy

Written August 5, 2008 in Note-To-Self

Post a Comment

I use the amazing AskApache google-404 plugin on this blog. (It makes my 404 page really helpful – take a look) Recently, I noticed a bunch of mysql errors in my error.log, like this:

[sourcecode language=sql]
WordPress database error Can’t find FULLTEXT index matching the column list for query SELECT ID, post_title, post_content,MATCH (post_name, post_content) AGAINST (‘feed funkypenguin’) AS score FROM wp_posts WHERE MATCH (post_name, post_content) AGAINST (‘feed funkypenguin’) AND post_date

Continue Reading »