Phoca Forum

The following error pops up, after trying to update to 3.5:

SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
Paket Aktualisierung: Bei der Installation der Erweiterung trat ein Fehler auf: com_phocacart_v3.5.0.zip

any ideas ?

thanks

Hi, can you paste a screenshots of the error? Where do you get this error? When you update the component? Where did you update it? If in Joomla! extension manager, try to enable debug mode in your global configuration to get more info. It seems like it is some error message coming directly from database when Joomla! tries to write some info about the extension.

Which webhosting server do you use? When I google such error, it somehow comes e.g. on siteground hostings:

stackoverflow.com/questions/45681365/mysql-error-1118-row-size-too-large-8126-no-access-to-sql-config
joomlapolis.com/forum/153-professional-member-support/237990-database-error-message-1118-row-size-too-large

Maybe support on webhosting can somehow help

Jan

Well issue is described here:

https://mariadb.com/kb/en/troubleshooti ... th-innodb/

After altering all tables, the issue is solved.

Hi, great to hear it and thank you for the info.

Jan