topic Upgrade to version 1.3 ERROR in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/upgrade-to-version-1-3-error/m-p/5432#M884 <HTML><HEAD></HEAD><BODY><SPAN>hi alfresco team</SPAN><BR /><BR /><SPAN>I have upgraded ver 1.2.1 to version 1.3</SPAN><BR /><SPAN>but seems there were error when migrate the MySQL content at final insert sql into access_control_entry.</SPAN><BR /><SPAN>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.</SPAN><BR /><BR /><SPAN>I skip that error message and when starting the application I've got error.</SPAN><BR /><SPAN>the error such like this:</SPAN><BR /><SPAN>17:59:04,489 ERROR [tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table child_ass</SPAN><BR /><SPAN>oc add index FKC6EFFF32A0F28D72 (child_protocol, child_identifier, child_guid), ad</SPAN><BR /><SPAN>d constraint FKC6EFFF32A0F28D72 foreign key (child_protocol, child_identifier, chi</SPAN><BR /><SPAN>ld_guid) references node (protocol, identifier, guid)</SPAN><BR /><SPAN>17:59:04,489 ERROR [tool.hbm2ddl.SchemaUpdate] Can't create table '.\alfresco\#sql</SPAN><BR /><SPAN>-9fc_c9.frm' (errno: 150)</SPAN><BR /><SPAN>17:59:04,567 ERROR [tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table child_ass</SPAN><BR /><SPAN>oc add index FKC6EFFF3294135688 (parent_protocol, parent_identifier, parent_guid),</SPAN><BR /><SPAN> add constraint FKC6EFFF3294135688 foreign key (parent_protocol, parent_identifier</SPAN><BR /><SPAN>, parent_guid) references node (protocol, identifier, guid)</SPAN><BR /><SPAN>17:59:04,583 ERROR [tool.hbm2ddl.SchemaUpdate] Can't create table '.\alfresco\#sql</SPAN><BR /><SPAN>-9fc_c9.frm' (errno: 150)</SPAN><BR /><SPAN>May 23, 2006 5:59:20 PM net.sf.joott.uno.UnoConnection connect</SPAN><BR /><BR /><SPAN>So help me to solve this…</SPAN><BR /><SPAN>can I remove the unique constraints or must I look for the duplicate permission on the running application…</SPAN><BR /><SPAN>What is the fastest way?</SPAN><BR /><BR /><SPAN>Thanks and God bless Alfresco</SPAN></BODY></HTML> Tue, 23 May 2006 11:43:33 GMT kun_skywalker 2006-05-23T11:43:33Z Upgrade to version 1.3 ERROR https://connect.hyland.com/t5/alfresco-archive/upgrade-to-version-1-3-error/m-p/5432#M884 hi alfresco teamI have upgraded ver 1.2.1 to version 1.3but 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 Tue, 23 May 2006 11:43:33 GMT https://connect.hyland.com/t5/alfresco-archive/upgrade-to-version-1-3-error/m-p/5432#M884 kun_skywalker 2006-05-23T11:43:33Z Re: Upgrade to version 1.3 ERROR https://connect.hyland.com/t5/alfresco-archive/upgrade-to-version-1-3-error/m-p/5433#M885 <HTML><HEAD></HEAD><BODY><SPAN>We are not using 1.3 yet but this could be relevant for you: </SPAN><A href="http://forums.alfresco.com/viewtopic.php?t=1895" rel="nofollow noopener noreferrer">Announcements: 1.3 preview</A><BR /><BR /><BLOCKQUOTE class="jive-quote">There are database schema changes, so this should only be used on new DB installs: upgrade scripts will become available in the next few days.</BLOCKQUOTE></BODY></HTML> Tue, 23 May 2006 14:31:01 GMT https://connect.hyland.com/t5/alfresco-archive/upgrade-to-version-1-3-error/m-p/5433#M885 simon 2006-05-23T14:31:01Z Re: Upgrade to version 1.3 ERROR https://connect.hyland.com/t5/alfresco-archive/upgrade-to-version-1-3-error/m-p/5434#M886 <HTML><HEAD></HEAD><BODY><SPAN>Thanks Simon…</SPAN><BR /><BR /><SPAN>Sorry for not carefully reading the announcements, okay I will be patient to wait the next release.</SPAN><BR /><BR /><SPAN>Thanks again….</SPAN><BR /><BR /><SPAN>kun</SPAN></BODY></HTML> Wed, 24 May 2006 03:24:53 GMT https://connect.hyland.com/t5/alfresco-archive/upgrade-to-version-1-3-error/m-p/5434#M886 kun_skywalker 2006-05-24T03:24:53Z Re: Upgrade to version 1.3 ERROR https://connect.hyland.com/t5/alfresco-archive/upgrade-to-version-1-3-error/m-p/5435#M887 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>We have released our upgrade information.</SPAN><BR /><SPAN>You can find it here:</SPAN><BR /><A href="http://wiki.alfresco.com/wiki/Upgrading_to_1.3.0" rel="nofollow noopener noreferrer">http://wiki.alfresco.com/wiki/Upgrading_to_1.3.0</A><BR /><BR /><SPAN>Note that this will upgrade you to the current version of the Alfresco Community Preview 1.3 that we have released.</SPAN><BR /><BR /><SPAN>Steve</SPAN></BODY></HTML> Thu, 25 May 2006 09:31:43 GMT https://connect.hyland.com/t5/alfresco-archive/upgrade-to-version-1-3-error/m-p/5435#M887 steve 2006-05-25T09:31:43Z Re: Upgrade to version 1.3 ERROR https://connect.hyland.com/t5/alfresco-archive/upgrade-to-version-1-3-error/m-p/5436#M888 <HTML><HEAD></HEAD><BODY><SPAN>Thanks Steve….</SPAN></BODY></HTML> Fri, 26 May 2006 04:03:46 GMT https://connect.hyland.com/t5/alfresco-archive/upgrade-to-version-1-3-error/m-p/5436#M888 kun_skywalker 2006-05-26T04:03:46Z