How To Find and Remove Invalid Pages in Translator 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 the invalid pages in translator cache and remove them 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 count(*) FROM `wp_atpp_page_cache` WHERE url like ‘%?p%’
SELECT count(*) FROM `wp_atpp_page_cache` WHERE url LIKE ‘%?%’
SELECT url FROM `wp_atpp_page_cache` WHERE url LIKE ‘http://%//%’
and you are done.
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
