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…

 

 

Joomla Virtuemart – Warning, the Safe Path is not accessible

I am setting up a new virtumart store and got some errors I needed to work through, so I am documenting them so I don’t forget these setting again.

ERROR: “Warning, the Safe Path is not accessible (does not exist or no permission), for safety reasons it is very important to create a folder in a path not accessible by an URL, create also a folder invoices in it to store your sensitive data secure. Our suggested path is for your system home/user/name the directory/, use this link to the config”

This YouTube video helped me get this part resolved.

 

The next error was: “vmError: The path for invoices seems to miss the correct file permissions Safe Path /” and the path was my Safe Path I just fixed.

This will fix itself when you re-save the configuration, because it will add the folder called “invoices” if it didn’t exist.

I hope this helps someone else out there…