sylday

I don’t want to shut off all comments, just comments on older posts. Would the following query work?

Update wp_posts
set comment_status = “closed”
where post_date < “2005-02-14”

Please tell me someone is working on updating auto-close comments and finding the backdoor. I love WP and I’ll stick with it no matter what, but I do like it better when it works without all this aggravation.

The auto-close comments is no longer working in the new install. That’s contributing to the spam problem. Is there a newer version of this plug-in that works with 1.5?

They’re killing me. I just woke up to find over a hundred pieces of WP spam in my inbox. If they’re doing this manually, they’d have to enter their email address to post and the auth image. All of these pieces of spam have no email addy.

There’s a new backdoor somewhere.

I get this:

WordPress database error: [You have an error in your SQL syntax near ‘ORDER BY post_date ASC LIMIT 0,1’ at line 1]
SELECT ID,post_title FROM wp_posts WHERE post_date > ” AND post_date_gmt < ‘2005-02-21 01:10:39’ AND post_status = ‘publish’ AND ID != ORDER BY post_date ASC LIMIT 0,1

Do I need to repair a table somewhere? Is that what the problem is?

Okay, creating a new .htaccess brought my old blog back online. Now, looking at the tamba2 list of files to delete, the .htaccess is not listed as one of them so I didn’t delete it. Is this why my install failed last night? Is that what caused the “no input file specified” problem? Now my old version of WP displays this under the Options tab:

Database error: [Table ‘wordpress.wp_optiongroups’ doesn’t exist]
SELECT group_id, group_name, group_desc, group_longdesc FROM wp_optiongroups ORDER BY group_id

Warning: Invalid argument supplied for foreach() in /usr/home/sday/www/htdocs/blog/wp-admin/options-head.php on line 10

I’m using my old install. Should I still redo the htaccess?

After restoring the database and returning to my previous files last night, the blog worked until this morning. When I attempted to edit a comment, the blog crashed. Now my blog is completely nonfunctional and returns a 500 server error.

I used the tamba2 instructions to the letter, no variation. My database was not wiped out, it simply became non-functional.

I heard, but haven’t verified, that after the worm defacing that occured with the phpBB message boards many servers installed safeguards that are preventing the installation of WordPress. The Step #2 error that you’re describing is the problem others are having.

Two days ago I was hit with hundreds of spam comments, even though I auto-shut off comments after two weeks. I plugged in Spam Karma and that stopped the spammers. Today, I’ve been hit with a flood of bestiality/incest trackbacks. I’m going to try the Trackback Spam Stopper. Thank you for that.