# Database Schema Update Error

**URL:** <https://forum.mautic.org/t/database-schema-update-error/10764>\
**Category:** Product Support\
**Created:** [October 20, 2018, 7:35am UTC](https://forum.mautic.org/t/database-schema-update-error/10764 "2018-10-20T07:35:32Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ahfauth](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/ahfauth/32/133_2.png) [@ahfauth](https://forum.mautic.org/u/ahfauth)\
**Post date:** [October 20, 2018, 7:35am UTC](https://forum.mautic.org/t/database-schema-update-error/10764/1 "2018-10-20T07:35:32Z")

</div>

I have updated Mautic from 2.13 to 2.14.1. I’m trying to make sure my database schema is up to date but I’m getting the following error:

php app/console doctrine:schema:update --force

Updating database schema…

[Doctrine\DBAL\Exception\DriverException]  
An exception occurred while executing ‘CREATE INDEX companywebsite\_search ON companies (companywebsite)’:

SQLSTATE[42000]: Syntax error or access violation: 1170 BLOB/TEXT column ‘companywebsite’ used in key specification without a key length

[Doctrine\DBAL\Driver\PDOException]  
SQLSTATE[42000]: Syntax error or access violation: 1170 BLOB/TEXT column ‘companywebsite’ used in key specification without a key length

[PDOException]  
SQLSTATE[42000]: Syntax error or access violation: 1170 BLOB/TEXT column ‘companywebsite’ used in key specification without a key length

Could someone help?

---

<div class="post-metadata">

**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:** [October 17, 2019, 4:33pm UTC](https://forum.mautic.org/t/database-schema-update-error/10764/2 "2019-10-17T16:33:15Z")

</div>