# Mautic update to 2.0

**URL:** <https://forum.mautic.org/t/mautic-update-to-2-0/3909>\
**Category:** Product Support\
**Created:** [July 7, 2016, 6:38pm UTC](https://forum.mautic.org/t/mautic-update-to-2-0/3909 "2016-07-07T18:38:17Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![menolo](https://avatars.discourse-cdn.com/v4/letter/m/eb8c5e/32.png) [@menolo](https://forum.mautic.org/u/menolo)\
**Post date:** [July 7, 2016, 6:38pm UTC](https://forum.mautic.org/t/mautic-update-to-2-0/3909/1 "2016-07-07T18:38:17Z")

</div>

I’m trying to update mautic 1.4.1 to 2.0  
  
  
  
Working through SSH I get an error updating the schema update. It seems to error on a custom field called “taal”.

Code:

php app/console doctrine:schema:update --force Updating database schema...

[DoctrineDBALExceptionDriverException]  
An exception occurred while executing ‘CREATE INDEX masoe\_taal\_search ON masoe\_leads (taal)’:  
SQLSTATE[42000]: Syntax error or access violation: 1170 BLOB/TEXT column ‘taal’ used in key sp  
ecification without a key length

[DoctrineDBALDriverPDOException]  
SQLSTATE[42000]: Syntax error or access violation: 1170 BLOB/TEXT column ‘taal’ used in key sp  
ecification without a key length

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

---

<div class="post-metadata">

**Author:** ![menolo](https://avatars.discourse-cdn.com/v4/letter/m/eb8c5e/32.png) [@menolo](https://forum.mautic.org/u/menolo)\
**Post date:** [July 7, 2016, 6:48pm UTC](https://forum.mautic.org/t/mautic-update-to-2-0/3909/2 "2016-07-07T18:48:42Z")

</div>

After deleting this custom field the schema updates again. It’s not a field I’m using anyways.

I do have some other mautic instances using custom field. I’m a bit careful updating these now…

---

<div class="post-metadata">

**Author:** ![menolo](https://avatars.discourse-cdn.com/v4/letter/m/eb8c5e/32.png) [@menolo](https://forum.mautic.org/u/menolo)\
**Post date:** [July 7, 2016, 6:38pm UTC](https://forum.mautic.org/t/mautic-update-to-2-0/3909/3 "2016-07-07T18:38:17Z")

</div>

I’m trying to update mautic 1.4.1 to 2.0

Working through SSH I get an error updating the schema update. It seems to error on a custom field called “taal”.

[code]php app/console doctrine:schema:update --force Updating database schema…

[DoctrineDBALExceptionDriverException]  
An exception occurred while executing ‘CREATE INDEX masoe\_taal\_search ON masoe\_leads (taal)’:  
SQLSTATE[42000]: Syntax error or access violation: 1170 BLOB/TEXT column ‘taal’ used in key sp  
ecification without a key length

[DoctrineDBALDriverPDOException]  
SQLSTATE[42000]: Syntax error or access violation: 1170 BLOB/TEXT column ‘taal’ used in key sp  
ecification without a key length

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