[Building Sakai] Profile2 1.5 org.apache.wicket.WicketRuntimeException in 2.9

[David Wafula]

We are using Mysql  5.5.It apparently never populated the fields. Running
those sql update stms fixed it.


On Fri, Nov 30, 2012 at 3:50 PM, David Horwitz <david.horwitz at uct.ac.za>wrote:

>  In Mysql that would set the default but not populate existing fields you
> would need:
>
> update PROFILE_PREFERENCES_T set USE_GRAVATAR = false where USE_GRAVATAR
> is null;
>
> D
>
> On 11/30/2012 03:48 PM, Sam Ottenhoff wrote:
>
> What database are you using?
>
>  Didn't this line from MySQL set the defaults correctly?
>
>  alter table PROFILE_PREFERENCES_T add USE_GRAVATAR bit not null DEFAULT
> false;
>
>
>
> On Fri, Nov 30, 2012 at 8:27 AM, David Wafula <davidwaf at gmail.com> wrote:
>
>> Turns out column USE_GRAVATAR  in   PROFILE_PREFERENCES_T  had NULL
>> entries after conversion, hence the error.
>>
>>
>> On Fri, Nov 30, 2012 at 3:18 PM, David Wafula <davidwaf at gmail.com> wrote:
>>
>>> Hi,
>>>
>>> So i upgraded a 2.8 instance to 2.9 (Really i just upgraded a 2.8 DB to 2.9..then did a fresh 2.9 install over it). I am getting the following in Profile2 (1.5.0), would appreciate where to look. But, another clean install of 2.9 of same code doesnt throw this error, it runs fine.
>>>
>>> org.sakaiproject.portal.api.PortalHandlerException: org.apache.wicket.WicketRuntimeException: Can't instantiate page using constructor public org.sakaiproject.profile2.tool.Dispatcher()
>>>     at org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal.java:881)
>>> caused by: org.apache.wicket.WicketRuntimeException: Can't instantiate page using constructor public org.sakaiproject.profile2.tool.Dispatcher()
>>>     at org.apache.wicket.session.DefaultPageFactory.newPage(DefaultPageFactory.java:97)
>>> caused by: java.lang.reflect.InvocationTargetException
>>>     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
>>> caused by: org.springframework.orm.hibernate3.HibernateSystemException: Null value was assigned to a property of primitive type setter of org.sakaiproject.profile2.model.ProfilePreferences.useGravatar; nested exception is org.hibernate.PropertyAccessException: Null value was assigned to a property of primitive type setter of org.sakaiproject.profile2.model.ProfilePreferences.useGravatar
>>>     at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
>>> caused by: org.hibernate.PropertyAccessException: Null value was assigned to a property of primitive type setter of org.sakaiproject.profile2.model.ProfilePreferences.useGravatar
>>>     at org.hibernate.tuple.entity.AbstractEntityTuplizer.setPropertyValues(AbstractEntityTuplizer.java:329)
>>> caused by: java.lang.IllegalArgumentException
>>>     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>>>     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>>>     at java.lang.reflect.Method.invoke(Method.java:601)
>>>     at org.hibernate.property.BasicPropertyAccessor$BasicSetter.set(BasicPropertyAccessor.java:42)
>>>     at org.hibernate.tuple.entity.AbstractEntityTuplizer.setPropertyValues(AbstractEntityTuplizer.java:329)
>>>     at org.hibernate.tuple.entity.PojoEntityTuplizer.setPropertyValues(PojoEntityTuplizer.java:232)
>>>     at org.hibernate.persister.entity.AbstractEntityPersister.setPropertyValues(AbstractEntityPersister.java:3557)
>>>     at org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:133)
>>>     at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:854)
>>>     at org.hibernate.loader.Loader.doQuery(Loader.java:729)
>>>     at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
>>>     at org.hibernate.loader.Loader.doList(Loader.java:2217)
>>>     at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2108)
>>>     at org.hibernate.loader.Loader.list(Loader.java:2103)
>>>     at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
>>>     at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:340)
>>>     at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
>>>     at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1122)
>>>     at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
>>>     at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
>>>     at org.sakaiproject.profile2.dao.impl.ProfileDaoImpl$25.doInHibernate(ProfileDaoImpl.java:738)
>>>     at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
>>>     at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339)
>>>     at org.sakaiproject.profile2.dao.impl.ProfileDaoImpl.getPreferencesRecordForUser(ProfileDaoImpl.java:742)
>>>
>>>
>>>  --
>>> David Wafula
>>>
>>
>>
>>
>>   --
>> David Wafula
>>
>> _______________________________________________
>> sakai-dev mailing list
>> sakai-dev at collab.sakaiproject.org
>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>
>> TO UNSUBSCRIBE: send email to
>> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
>> "unsubscribe"
>>
>
>
>
> _______________________________________________
> sakai-dev mailing listsakai-dev at collab.sakaiproject.orghttp://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
>
>
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>



-- 
David Wafula
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20121130/5026e968/attachment.html