Welcome to Geeklog, Anonymous Sunday, October 13 2024 @ 02:43 am EDT
Geeklog Forums
Need to delete all trackbacks
I know there's a way to delete spam trackbacks with spam-x, but that uses rules and limits deletions to 400 per run. I have 10s of thousands of trackbacks (incoming) and am hoping there's a way I can delete them all, with minimum time and effort. They're probably stored in my geeklog database, so I may be able to use phpMyAdmin, but I'm not sure what to look for and delete inside the db.
I know I can disable trackbacks, but I need to delete the existing ones and then enable future ones. Any advice?
Thanks
I know I can disable trackbacks, but I need to delete the existing ones and then enable future ones. Any advice?
Thanks
5
7
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
If you really want to get rid of all the trackbacks (no exceptions), then the quickest way would be to empty the gl_trackback table
and then fix the trackback counters in the stories
bye, Dirk
Text Formatted Code
DELETE FROM gl_trackback;Text Formatted Code
UPDATE gl_stories SET trackbacks = 0;bye, Dirk
5
4
Quote
All times are EDT. The time is now 02:43 am.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content