VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: duncan12 on October 14, 2015, 00:35:38 AM

Title: All products and categories have disappeared!
Post by: duncan12 on October 14, 2015, 00:35:38 AM
 :o
I had hundreds of products across dozens of categories. They are all now gone. I have no products. I have no categories.

What did I do? I went into virtuemart Configuration => Language Settings => Multi Lingual Shop, and selected English (there was nothing selected before.)

I have tried to unselect it, but it can't be done. All my data is wiped out. I've gone into phpMyAdmin and repaired tables... no luck.

Virtuemart 3.0.10
Title: Re: All products and categories have disappeared!
Post by: duncan12 on October 14, 2015, 00:39:39 AM
Poking around in the database, I can see that the categories are listed in a table called: virtuemart_categories_en_us

So they are still there, but virtuemart doesn't see them for some reason?
Title: Re: All products and categories have disappeared!
Post by: duncan12 on October 14, 2015, 00:54:20 AM
OK. I got my products back, but WOW, what an unexpected disaster/detour. Here's the solution:

I went into the database and found the table called virtuemart_configs. I edited it... it has virtually all of your VM settings is a massive text file. one part of the text file says "active_languages=["en-GB"]" I tried deleting that. Didn't work. So I edited it and changed it to "en-US". All of my categories and products came back, I think.
Title: Re: All products and categories have disappeared!
Post by: GJC Web Design on October 14, 2015, 10:42:12 AM
in the admin was there two "English" i.e. gb & us?  Is it a labelling problem?
Title: Re: All products and categories have disappeared!
Post by: Milbo on October 14, 2015, 12:50:00 PM
This is also described in the manual

http://docs.virtuemart.net/manual/general-concepts/218-installation-updating.html

and a FAQ http://docs.virtuemart.net/faqs/113-products-vanished.html