Warning on update from 3.9.15 to 3.9.16 Topic is solved

[dyfrig]

When I updated a site to Joomla 3.9.16 I had a warning.

JInstaller: :Install: Error SQL 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
Files Update: SQL error file DB function failed with error number 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

SQL =
ALTER TABLE `#__ucm_content` MODIFY `core_body` mediumtext;

However the update did seem to complete. Is this something I need to worry about?



FPA details below

Warning on update from 3.9.15 to 3.9.16

Joomla! Instance :: Joomla! 3.9.16-Stable (Amani) 10-March-2020
Joomla! Platform :: Joomla Platform 13.1.0-Stable (Curiosity) 24-Apr-2013
Joomla! Configured :: Yes | Read-Only (444) | Owner: --protected-- . (uid: 1/gid: 1) | Group: --protected-- (gid: 1) | Valid For: 3.9
Configuration Options :: Offline: false | SEF: true | SEF Suffix: false | SEF ReWrite: true | .htaccess/web.config: Yes | GZip: true | Cache: true | CacheTime: 15 | CacheHandler: file | CachePlatformPrefix: true | FTP Layer: false | Proxy: false | LiveSite: | Session lifetime: 15 | Session handler: database | Shared sessions: false | SSL: 2 | Error Reporting: none | Site Debug: false | Language Debug: false | Default Access: 1 | Unicode Slugs: true | dbConnection Type: mysqli | PHP Supports J! 3.9.16: Yes | Database Supports J! 3.9.16: Yes | Database Credentials Present: Yes |

Host Configuration :: OS: Linux | OS Version: 2.6.32-954.3.5.lve1.4.61.el6.x86_64 | Technology: x86_64 | Web Server: LiteSpeed | Encoding: gzip, deflate, br | Doc Root: --protected-- | System TMP Writable: Yes | Free Disk Space : 80.32 GiB |

PHP Configuration :: Version: 7.2.28 | PHP API: litespeed | Session Path Writable: Yes | Display Errors: | Error Reporting: 32767 | Log Errors To: error_log | Last Known Error: | Register Globals: | Magic Quotes: | Safe Mode: | Allow url fopen: 1 | Open Base: | Uploads: 1 | Max. Upload Size: 128M | Max. POST Size: 128M | Max. Input Time: -1 | Max. Execution Time: 60 | Memory Limit: 128M

Database Configuration :: Version: 10.2.27-MariaDB (Client:10.2.27) | Host: --protected-- (--protected--) | default Collation: latin1_swedish_ci (default Character Set: latin1) | Database Size: 35.49 MiB | #of Tables:  201

PHP Extensions :: Core (7.2.28) | date (7.2.28) | libxml (7.2.28) | openssl (7.2.28) | pcre (7.2.28) | sqlite3 (7.2.28) | zlib (7.2.28) | bz2 (7.2.28) | calendar (7.2.28) | ctype (7.2.28) | curl (7.2.28) | hash (1.0) | filter (7.2.28) | ftp (7.2.28) | gettext (7.2.28) | gmp (7.2.28) | SPL (7.2.28) | iconv (7.2.28) | pcntl (7.2.28) | readline (7.2.28) | Reflection (7.2.28) | session (7.2.28) | standard (7.2.28) | shmop (7.2.28) | SimpleXML (7.2.28) | mbstring (7.2.28) | tokenizer (7.2.28) | xml (7.2.28) | litespeed () | bcmath (7.2.28) | dba (7.2.28) | dom (20031129) | enchant (7.2.28) | fileinfo (1.0.5) | gd (7.2.28) | imap (7.2.28) | intl (1.1.0) | json (1.6.0) | ldap (7.2.28) | exif (7.2.28) | mysqli (7.2.28) | mysqlnd (mysqlnd 5.0.12-dev - 20150407 - $Id: 3591daad22de08524295e1bd073aceeff11e6579 $) | odbc (7.2.28) | PDO (7.2.28) | pdo_mysql (7.2.28) | PDO_ODBC (7.2.28) | pdo_sqlite (7.2.28) | Phar (2.0.2) | posix (7.2.28) | pspell (7.2.28) | soap (7.2.28) | tidy (7.2.28) | timezonedb (2019.3) | wddx (7.2.28) | xmlreader (7.2.28) | xmlrpc (7.2.28) | xmlwriter (7.2.28) | xsl (7.2.28) | zip (1.15.4) | Zend Engine (3.2.0) |
Potential Missing Extensions ::

Switch User Environment (Experimental) :: PHP CGI: No | Server SU: No | PHP SU: No | Custom SU (LiteSpeed/Cloud/Grid): Yes
Potential Ownership Issues: No

