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 :
https://www.dropbox.com/s/27aq2xv03dkfxos/seblod_update_383.jpg?dl=0
Any idea ?
Hi,
you are right, you should not change core table - please contact your hosting provider if they can help you increase maximum row size in the database.
Hi Klas, thank you for your answer.
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.