Forums

Home » Liferay Social Office

Combination View Flat View Tree View
Threads [ Previous | Next ]
Putchhat Srun
No social activity displayed
November 22, 2013 2:48 AM
Answer

Putchhat Srun

Rank: New Member

Posts: 6

Join Date: September 2, 2013

Recent Posts

Hello,

In the first environment, I installed the bundle liferay-portal-tomcat-6.1.1-ce-ga2-20120731132656558.zip and then I installed social office package 15190404_25011213_25012280.lpkg. Everything works fine. I can see social activities and also can configure which activities I want to see. In this Environement, we are using Postgres.

In another environment, Liferay 6.1.1 (same bundle) has already been installed and customized with specific portlets, hooks and themes. The DBMS is MySQL. I then installed the same social office package 15190404_25011213_25012280.lpkg. I created a group 'Club Photo' with Social Office and then created a blog entry and a forum thread for that group. Here are the issues :
- I can't see any social activities.
- When I try to configure social activities for one group that I created with Social Office, the setting pages is not complete :
-> only checkboxes are displayed for Blog Entry, MB Message and WikiPage but the detail fields is not displayed for any application.
-> Moreover, there is no save button.
- In the database (MySQL), the table socialactivitysetting is empty. I tried to fill it for my group and then created a blog entry and a forum thread but cannot still see any social activity. FYI, here are the queries :
 1-- Activer les activités sur les blogs, messages et wiki pour le groupe Guest et le groupe Club Photo
 2insert into socialactivitysetting (activitysettingid, groupId, companyid, classnameid, activitytype, name, value)
 3values (1, 10226, 10202, 10054, 0, 'enabled', 'true');
 4insert into socialactivitysetting (activitysettingid, groupId, companyid, classnameid, activitytype, name, value)
 5values (2, 10226, 10202, 10081, 0, 'enabled', 'true');
 6insert into socialactivitysetting (activitysettingid, groupId, companyid, classnameid, activitytype, name, value)
 7values (3, 10226, 10202, 10114, 0, 'enabled', 'true');
 8
 9insert into socialactivitysetting (activitysettingid, groupId, companyid, classnameid, activitytype, name, value)
10values (4, 152871, 10202, 10054, 0, 'enabled', 'true');
11insert into socialactivitysetting (activitysettingid, groupId, companyid, classnameid, activitytype, name, value)
12values (5, 152871, 10202, 10081, 0, 'enabled', 'true');
13insert into socialactivitysetting (activitysettingid, groupId, companyid, classnameid, activitytype, name, value)
14values (6, 152871, 10202, 10114, 0, 'enabled', 'true');
15insert into socialactivitysetting (activitysettingid, groupId, companyid, classnameid, activitytype, name, value)
16values (7, 152871, 10202, 10081, 10001, 'contribution', '{"enabled":true,"limitValue":0,"ownerType":3,"value":0,"limitEnabled":true,"limitPeriod":1}');
17insert into socialactivitysetting (activitysettingid, groupId, companyid, classnameid, activitytype, name, value)
18values (8, 152871, 10202, 10081, 10001, 'popularity', '{"enabled":true,"limitValue":0,"ownerType":2,"value":0,"limitEnabled":true,"limitPeriod":1}');
19insert into socialactivitysetting (activitysettingid, groupId, companyid, classnameid, activitytype, name, value)
20values (9, 152871, 10202, 10081, 2, 'participation', '{"enabled":true,"limitValue":0,"ownerType":1,"value":0,"limitEnabled":true,"limitPeriod":1}');
21insert into socialactivitysetting (activitysettingid, groupId, companyid, classnameid, activitytype, name, value)
22values (10, 152871, 10202, 10081, 10003, 'contribution', '{"enabled":false,"limitValue":0,"ownerType":3,"value":0,"limitEnabled":true,"limitPeriod":1}');
23insert into socialactivitysetting (activitysettingid, groupId, companyid, classnameid, activitytype, name, value)
24values (11, 152871, 10202, 10081, 10003, 'participation', '{"enabled":false,"limitValue":0,"ownerType":1,"value":0,"limitEnabled":true,"limitPeriod":1}');
25insert into socialactivitysetting (activitysettingid, groupId, companyid, classnameid, activitytype, name, value)
26values (12, 152871, 10202, 10081, 10003, 'popularity', '{"enabled":false,"limitValue":0,"ownerType":2,"value":0,"limitEnabled":true,"limitPeriod":1}');
27insert into socialactivitysetting (activitysettingid, groupId, companyid, classnameid, activitytype, name, value)


