How to remove a category from a second language

[Miku]

Hi,
I have multilanguage website (two languages). Not all categories are available for both languages. When we place translation for the second language it appears on the appropriate language. If we don't do that the category isn't visible.. Thus everything was fine till now. I've placed the translation for the second language by mistake and now I'm not able to remove it. I've tried to do this manually by removing appropriate entries in database but with no luck. Specifically I removed appopriate entries from virtuemart_categories_en_gb table (my second language) but even though the name and the description is still visible on the English version of the website . The data derive from my primary language..
What can be wrong?

Probably it has something to do with this thread
http://forum.virtuemart.net/index.php?PHPSESSID=8fj07tpgvvt4m8seidskl08dc4&topic=128379.msg441086#new

[jjk]

Did you clear the cache files in Joomla administration > System > Clear Cache?

[Miku]

Yes, I did. The problem seems to be that if we have untranslated products or categories (we do that by design in order to have product only in one language) the description (the name of the category) is automatically taken over by the second language...

[jjk]

Provided that you did create a Joomla menu for each of your languages and menu items for your categories in each language,  you could simply unpublish your unwanted english language category.

[Miku]

In my case it seems to doesn't matter.  I mean the case when we have categories layout view. So it is a view when we have a collection of categories assign to one menu item. The translated category is still in that view even though I have deleted the appropriate entries from the database and cleared the cache. It's still there taking the data ( the name) from the primary language.

[jjk]

Which versions of Joomla and VM do you use? Also, do you actuallly still use the 'Categories Layout View'? in one of your menus? If so, select the 'Virtuemart Front Page' instead. The 'categories' layout was removed some time last year, but if you have an updated shop, it might still appear in the menu item selection.

[Miku]

I've been using 'Category Layout' with page layout override set to 'categories' ( one of the menu item option)
Additional settings:
Show categories: YES
Show products: NO
J!3.4.1
VM 3.0.7