Core Folders :: images/ (755) | components/ (755) | modules/ (755) | plugins/ (755) | language/ (755) | templates/ (755) | cache/ (755) | logs/ (---) | tmp/ (755) | administrator/components/ (755) | administrator/modules/ (755) | administrator/language/ (755) | administrator/templates/ (755) | administrator/logs/ (755) |

Elevated Permissions (First 10) :: downloads/Adnoddau/Canolradd/ (775) | downloads/Adnoddau/Mynediad/ (775) | downloads/Adnoddau/Mynediad/Mynediad 1/ (775) | downloads/Adnoddau/Mynediad/Mynediad 1/Adnoddau Hen Gwrs Popeth Cymraeg/ (775) | downloads/Adnoddau/Mynediad/Mynediad 2/ (775) | downloads/Adnoddau/Mynediad/Mynediad 2/Adnoddau PC Cwrs Mynediad 2 Cenedlaethol/ (775) | downloads/Adnoddau/Mynediad/Mynediad 2/Adnoddau PC Cwrs Mynediad 2 Cenedlaethol/Uned 16/ (775) | downloads/Adnoddau/Sylfaen/ (775) | downloads/Adnoddau/Sylfaen/Adnoddau r Cwrs Sylfaen Newydd/ (775) | downloads/Adnoddau/Uwch/ (775) |

Database statistics :: Uptime: 3155753 | Threads: 24 | Questions: 5036074719 | Slow queries: 855 | Opens: 6859686 | Flush tables: 145 | Open tables: 70000 | Queries per second avg: 1595.839 |

Components :: SITE ::
Core :: com_mailto (3.0.0) 1 | com_wrapper (3.0.0) 1 |
3rd Party:: WF_FILESYSTEM_JOOMLA_TITLE (2.8.9) ? | WF_LINK_SEARCH_TITLE (2.8.9) ? | FLEXIcontent Links (2.3.0-rc) ? | WF_LINKS_JOOMLALINKS_TITLE (2.8.9) ? | WF_AGGREGATOR_VIDEO_TITLE (2.8.9) ? | WF_AGGREGATOR_DAILYMOTION_TITLE (2.8.9) ? | WF_AGGREGATOR_[youtube]_TITLE (2.8.9) ? | WF_AGGREGATOR_AUDIO_TITLE (2.8.9) ? | WF_AGGREGATOR_VIMEO_TITLE (2.8.9) ? | WF_POPUPS_JCEMEDIABOX_TITLE (2.8.9) ? | WF_CONTEXTMENU_TITLE (2.8.9) ? | WF_ANCHOR_TITLE (2.8.9) ? | WF_FORMATSELECT_TITLE (2.8.9) ? | WF_VISUALCHARS_TITLE (2.8.9) ? | WF_MEDIAMANAGER_TITLE (2.8.9) ? | WF_FULLSCREEN_TITLE (2.8.9) ? | WF_CLEANUP_TITLE (2.8.9) ? | JCE - Columns (1.0.0) ? | WF_FONTSIZESELECT_TITLE (2.8.9) ? | WF_HELP_TITLE (2.8.9) ? | WF_XHTMLXTRAS_TITLE (2.8.9) ? | WF_IMGMANAGER_TITLE (2.8.9) ? | WF_CHARMAP_TITLE (2.8.9) ? | WF_TEXTPATTERN_TITLE (2.8.9) ? | WF_EMOTIONS_TITLE (2.8.9) ? | WF_PRINT_TITLE (2.8.9) ? | WF_FONTSELECT_TITLE (2.8.9) ? | WF_TABLE_TITLE (2.8.9) ? | WF_HR_TITLE (2.8.9) ? | WF_LAYER_TITLE (2.8.3) ? | WF_LISTS_TITLE (2.8.9) ? | WF_SPELLCHECKER_TITLE (2.8.9) ? | WF_STYLE_TITLE (2.8.9) ? | WF_SOURCE_TITLE (2.8.9) ? | WF_MICRODATA_TITLE (2.8.9) ? | WF_AUTOSAVE_TITLE (2.8.9) ? | WF_DIRECTIONALITY_TITLE (2.8.9) ? | WF_ARTICLE_TITLE (2.8.9) ? | WF_LINK_TITLE (2.8.9) ? | WF_MEDIA_TITLE (2.8.9) ? | WF_KITCHENSINK_TITLE (2.8.9) ? | WF_TEMPLATEMANAGER_TITLE (2.8.9) ? | WF_CAPTION_TITLE (2.8.9) ? | WF_WORDCOUNT_TITLE (2.8.9) ? | WF_BROWSER_TITLE (2.8.9) ? | WF_FILEMANAGER_TITLE (2.8.9) ? | WF_TEXTCASE_TITLE (2.8.9) ? | WF_SEARCHREPLACE_TITLE (2.8.9) ? | WF_FONTCOLOR_TITLE (2.8.9) ? | WF_IFRAME_TITLE (2.8.9) ? | WF_CLIPBOARD_TITLE (2.8.9) ? | JCE - Noneditable (1.0.0) ? | WF_NONBREAKING_TITLE (2.8.9) ? | WF_VISUALBLOCKS_TITLE (2.8.9) ? | WF_IMGMANAGER_EXT_TITLE (2.8.9) ? | WF_STYLESELECT_TITLE (2.8.9) ? | WF_PREVIEW_TITLE (2.8.9) ? |

