You can use PhpMyAdmin to delete all comments of type trackback.

¥

I would like to disable the trackback feature. Also I would like to add an anti-spam feature to the comment feature. Any suggestions? I am very new to b2evo and php.

Thanks.
- ecology

afaik, best way to prevent comment spamming is either using [url=http://manual.b2evolution.net/Plugins/captcha_img_plugin]Image verification (Captcha Image)[/url] or using the [url=http://wonderwinds.com/hackblog.php/2007/12/turing-test-plugin-updated-for-v220]Turing Test plugin[/url]

and btw you can disable trackbacks, under blog settigns > Features tab

Help! Some of my posts have hundreds of existing spam trackbacks. How can I automatically select and delete these spam?

Many thanks,
ecology

I have managed to delete some existing trackbacks by adding banned words to antispam but it is slow going.

I'd try what ¥åßßå suggested:

Hit phpMyAdmin and go to the SQL pane ...

DELETE from 'evo_comments'
WHERE 'comment_type' = 'trackback'

All yer trackback spam is *poof* gone :D

Thanks, but I haven't tried that solution because I don't know how to get to PhpMyAdmin. I appreciate your direction.

Thanks.
ecology

Found php myadmin and sql but

DELETE from 'evo_comments'
WHERE 'comment_type' = 'trackback'

is incorrect code. I am using MySQL client version: 4.1.22.

Yes! I found help in the MySQL 5.0 manual and here is the correct code: DELETE FROM evo_comments WHERE comment_type = 'trackback'.

Thanks stk.

- ecology

no worries ... seems odd that it was tossing errors b/c of single quotes (code looks the same, minus those). Then again ... the mySQL stuff does seem to be picky.

Glad you got it sorted. :D

It is probably due to the 2 different types of single quotes available on a keyboard. Surrounding the field name, phpmyadmin likes to see the ones that come from the key on the left of the numbers across the top of the keyboard. The key with the tilda on it, which is what I think that thing is called. ~ and ` on the same key. For the value name, phpmyadmin likes the traditional single quote character that looks like ' which hopefully will be different in this post.

This post should be stickied. I enabled trackback because it sounded helpful. Next time I checked the email there was 1000 trackback spams.

Deleting those one at a time was giving me a really bad attitude towards the blog software.

Now they are all gone with that MySql command

DELETE FROM evo_comments
WHERE comment_type = 'trackback'