How to fix disappeared WordPress comments

I’m not sure if this happened after an upgrade or something, but I logged in to WordPress this morning and found that ALL comments on the blog had disappeared! No approved… no pending… no spam. I knew that couldn’t be right, so I did some research and found this post on the WordPress Support forums:

Been using WordPress for years without hitch. I recently however upgraded to 2.9.1 and nobody can now post comments. If I try to post a comment, the page goes blank (on this url http://eastlower.co.uk/wp-comments-post.php#comment-)

Worse, all my previous comments from 606 posts appear to have disappeared (at least it says they have on the dashboard).

I’ve contacted my administrator who says my database in phpmyadmin is fine – though the comments table says ‘in use’.

I logged into phpMyAdmin and sure enough, the comments table says “in use.” I scrolled down a little farther and this comment seemed promising:

In Cpanel click on MySql Databases. On the next page you should see your MySql DBs. click on the “repair” button for the db you are using for your site. Hope it helps. Worked for me and I had the same problem.

I had some trouble finding this “repair” button and once I found it, I thought I would do a little step by step for others that had problems. This is using phpMyAdmin version 3.4.5.

Step 1: Log into your cPanel (located on your server, separate from WordPress) and then log into phpMyAdmin. Click on your WordPress database. BACK UP YOUR DATABASE BEFORE GOING ANY FURTHER.

(click to enlarge)

Step 2: In the list of tables, locate wp_comments and click the check box next to it.

(click to enlarge)

Step 3: Scroll down and choose “Repair Table” from the drop down box.

(click to enlarge)

Step 4: Success! It’s been repaired successfully.

(click to enlarge)

And now all my comments are back, even those lovely spam comments 😀

See, that wasn’t too hard! Hopefully that helps you!

Stash Report – Week of May 6, 2012

I was inspired by Judy over at Patchwork Times to sit down and measure out my stash of fabric. I didn’t really want to face how much fabric I might have shoved under the bed, lol. After all the measuring and adding, I estimate my stash to be around 97 yards!! :omg: And that’s not even including my scraps bin, which has a couple of charm packs and a layer cake in it… :blush:

I’m going to start as of today; I have no idea how much fabric I’ve used so far and I do not want to figure it out!! So here’s my stash report:

Used this Week: 0 yards
Used year to Date: 0 yards
Added this Week: 0 yards
Added Year to Date: 97 yards
Net Used for 2012: 0 yards

I really need to get rid of some fabric apparently!!

Spring Concerts – Bon Iver

Untitled

On Monday, April 16 my brother and I made our way over to the Fox theater in Pomona to see Bon Iver. The Fox is a great little theater, but I really hate how it’s all General Admission, even if you have a balcony ticket (where there are seats). We ended up getting great seats on the balcony though, so I guess I didn’t mind it too much.

On the way to the show, as is my custom, I was listening to Bon Iver’s “For Emma, Forever Ago” and their self-titled “Bon Iver.” I started to get a little sleepy, to be honest! I was worried the show would be boring but it was anything but. I couldn’t tell you the complete set list but it was an amazing show.

All Tiny Creatures opened the show and did a great job of making me want to pick up their album. Then Bon Iver came out and opened the show with “Perth.” It seemed like all 9 members of the band that night (save the two drummers) played at least two instruments. With so much talent, you know it’s going to be a good show and it was. The music was so full bodied; there was so much layering and harmonizing going on.

I really enjoyed lighting effects they had going on, too. They had these racks with lights at the end of poles set up in two rows on the stage. At times the stage would go dark and these lights would look like fireflies or stars, it was really cool. You can kind of see them in the picture above, but they’re not lit up.

One special moment was when all the musicians except Justin Vernon left the stage and he played an acoustic version of “re: Stacks.” You could hear the entire audience singing along. For the encore the band came back out and Justin had everyone sing along with him. A great show, definitely see them if you get a chance!

Positively Perfect Quilt: Completed!

The quilt for mu cousin is finished! I used this Positively Perfect quilt pattern and a jelly roll of Cape Ann fabrics, among others, to make it. I tried to get some outdoor pictures of the quilt this time and I also messed around with the contrast and other settings in Photoshop, so maybe this time my pictures are a bit better!

complete

You can see the quilting really well in this shot. I did a diamond pattern on the pluses and dots, and then lines on the borders.

back

The back was pieced together using leftover pieces from the two border fabrics on the front, and leftover pieces from the Jelly roll. I also had one more plus left over somehow, so I used that in the backing, too.

complete2

You can see the binding a bit better on this one. I used all the leftover stripey fabrics from the jelly roll to machine bind my quilt. I love that I can just grab a few strips from my Jelly roll to bind the quilt! Makes things so easy.

label

This “made with love” label was on one of the selvage pieces! How nice is that? So I added in my name and date to the label. Forgive the smudging… I want to keep things as anonymous as possible. :blush:

Happy Friday!
Continue reading

Spring Concerts – The Magnetic Fields

Untitled

On March 23 my brother and I made the trek to downtown Los Angeles’ Orpheum theater to see The Magnetic Fields perform. I was so incredibly excited to see them and they did not disappoint. We got there a little early and grabbed dinner at Urbano Pizza Bar nearby (you can read my review here) and then headed over.

Our seats were kind of laughably far back but like i said in my review of the theatre, it doesn’t really matter too much. It didn’t help with taking pictures though (as you can see!). The opener, Bachelorette, wasn’t that great in my opinion, but my brother thought she was alright. Here is The Magnetic Fields’ set list (I starred my favorites):

I Die
Chicken With Its Head Cut Off*
Your Girlfriend’s Face
Reno, Dakota*
Come Back From San Francisco*
No One Will Ever Love You
I’ve Run Away to Join the Fairies
Plant White Roses
Drive on Driver
My Husband’s Pied-à-Terre
Time Enough for Rocking When We’re Old
The Horrible Party
Smoke and Mirrors
Going Back to the Country
Andrew in Drag*
Quick!
Busby Berkeley Dreams
Boa Constrictor
Book of Love*
Fear of Trains
You Must Be Out of Your Mind
Grand Canyon*
Swinging London
It’s Only Time
Smile! No One Cares How You Feel
Encore:
Tar-Heel Boy
Forever and a Day

A very generous set and I was thrilled they played “Grand Canyon,” it’s one of my favorites. Claudia and Stephen had an interesting dynamic going; she was very personable and friendly whereas Stephen was more reserved and sometimes cranky. At one point someone requested “I Don’t Want to Get Over You,” to which Stephen replied “I haven’t taken requests in over 20 years.” lol I loved that! I hope they come back to LA soon, I’d love to see them again.

Spring in San Diego

Things have been crazy around here. Sometimes I wonder why I am in the business of catering weddings — one of the most stressful (and wonderful!) days of a person’s life!

Yesterday I drove my in-laws to the San Diego International airport, which happens to be the airport closest to us. They are flying out to a cousin’s wedding (the cousin this quilt is for). I just barely got the quilt done that morning in time for them to take it. Some of my markings didn’t wash out completely — oh well! I tried, anyway. I will have a post on it as soon as I have time to load the pictures from my camera.

After I dropped them off at the airport I decided to stop for a cup of coffee and walk around Balboa park a bit. I can’t believe it’s already been six years since I’ve been there! I walked through the rose garden…

Untitled

Untitled

Untitled

Untitled

Then I took the bridge behind that crazy cactus across the street to where the museums are.

Untitled

This is in front of the Science museum (not pictured). On the right is the Natural History Museum and behind the fountain is a path down to the belltower, which tolled 11AM as I took this picture. Back to reality. Got in my car and headed back to work… I hope we can come back for a longer visit soon.

Granny Squares!

Still working on my Positively Perfect Quilt, I actually finished the backer tonight but couldn’t jump into quilting it just yet. I don’t have a big enough space in my home to baste quilts, so I take it to our shop and baste it there. :)

So in the meantime, I got started on ANOTHER quilt that will be a wedding gift! I saved some of the pink jelly roll strips from the Positively Perfect quilt to use on this one. This girl seriously LOVES pink; her wedding this summer is pink-themed. The bridesmaids are even wearing pink dresses! (I should know… I just picked mine up!)

I have been wanting to try out a Granny Square block, it seems like they’ve been popping up ALL over the quilting blogosphere! I thought this would be the perfect opportunity to try it out. I’m SO glad I did! I am LOVING Granny Squares! They’re so FAST and EASY to make, I got three done in just about an hour and cut out the pieces for a fourth. Here they are on my improvised design wall:

IMG_4262

I seriously need to get some better lighting in this apartment.

It’s going to be really fun coming up with new color combinations with this. I want all of the blocks to have at least SOME pink in them. This one combines some Cape Ann prints (pink) with Michael Miller (yellow):

Untitled

Some more Cape Ann with a purple solid I picked up in the remnants bin:

Untitled

And these are both Cape Ann:

Untitled

So, three blocks down, at least 17 more to go! I hope this one comes together quickly. I want to have it ready for the bridal shower, which is just around the corner.

Have you make Granny Squares yet? What quilting design do you think you would use?