Components :: ADMIN ::
Core :: com_languages (3.0.0) 1 | com_login (3.0.0) 1 | com_admin (3.0.0) 1 | com_content (3.0.0) 1 | com_tags (3.1.0) 1 | com_weblinks (3.7.0) 1 | com_postinstall (3.2.0) 1 | com_newsfeeds (3.0.0) 1 | com_redirect (3.0.0) 1 | com_media (3.0.0) 1 | com_users (3.0.0) 1 | com_plugins (3.0.0) 1 | com_menus (3.0.0) 1 | com_templates (3.0.0) 1 | com_config (3.0.0) 1 | com_fields (3.7.0) 1 | com_search (3.0.0) 1 | com_messages (3.0.0) 1 | com_privacy (3.9.0) 1 | com_categories (3.0.0) 1 | com_modules (3.0.0) 1 | com_banners (3.0.0) 1 | com_actionlogs (3.9.0) 1 | com_ajax (3.2.0) 1 | com_associations (3.7.0) 1 | com_checkin (3.0.0) 1 | com_cache (3.0.0) 1 | com_contenthistory (3.2.0) 1 | com_joomlaupdate (3.6.2) 1 | com_installer (3.0.0) 1 | com_finder (3.0.0) 1 | com_cpanel (3.0.0) 1 |
3rd Party:: COM_JCE (2.8.9) 1 | com_localise (4.0.35-dev) 1 | COM_SHACKARTICLEMANAGER (1.0.2) 1 | com_shackspreadsheets (1.2.0) 1 | COM_SHACKFORMS (4.0.24) 1 | Akeeba (7.0.2) 1 | com_regularlabsmanager (7.4.4) 1 | com_osmeta (1.4.9) 1 | com_jDownloads (3.2.66) 1 | COM_OSMAP (4.2.28) 1 |

