Author Topic: Error updating 3.0.18 to 3.2 Column length too big for column 'cat_params'  (Read 7870 times)

SteP[IT]

  • Jr. Member
  • **
  • Posts: 199
  • Independent Websites Builder
    • MMC Edizioni - Italian Publisher (First Class PaperBooks)
  • VirtueMart Version: 3.4.3
Thanks Milbo, now it works for me
J 3.9.2 - VM 3.4.3

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

RensvN

  • Beginner
  • *
  • Posts: 22
I got the same problem after updating to 3.2.1
Code: [Select]
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]

  • Jr. Member
  • **
  • Posts: 199
  • Independent Websites Builder
    • MMC Edizioni - Italian Publisher (First Class PaperBooks)
  • VirtueMart Version: 3.4.3
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

  • Beginner
  • *
  • Posts: 22
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!

CDCG

  • Beginner
  • *
  • Posts: 16
Thanks.  The updated version works.