VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: danielll on April 25, 2016, 11:21:32 AM

Title: old products appearing on site but not in administrator (after reinstalling)
Post by: danielll on April 25, 2016, 11:21:32 AM
Hi please, few day ago I had to reinstall virtuemart, and after that, the products that Ive had there stayed there, but cant find it in administrator/VM/products... So right now I have it only on my site but not in administrator so I dont know how to remove/edit them. Ive tried to delete pictures and that doesnt work. I also made new ones so I have to delete them old ones..
Here is screenshot (old ones are 3 on the up) : https://gyazo.com/ba611dae6ba9e12e33af3e5b45674268
here is screen of administrator/products : https://gyazo.com/ce9a2aaceadf8e9d9cb8b51841585491
site is www.reachtraning.com
As you can see on the second screenshot, I just have there my 2 new products .. :/
Can you please help me? THANKS a lot for help!
Title: Re: old products appearing on site but not in administrator (after reinstalling)
Post by: GJC Web Design on April 25, 2016, 11:28:58 AM
normally language related - i.e. no entry in the product lang table

in the screen u have a mix of languages.. check your lang setup etc

look in the DB tables for what product lang tables u have
Title: Re: old products appearing on site but not in administrator (after reinstalling)
Post by: danielll on April 25, 2016, 13:18:09 PM
Please where can I check lang setup? and DB tables you mean in FTP or where? Sorry im new to those things. Although thanks for reply!
Title: Re: old products appearing on site but not in administrator (after reinstalling)
Post by: GJC Web Design on April 25, 2016, 13:32:33 PM
via your hosting control panel.. for basic questions like this google is your friend
Title: Re: old products appearing on site but not in administrator (after reinstalling)
Post by: danielll on April 25, 2016, 14:46:19 PM
so I have there otxk_virtuemart_manufacturercategories_sk_sk  and  otxk_virtuemart_manufacturercategories_en_gb ... should I delete sk?
Title: Re: old products appearing on site but not in administrator (after reinstalling)
Post by: GJC Web Design on April 25, 2016, 16:22:43 PM
I wouldn't delete anything at this stage

your looking for product tables .. not manufactuers

check there are entries in both tables for each product id
Title: Re: old products appearing on site but not in administrator (after reinstalling)
Post by: danielll on April 26, 2016, 11:43:37 AM
So otxk_virtuemart_products_en_gb has the 2 new ones (what I want).. and otxk_virtuemart_products_sk_sk has the other bad ones (I want to delete).. So what to do now? .. I deleted it from ...sk and it does not work.. it still appears on the site :/..
Title: Re: old products appearing on site but not in administrator (after reinstalling)
Post by: Jörgen on April 26, 2016, 11:51:17 AM
Hello

The Products appear with their language specific data int these table: virtuemart_products_xx_xx, but the original data is stored in the table: virtuemart_products, without any language appendice. You should also delete them from that table.

Check first that You find the correct products, before deleting.

regards

Jörgen @ Kreativ Fotografi
Title: Re: old products appearing on site but not in administrator (after reinstalling)
Post by: danielll on April 26, 2016, 12:47:49 PM
Thanks for help guys! Problem solved!

Really appritiate the help! Have a nice day :)
Title: Re: old products appearing on site but not in administrator (after reinstalling)
Post by: Jörgen on April 26, 2016, 12:57:11 PM
Nice to be of help :)

regards

Jörgen @ Kreativ Fotografi