Hi Seblod, I'm updating from a Seblod 3.7.2 to 3.8.3.
I get the message :
"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 `#__cck_core_fields` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;"
I have read on your blog that i can solve this by changing some field from VARCHAR to TEXT. But __cck_core_fields is one of Core Seblod table. And as I'm not a pro of MySQL i just don't know wich row to change. For info, I have never changed anything in that table. Here's for info a screenshot of the structure table :
I have ask to my Host Provider (SiteGround) who had a look. After some try of increasing "Max Row", he came back, asking me to go back to you to get more infos... So what I did and works apparently (for those who may be interested) :
I opened PHPMyAdmin
Went to table "#__cck_core_fields"
Went to field "description"
changed it from VARCHAR to TEXT
Converted my table to utf8mb4_unicode_ci with a SQL query : ALTER TABLE `#__cck_core_fields` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; (becareful to change the prefix of your table)
Went to my Joomla Administration > Instal Component
Installed back Seblod 3.8.3 : NO MORE ERROR MESSAGE
Plus, this last instal have apparently convert back the "description" field from TEXT to MEDIUMTEXT
Test = Work = a happy Stef :-)
Could you just confirm that the field "description" is now correct ? I have tried about all test possible and every thingds seems to work. Or just your advice ?
Default type after conversion for this column is varchar(5120), but mediumtext shoud work fine as only difference is place where it is stored, varchars are stored in a row and since marginally faster and texts are stored elsewhere so they don't count towards row size.