143 Posts
Stef
8 years ago
3
Topic

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 ?

Get a Book for SEBLOD
4229 Posts
Kadministrator
8 years ago
0
Level 1

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.

143 Posts
Stef
8 years ago
1
Level 1

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) :

  1. I opened PHPMyAdmin
  2. Went to table "#__cck_core_fields"
  3. Went to field "description"
  4. changed it from VARCHAR to TEXT
  5. 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)
  6. Went to my Joomla Administration > Instal Component
  7. Installed back Seblod 3.8.3 : NO MORE ERROR MESSAGE
  8. Plus, this last instal have apparently convert back the "description" field from TEXT to MEDIUMTEXT
  9. 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 ?

4229 Posts
Kadministrator
8 years ago
0
Level 2

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.

Get a Book for SEBLOD