News:

Looking for documentation? Take a look on our wiki

Main Menu

VM3 1054 Error

Started by treodude, December 02, 2014, 15:39:00 PM

Previous topic - Next topic

treodude

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

jenkinhill

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.
Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Milbo

Just execute in the tools the "update tables" command. It will also rename the fields.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

treodude

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?