[Building Sakai] Samigo randomDrawDate parse error

[David Horwitz]

Hi Omar,

Your right that that date format did change from

Wed Sep 14 11:40:53 CDT 2011 (output of Date.toString())

to

2012-08-23T10:59:34.180-0500 (ISO8601 format)

As the former failed in certain timezones (South Africa for one)

see https://jira.sakaiproject.org/browse/SAM-1550

The conversion on mysql would look something like:

update SAM_SECTIONMETADATA_T set entry = date_format(str_to_date(entry, 
'%a %b %d %T SAST %Y'),'%Y-%m-%dT%H:%i:%S.000+02:00') where 
label='QUESTIONS_RANDOM_DRAW_DATE';
update SAM_PUBLISHEDSECTIONMETADATA_T set entry = 
date_format(str_to_date(entry, '%a %b %d %T SAST 
%Y'),'%Y-%m-%dT%H:%i:%S.000+02:00') where 
label='QUESTIONS_RANDOM_DRAW_DATE';



The input format here would be for the SA one. But I think might work by 
changing the SAST string to CDT in your case ...

D

On 09/11/2012 10:58 PM, Karen Tsao wrote:
> David from UCT is the one provide the patch, let me cc him here.
>
> Hi David,
>
> Could you please take a look? Thanks.
>
> Karen
>
> On Tue, Sep 11, 2012 at 12:48 PM, Omer A Piperdi <omer at rice.edu 
> <mailto:omer at rice.edu>> wrote:
>
>     We have different date formats in sam_sectionmetadata_t for label
>     QUESTIONS_RANDOM_DRAW_DATE..
>
>     2012-08-23T10:59:34.180-0500 and Wed Sep 14 11:40:53 CDT 2011
>
>     That might be causing it.. I wonder if this should be a part of db
>     conversion in 2.9 upgrade.
>
>     Thanks
>     Omer
>     On 9/11/2012 1:41 PM, Omer A Piperdi wrote:
>     > We are getting lots of stack trace like below.. and I have
>     checked our
>     > 2.9.x version, which already has
>     > https://jira.sakaiproject.org/browse/SAM-1550
>     >
>     > Any idea or suggestion? We are on Oracle.
>     >
>     > Thanks
>     > Omer
>     >
>     >
>     > 2012-09-06 00:07:07,211 ERROR http-bio-8443-exec-115
>     >
>     org.sakaiproject.tool.assessment.ui.bean.delivery.SectionContentsBean
>     -
>     > Unable to parse date text: Tue Jul 31 15:37:15 CDT 2012
>     > java.lang.IllegalArgumentException: Invalid format: "Tue Jul 31
>     15:37:15
>     > CDT 2012"
>     >           at
>     >
>     org.joda.time.format.DateTimeFormatter.parseDateTime(DateTimeFormatter.java:866)
>     >           at
>     >
>     org.sakaiproject.tool.assessment.ui.bean.delivery.SectionContentsBean.setMetaData(SectionContentsBean.java:436)
>     >           at
>     >
>     org.sakaiproject.tool.assessment.ui.bean.delivery.SectionContentsBean.<init>(SectionContentsBean.java:384)
>     >           at
>     >
>     org.sakaiproject.tool.assessment.ui.listener.delivery.DeliveryActionListener.getPartBean(DeliveryActionListener.java:861)
>     >           at
>     >
>     org.sakaiproject.tool.assessment.ui.listener.delivery.DeliveryActionListener.getContents(DeliveryActionListener.java:542)
>     >           at
>     >
>     org.sakaiproject.tool.assessment.ui.listener.delivery.DeliveryActionListener.processAction(DeliveryActionListener.java:424)
>     >           at
>     >
>     org.sakaiproject.tool.assessment.ui.bean.delivery.DeliveryBean.next_page(DeliveryBean.java:1704)
>     >
>     > _______________________________________________
>     > 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"
>     >
>     > !DSPAM:2294,504f8735128427691497720!
>     >
>     >
>
>     _______________________________________________
>     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/20120912/3ef595a5/attachment.html