URL Shortening cleanup

  • Resolved Zumatra

    (@zumatra)


    12 years, 2 months ago

    Hello,

    I was just configuring WP to Twitter on a new site and checking the Twitter output.

    I realised I had set the wrong URL shortener for several posts and it seems that the first choice is the one which sticks for each post.

    Is it possible to clear the Tweet stored data on a post by post basis? I have tried deleting the post’s Tweet History but that did not work.

    I am creating a local community website on a voluntary basis and would like to be able to demonstrate its capabilities – it would be nice if I could get all the posts to have the same format.

    I’d appreciate any advice, thanks.

    https://ww.wp.xz.cn/plugins/wp-to-twitter/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Joe Dolson

    (@joedolson)

    12 years, 2 months ago

    At the moment, you can only do this by editing the database and removing the post meta field containing the short URL for the post.

    Thread Starter Zumatra

    (@zumatra)

    12 years, 2 months ago

    Thanks for the reply.

    I’m not very MySQL savvy but I wouldn’t be put off delving into the database to find the post data to correct it.

    Plugin Author Joe Dolson

    (@joedolson)

    12 years, 2 months ago

    Go into the database, and open the wp_post_meta table. Do a search for the post IDs you want to edit against the post_ID column. You’ll find post meta fields with names like these:

    _wp_jd_supr,_wp_jd_ind,_wp_jd_bitly,_wp_jd_wp,_wp_jd_yourls,_wp_jd_url,_wp_jd_goo,_wp_jd_target

    Those are the fields that hold historical short URLs for each post. You can delete them. They are only used for avoiding extra queries to the URL shortener; they won’t impact anything you’ve already done, simply cause WP to Twitter to re-query the URL when you next update.

    Thread Starter Zumatra

    (@zumatra)

    12 years, 2 months ago

    Thank you for the reply.

    I’m unable to work on the database at the moment but will look at your instructions as soon as I have access to my own computer.

    Thanks.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘URL Shortening cleanup’ is closed to new replies.