[Building Sakai] Sakai 2.8.0 Messages

[David Horwitz]

Hi Cillie,

It suggests that there are 2 entries for that users private forum in the 
site.

First you need to find the Area:

select * from MFR_AREA_T where 
context_id='f86ba208-547c-40f5-8081-b9bc085d0034' and name='Private 
Messages';

(substitute your site id). Then do:

select * from MFR_PRIVATE_FORUM_T where owner='dhorwitz' and 
surrogateKey = 1;

(substituting the internal user id of your user and the id you found in 1)

That should give you a result of 2. You will need to delete 1 of these - 
this might require you to delete some references in other tables too...

D

On 05/17/2012 04:18 PM, Ciellie wrote:
> Hallo
>
> I just want to know what the query is that's causing an error like this. It's
> happening only with one lecturer in a particular site. Can I fix this within the
> db or do we need to create a new site for this lecturer ?
>
> Thanx for the help
> Ciellie
>
>
> org.sakaiproject.portal.api.PortalHandlerException:
> org.sakaiproject.tool.api.ToolException: query did not return a unique
> result: 2
>      at org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(
> SkinnableCharonPortal.java:862)
> caused by: org.sakaiproject.tool.api.ToolException: query did not return a
> unique result: 2
>      at org.sakaiproject.portal.charon.SkinnableCharonPortal.
>
>
> forwardTool(SkinnableCharonPortal.java:1429)
> caused by: org.apache.jasper.JasperException: query did not
> return a unique result: 2
>      at org.apache.jasper.servlet.JspServletWrapper.service(JspS
> ervletWrapper.java:389)
> caused by: org.springframework.dao.IncorrectResultSizeD
> ataAccessException: query did not return a unique result: 2
>      at org.springframework.orm.hibernate3.SessionFactoryUtils.
> convertHibernateAccessException(SessionFactoryUtils.java:666)
>      at org.springframework.orm.hibernate3.HibernateAccessor.
> convertHibernateAccessException(HibernateAccessor.java:412)
>      at org.springframework.orm.hibernate3.HibernateTemplate.
> doExecute(HibernateTemplate.java:424)
>      at org.springframework.orm.hibernate3.HibernateTemplate.
> execute(HibernateTemplate.java:339)
>      at org.sakaiproject.component.app.messageforums.Message
> ForumsForumManagerImpl.getPrivateForumByOwnerArea(
> MessageForumsForumManagerImpl.java:571)
>
> _______________________________________________
> 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"
>