old products appearing on site but not in administrator (after reinstalling)

Started by danielll, April 25, 2016, 11:21:32 AM

Previous topic - Next topic

danielll

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!

GJC Web Design

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
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

danielll

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!

GJC Web Design

via your hosting control panel.. for basic questions like this google is your friend
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

danielll

so I have there otxk_virtuemart_manufacturercategories_sk_sk  and  otxk_virtuemart_manufacturercategories_en_gb ... should I delete sk?

GJC Web Design

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
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

danielll

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 :/..

Jörgen

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
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

danielll

Thanks for help guys! Problem solved!

Really appritiate the help! Have a nice day :)

Jörgen

Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.