topic Server Migration / Database Problem in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/server-migration-database-problem/m-p/287185#M240315 <HTML><HEAD></HEAD><BODY><SPAN>I'm moving my alfresco 4.2.c installation from one server to another and it appears to be working but I'm getting the following error in my catalina.out log</SPAN><BR /><BR /><SPAN>thanks in advance for any ideas.</SPAN><BR /><BR /><SPAN>### Error updating database.&nbsp; Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'activity_format' in 'field list'</SPAN><BR /><SPAN>### The error may involve alfresco.activities.insert.insert_activity_feed-Inline</SPAN><BR /><SPAN>### The error occurred while setting parameters</SPAN><BR /><SPAN>### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'activity_format' in 'field list'</SPAN><BR /><SPAN>; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'activity_format' in 'field list'</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:233)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:71)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:346)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at $Proxy5.insert(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:231)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.activities.ibatis.ActivityFeedDAOImpl.insertFeedEntry(ActivityFeedDAOImpl.java:37)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.activities.feed.local.LocalFeedTaskProcessor.insertFeedEntry(LocalFeedTaskProcessor.java:184)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.activities.feed.FeedTaskProcessor.process(FeedTaskProcessor.java:394)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.activities.feed.local.LocalFeedGridJob.execute(LocalFeedGridJob.java:51)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.activities.feed.local.LocalFeedGenerator.generate(LocalFeedGenerator.java:96)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.activities.feed.AbstractFeedGenerator.execute(AbstractFeedGenerator.java:179)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.activities.feed.FeedGeneratorJob.execute(FeedGeneratorJob.java:50)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.quartz.core.JobRunShell.run(JobRunShell.java:216)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)</SPAN><BR /><SPAN>Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'activity_format' in 'field list'</SPAN><BR /></BODY></HTML> Tue, 20 Jan 2015 03:54:46 GMT damageg 2015-01-20T03:54:46Z Server Migration / Database Problem https://connect.hyland.com/t5/alfresco-archive/server-migration-database-problem/m-p/287185#M240315 I'm moving my alfresco 4.2.c installation from one server to another and it appears to be working but I'm getting the following error in my catalina.out logthanks in advance for any ideas.### Error updating database.&nbsp; Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column ' Tue, 20 Jan 2015 03:54:46 GMT https://connect.hyland.com/t5/alfresco-archive/server-migration-database-problem/m-p/287185#M240315 damageg 2015-01-20T03:54:46Z Re: Server Migration / Database Problem https://connect.hyland.com/t5/alfresco-archive/server-migration-database-problem/m-p/287186#M240316 <HTML><HEAD></HEAD><BODY><SPAN>Can you please describe the steps you carried out for migration?</SPAN><BR /><BR /></BODY></HTML> Tue, 20 Jan 2015 17:49:11 GMT https://connect.hyland.com/t5/alfresco-archive/server-migration-database-problem/m-p/287186#M240316 sujaypillai 2015-01-20T17:49:11Z Re: Server Migration / Database Problem https://connect.hyland.com/t5/alfresco-archive/server-migration-database-problem/m-p/287187#M240317 <HTML><HEAD></HEAD><BODY><SPAN>The column is not needed and should have been deleted.</SPAN></BODY></HTML> Wed, 21 Jan 2015 10:46:33 GMT https://connect.hyland.com/t5/alfresco-archive/server-migration-database-problem/m-p/287187#M240317 mrogers 2015-01-21T10:46:33Z Re: Server Migration / Database Problem https://connect.hyland.com/t5/alfresco-archive/server-migration-database-problem/m-p/287188#M240318 <HTML><HEAD></HEAD><BODY><SPAN>The column is not needed and should have been deleted.&nbsp;&nbsp; In the meantime It's only a warning and should not hurt.</SPAN></BODY></HTML> Wed, 21 Jan 2015 10:47:37 GMT https://connect.hyland.com/t5/alfresco-archive/server-migration-database-problem/m-p/287188#M240318 mrogers 2015-01-21T10:47:37Z