# \[SOLVED\] Upgrade to 3.0.1 - Row size too large - MariaDB 10.5 **URL:** \ **Category:** Mautic 3 - Install/Upgrade Support\ **Created:** [August 3, 2020, 3:34pm UTC](https://forum.mautic.org/t/solved-upgrade-to-3-0-1-row-size-too-large-mariadb-10-5/15495 "2020-08-03T15:34:47Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![maumatic](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/maumatic/32/3284_2.png) [@maumatic](https://forum.mautic.org/u/maumatic)\ **Post date:** [August 3, 2020, 3:34pm UTC](https://forum.mautic.org/t/solved-upgrade-to-3-0-1-row-size-too-large-mariadb-10-5/15495/1 "2020-08-03T15:34:47Z")
**Your software** _My PHP version is_ : 7.3.20 _My MariaDB version is_ : 10.5 Server version: 10.5.4-MariaDB MariaDB Server Client: mysql Ver 15.1 Distrib 10.5.4-MariaDB, for Linux (x86\_64) using readline 5.1 **Updating/Installing Errors** _I am_ : Updating from 2.16.3 to 3.0.1 _Upgrading via_ : Command Line with command “php upgrade\_v3.php --ignore-warnings” as my installation has more than 10000 contacts _These errors are showing in the installer_ : ``` -> ALTER TABLE users DROP online_status ``` Migration 20200211095409 failed during Execution. Error An exception occurred while executing ‘ALTER TABLE users DROP online\_status’: 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 In AbstractMySQLDriver.php line 106: An exception occurred while executing ‘ALTER TABLE users DROP online\_status’: 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 In PDOConnection.php line 80: 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 In PDOConnection.php line 75: 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 _These errors are showing in the Mautic log_ : _These errors are showing in the upgrade\_log.txt file (located in the root of your Mautic instance when an upgrade has been attempted - ensure you remove or redact any sensitive data such as domain names in the file path)_ : Same output there as in the console **Your problem** _My problem is_ : I’m unable to finish the upgrade and I think I’m stuck between version 2 and 3 of Mautic. _Steps I have tried to fix the problem_ : I looked at other “Row size too large” problem reports and it seems the solution was always to upgrade to the latest version of MySQL/MariaDB. I’m running the latest stable version of MariaDB on my system (10.5) but I’m getting this error. Any help is welcome… ---
**Author:** ![maumatic](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/maumatic/32/3284_2.png) [@maumatic](https://forum.mautic.org/u/maumatic)\ **Post date:** [August 3, 2020, 4:57pm UTC](https://forum.mautic.org/t/solved-upgrade-to-3-0-1-row-size-too-large-mariadb-10-5/15495/2 "2020-08-03T16:57:01Z")
After fiddling around I think I fixed the problem. I edited the MariaDB server config file (located in /etc/my.cnf.d/server.cnf) and added those 2 lines: innodb\_log\_file\_size=512M innodb\_strict\_mode=0 This fixed the “Row size too large” error. Now in order to get the upgrade script to run and resume the second stage I had to comment out the lines where it tries to copy files over (line 819 to 847). However once the upgrade script finished some Mautic v3 files were missing. So I downloaded the 3.0.1 Mautic ZIP file [https://github.com/mautic/mautic/releases/download/3.0.1/3.0.1.zip](https://github.com/mautic/mautic/releases/download/3.0.1/3.0.1.zip) and extracted its content in my new Mautic 3 base directory. I got a final bug where my browser was telling me I wasn’t authorized to access my Mautic web site. I fixed this by restoring the .htaccess file from my old Mautic 2 installation in the Mautic 3 base directory. (and then rewrite rules are working and I have Mautic 3 working fine) Good luck everybody, I hope this helps someone hitting the same problems.