View Sidebar

Archive for July, 2009

Visual Studio 2008 Freezing After Office 2010 Install

Visual Studio 2008 Freezing After Office 2010 Install

After some very frustrating experiences with Visual Studio 2008 hanging inexplicably, I discovered that the problem was the technical preview of Microsoft Office 2010 I had installed.  The fix was easy:

http://blog.hinshelwood.com/archive/2009/07/19/office-2010-gotcha-2-visual-studio-2008-locks.aspx

July 30, 2009Comments are DisabledRead More
Fix for WordPress XMLRPC 500 Internal Server Error

Fix for WordPress XMLRPC 500 Internal Server Error

One of my WordPress-based sites (http://crowdspace.net) was not working when I tried to publish posts containing images from Windows Live Writer.  I was getting a 500 Internal Server Error.

I was able to fix the problem by making a small change to the database.

The Error Message

I enabled Failed Request Tracing in IIS7 to find out what was happening server-side to cause the HTTP 500 error.  I discovered that the PHP script was trying to insert a row into the wp_posts table with a value of -1 in the post_parent column:

WordPress database error Out of range value for column ‘post_parent’ at row 1 for query INSERT INTO `wp_posts` (`post_author`,`post_date`,`post_date_gmt`, `post_content`, `post_content_filtered`, `post_title`, `post_excerpt`, `post_status`, `post_type`, `comment_status`,`ping_status`, `post_password`, `post_name`, `to_ping`, `pinged`, `post_modified`, `post_modified_gmt`, `post_parent`,`menu_order`,`post_mime_type`,`guid`) VALUES (‘1′,’2009-07-15 14:37:14′,’2009-07-15 17:37:14′,”,”,’2827426439_7b744abd30_m.jpg’, ”, ‘inherit’, ‘attachment’,’open’,’open’, ”, ‘2827426439_7b744abd30_m-jpg’,”,”,’2009-07-15 14:37:14′,’2009-07-15 17:37:14′,’-1′, ‘0’, ‘image/jpeg’, ‘http://crowdspace.net/files/2827426439_7b744abd30_m5.jpg’) made by wp_xmlrpc_server->wp_xmlrpc_server, IXR_Server->IXR_Server, IXR_Server->serve, IXR_Server->call, wp_xmlrpc_server->mw_newMediaObject, wp_insert_attachment
ErrorCode 5
ErrorCode
 

Apparently the database didn’t like that…  I investigated further and discovered that the post_parent column in my database was set to BIGINT UNSIGNED.  In other words, that database column could not hold the value -1 (unsigned integers are zero or higher).

Some Sanity Checking

I checked several other WordPress databases that I control and found that post_parent column is not UNSIGNED in any of my other WP databases.

So why the difference?  All my other databases were created with earlier versions of WordPress and upgraded.  The database in question, however, had been created with the latest WordPress release (2.8 at the time).  So I popped open the PHP file that defines the database (schema.php) and discovered:

post_parent bigint(20) unsigned NOT NULL default ‘0’,

What’s Going On Here?

When the XMLRPC script uploads an image (called an attachment in WordPress), it uploads it with a post_parent of -1.  Then after the post is created, the script updates attachments with post_parent=-1 with the actual ID of the freshly created post.

My guess is that a developer on the project decided to update the schema to UNSIGNED because posts do not have negative values for IDs and the post_parent column references a post ID.  Obviously that developer did not realize the special use case in xmlrpc.php.

How Do I Fix This?

Fortunately the workaround is easy.  Just run the following database query to change the data type on the post_parent column:

ALTER TABLE wp_posts CHANGE post_parent post_parent BIGINT;

If you don’t know how to run queries against your MySQL database, well, this is a good time to learn.  I did it at the command line on my 64-bit Windows server:

cd "C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\"

mysql.exe –u root -p
Enter password: ***********************

Welcome to the MySQL monitor.  Commands end with ; or \g.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.

mysql> use crowdspace
Database changed
mysql> ALTER TABLE wp_posts CHANGE post_parent post_parent BIGINT;

The process is similar on a Linux box.  I’m going to go out on a limb here and assume that you can figure out how to run mysql on Linux if you’re running your own Linux server.

If you’re using a shared web hosting service, you should be able to use a web interface such as phpMyAdmin to run this command.

That’s all it took to fix the problem for me.  Happy blogging!

July 15, 200914 commentsRead More
Free Ebook Developers Developers Developers Developers

Free Ebook Developers Developers Developers Developers

Content from Microsoft’s {You Shape} It campaign has been rolled up into the ebook Developers Developers Developers Developers.  Many of the contributors are Microsoft MVPs and/ Microsoft Regional Directors.

It’s a free download and released under a Creative Commons license so share share share!

http://devshaped.com/book

http://devshaped.com/files/developersdevelopers.pdf

In the book:

Working with Brownfield Code by Donald Belcham (Microsoft MVP)

Beyond C# and VB by Ted Neward (Microsoft MVP)

Remaining Valuable to Employers featuring Barry Gervin, Billy Hollis, Bruce Johnson, Scott Howlett, Adam Cogan, and Jonathan Zuck

All I Wanted Was My Data by Barry Gervin (Microsoft Regional Director and MVP)

Efficiency Upgrade by Derek Hatchard (Microsoft Regional Director and MVP)

Getting Started with Continuous Integration by Sondre Bjellås (Microsoft Regional Director and MVP)

On Strike at the Software Factory by Daniel Crenna (Microsoft MVP)

C# Features You Should Be Using by Ted Neward (Microsoft MVP)

Accelerate Your Coding with Code Snippets by Brian Noyes (Microsoft Regional Director and MVP)

Is Silverlight 2 Ready for Business Applications? by Jonas Follesø (Microsoft Regional Director and MVP)

Innovate with Silverlight 2 by Daniel Crenna (Microsoft MVP)

Real World WPF: Rich UI + HD by Gill Cleeren (Microsoft Regional Director and MVP)

Hidden Talents by Peter Jones

Creating Useful Installers with Custom Actions by Christian Jacob

Banking with XML by Peter Jones

Sending Email by Derek Hatchard (Microsoft Regional Director and MVP)

July 9, 20092 commentsRead More