[Building Sakai] Samigo deleted tests aren't deleted in Gradebook (in 2.5.3)

[Daniel Merino]

Hi, Karen.

I have tried this SQL and it seems to work fine.

update GB_GRADABLE_OBJECT_T
set removed = 1
where external_app_name = 'Exámenes'
and external_id in (select id from SAM_PUBLISHEDASSESSMENT_T where status=2)

All unpublished or deleted tests in Samigo seem to have their status set 
to 2 in SAM_PUBLISHEDASSESSMENT_T so I think that this SQL should fix 
our problem.

Please, if you have any dissapointment to this SQL, just tell me.

Thanks and best regards.

Karen Tsao escribió:
> Hi Daniel,
>
> Please try following query:
>
> update gb_gradable_object_t set removed = 1 where external_app_name = 
> 'Tests & Quizzes' and external_id in (:published_assessment_id_1, 
> :published_assessment_id_2, ...)
>
> As I am not an expert in Gradebook, please test the query in your QA 
> instance first. And let me know if this doesn't work for you.
>
> Thanks,
> Karen
>
> On Wed, Mar 31, 2010 at 10:20 AM, Karen Tsao <ktsao at stanford.edu 
> <mailto:ktsao at stanford.edu>> wrote:
>
>     Hi Daniel,
>
>     This is fixed in http://jira.sakaiproject.org/browse/SAK-12907.
>     Please patch the fix and see if your issue can be solved.
>
>     Thanks,
>     Karen
>
>
>     On Wed, Mar 31, 2010 at 4:08 AM, Daniel Merino
>     <daniel.merino at unavarra.es <mailto:daniel.merino at unavarra.es>> wrote:
>
>         Hi everybody.
>
>         We have a fresh & clean 2.5.3 Sakai where we are having the
>         next issue:
>
>         -We create a Samigo test with grading available in Gradebook
>         and publish it.
>         -The test is showed in Gradebook as usual.
>         -We delete from Samigo the published test, and even the test
>         itself. But
>         that test can still be viewed in Gradebook. Even worse, an
>         attempt to
>         re-publish in Samigo the same test gives us an error because there
>         exists already in Gradebook a test with that name.
>
>         I have tested this in a 2.5.x qa server
>         (http://qa5-us.sakaiproject.org/portal) and it seems that this
>         problem
>         is solved there. But I'm not able to find the issue in
>         Samigo's JIRA
>         neither in Gradebook's JIRA.
>
>         Please, could somebody guide me to the patch which solves this
>         problem?
>         Thanks in advance.
>         --
>         Daniel Merino Echeverría
>         daniel.merino at unavarra.es <mailto:daniel.merino at unavarra.es>
>         Gestor de teleformación - Centro Superior de Innovación Educativa.
>         Tfno: 948-168489 - Universidad Pública de Navarra.
>         --
>         Lo consiguió porque no sabía que era imposible.
>
>         _______________________________________________
>         sakai-dev mailing list
>         sakai-dev at collab.sakaiproject.org
>         <mailto: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
>         <mailto:sakai-dev-unsubscribe at collab.sakaiproject.org> with a
>         subject of "unsubscribe"
>
>
>

-- 
Daniel Merino Echeverría
daniel.merino at unavarra.es
Gestor de teleformación - Centro Superior de Innovación Educativa.
Tfno: 948-168489 - Universidad Pública de Navarra.
--
La esclavitud no se abolió, se cambió a 8 horas diarias.