title: MySQL - Error 1118 Row size too large (> 8126) - No access to sql-config
body: <p>I know this question is asked a lot and I also found a lot advice, but none that is practicable for me. My website is hostet on siteground.com. Everything works fine so far and suddenly I got </p>
  
  <blockquote>
    <p>Error: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.</p>
  </blockquote>
  
  <p>on a "random" basis. </p>
  
  <p>Actually my whole website (joomla 3.7.4 / PHP 7.0.22 /sql-server:  5.6.36-82.1-log - Percona Server (GPL), Release 82.1, Revision 1a00d79) with lot of custom code isn't usable anymore because of this.</p>
  
  <p>Now I understand that this has something to do with the total Row size, but as an database and php-amateur I still don't get it. </p>
  
  <ul>
  <li>Are there too much colums in one row, or is there too much Data in
  the columns? </li>
  <li>What ist ment by "Row size too large (> 8126)"?    Currently there
  are 81 Columns per row and according to phpMyAdmin    the whole table
  needs 32KiB of Data, 16KiB of Index and alltogether    48 KiB. If I
  look at other Tables of the Joomla-System this is a    pretty small
  amount of Data <em>(consisting out of serialized arrays,    some text and
  thats it)</em></li>
  <li>Why do this issue come "over-night" - there was no update or any changes on db-strukture from my side.</li>
  <li>How can I determine or see the actual Row size, so I can "try" arround to fit the db-settings needs?</li>
  </ul>
  
  <p>Can I do something about that problem? Or am I "stranded" if the hoster can't or won't changed something in the settings?</p>
  
  <p>What I have done so far:</p>
  
  <p>Since I have no access to server-settings I startet to limit all "int" and "char". After no effect I startet to change all Typs to "medium-txt" and "tiny-txt". In round #3 I changed all Typs to "txt", but also no changed result. I additionally converted all <code>utf8_general_ci</code> to <code>utf8mb4_general_ci</code>. Basically I did all I could find but no successs. </p>
  
  <p>As you can read out of the above text I'm like a blind guy lost in the woods who    desperate tries everything without any expertise behind, to solve that issue.</p>
  
  <p>Adittional Info <em>(akkording to phpMyAdmin)</em>: </p>
  
  <ul>
  <li><code>innodb log file size = 128MiB</code> </li>
  <li><code>innodb_strict_mode = OFF</code></li>
  <li><code>Tabel-Typ = InnoDB</code></li>
  </ul>
  
  <p>Any help would be appreciated. Either in possible solutions or understanding of the actuall issue iteself. Thx in advanced!</p>