cancel
Showing results for 
Search instead for 
Did you mean: 

Server Migration / Database Problem

damageg
Champ in-the-making
Champ in-the-making
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'
3 REPLIES 3

sujaypillai
Confirmed Champ
Confirmed Champ
Can you please describe the steps you carried out for migration?

mrogers
Star Contributor
Star Contributor
The column is not needed and should have been deleted.

mrogers
Star Contributor
Star Contributor
The column is not needed and should have been deleted.   In the meantime It's only a warning and should not hurt.