cancel
Showing results for 
Search instead for 
Did you mean: 

3.2 Ubuntu package to 3.2r2 Standard package..Is possible?

neozone
Champ in-the-making
Champ in-the-making
Hi, I want to backup from Alfresco Community 3.2 Ubuntu Package restore to Standard Installation "Alfresco-Community-3.2r2-Linux-x86-Install" that I download from http://wiki.alfresco.com/wiki/Download_Alfresco_Community_Network and setting environment from http://wiki.alfresco.com/wiki/Installing_Alfresco_Lab_3_Stable_on_Ubuntu_8.10

I use Backup and Restore procedure from http://wiki.alfresco.com/wiki/Backup_and_Restore
and got error like this
15:56:16,815 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Statement execution failed:
   SQL: CREATE TABLE alf_prop_class
(
   id BIGINT NOT NULL AUTO_INCREMENT,
   java_class_name VARCHAR(255) NOT NULL,
   java_class_name_short VARCHAR(32) NOT NULL,
   java_class_name_crc BIGINT NOT NULL,
   UNIQUE INDEX idx_alf_prop_class_crc (java_class_name_crc, java_class_name_short),
   INDEX idx_alf_prop_class_class (java_class_name),
   PRIMARY KEY (id)
) ENGINE=InnoDB
   Error: Table 'alf_prop_class' already exists
   File: /opt/Alfresco/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-5699059361522429175.sql
   Line: 19
15:56:16,821 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema auto-update failed
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'alf_prop_class' already exists

15:56:16,829 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 11140000 Schema auto-update failed
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'alf_prop_class' already exists

Can it be possible?
And if it possible, How can I do that?
3 REPLIES 3

mikeh
Star Contributor
Star Contributor

neozone
Champ in-the-making
Champ in-the-making
I try config all same from old server, And still get this error

ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema auto-update failed
org.alfresco.error.AlfrescoRuntimeException: 11140054 A previous schema upgrade failed or was not completed.  Revert to the original database before attempting the upgrade again.

neozone
Champ in-the-making
Champ in-the-making
If I install new alfresco 3.2 from http://wiki.alfresco.com/wiki/Community_Edition_file_list
Then, just create site and user. After that, try to upgrade to alfresco 3.2r2 and it work!

I guess, is have something to do with Ubuntu package?