Chris Farris - Geeklog

ALE WordPress talking points

Posted on January 30th, 2007 by Chris Farris.
Categories: Wordpress.

Title: World Domination with WordPress

• What is WordPress
• The joys of Plugins
• antispam captcha
• spell check
• post rankings
• Firestats
• iCal
• Database management
• WP-phpMyAdmin
• Database Backup
• The joys of Themes
• Database nitty-gritty
• How WP can help with your meglamanical schemes
• Websites:
• http://www.ale.org
• http://www.gwinnettgop.org
• http://www.gopliberty.org
• Blogs:
• http://www.vitalpowers.com/blog
• http://www.chrisfarris.com/geeklog
• Advanced stuff:
• http://www.georgialegislativewatch.com/

0 comments.

MythTV Rebuild

Posted on January 27th, 2007 by Chris Farris.
Categories: MythTV.

Wow, MythTV is a pain in the ass to build. Luckly I found a site that had OpenSuSE 10.2 rpms. That made it easier. I still had to copy over my config files from the old MythTV build.

http://packman.iu-bremen.de/suse/10.2

I had to manually alter the recording tables to copy the data from the old system to the new database.

The following query was used to compare settings from the old settings table and the new settings table:
select mythconverg.settings.value, mythconverg.settings.data, mythOLD.settings.data from mythconverg.settings, mythOLD.settings WHERE mythconverg.settings.value=mythOLD.settings.value AND mythconverg.settings.data != mythOLD.settings.data INTO OUTFILE '/tmp/setting.diff';

0 comments.

Fun MySQL debugging commands

Posted on January 16th, 2007 by Chris Farris.
Categories: strange horned toads.

SHOW ENGINE INNODB STATUS\G

0 comments.

Wordpress Captcha

Posted on January 7th, 2007 by Chris Farris.
Categories: Wordpress.

Here is a good captcha anti-comment-spam tool for wordpress

Make sure to note This comment which has the fix for Wordpress 2.0. If you don’t then the captcha is there, but any value will still allow a post.

This looks to be an even better version

0 comments.