Mautic Community Forums

Mautic update to 2.0

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

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…

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]