News:

Support the VirtueMart project and become a member

Main Menu

Error upgrading from 3.2.0 to 3.2.1

Started by SteP[IT], March 30, 2017, 19:28:36 PM

Previous topic - Next topic

SteP[IT]

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?
J 3.9.2 - VM 3.4.3

MMC EDIZIONI - Italian High-Quality PaperBooks Publisher
Site: https://www.mmcedizioni.it

Milbo

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

diri

At 1und1 rowsize at mySQL 5.5 is limited to 65535. Altering column size to 3970 works (tbl *_customs).

David

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`
Joomla 3.8.3, VirtueMart 3.4.2

SteP[IT]

#4
I can confirm the persisting error
J 3.9.2 - VM 3.4.3

MMC EDIZIONI - Italian High-Quality PaperBooks Publisher
Site: https://www.mmcedizioni.it

Milbo

Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/