Hi Virtue Forum,
Recently I updated to VM3 with Joomla 3.3.6, but I encountered the error 1054, when trying to visit VM in the frontend.
Through mysql I imported stuff like products from a different website, which was still running VM 2.6.10. Backend everything works fine.
Please check it out yourself http://aircopomponline.nl/index.php/webshop
http://aircopomponline.nl/ (When you click here on "Webshop" you'll go to VM)
Any ideas what I could have done wrong?
Kind regards,
Treodude
Database error, VM3 has the field custom_desc in the table ###_virtuemart_customs and is looking for it in your db. But the custom_desc field is not used in VM2.x and since you just copied the db from VM2 to VM3 then an error results.
The original site must be upgraded to VM3 before importing the database as the VM3 installer converts the 2.x db to the new 3.0 format.
Just execute in the tools the "update tables" command. It will also rename the fields.
Hi there,
I tried doing so, but it gave me the following error after having pressed the button
"1060 Duplicate column name 'product_price_publish_up' SQL=ALTER TABLE `airco_virtuemart_product_prices` CHANGE COLUMN `product_price_vdate` `product_price_publish_up` DATETIME NULL DEFAULT NULL AFTER `product_currency`"
Just go back to VM2 and start from there again perhaps?