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?