News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

Error updating 3.0.18 to 3.2 Column length too big for column 'cat_params'

Started by Capogr, March 23, 2017, 12:47:13 PM

Previous topic - Next topic

SteP[IT]

J 3.9.2 - VM 3.4.3

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

RensvN

I got the same problem after updating to 3.2.1
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`

As far as I can see my shop is still working.
How harmfull is this error, does it affect my webshop?

SteP[IT]

Did you try to re-download VM and reinstall it? Milbo made a patch that should solve it.
J 3.9.2 - VM 3.4.3

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

RensvN

Oh I'm sorry, Forgot to check.

I saw the last version was still 3.2.1 so I thought there was no update anymore.

I tried to re-download and it looks like the problem is solved now.

Thanks a lot!