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]