Archive for December, 2009

Moving a WordPress Site

Dec 17 2009

I love WordPress and I use it pretty much exclusively for small to mid-sized website development. Wordpress development is quick, easy and website owners love the fact that there's none of the complications that come with proprietary content management systems. Sometimes it becomes necessary to move your beloved WordPress sites to other servers or directories. I've found many online resources elaborating on this topic including the WordPress docs themselves. I prefer to have a quick reference guide for my own purposes though. I've given credit and links where applicable.

If you're moving a WordPress site to a different server or a different directory on the current server there are several steps to go through to ensure that everything works correctly on the other side of the move.

The Database Edits: (from My Digital Life)

SQL From phpMyAdmin or similar: (in phpMyAdmin go to the top level of the database by clicking on the db name and click on the "SQL" tab. don't forget to add the appropriate db table prefix if different from the default wp_ )

UPDATE wp_options SET option_value = replace(option_value, 'http://www.old-domain.com', 'http://www.new-domain.com') WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts SET guid = replace(guid, 'http://www.old-domain.com','http://www.new-domain.com');

UPDATE wp_posts SET post_content = replace(post_content, 'http://www.old-domain.com', 'http://www.new-domain.com');

On occasion you may need to add this to your config.php file: (from the WordPress Codex)

define('WP_HOME','http://www.new-site-location.com');
define('WP_SITEURL','http://www.new-site-location.com/subdirectory-if-applicable');

Sometimes it's necessary to update permalinks by simply going to SETTINGS > PERMALINKS and clicking on SAVE CHANGES. you don't have to change anything, just click the button. Not sure why but it works.

The WordPress Codex has a detailed article on moving WordPress available.

Don't forget to check your theme files (and Flash!) for hard-coded file paths.

Wordpress permissions issues. Can’t auto-update Plugins?

Dec 17 2009

I'm currently on a Media Temple DV 3.5 hosting server and I design and develop using wordpress a lot. WP seems to work great on shared servers as far as the auto upgrades, installing plugins and uploading media. However, Wordpress installs on my server always required me to use an FTP program to temporarily change directory permissions to 777 in order to upgrade WP itself or plugins and I had various issues uploading media through the media manager. Even then, I still had to input the FTP password in the Wordpress backend. This gets to be a pain if you're actively using a Wordpress as a Content Management System. Of course leaving directory permissions at 777 is not a valid option so I did a little digging and found that several other people had the same issue.

I had previously used suPHP to take care of this but there's a much easier solution found on the MT forums… https://forums.mediatemple.net/viewtopic.php?id=4413 – This solution uses FastCGI+SuExec to allow php scripts to fix permissions issues on a media temple dv server. It's fairly easy to accomplish and isn't quite as messy as installing suPHP.

Nashville Interactive Now Using Feedburner

Dec 14 2009

In an effort to better aggregate fresh Nashville Interactive content (and stay on top of the latest technologies for content feeds), We're now using Feedburner to handle all RSS content. This Google-provided service allows website owners access great data on their site's feed usage. Also, feedburner now updates your twitter page with your latest posts and integrates effortlessly with Google Analytics and AdWords too. Exciting stuff for content people.

Please enjoy, let us know if you love it or hate it and SUBSCRIBE TO THE RSS FEED of course.

If you're interested in using feedburner for your site's feed here's a few good links:
- http://feedburner.google.com/ (obviously!)
- http://adsenseforfeeds.blogspot.com/