Pak ud
kopier properties og mysql connector
start
Problem - > https://issues.liferay.com/browse/LPS-60081
11:29:46,223 INFO [localhost-startStop-1][AutoDeployDir:138] Auto deploy scanner started for /opt/liferay-portal-7.0-ce-a2/deploy 11:29:47,826 INFO [elasticsearch[Orbit][clusterService#updateTask][T#1]][metadata:452] [Orbit] [10204] creating index, cause [api], templates [], shards [1]/[0], mappings [LiferayDocumentType, KeywordQueryDocumentType, SpellCheckDocumentType] 11:29:48,297 ERROR [localhost-startStop-1][PortalInstances:373] com.liferay.portal.kernel.exception.SystemException: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT roleId FROM Users_Roles WHERE companyId = ? AND userId = ?]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'companyId' in 'where clause' com.liferay.portal.kernel.exception.SystemException: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT roleId FROM Users_Roles WHERE companyId = ? AND userId = ?]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'companyId' in 'where clause' at com.liferay.portal.service.persistence.impl.TableMapperImpl.getPrimaryKeys(TableMapperImpl.java:479) at com.liferay.portal.service.persistence.impl.TableMapperImpl.getLeftPrimaryKeys(TableMapperImpl.java:303) at com.liferay.portal.service.persistence.impl.ReverseTableMapper.getRightPrimaryKeys(ReverseTableMapper.java:107) at com.liferay.portal.service.persistence.impl.UserPersistenceImpl.setRoles(UserPersistenceImpl.java:8990) at com.liferay.portal.service.impl.RoleLocalServiceImpl.setUserRoles(RoleLocalServiceImpl.java:1321) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:153) at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:93) at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:55) at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:127) at com.liferay.portal.spring.aop.RetryAdvice.invoke(RetryAdvice.java:46) at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:127) at com.liferay.portal.service.ServiceContextAdvice.invoke(ServiceContextAdvice.java:38) at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:127) at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56) at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBean