[Forum] How to clean up custom phrases left by uninstalled products?

[AbdullahSZ]

There are way too many of unused phrases. Is there a way to delete them with few clicks?

Thanks.

[Sebastiano Vassellatti]

Can you please tell me which is the fieldname of each phrase group that contains the phrases you want to remove? (For example, "adv_gallery" for the phrase group displayed in your screenshot)

[AbdullahSZ]

adv_gallery
adv_gallery_cp
adv_gallery_ecard
adv_gallery_showimg
adv_gallery_upload
adv_portal_cp

There's a phrase type that is empty, no fieldname or anything. How can I delete the empty one and the blank ones?

[Sebastiano Vassellatti]

Backup your database first. Then go in Maintenance -> Execute SQL Query -> Manual Query.
Run these queries:

DELETE FROM phrase WHERE languageid='0' AND fieldname='adv_gallery'
DELETE FROM phrase WHERE languageid='0' AND fieldname='adv_gallery_cp'
DELETE FROM phrase WHERE languageid='0' AND fieldname='adv_gallery_ecard'
DELETE FROM phrase WHERE languageid='0' AND fieldname='adv_gallery_showimg'
DELETE FROM phrase WHERE languageid='0' AND fieldname='adv_gallery_upload'
DELETE FROM phrase WHERE languageid='0' AND fieldname='adv_portal_cp'

There's a phrase type that is empty, no fieldname or anything. How can I delete the empty one and the blank ones?

If you delete all the phrases that belong to this phrase group, the phrase group itself should disappear. However if there is no filedname for this phrase group I think you cannot remove them with a query, but you will need to delete all the phrases of this phrase group manually.

[AbdullahSZ]

Great! It did remove all phrases but not the phrase type.

What about the ones inside GLOBAL?

[Sebastiano Vassellatti]

Great! It did remove all phrases but not the phrase type.

You can then try with these queries to remove also those phrase types:

DELETE FROM phrasetype WHERE fieldname='adv_gallery'
DELETE FROM phrasetype WHERE fieldname='adv_gallery_cp'
DELETE FROM phrasetype WHERE fieldname='adv_gallery_ecard'
DELETE FROM phrasetype WHERE fieldname='adv_gallery_showimg'
DELETE FROM phrasetype WHERE fieldname='adv_gallery_upload'
DELETE FROM phrasetype WHERE fieldname='adv_portal_cp'

If the phrase type that has not been deleted is the one that had no field name, you can try with:

DELETE FROM phrasetype WHERE fieldname=''

This should work.

What about the ones inside GLOBAL?

I think you should manually delete the phrases you want to delete. The GLOBAL phrase group also contains the phrase you created with thread prefixes and notices (if you have created some of them), so you can't use a query like the ones above because it would delete these phrases too.

[AbdullahSZ]

The blanks ones are gone now . Thank you!

The empty one goes by vBadvanced CMPS. I tried the following but didn't work.

DELETE FROM phrasetype WHERE fieldname='vBadvanced CMPS'

[Sebastiano Vassellatti]

Try this:

DELETE FROM phrasetype WHERE title='vBadvanced CMPS'

[AbdullahSZ]

I added a new phrase to it which made the fieldname appear (sneaky).

Try this:

DELETE FROM phrasetype WHERE title='vBadvanced CMPS'

It worked.

Thank you very much Darkshenron!