bakshi
Forum Replies Created
-
Forum: Your WordPress
In reply to: Need feedback on my WIPWhen will this theme be available for download?
Forum: Fixing WordPress
In reply to: How to delete 3400 spam comments?Actually, that site you gave me the address to solved the problem. The site contained the only command I needed.
“DELETE from wp_comments WHERE comment_approved = ‘spam'”
That’s all it needed. Thank you very much for your help. If it wasn’t for you posting that link, I probably would of given up 🙂
Forum: Fixing WordPress
In reply to: How to delete 3400 spam comments?That would be useful, however I can’t access WordPress itself. The directory was accidentally deleted during the worm cleaning. So I need to just export the comments and upload them to the cleaned WordPress on the new host.
Also I checked the size of the comment table, it’s 15.5 MB. That’s quite alot of spam.
I hope I don’t get an SOL reply. Pleaassee
Forum: Fixing WordPress
In reply to: How to delete 3400 spam comments?It was marked as spam.
Forum: Fixing WordPress
In reply to: How to delete 3400 spam comments?Okay, I hate bumping this very old thread but I have a huge problem.
Recently, my site got infected with a javascript worm and my host (ipowerweb) proved to be very incompetent at fixing my problem.
Also, I host alot of blogs, most of them belonging to my friends.
Because of this, I chose a new host Powweb. I was able to export some of the MySQL entries from my old host to my new host successfully.
However, there was one blog that had more than a thousand spam comments on it.
iPowerWeb, being a cheapass host, only limits export to like 600kb.
So when I tried to export the comments from the old host in phpMyAdmin, I’d get an error message and then a file can’t be found page in my browser. I’ve tried this with several browsers but to no avail.
Is there any way I can delete the spam in the MySQL database without having to delete all the comments?
Or another way to download it instead of going through iPowerWebs phpMyAdmin screen?
This problem is frustrating me, thanks.
Also I should note that the WordPress directory was deleted so I can’t delete the comments from the blog.
This is the new host where my friends blog is hosted.
http://gooie.bakshi.usForum: Plugins
In reply to: Any Spam Karma Troubles or Complaints?How do I find out what version of Spam Karma that I have installed on my blog?
Forum: Plugins
In reply to: Spam Karma 1.5 (WP 1.2 compatible)…Spam Karma works perfectly with my 1.5 installation. It’s caught 50 spam comments since I’ve installed it last night.
Forum: Fixing WordPress
In reply to: combat new trackback spamI jsut installed Spam Karma on my wp 1.5. Does Spam Karma work well at fighting trackback spam?
Forum: Your WordPress
In reply to: Webfroot.co.nz — Not your ordinary WPwow, your site is amazing!
Forum: Fixing WordPress
In reply to: Change from wp 1.2.2 to 1. 5 beta breaksthe same happened with me. how can this be fixed?
Forum: Plugins
In reply to: Does Kitten’s Spaminator check Trackbacks & Pingbacks?mmmhmm
Can the creator of stopgap also make some way to battle trackback spammers?
From: “A Slice of Americana” <[email protected]>
Content-Type: text/plain; charset=”utf-8″New trackback on your post # “Drool..”
Website: zeoogpziv (IP: 24.250.102.125 , ip24-250-102-125.dc.dc.cox.net)
URI : http://ykioycfyuvwx.com/
Excerpt:
<trackback />yvhvhgdrc
juepyceYou can see all trackbacks on this post here:
http://michael.bakshi.us/archives/2004/05/30/drool/#comments
Forum: Everything else WordPress
In reply to: Why I Hate GmailI got a rediff email address too. It’s pretty good, no ads.
Forum: Everything else WordPress
In reply to: Why I Hate Gmailya, your right. when i got my gmail i immediatly changed all my community profiles to send emails to my gmail, my website also to my gmail, the only thing i haven’t changed is my email in my wordpress support profile
Forum: Everything else WordPress
In reply to: Why I Hate GmailThe reason I hate gMail is that it has been down for 3 days! I can’t be without my email for that long! It’s because these corporations depend on Akamai to do everything for them, and when it goes down, several huge websites go down with Akamai too.
Forum: Everything else WordPress
In reply to: Direct from Microsoft, free Visual Basic.net offerWell, would you rather pay it’s market price or get it for free and brag about it?