[Building Sakai] Samigo NPE error

[Kirschner, Beth]

Thanks! That worked.

- Beth

On Oct 25, 2013, at 10:32 AM, Brian Jones <bjones86 at uwo.ca> wrote:

> Here's some SQL to help you out:
> 
> 1) find pools that have null titles (null titles will be pushed to the top
> of the results list):
> SELECT * FROM SAKAIADMIN.SAM_QUESTIONPOOL_T
> ORDER BY TITLE desc;
> 
> 2) determine if question pool has questions attached:
> SELECT * FROM SAKAIADMIN.SAM_QUESTIONPOOLITEM_T
> WHERE questionpoolid LIKE '<questionpoolid>';
> 
> 3) if no questions, delete:
> DELETE FROM SAKAIADMIN.SAM_QUESTIONPOOL_T WHERE QUESTIONPOOLID =
> <questionpoolid>;
> 
> 4) if has questions, give it a title:
> UPDATE SAKAIADMIN.SAM_QUESTIONPOOL_T SET "TITLE" = '<newTitle>' WHERE
> QUESTIONPOOLID = <questionpoolid>;
> 
> Hope this helps :)
> 
> Brian Jones
> Applications Development
> Information Technology Services
> Support Services Building, Room 4326
> Western University
> (519) 661-2111 x86969
> bjones86 at uwo.ca
> 
> 
> -----Original Message-----
> From: sakai-dev-bounces at collab.sakaiproject.org
> [mailto:sakai-dev-bounces at collab.sakaiproject.org] On Behalf Of Kirschner,
> Beth
> Sent: Friday, October 25, 2013 10:22 AM
> To: dev sakai
> Subject: [Building Sakai] Samigo NPE error
> 
> We have a user who's unable to access her Samigo Question Pools, after
> attempting to import an invalid xml file:
> 	https://jira.sakaiproject.org/browse/SAM-2234
> 
> Can anyone suggest some SQL that might 'clean up' the problem as a
> workaround such that she could continue using Test & Quizzes? Right now she
> gets a NPE crash every time she tries to access the Question Pools.
> 
> Thanks,
> - Beth
> 
> _______________________________________________
> 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"
>