179 Posts
carin
7 years ago
Topic

Updating from 3.7.2 to 3.8.1 gives:


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 `#__cck_store_item_content` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; Package Install: There was an error installing an extension: plg_content_cck.zip

Any hint how to solve that? cheers

Get a VIP membership
4229 Posts
Kadministrator
7 years ago
1
Level 1

This can be basically fixed in 2 ways:

increase server limits

or

  • change your table columns types - most usually what needs to be chaged is that varchar columns are converted to text before you attempt upgrade.

Don't forget to backup before doing any changes!

179 Posts
carin
7 years ago
0
Level 2

Thanks, converting some fields to text helped.

Get a VIP membership