Sep 24 2009post3

Everything seemed fine last night but I gave it a fresh look this morning and noticed that the post thumbnails for the blog home page were not displaying at all. My blogs use the Thesis theme which lets you specify the thumbnail as a URL to the image file in the Write Post admin page. For some reason the .htaccess redirection for the old domain name was not working for the URLs configured on each post for the thumbnail image.

After a little snooping around in MySQL I found that Thesis stores this setting in the wp_postmeta table with a key name of thesis_thumb and a value of the URL itself. So the solution was as simple as performing a find/replace operation in MySQL. I made sure to backup my database first, then ran this SQL command:
Everything seemed fine last night but I gave it a fresh look this morning and noticed that the post thumbnails for the blog home page were not displaying at all. My blogs use the Thesis theme which lets you specify the thumbnail as a URL to the image file in the Write Post admin page. For some reason the .htaccess redirection for the old domain name was not working for the URLs configured on each post for the thumbnail image.

After a little snooping around in MySQL I found that Thesis stores this setting in the wp_postmeta table with a key name of thesis_thumb and a value of the URL itself. So the solution was as simple as performing a find/replace operation in MySQL. I made sure to backup my database first, then ran this SQL command:Everything seemed fine last night but I gave it a fresh look this morning and noticed that the post thumbnails for the blog home page were not displaying at all. My blogs use the Thesis theme which lets you specify the thumbnail as a URL to the image file in the Write Post admin page. For some reason the .htaccess redirection for the old domain name was not working for the URLs configured on each post for the thumbnail image.

After a little snooping around in MySQL I found that Thesis stores this setting in the wp_postmeta table with a key name of thesis_thumb and a value of the URL itself. So the solution was as simple as performing a find/replace operation in MySQL. I made sure to backup my database first, then ran this SQL command:
Everything seemed fine last night but I gave it a fresh look this morning and noticed that the post thumbnails for the blog home page were not displaying at all. My blogs use the Thesis theme which lets you specify the thumbnail as a URL to the image file in the Write Post admin page. For some reason the .htaccess redirection for the old domain name was not working for the URLs configured on each post for the thumbnail image.

After a little snooping around in MySQL I found that Thesis stores this setting in the wp_postmeta table with a key name of thesis_thumb and a value of the URL itself. So the solution was as simple as performing a find/replace operation in MySQL. I made sure to backup my database first, then ran this SQL command: