I recently updated virtumart in a Joomla 3.6.5 site and got the following error.
1054 Unknown column ‘product_stockhandle’ in ‘field list’ SQL=UPDATE `#__virtuemart_products` SET `virtuemart_vendor_id`=’1′,
It was longer than that, but I needed to fix the site so I don’t the rest would help. I could be wrong.
My last back up was too long ago. I was kind of screwed.
I restored the backup in a close directory on the production server. It was on https so I couldn’t do it localhost. I exported all the virtuemart tables in one MySQL statement by selecting “custom” when exporting. I did have to move the images/stories/virtumart directory. After that the store was operating normally. I made a backup before doing anything else.
I used FTP and copied the components/virtumart directory over to the site that had issue; however, this didn’t fix the issue. Not sure what broke.
I hope this helps someone else out there…