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)
