# Mautic 3.0 Installation Error - Row size too large **URL:** \ **Category:** Mautic 3 - Install/Upgrade Support\ **Created:** [June 16, 2020, 8:02am UTC](https://forum.mautic.org/t/mautic-3-0-installation-error-row-size-too-large/14801 "2020-06-16T08:02:12Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![malik](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/malik/32/433_2.png) [@malik](https://forum.mautic.org/u/malik)\ **Post date:** [June 16, 2020, 8:02am UTC](https://forum.mautic.org/t/mautic-3-0-installation-error-row-size-too-large/14801/1 "2020-06-16T08:02:12Z")
**Your software** _My PHP version is_ : 7.3 _My MySQL version is_ : 5.6.41-84.1 **Updating/Installing Errors** _Upgrading/installing via_: Web Cpanel _These errors are showing in the installer_ : An error occurred while attempting to add default data: An exception occurred while executing ‘CREATE INDEX instagram\_search ON leads (instagram)’: 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_ : [16-Jun-2020 07:37:42 UTC] PHP Warning: Class ‘Tightenco\Collect\Support\LazyCollection’ not found in [MAUTIC PATH]/vendor/tightenco/collect/src/Collect/Support/alias.php on line 19 [16-Jun-2020 07:37:42 UTC] PHP Parse error: syntax error, unexpected ‘=’ in [MAUTIC PATH]/vendor/tightenco/collect/src/Collect/Support/LazyCollection.php on line 611 **Your problem** _My problem is_ : Not able to install Mautic on my subdomain ---
**Author:** ![silavapi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/silavapi/32/7424_2.png) [@silavapi](https://forum.mautic.org/u/silavapi)\ **Post date:** [June 16, 2020, 8:20am UTC](https://forum.mautic.org/t/mautic-3-0-installation-error-row-size-too-large/14801/2 "2020-06-16T08:20:49Z")
Hi there, Thanks for taking the time to report this, we have seen this in a few cases but they were using MariaDB - are you definitely on MySQL? Can you clarify, version 8.2? Also what collation etc are you using for the database? ---
**Author:** ![malik](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/malik/32/433_2.png) [@malik](https://forum.mautic.org/u/malik)\ **Post date:** [June 16, 2020, 8:27am UTC](https://forum.mautic.org/t/mautic-3-0-installation-error-row-size-too-large/14801/3 "2020-06-16T08:27:20Z")
My bad, upon checking I realized it’s 5.6.41-84.1 ---
**Author:** ![silavapi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/silavapi/32/7424_2.png) [@silavapi](https://forum.mautic.org/u/silavapi)\ **Post date:** [June 16, 2020, 7:34pm UTC](https://forum.mautic.org/t/mautic-3-0-installation-error-row-size-too-large/14801/4 "2020-06-16T19:34:38Z")
What database collation are you using? ---
**Author:** ![EJL](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/ejl/32/12155_2.png) [@EJL](https://forum.mautic.org/u/EJL)\ **Post date:** [June 16, 2020, 10:48pm UTC](https://forum.mautic.org/t/mautic-3-0-installation-error-row-size-too-large/14801/5 "2020-06-16T22:48:44Z")
I had a similar error. Upgrading from Mariadb 10.1.45 to 10.3 solved the issue. ---
**Author:** ![silavapi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/silavapi/32/7424_2.png) [@silavapi](https://forum.mautic.org/u/silavapi)\ **Post date:** [June 16, 2020, 11:36pm UTC](https://forum.mautic.org/t/mautic-3-0-installation-error-row-size-too-large/14801/6 "2020-06-16T23:36:30Z")
> [@EJL](#): > > Upgrading from Mariadb 10.1.45 to 10.3 solved the issue This is what we find, but the OP seems to be using MySQL. Maybe there’s a comparable bug/issue with the related MySQL version? Will do a bit of digging tomorrow! ---
**Author:** ![silavapi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/silavapi/32/7424_2.png) [@silavapi](https://forum.mautic.org/u/silavapi)\ **Post date:** [June 17, 2020, 6:48am UTC](https://forum.mautic.org/t/mautic-3-0-installation-error-row-size-too-large/14801/7 "2020-06-17T06:48:45Z")
@malik you will need to update your MySQL version before you update. **Mautic 3 has a [minimum requirement of MySQL 5.7](https://www.mautic.org/download/requirements)**. See also the [‘what’s new’](https://docs.mautic.org/en/features-by-major-release#hosting-requirements) page on the docs. According to the version compatibility, > [MariaDB 10.2](https://mariadb.com/kb/en/what-is-mariadb-102/), [MariaDB 10.3](https://mariadb.com/kb/en/what-is-mariadb-103/), and [MariaDB 10.4](https://mariadb.com/kb/en/what-is-mariadb-104/) function as limited **drop-in replacements for MySQL 5.7** , as far as [InnoDB](https://mariadb.com/kb/en/innodb/) is concerned. However, the implementation differences continue to grow in each new MariaDB version. > [MariaDB 10.0](https://mariadb.com/kb/en/what-is-mariadb-100/) and [MariaDB 10.1](https://mariadb.com/kb/en/what-is-mariadb-101/) function as limited **drop-in replacements for MySQL 5.6** , as far as [InnoDB](https://mariadb.com/kb/en/innodb/) is concerned. However, there are some implementation differences in some features. Source: [MariaDB versus MySQL - Compatibility - MariaDB Knowledge Base](https://mariadb.com/kb/en/mariadb-vs-mysql-compatibility/) This explains the issue for MariaDB 10.0/10.1 users. ---
**Author:** ![silavapi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/silavapi/32/7424_2.png) [@silavapi](https://forum.mautic.org/u/silavapi)\ **Post date:** [June 17, 2020, 9:35am UTC](https://forum.mautic.org/t/mautic-3-0-installation-error-row-size-too-large/14801/8 "2020-06-17T09:35:51Z")
A post was split to a new topic: [Guide to installing Mautic](https://forum.mautic.org/t/guide-to-installing-mautic/14837) ---
**Author:** ![django](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/django/32/1148_2.png) [@django](https://forum.mautic.org/u/django)\ **Post date:** [June 18, 2020, 5:12pm UTC](https://forum.mautic.org/t/mautic-3-0-installation-error-row-size-too-large/14801/9 "2020-06-18T17:12:50Z")
Hmmmm - this is concerning. I thought that MaridaDB was a 100% drop-in replacement from MySQL. Does this mean that we should ONLY be using MySQL for Mautic installations? We have installed with MariaDB v10.3.22 and it “seems” ok… But we have not yet started to acutally use the software yet 😉 Also as there is no corresponding mathcing numbers between the two RDBMS - how is one to compare? ---
**Author:** ![silavapi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/silavapi/32/7424_2.png) [@silavapi](https://forum.mautic.org/u/silavapi)\ **Post date:** [June 18, 2020, 5:32pm UTC](https://forum.mautic.org/t/mautic-3-0-installation-error-row-size-too-large/14801/10 "2020-06-18T17:32:12Z")
This is a discussion we are having in the [Mautic 3 channel on Slack](https://mautic.slack.com/archives/CPVGZE516/p1592376648193900) - as per the info above it seems they are becoming less a ‘drop in replacement’ as time goes on. We are proposing: - Update the stats app in such way that we can see the amount of MariaDB installations - If a large number of users are using MariaDB, we could consider adding MariaDB to the Travis config (we currently only test against MySQL) so that we are notified automatically if a migration or feature is created that’s incompatible with MariaDB. Travis supports it: [https://docs.travis-ci.com/user/database-setup/#mariadb](https://docs.travis-ci.com/user/database-setup/#mariadb) So we are actively looking into it as a result of this issue. ---
**Author:** ![django](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/django/32/1148_2.png) [@django](https://forum.mautic.org/u/django)\ **Post date:** [June 18, 2020, 5:39pm UTC](https://forum.mautic.org/t/mautic-3-0-installation-error-row-size-too-large/14801/11 "2020-06-18T17:39:57Z")
very interesting - I had no idea! It did not even dawn on me to even THINK about the differences between MySQL and MariaDB…Oh no…!! I would be curious to see those stats too - as I guess most will just go with MariaDB as it is supposed tobe the “right one” and free of the big O’s nasty grip… Ok - but on another tak - software like Nextcloud are “db agnostic” (sort-off) - I am surprised that given the big effort of the V3 re-write - and the proposed move to microservices - that this is hitched to MySQL - epsecially as it’s not exactly the most popular DB these days 😉 Personally i like Pg (PosgreSQL) - a quality database, FOSS, and solid. ---
**Author:** ![dennisameling](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/dennisameling/32/958_2.png) [@dennisameling](https://forum.mautic.org/u/dennisameling)\ **Post date:** [June 22, 2020, 10:41am UTC](https://forum.mautic.org/t/mautic-3-0-installation-error-row-size-too-large/14801/12 "2020-06-22T10:41:44Z")
Can confirm MariaDB 10.2 is the minimum required version for Mautic 3, as it’s basically the same as MySQL 5.7. Versions older than 10.2 are not compatible. For more details, see this reply: > [@Upgrade Error From 2.16.2 to 3.x](https://forum.mautic.org/t/upgrade-error-from-2-16-2-to-3-x/14663/16): > > Thanks for reporting back. We have taken the following steps to improve MariaDB support: [Add MariaDB to our CI testing pipeline](https://github.com/mautic/mautic/pull/8930)[Check for MariaDB 10.2+ (instead of 10.1+) in the Mautic 3 upgrade script](https://github.com/mautic/mautic/issues/8931)[Check if you’re running a supported database version in the clean installation process](https://forum.mautic.org/t/include-database-version-test-in-installer/14872) I will go ahead and close this topic now. If you came across any other issues, please feel free to let us know in a new topic slight_smile ---
**Author:** ![rehansaleem](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/rehansaleem/32/398_2.png) [@rehansaleem](https://forum.mautic.org/u/rehansaleem)\ **Post date:** [August 10, 2020, 8:52pm UTC](https://forum.mautic.org/t/mautic-3-0-installation-error-row-size-too-large/14801/13 "2020-08-10T20:52:44Z")
Hi, I’m installing new instance and having same issue configuring cron jobs on plesk, I’m on Mysql 5.7 and PHP7.2, I have also tried PHP7.3 and its producing same error. Any suggestions? Thanks. ---
**Author:** ![rol](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/rol/32/510_2.png) [@rol](https://forum.mautic.org/u/rol)\ **Post date:** [August 14, 2020, 3:32pm UTC](https://forum.mautic.org/t/mautic-3-0-installation-error-row-size-too-large/14801/14 "2020-08-14T15:32:53Z")
Hi @rehansaleem, Were you able to solve this? What is your version of Mautic installed? ---
**Author:** ![silavapi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/silavapi/32/7424_2.png) [@silavapi](https://forum.mautic.org/u/silavapi)\ **Post date:** [August 14, 2020, 3:36pm UTC](https://forum.mautic.org/t/mautic-3-0-installation-error-row-size-too-large/14801/15 "2020-08-14T15:36:33Z")
The row size too large error occurs when the incorrect database version is being used. You’ll need to update your database if you’re seeing this error (see the solution in the first thread). ---
**Author:** ![henryweismann](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/henryweismann/32/3125_2.png) [@henryweismann](https://forum.mautic.org/u/henryweismann)\ **Post date:** [August 16, 2020, 11:13am UTC](https://forum.mautic.org/t/mautic-3-0-installation-error-row-size-too-large/14801/16 "2020-08-16T11:13:10Z")
Hi @rehansaleem, We had this issue too but moving to php 7.2 fixed it. Which version of php 7.2.x are you on that you still get the error? See this: > [@Errors with Cron jobs after updating to Mautic 3](https://forum.mautic.org/t/errors-with-cron-jobs-after-updating-to-mautic-3/15016/12): > > I had this too: [16-Aug-2020 10:08:00 UTC] PHP Warning: Class ‘Tightenco\Collect\Support\LazyCollection’ not found in …/vendor/tightenco/collect/src/Collect/Support/alias.php on line 19 [16-Aug-2020 10:08:00 UTC] PHP Parse error: syntax error, unexpected ‘=’ in …/vendor/tightenco/collect/src/Collect/Support/LazyCollection.php on line 611 It was because MAUTIC requires PHP 7.2 and even though I had upgraded an htaccess setting had it at 7.0 still. I also got a memory error after that was … You might want to confirm your PHP version a phpinfo() file in the root if you can’t access the server details in the settings area of Mautic. (Also you may need to disable htaccess to load the phpinfo php file in the root as the htaccess routes all requests to index) Also if it is the right version make don’t assume its the same error causing the 500 error…make sure the error did not change to a memory error. ---
**Author:** ![rehansaleem](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/rehansaleem/32/398_2.png) [@rehansaleem](https://forum.mautic.org/u/rehansaleem)\ **Post date:** [August 16, 2020, 11:33am UTC](https://forum.mautic.org/t/mautic-3-0-installation-error-row-size-too-large/14801/17 "2020-08-16T11:33:41Z")
Hi @henryweismann on Plesk I selected to run the cronjob as PHP and chose the PHP 7.2 to run the command which solved the issue. Thanks. ---
**Author:** ![henryweismann](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/henryweismann/32/3125_2.png) [@henryweismann](https://forum.mautic.org/u/henryweismann)\ **Post date:** [August 16, 2020, 11:57am UTC](https://forum.mautic.org/t/mautic-3-0-installation-error-row-size-too-large/14801/18 "2020-08-16T11:57:08Z")
Actually @silavapi I know why this might happen. Your install script replaces the .htaccess file with a newer version. Some hosts have a multi php feature that allows changing the php version in the htaccess file and in those cases as soon as the upgrade is done bam you get the 500 error because the code (something like this): ``` # php -- BEGIN cPanel-generated handler, do not edit # Set the “ea-php72” package as the default “PHP” programming language. AddType application/x-httpd-ea-php72 .php .php7 .phtml ``` `# php -- END cPanel-generated handler, do not edit` Is deleted. Now I don’t know if this is something you need to handle or not but maybe it should be mentioned in the install docs or the install script compatibility check? ---
**Author:** ![silavapi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/silavapi/32/7424_2.png) [@silavapi](https://forum.mautic.org/u/silavapi)\ **Post date:** [August 16, 2020, 1:02pm UTC](https://forum.mautic.org/t/mautic-3-0-installation-error-row-size-too-large/14801/19 "2020-08-16T13:02:45Z")
@dennisameling this might be something to include in the issue you have open about improving the install/upgrade process. ---
**Author:** ![malik](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/malik/32/433_2.png) [@malik](https://forum.mautic.org/u/malik)\ **Post date:** [August 27, 2020, 1:09pm UTC](https://forum.mautic.org/t/mautic-3-0-installation-error-row-size-too-large/14801/20 "2020-08-27T13:09:07Z")
Thanks for the help @silavapi, I was not using the appropriate database version [Next page](https://forum.mautic.org/t/mautic-3-0-installation-error-row-size-too-large/14801.md?page=2)