How To Find 6 Month Old Stale Pages in Cache

Hello Translator Plugin Pro user. Hope you are benefiting from our product. Why don’t we give you more reasons to smile and work quickly? Here are some tricks that will help you.

Suppose you want to find 6 month old stale pages in translator cache from database. There is a simple solution for that.

Guide

  1. Open a terminal
  2. type mysql -u <user_name> -p
  3. Give your password when prompted for
  4. type use <database_name>
  5. then type
    SELECT url, language, last_updated, next_update from wp_atpp_page_cache WHERE stale = 1 AND manual = 0 AND year(last_updated) = 2008 AND month(last_updated) < 6 LIMIT 10

and you are done.

p.s. -> You can use your current year in place of 2008 too.

Note: Translator Plugin Pro (for WordPress blogs) provides automatic machine translation of blogs in 13+1 languages (many more will be added soon) with 4 translation engines to provide transparent fail-over support and load balancing.

Translator Plugin Gold (for WordPress blogs) provides automatic machine translation of blogs in 32 languages (more will be added soon) with 5 translation engines to provide transparent fail-over support and advanced load balancing.

Tags: , ,

One Response to “How To Find 6 Month Old Stale Pages in Cache”

  1. 6 Must Know Tips for Translator Plugin Says:

    [...] How To Find 6 Month Old Stale Pages in Cache [...]

Leave a Reply

You must be logged in to post a comment.