error update to 3.0.4

[carsten888]

On install I get this error.

Error: 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

[GJC Web Design]

have u tried b4 install the tools-> convert custom fields or install/update tables?
sometimes helps

[Milbo]

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.

[carsten888]

...execute the table updater in the tools again.

which one? "Install or if necessary update tables"?

[GJC Web Design]

which one? "Install or if necessary update tables"?

yes

[carsten888]

when I do that I get this error:

Error: 1060 Duplicate column name 'customfield_value' SQL=ALTER TABLE `fsfdf_virtuemart_product_customfields` CHANGE COLUMN `custom_value`  `customfield_value` varchar(2500) COMMENT 'field value'

[GJC Web Design]

well then this advice obviously applies again!!!

Please 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 ..

[carsten888]

after another 5 of those it gave me the

Database updated

Maybe the update script should check first if the column does not exist already. And maybe run this script when installing/updating.

[GJC Web Design]

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