Wednesday, December 12, 2018

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…

 

 

0 Comments

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>