# Database errors upon installation

**URL:** <https://forum.mautic.org/t/database-errors-upon-installation/20832>\
**Category:** Product Support\
**Tags:** mautic-4\
**Created:** [September 11, 2021, 11:34pm UTC](https://forum.mautic.org/t/database-errors-upon-installation/20832 "2021-09-11T23:34:00Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![randerson](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/randerson/32/4619_2.png) [@randerson](https://forum.mautic.org/u/randerson)\
**Post date:** [September 11, 2021, 11:34pm UTC](https://forum.mautic.org/t/database-errors-upon-installation/20832/1 "2021-09-11T23:34:00Z")

</div>

**Your software**  
My Mautic version is: 4.0  
My PHP version is: 7.4  
My Database type and version is: MySQL version: **5.5.5-10.1.48-MariaDB-1~stretch** through PHP extension **MySQLi**

**Your problem**

Errors during installation.

**These errors are showing in the log:**

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.

**Steps I have tried to fix the problem:**

_I recently signed up for Cloudways hosting and am experiencing database issues while trying to install Mautic. Cloudways support suggested I reach out. Here’s what they said regarding the installation error._

ORIGINAL ERROR:  
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

_Here is the error I got. Please, do note that this comes directly from the application. A quick search on the Internet shows several workarounds. Particularly, something like this:_

ALTER ${table} ROW\_FORMAT=COMPRESSED;

_However, this should be done in the application itself as this is triggered during the installation process. At this point, I would recommend contacting the application developer/vendor about this._

_You have to change some columns to TEXT or BLOBs. I recommend contacting the application developer/vendor in this case_

_This needs to be fixed in the installation script._

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [September 12, 2021, 5:55am UTC](https://forum.mautic.org/t/database-errors-upon-installation/20832/2 "2021-09-12T05:55:01Z")

</div>

You need to use Mariadb 10.5 in my experience.

---

<div class="post-metadata">

**Author:** ![randerson](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/randerson/32/4619_2.png) [@randerson](https://forum.mautic.org/u/randerson)\
**Post date:** [September 12, 2021, 12:33pm UTC](https://forum.mautic.org/t/database-errors-upon-installation/20832/3 "2021-09-12T12:33:30Z")

</div>

Thanks @joeyk! I’ll try it out today and post results.

---

<div class="post-metadata">

**Author:** ![randerson](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/randerson/32/4619_2.png) [@randerson](https://forum.mautic.org/u/randerson)\
**Post date:** [September 12, 2021, 7:35pm UTC](https://forum.mautic.org/t/database-errors-upon-installation/20832/4 "2021-09-12T19:35:04Z")

</div>

I upgraded to Mariadb 10.3 and it worked like a charm! Thank you for the guidance.