php - MySQL - Error 1118 Row size too large (> 8126) - No access to sql-config -
i know question asked lot , found lot advice, none practicable me. website hostet on siteground.com. works fine far , got
error: 1118 row size large (> 8126). changing columns text or blob or using row_format=dynamic or row_format=compressed may help. in current row format, blob prefix of 768 bytes stored inline.
on "random" basis.
actually 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) lot of custom code isn't usable anymore because of this.
now understand has total row size, database , php-amateur still don't it.
- are there colums in 1 row, or there data in columns?
- what ist ment "row size large (> 8126)"? there 81 columns per row , according phpmyadmin whole table needs 32kib of data, 16kib of index , alltogether 48 kib. if @ other tables of joomla-system pretty small amount of data (consisting out of serialized arrays, text , thats it)
- why issue come "over-night" - there no update or changes on db-strukture side.
- how can determine or see actual row size, can "try" arround fit db-settings needs?
can problem? or "stranded" if hoster can't or won't changed in settings?
what have done far:
since have no access server-settings startet limit "int" , "char". after no effect startet change typs "medium-txt" , "tiny-txt". in round #3 changed typs "txt", no changed result. additionally converted utf8_general_ci
utf8mb4_general_ci
. did find no successs.
as can read out of above text i'm blind guy lost in woods desperate tries without expertise behind, solve issue.
adittional info (akkording phpmyadmin):
innodb log file size = 128mib
innodb_strict_mode = off
tabel-typ = innodb
any appreciated. either in possible solutions or understanding of actuall issue iteself. thx in advanced!
have mysql documentation row size limit here: https://dev.mysql.com/doc/refman/5.7/en/column-count-limit.html might useful.
Comments
Post a Comment