AnsweredAssumed Answered

MYSql problem while upgrading to Alfresco 3.2

Question asked by breandanose on Jul 30, 2009
Latest reply on Jul 31, 2009 by mikeh
Hello,

Just wondering has anyone had problems like this before while upgrading from Alfresco 3stable Community to Alfresco 3.2 Community?

Error: Can't create table 'alfresco.alf_content_data' (errno: 150)


See exception details below:


11:52:46,474  ERROR [domain.schema.SchemaBootstrap] Statement execution failed:
   SQL: CREATE TABLE alf_content_data
(
   id BIGINT NOT NULL AUTO_INCREMENT,
   version BIGINT NOT NULL,
   content_url_id BIGINT NULL,
   content_mimetype_id BIGINT NULL,
   content_encoding_id BIGINT NULL,
   content_locale_id BIGINT NULL,
   CONSTRAINT fk_alf_cont_url FOREIGN KEY (content_url_id) REFERENCES alf_content_url (id),
   CONSTRAINT fk_alf_cont_mim FOREIGN KEY (content_mimetype_id) REFERENCES alf_mimetype (id),
   CONSTRAINT fk_alf_cont_enc FOREIGN KEY (content_encoding_id) REFERENCES alf_encoding (id),
   CONSTRAINT fk_alf_cont_loc FOREIGN KEY (content_locale_id) REFERENCES alf_locale (id),
   PRIMARY KEY (id)
) ENGINE=InnoDB
   Error: Can't create table 'alfresco.alf_content_data' (errno: 150)
   File: C:\Alfresco\tomcat\temp\Alfresco\AlfrescoSchema-MySQLInnoDBDialect-Upda
te-17993.sql

   Line: 56
11:52:46,489  ERROR [domain.schema.SchemaBootstrap] Schema auto-update failed
java.sql.SQLException: Can't create table 'alfresco.alf_content_data' (errno: 150)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)

Outcomes