From time to time I do a fresh Liferay and/or Social Office Installation for demonstration purposes in preparation for customer pre-sales pitches. Last time, three weeks ago everything worked like a charm. But now I'm unable to set up a brand new Liferay 6.1.1 CE2 Liferay Installation with Social Office. I tried it several times on different machines today. What I did today was:
- created a brand new DB schema in MySQL
- Installed a fresh Liferay 6.1.1 CE2 Tomcat Bundle
- created a portal-ext.properties file to use the new DB Schema
- deleted welcome-theme and resources-importer-web from Web-apps folder
- fired up Liferay and gone through the initial setup process
- went to control panel and downloaded social office
- installed social office
- saw several exceptions in tomcats log file
Results:
- no changes in the Liferay tool bar
- the SO theme is available, Login Page has been changed, but the "default social office site" site template is empty
Problems seem to have been started here in the logs:
119:21:23,954 ERROR [pool-2-thread-2][JDBCExceptionReporter:76] Incorrect string value: '\xE4\xB8\xBB\xE9\xA1\xB5...' for column 'name' at row 1
219:21:23,960 ERROR [pool-2-thread-2][InstanceUtil:78] com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
3com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
4 at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:193)
5...
6...
I've attached the whole Tomcat log, from first startup until the end of my tests (only 60k
