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
- Open a terminal
- type mysql -u <user_name> -p
- Give your password when prompted for
- type use <database_name>
- 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: WordPress, WordPress Translator Plugin Gold, WordPress Translator Plugin Pro
November 7th, 2008 at 1:33 pm
[...] How To Find 6 Month Old Stale Pages in Cache [...]