VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: SteP[IT] on March 30, 2017, 19:28:36 PM

Title: Error upgrading from 3.2.0 to 3.2.1
Post by: SteP[IT] on March 30, 2017, 19:28:36 PM
When upgrading from 3.2.0 to 3.2.1 I get this 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 `#__virtuemart_customs` CHANGE COLUMN `custom_value` `custom_value` VARCHAR(4096) COMMENT 'DEFAULT VALUE' AFTER `custom_tip`

Joomla 3.6.5
PHP 5.6.30-7+deb.sury.org~trusty+1
MySQL 5.5.54-0ubuntu0.14.04.1

It seems to be related to the way MySQL manages tables: should you use text type instead of varchar for long strings?
Title: Re: Error upgrading from 3.2.0 to 3.2.1
Post by: Milbo on March 30, 2017, 22:17:15 PM
The problem is due the new default utf8mb4. A lot db use it also now by default and seem to ignore the one set in the "create table sql".

I reupped the version, because just some downloaded it. So please, just download it again and try with the reupped one. I created all tables with utf8mb4 and removed a lot of this errors, so it should work now.
Title: Re: Error upgrading from 3.2.0 to 3.2.1
Post by: diri on March 31, 2017, 04:25:00 AM
At 1und1 rowsize at mySQL 5.5 is limited to 65535. Altering column size to 3970 works (tbl *_customs).
Title: Re: Error upgrading from 3.2.0 to 3.2.1
Post by: David on March 31, 2017, 05:05:26 AM
Just downloaded and installed 3.2.1 again - the error is still there:
Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs SQL=ALTER TABLE `#__virtuemart_customs` CHANGE COLUMN `custom_value` `custom_value` VARCHAR(4096) COMMENT 'DEFAULT VALUE' AFTER `custom_tip`
Title: Re: Error upgrading from 3.2.0 to 3.2.1
Post by: SteP[IT] on March 31, 2017, 07:47:49 AM
I can confirm the persisting error
Title: Re: Error upgrading from 3.2.0 to 3.2.1
Post by: Milbo on March 31, 2017, 07:49:32 AM
Please join here http://forum.virtuemart.net/index.php?topic=137004.msg479655#msg479655