The problem may appear at the creation of the blog entry because the folowing stackTrace appears and no social activity is inserted in socialactivity table.

 1Hibernate: select resourcepe0_.resourcePermissionId as resource1_47_, resourcepe0_.companyId as companyId47_, resourcepe0_.name as name47_, resourcepe0_.scope as scope47_, resourcepe0_.primKey as primKey47_, resourcepe0_.roleId as roleId47_, resourcepe0_.ownerId as ownerId47_, resourcepe0_.actionIds as actionIds47_ from ResourcePermission resourcepe0_ where ((resourcepe0_.companyId=? ))AND((resourcepe0_.name=? ))AND((resourcepe0_.scope=? ))AND((resourcepe0_.primKey=? ))AND(((resourcepe0_.roleId=? )))
 2Hibernate: select COUNT(*) as col_0_0_ from MBMessage mbmessagei0_ where (mbmessagei0_.threadId=? )AND(mbmessagei0_.status=? )
 310:37:06,588 ERROR [ajp-apr-9109-exec-7][IncludeTag:253] Current URL /web/club-theatre/blogs?p_p_id=33&p_p_lifecycle=0&p_p_state=normal&p_p_mode=view&p_p_col_id=column-1&p_p_col_count=1 generates exception: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: java.lang.NullPointerException
 410:37:06,590 ERROR [ajp-apr-9109-exec-7][IncludeTag:154] com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: java.lang.NullPointerException
 5[color=#ff0000]        at com.liferay.portlet.asset.service.persistence.AssetCategoryFinderImpl.findByC_C(AssetCategoryFinderImpl.java:350)
 6        at com.liferay.portlet.asset.service.impl.AssetCategoryLocalServiceImpl.getCategories(AssetCategoryLocalServiceImpl.java:236)[/color]
 7        at com.liferay.portlet.asset.service.impl.AssetCategoryLocalServiceImpl.getCategories(AssetCategoryLocalServiceImpl.java:244)
 8        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:122)
 9        at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:71)
10        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
11        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:57)
12        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
13        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:57)
14        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
15        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:57)
16        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
17        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:57)
18        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
19        at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:211)
20        at com.liferay.portlet.asset.service.impl.AssetCategoryServiceImpl.getCategories(AssetCategoryServiceImpl.java:101)
21        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:122)
22        at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:71)
23        at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:118)
24        at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:57)
25[color=#ff0000]Caused by: com.liferay.portal.kernel.dao.orm.ORMException: java.lang.NullPointerException
26        at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:30)[/color]
27        at com.liferay.portal.dao.orm.hibernate.SessionImpl.createSQLQuery(SessionImpl.java:95)
28        at com.liferay.portal.dao.orm.hibernate.SessionImpl.createSQLQuery(SessionImpl.java:82)
29        at com.liferay.portal.kernel.dao.orm.ClassLoaderSession.createSQLQuery(ClassLoaderSession.java:140)
30        at com.liferay.portlet.asset.service.persistence.AssetCategoryFinderImpl.findByC_C(AssetCategoryFinderImpl.java:338)
31        at com.liferay.portlet.asset.service.impl.AssetCategoryLocalServiceImpl.getCategories(AssetCategoryLocalServiceImpl.java:236)
32        at com.liferay.portlet.asset.service.impl.AssetCategoryLocalServiceImpl.getCategories(AssetCategoryLocalServiceImpl.java:244)
33        at sun.reflect.GeneratedMethodAccessor702.invoke(Unknown Source)
34        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)


1     Why  assetCategoryFinder is null in the following code snipet ?
2
3    @ThreadLocalCachable
4    public List<AssetCategory> getCategories(long classNameId, long classPK)
5        throws SystemException {
6
7        [color=#ff0000]return assetCategoryFinder.findByC_C(classNameId, classPK); ---------> AssetCategoryLocalServiceImpl.java:236 NullPointerException[/color]
8    }


The version of MySQL is 5.5.31. The initial version of the MySQL jdbc connector included in the bundle is 5.0.7. I replaced it by the 5.1.27 version in liferay-portal-6.1.1-ce-ga2/tomcat-7.0.27/lib/ext but always have the same error.

Did I miss anything to enable social activities ?
Thank you for your help.

Best regards