Loading...
 
Skip to main content

Custom Share Module 0.1dev

Features / Usability

Features / Usability

Forum List Topic List

Forums » Features / Usability » Deleting many trackback pings?
 
Thread actions
Print this page
  • Print all pages

    • Deleting many trackback pings?

    Posted by mstovenour posts: 17 United States
    I just noticed thousands of spam trackback pings across multiple blogs. I can, given a couple of days at the mouse, delete them one at a time in the user interface, however I would like to delete them directly in mysql. I am going through the code to determine the right tables, rows, and / or columns to update or delete. However I was hoping that someone might have already solved this problem. Does anyone know which entities I need to update to remove the trackback pings?
    Reads: 1368
    Posted by Gary Cunningham-Lee posts: 4657 Japan

    There are trackback_to and trackback_from fields in the tiki_blog_posts table. You could look at these to verify what needs to be deleted. I'm not sure of the sql statement offhand.

    -- Gary


    Posted by mstovenour posts: 17 United States

    I figured this out. If anyone else needs to know how this is done, my attempt is below. One word of caution, I am not a Tikiwiki db expert so this might not be the "right way" to do this. Also be sure to make a db backup before you try this.

    I opened mysql and pulled a few queries for blog entries that were not affected as well as some that were a problem. I then determined that, at least for my Tikiwiki version, empty traceback_from entries contain 'a:0:{}'. I used a few queries to get a listing of the damage. Once I was comfortable that I knew the format I used an update query to dump all at once. BTW, this assumes that there are no legitimate traceback_from entries.

    For some reason this forum (maybe all Tikiwiki forums) does not allow me to post sql statements. I get an Internal Server Error when I try. Even when placed in CODE sections. You can see all the SQL queries that I used on my blog: Found spam traceback pings on some of the Tikiwiki blog posts

    Oh... new bug.. Parser should not try to link hotwords found in an external reference!