Error on execute doctrine:schema:update --force

[skrosoft]

Hi,

It's imposible for me to install the table jasperreport_report_history

This is the error:

 [Doctrine\DBAL\Exception\DriverException]                                                                                                                                                     
  An exception occurred while executing 'CREATE TABLE jasperreport_report_history (id INT AUTO_INCREMENT NOT NULL, date DATETIME NOT NULL, parameters LONGTEXT DEFAULT NULL, requestId LONGTEX  
  T NOT NULL, report_uri LONGTEXT NOT NULL, username LONGTEXT NOT NULL, status LONGTEXT NOT NULL, formats LONGTEXT NOT NULL, UNIQUE INDEX UNIQ_79FD097CA1637001 (requestId), PRIMARY KEY(id))   
  DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB':                                                                                                                          
  SQLSTATE[42000]: Syntax error or access violation: 1170 BLOB/TEXT column 'requestId' used in key specification without a key length 

Someone else had this error in July 2016 and had no answer: http://es.stackoverflow.com/questions/8785/c%C3%B3mo-emplear-jasper-report-en-symfony-2

Vincent

[vanclei]

Change the ReportingHistory.orm.yml -> requestId -> type from text to string and it works :-)