On install I get this error.
QuoteError: 1060 Duplicate column name 'custom_desc' SQL=ALTER TABLE `fsfdf_virtuemart_customs` CHANGE COLUMN `custom_field_desc` `custom_desc` char(255) COMMENT 'description or unit'
updating from VM 3.0.0 on J3.3.6
have u tried b4 install the tools-> convert custom fields or install/update tables?
sometimes helps
Similar problem as the other post with the price table. It seems that you had a stopped update process or so. You have still a custom_field_desc (from vm2), even it should be already renamed to custom_desc. But you have custom_desc already there. It tries to rename it again and fails. Please check both columns, you must see yourself which is the one containing all data. Then delete the one with the (mostly) empty values and execute the table updater in the tools again.
Quote from: Milbo on February 01, 2015, 16:19:00 PM
...execute the table updater in the tools again.
which one? "Install or if necessary update tables"?
Quotewhich one? "Install or if necessary update tables"?
yes
when I do that I get this error:
QuoteError: 1060 Duplicate column name 'customfield_value' SQL=ALTER TABLE `fsfdf_virtuemart_product_customfields` CHANGE COLUMN `custom_value` `customfield_value` varchar(2500) COMMENT 'field value'
well then this advice obviously applies again!!!
QuotePlease check both columns, you must see yourself which is the one containing all data. Then delete the one with the (mostly) empty values
your update originally stopped somewhere and left some table fields there that shouldn't be there ..
after another 5 of those it gave me the
QuoteDatabase updated
Maybe the update script should check first if the column does not exist already. And maybe run this script when installing/updating.
normally it runs fine - have done dozens of various migrations, upgrades etc etc
yours stopped some how in the middle.. timeout/lack of resource etc - but normally shouldn't