AnsweredAssumed Answered

Server Migration / Database Problem

Question asked by damageg on Jan 20, 2015
Latest reply on Jan 21, 2015 by mrogers
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

thanks in advance for any ideas.

### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'activity_format' in 'field list'
### The error may involve alfresco.activities.insert.insert_activity_feed-Inline
### The error occurred while setting parameters
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'activity_format' in 'field list'
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'activity_format' in 'field list'
   at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:233)
   at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
   at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:71)
   at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:346)
   at $Proxy5.insert(Unknown Source)
   at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:231)
   at org.alfresco.repo.domain.activities.ibatis.ActivityFeedDAOImpl.insertFeedEntry(ActivityFeedDAOImpl.java:37)
   at org.alfresco.repo.activities.feed.local.LocalFeedTaskProcessor.insertFeedEntry(LocalFeedTaskProcessor.java:184)
   at org.alfresco.repo.activities.feed.FeedTaskProcessor.process(FeedTaskProcessor.java:394)
   at org.alfresco.repo.activities.feed.local.LocalFeedGridJob.execute(LocalFeedGridJob.java:51)
   at org.alfresco.repo.activities.feed.local.LocalFeedGenerator.generate(LocalFeedGenerator.java:96)
   at org.alfresco.repo.activities.feed.AbstractFeedGenerator.execute(AbstractFeedGenerator.java:179)
   at org.alfresco.repo.activities.feed.FeedGeneratorJob.execute(FeedGeneratorJob.java:50)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'activity_format' in 'field list'

Outcomes