[Building Sakai] Announcements owner

[Maurer, Christopher Wayne]

You'll probably have to get in the xml field and change data as well.

Chris

On Aug 25, 2010, at 4:55 AM, Yzelle, Sonette wrote:

This message (and attachments) is subject to restrictions and a disclaimer. Please refer to http://www.unisa.ac.za/disclaimer for full details.
________________________________

Morning,

Can someone please help.
We are using Sakai 2.6.2 and Oracle db.
We have a problem where a user who added an announcement (table: announcement_message , column: owner) does not exist on our Ad Directory provider anymore.  Now when someone tries to open the announcements for that site the announcements tool gives an error, AD Directory gives a nullpointer exception.  I have tried to update the owner column to a valid user but announcements are still picking up the incorrect user_id.
Can someone please advise with the following:
*         how I can fix the userid in the announcements?
*         Where is announcements getting the old user_id?
*         Where is the announcement begin and end date stored?
*         Is there any other tables that announcements use beside the announcement_channel and announcement_message tables?

We are going to change our provider to not return a null when the user does not exist but for now I need a urgent fix so that the lecturers can add announcements.

SOnette

Sonette Yzelle
Analyst Developer
ICT
UNISA
South Africa
email: syzelle at unisa.ac.za<mailto:syzelle at unisa.ac.za>

_______________________________________________
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"

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20100825/ddb1f942/attachment.html