Tag Archives: sql

Tweeting MythTV events in the new OAuth era

Posted on August 30, 2010 by cdn

The mythtv wiki has a few scripts for tweeting MythTV stuff to twitter; although they all relied upon Basic Auth. until recently. Taking a leaf out of Twitter Tools‘ book it’s possible to convert the LWP::UserAgent-based code to do OAuth. … Continue reading →

Posted in MythTV, Web, twitter | Tagged , , , , , | Leave a comment

Yes, this IS getting boring

Posted on May 24, 2010 by cdn

Upgraded most of the short linking I’ve been doing outside wordpress/la-petite-url to use yourls; except, of course, that a quick bit of sql didn’t translate everything. The MySQL insert into yourls_url select key1, target, timestamp(concat(year, ‘-’, month, ‘-’,day, ‘ 12:00:00′)), … Continue reading →

Posted in Web | Tagged , , | Comments Off

“Fix”ing WordPress database tables

Posted on February 6, 2010 by cdn

After restoring tables from a WP mu backup (an incomplete one as it turned out) various issues presented themselves, not least an inability to submit posts (HTTP 500 not informative). A little searching revealed a likely cause (http://discuss.joyent.com/viewtopic.php?id=19116): missing auto_increment … Continue reading →

Posted in Web | Tagged , , | Comments Off