[Building Sakai] Samigo NPE error

[Brian Jones]

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"