Welcome to Geeklog, Anonymous Saturday, December 21 2024 @ 09:20 am EST

Geeklog Forums

Need to delete all trackbacks


Status: offline

PWR

Forum User
Junior
Registered: 04/02/06
Posts: 21
determined
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


 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
Text Formatted Code
DELETE FROM gl_trackback;
 
and then fix the trackback counters in the stories
Text Formatted Code
UPDATE gl_stories SET trackbacks = 0;
 

bye, Dirk
 Quote

All times are EST. The time is now 09:20 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