Unofficial RFF blog - Kaiyen are you there?!

[RML]

Kaiyen, the blog isn't working properly. It shows an error message:

WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND comment_approved = '1'' at line 1]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = AND comment_approved = '1';


Could you see and find out what's the matter?

[kaiyen]

Yeah, I know. I upgraded to 2.0 and it broke the SQL db. I don't have shell access so I can't fix it yet. I'm waiting on my hosting company to restore the old version.

don't worry. I know.
allan

[RML]

Good of you to let us know, Allan. Thanks.

[kaiyen]

Hey. It's cool that people (even if it's just you, remy) read it. I did "test" upgrades to three other blogs that worked just fine, and this one didn't. argh.

allan

[kaiyen]

The good news is that I've got it upgraded. The bad news is that...well, I didn't so much upgrade as lose the entire blog and reinstall.

So now I have no blogs being fed in. I'll go searching but if you have a photo blog, just post here. You don't even need to say anything if you got your blog in your sig.

allan