Text only | Text with Images

VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: 0Drax0 on July 21, 2016, 11:19:51 AM

Title: VM3.0.17.2 MySQL error 1118 after update tables
Post by: 0Drax0 on July 21, 2016, 11:19:51 AM
After update from 3.0.6.2 and while running update tables in the db tool I get the following error:

1118 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_products_nl_nl` CHANGE COLUMN `customtitle` `customtitle` VARCHAR(255) NOT NULL DEFAULT '' AFTER `metakey`

Site seems to be working fine, but I have not tested all functionality in depth yet.

Title: Re: VM3.0.17.2 MySQL error 1118 after update tables
Post by: Jumbo! on July 21, 2016, 12:16:25 PM
How many products do you have in the site?
Title: Re: VM3.0.17.2 MySQL error 1118 after update tables
Post by: 0Drax0 on July 21, 2016, 13:02:31 PM
1810 products
Title: Re: VM3.0.17.2 MySQL error 1118 after update tables
Post by: Milbo on July 21, 2016, 19:56:12 PM
It has nothing todo with it. Please use directly the 3.0.17.4 http://dev.virtuemart.net/projects/virtuemart/files and just execute the tool "update tables,..."
Text only | Text with Images