VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: fmlk4u on October 01, 2014, 21:45:25 PM

Title: Upgrading VM 2.6.10 to 2.9.9e gives errors
Post by: fmlk4u on October 01, 2014, 21:45:25 PM
After installation I get errors:



        vmError: alterTable CHANGE kbc_virtuemart_product_customfields.customfield_value :
        vmError: alterTable CHANGE kbc_virtuemart_product_customfields.customfield_params : Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs SQL=ALTER TABLE `kbc_virtuemart_product_customfields` CHANGE COLUMN `customfield_value` `customfield_value` VARCHAR(3000) COMMENT 'FIELD VALUE' AFTER `virtuemart_custom_id`
        vmError: Tableupdater updating table kbc_virtuemart_product_customfields throws error Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs SQL=ALTER TABLE `kbc_virtuemart_product_customfields` CHANGE COLUMN `customfield_params` `customfield_params` VARCHAR(17000) NOT NULL DEFAULT '' COMMENT 'PARAM FOR PLUGINS' AFTER `override`

and warnings:

alterTable CHANGE kbc_virtuemart_categories.virtuemart_vendor_id : ALTER TABLE `kbc_virtuemart_categories` CHANGE COLUMN `virtuemart_vendor_id` `virtuemart_vendor_id` SMALLINT(1) UNSIGNED NOT NULL DEFAULT '1' COMMENT 'BELONGS TO VENDOR' AFTER `virtuemart_category_id`
alterTable CHANGE kbc_virtuemart_customs.custom_value : ALTER TABLE `kbc_virtuemart_customs` CHANGE COLUMN `custom_value` `custom_value` VARCHAR(2000) COMMENT 'DEFAULT VALUE' AFTER `custom_tip`
alterTable CHANGE kbc_virtuemart_customs.field_type : ALTER TABLE `kbc_virtuemart_customs` CHANGE COLUMN `field_type` `field_type` CHAR(2) NOT NULL DEFAULT '0' COMMENT 'S:STRING,I:INT,P:PARENT, B:BOOL,D:DATE,T:TIME,H:HIDDEN' AFTER `custom_desc`
alterTable CHANGE kbc_virtuemart_customs.custom_params : ALTER TABLE `kbc_virtuemart_customs` CHANGE COLUMN `custom_params` `custom_params` VARCHAR(17000) NOT NULL DEFAULT '' AFTER `layout_pos`
alterTable CHANGE kbc_virtuemart_customs.shared : ALTER TABLE `kbc_virtuemart_customs` CHANGE COLUMN `shared` `shared` TINYINT(1) NOT NULL DEFAULT '0' COMMENT 'VALID FOR ALL VENDORS?' AFTER `custom_params`
alterTable CHANGE kbc_virtuemart_medias.file_params : ALTER TABLE `kbc_virtuemart_medias` CHANGE COLUMN `file_params` `file_params` VARCHAR(17000) NOT NULL AFTER `file_is_forSale`
alterTable CHANGE kbc_virtuemart_medias.file_lang : ALTER TABLE `kbc_virtuemart_medias` CHANGE COLUMN `file_lang` `file_lang` VARCHAR(500) NOT NULL DEFAULT '' AFTER `file_params`
alterTable CHANGE kbc_virtuemart_orders.virtuemart_vendor_id : ALTER TABLE `kbc_virtuemart_orders` CHANGE COLUMN `virtuemart_vendor_id` `virtuemart_vendor_id` SMALLINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `virtuemart_user_id`
alterTable CHANGE kbc_virtuemart_product_prices.product_price : ALTER TABLE `kbc_virtuemart_product_prices` CHANGE COLUMN `product_price` `product_price` DECIMAL(15,6) AFTER `virtuemart_shoppergroup_id`
alterTable CHANGE kbc_virtuemart_shoppergroups.shopper_group_name : ALTER TABLE `kbc_virtuemart_shoppergroups` CHANGE COLUMN `shopper_group_name` `shopper_group_name` CHAR(128) AFTER `virtuemart_vendor_id`
alterTable CHANGE kbc_virtuemart_shoppergroups.shopper_group_desc : ALTER TABLE `kbc_virtuemart_shoppergroups` CHANGE COLUMN `shopper_group_desc` `shopper_group_desc` CHAR(255) AFTER `shopper_group_name`
Taking config from file

Nevertheless the conclusion text reads install is successful.

In the frontend I see layout problems: compare e.g. the layout of the products list http://keyboard-centrum.nl/nl/winkel/keyboards with http://staging1.keyboard-centrum.nl/nl/winkel/keyboards

and e.g product page: http://keyboard-centrum.nl/nl/winkel/keyboards/gw-8e-gw-8l2013-04-07-20-34-59-detail with http://staging1.keyboard-centrum.nl/nl/winkel/keyboards/gw-8e-gw-8l2013-04-07-20-34-59-detail: title and price below image as if with hard return. Strange tooltip icon in the bottom and youtbe embed plugin not compatible with this VM while the extension is sold via the VM website!

Who can help me further.

Thanks for help, Fred
Title: Re: Upgrading VM 2.6.10 to 2.9.9e gives errors
Post by: jenkinhill on October 01, 2014, 23:22:03 PM
2.9.9e is a late beta (near RC) development/testing version for VM3 and has significant changes in templating from 2.6.x as it makes use of sublayouts meaning that any existing template overrides may need editing. Most plugins have not yet been updated to work with the new version.

Please feel free to test it and report any findings on the Development and Testing board - http://forum.virtuemart.net/index.php?board=136.0