News:

Support the VirtueMart project and become a member

Main Menu

error update to 3.0.4

Started by carsten888, January 30, 2015, 08:20:53 AM

Previous topic - Next topic

carsten888

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

GJC Web Design

have u tried b4 install the tools-> convert custom fields or install/update tables?
sometimes helps
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

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.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

carsten888

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"?

GJC Web Design

Quotewhich one? "Install or if necessary update tables"?
yes
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

carsten888

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'

GJC Web Design

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 ..
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

carsten888

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.

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
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation