AnsweredAssumed Answered

Upgrade to version 1.3 ERROR

Question asked by kun_skywalker on May 23, 2006
Latest reply on May 26, 2006 by kun_skywalker
hi alfresco team

I have upgraded ver 1.2.1 to version 1.3
but seems there were error when migrate the MySQL content at final insert sql into access_control_entry.
I recognize that the table of access_control_entry need unique of acl_id, permission_id, authority_id, however I have duplicate of that keys in T_access_control_entry.

I skip that error message and when starting the application I've got error.
the error such like this:
17:59:04,489 ERROR [tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table child_ass
oc add index FKC6EFFF32A0F28D72 (child_protocol, child_identifier, child_guid), ad
d constraint FKC6EFFF32A0F28D72 foreign key (child_protocol, child_identifier, chi
ld_guid) references node (protocol, identifier, guid)
17:59:04,489 ERROR [tool.hbm2ddl.SchemaUpdate] Can't create table '.\alfresco\#sql
-9fc_c9.frm' (errno: 150)
17:59:04,567 ERROR [tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table child_ass
oc add index FKC6EFFF3294135688 (parent_protocol, parent_identifier, parent_guid),
add constraint FKC6EFFF3294135688 foreign key (parent_protocol, parent_identifier
, parent_guid) references node (protocol, identifier, guid)
17:59:04,583 ERROR [tool.hbm2ddl.SchemaUpdate] Can't create table '.\alfresco\#sql
-9fc_c9.frm' (errno: 150)
May 23, 2006 5:59:20 PM net.sf.joott.uno.UnoConnection connect

So help me to solve this…
can I remove the unique constraints or must I look for the duplicate permission on the running application…
What is the fastest way?

Thanks and God bless Alfresco

Outcomes