Modules :: SITE ::
Core :: mod_search (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_random_image (3.0.0) 1 | mod_banners (3.0.0) 1 | mod_footer (3.0.0) 1 | mod_finder (3.0.0) 1 | mod_articles_news (3.0.0) 1 | mod_tags_similar (3.1.0) 1 | mod_articles_category (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_articles_archive (3.0.0) 1 | mod_tags_popular (3.1.0) 1 | mod_login (3.0.0) 1 | mod_related_items (3.0.0) 1 | mod_stats (3.0.0) 1 | mod_languages (3.5.0) 1 | mod_articles_categories (3.0.0) 1 | mod_breadcrumbs (3.0.0) 1 | mod_articles_popular (3.0.0) 1 | mod_whosonline (3.0.0) 1 | mod_articles_latest (3.0.0) 1 | mod_wrapper (3.0.0) 1 | mod_weblinks (3.7.0) 1 | mod_syndicate (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_users_latest (3.0.0) 1 |
3rd Party:: DJ-MegaMenu (4.0.0) 1 | jDownloads Top (3.2.38) 1 | jDownloads Tree (3.2.38) 1 | jDownloads Stats (3.2.31) 1 | jDownloads Most Recently Downloaded (3.2.38) 1 | jDownloads Latest (3.2.38) 1 | jDownloads Rated (3.2.42) 1 | jDownloads Last Updated (3.2.38) 1 | MOD_PWEBCONTACT (4.0.24) 1 | jDownloads View Limits (3.2.53) 1 | jDownloads Featured (3.2.45) 1 | DJ-MegaMenu - Mobile Menu Button (3.7.0) 1 | jDownloads Related (3.2.66) 1 |

Modules :: ADMIN ::
Core :: mod_feed (3.0.0) 1 | mod_title (3.0.0) 1 | mod_submenu (3.0.0) 1 | mod_latestactions (3.9.0) 1 | mod_latest (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_login (3.0.0) 1 | mod_multilangstatus (3.0.0) 1 | mod_logged (3.0.0) 1 | mod_privacy_dashboard (3.9.0) 1 | mod_quickicon (3.0.0) 1 | mod_stats_admin (3.0.0) 1 | mod_version (3.0.0) 1 | mod_status (3.0.0) 1 | mod_popular (3.0.0) 1 | mod_sampledata (3.8.0) 1 | mod_menu (3.0.0) 1 | mod_toolbar (3.0.0) 1 |
3rd Party:: jDownloads admin stats (3.2.46) 1 |

Libraries ::
Core ::
3rd Party:: file_fof30 (3.5.1) ? | Regular Labs Library (20.2.10719) 1 |

Plugins ::
Core :: plg_captcha_recaptcha_invisible (3.8) 0 | plg_captcha_recaptcha (3.4.0) 1 | plg_search_categories (3.0.0) 1 | plg_search_weblinks (3.7.0) 0 | plg_search_contacts (3.0.0) 1 | plg_search_newsfeeds (3.0.0) 1 | plg_search_content (3.0.0) 1 | plg_search_tags (3.0.0) 1 | plg_authentication_gmail (3.0.0) 0 | plg_authentication_joomla (3.0.0) 1 | plg_authentication_ldap (3.0.0) 0 | plg_authentication_cookie (3.0.0) 1 | plg_extension_joomla (3.0.0) 1 | plg_user_terms (3.9.0) 0 | plg_user_profile (3.0.0) 0 | plg_user_joomla (3.0.0) 1 | plg_user_contactcreator (3.0.0) 0 | plg_system_cache (3.0.0) 1 | plg_system_p3p (3.0.0) 0 | plg_system_sessiongc (3.8.6) 1 | plg_system_log (3.0.0) 1 | plg_system_languagecode (3.0.0) 1 | plg_system_weblinks (3.7.0) 0 | plg_system_logrotation (3.9.0) 1 | plg_system_privacyconsent (3.9.0) 0 | plg_system_sef (3.0.0) 1 | plg_system_debug (3.0.0) 1 | plg_system_languagefilter (3.0.0) 1 | plg_system_redirect (3.0.0) 1 | plg_system_stats (3.5.0) 1 | plg_system_highlight (3.0.0) 1 | PLG_SYSTEM_ACTIONLOGS (3.9.0) 0 | plg_system_remember (3.0.0) 1 | plg_system_fields (3.7.0) 0 | plg_system_logout (3.0.0) 1 | plg_system_updatenotification (3.5.0) 1 | PLG_ACTIONLOG_JOOMLA (3.9.0) 1 | plg_twofactorauth_totp (3.2.0) 0 | plg_twofactorauth_yubikey (3.2.0) 0 | plg_quickicon_joomlaupdate (3.0.0) 1 | plg_quickicon_privacycheck (3.9.0) 1 | plg_quickicon_phpversioncheck (3.7.0) 0 | plg_quickicon_extensionupdate (3.0.0) 1 | plg_installer_webinstaller (2.0.1) 1 | plg_installer_packageinstaller (3.6.0) 1 | PLG_INSTALLER_FOLDERINSTALLER (3.6.0) 1 | PLG_INSTALLER_URLINSTALLER (3.6.0) 1 | plg_finder_categories (3.0.0) 1 | plg_finder_weblinks (3.7.0) 0 | plg_finder_contacts (3.0.0) 1 | plg_finder_newsfeeds (3.0.0) 1 | plg_finder_content (3.0.0) 1 | plg_finder_tags (3.0.0) 1 | plg_privacy_message (3.9.0) 1 | plg_privacy_consents (3.9.0) 1 | plg_privacy_user (3.9.0) 1 | plg_privacy_actionlogs (3.9.0) 1 | plg_privacy_content (3.9.0) 1 | plg_editors-xtd_menu (3.7.0) 0 | plg_editors-xtd_module (3.5.0) 0 | plg_editors-xtd_readmore (3.0.0) 1 | plg_editors-xtd_pagebreak (3.0.0) 1 | plg_editors-xtd_article (3.0.0) 1 | plg_editors-xtd_image (3.0.0) 1 | plg_editors-xtd_weblink (3.7.0) 0 | plg_editors-xtd_fields (3.7.0) 0 | plg_content_loadmodule (3.0.0) 1 | plg_content_joomla (3.0.0) 1 | plg_content_pagebreak (3.0.0) 1 | plg_content_vote (3.0.0) 1 | plg_content_confirmconsent (3.9.0) 0 | plg_content_pagenavigation (3.0.0) 1 | plg_content_finder (3.0.0) 1 | plg_content_emailcloak (3.0.0) 1 | plg_content_fields (3.7.0) 1 | plg_fields_color (3.7.0) 1 | plg_fields_text (3.7.0) 1 | plg_fields_sql (3.7.0) 1 | plg_fields_integer (3.7.0) 1 | plg_fields_calendar (3.7.0) 1 | plg_fields_textarea (3.7.0) 1 | plg_fields_user (3.7.0) 1 | plg_fields_list (3.7.0) 1 | plg_fields_checkboxes (3.7.0) 1 | plg_fields_imagelist (3.7.0) 1 | plg_fields_media (3.7.0) 1 | plg_fields_radio (3.7.0) 1 | plg_fields_editor (3.7.0) 1 | plg_fields_usergrouplist (3.7.0) 1 | plg_fields_url (3.7.0) 1 | plg_fields_repeatable (3.9.0) 1 |
3rd Party:: plg_search_jdownloads (3.2.32) 0 | plg_extension_jce (2.8.9) 1 | plg_system_osmylicensesmanager (1.3.2) 1 | plg_system_modulesanywhere (7.9.0) 1 | plg_system_djmegamenu (3.6.0) 1 | plg_system_ef4_jmframework (4.8.5) 1 | plg_system_jce (2.8.9) 1 | PLG_SYSTEM_BACKUPONUPDATE (7.0.2) 1 | AcyMailing: override Joomla mailing (5.7.0) ? | plg_system_regularlabs (20.2.10719) 1 | plg_system_jdownloads (3.2.42) 1 | System - OSMeta Renderer (1.4.9) 1 | PLG_SYSTEM_AKEEBAUPDATECHECK (7.0.2) 1 | plg_system_ossystem (1.3.0) 1 | PLG_ACTIONLOG_AKEEBABACKUP (7.0.2) 0 | plg_actionlog_regularlabsmanager (7.4.4) 1 | plg_quickicon_akeebabackup (7.0.2) 1 | plg_quickicon_jce (2.8.9) 1 | OSMap - WebLinks Plugin (4.2.28) 0 | OSMap - Kunena Plugin (4.2.28) 0 | PLG_OSMAP_JOOMLA (4.2.28) 1 | OSMAP_PLUGIN_K2 (4.2.28) 0 | OSMap - Virtuemart Plugin (4.2.28) 0 | OSMap - SobiPro Plugin (4.2.28) 0 | OSMap - Mosets Tree Plugin (4.2.28) 0 | plg_editors_codemirror (5.40.0) 1 | plg_editors_jce (2.8.9) 1 | plg_editors_tinymce (4.5.11) 1 | plg_installer_jce (2.8.9) 1 | jDownloads Example (3.2) 0 | plg_editors-xtd_modulesanywhere (7.9.0) 1 | plg_editors-xtd_shackspreadsheets (1.2.0) 1 | Button - jDownloads Content (3.2.60) 1 | plg_content_jdownloads_tags_fix (3.2.61) 1 | plg_content_jce (2.8.9) 1 | Content - OSMeta Content (1.4.9) 1 | Content - jDownloads (3.2.42) 1 | plg_fields_mediajce (2.8.9) 1 | K2 - OSMeta K2 (1.4.9) 0 |

Templates :: SITE :: protostar (1.0) ? | jm-university (1.1.7) 1 | beez3 (3.1.0) ? | js_wright (3.7.11) 1 |
Templates :: ADMIN :: isis (1.0) 1 | hathor (3.0.0) ? |

[Webdongle]

Fix your file Permissions
Then
Extensions >> Manage >>> Database

Make a backup

Then download Joomla! 3.9.16 Upgrade Package (.zip) https://downloads.joomla.org/cms/joomla ... format=zip
Next
Components >>> Joomla update ... Upload&Update (tab) ... upload and install the update package.

[Webdongle]

Found this https://docs.joomla.org/J3.x:Duplicate_ ... date_issue

[Per Yngve Berg]

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

[dyfrig]

Thanks Webdongle. I had already fixed the database as you suggest. I have now reapplied the update and the error did not manifest itself so I assume everything is now OK.

Thanks for all other suggestions.

[cloakendagger28]

Had a similar issue when I upgraded from 3.8.x to 3.9.22

When I went to fix the database I got this same error.

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

I fixed it by going into the content table, and changing column "attribs" to TEXT. I guess that column was set to Varchar with a value over 5100.

Then went back to the admin and the database fix went through just fine.

Hope this helps.