On attempting to import a document from Alfresco, import fails and the following error occurs:

Incorrect datetime value: '2009-01-26T17:42:56.080Z' for column 'cm_created' at row 1 query: INSERT INTO alfresco_node (vid, nid, reference, timestamp, cm_name, cm_title, cm_description, cm_author, cm_created, cm_creator, cm_modified, cm_modifier) VALUES (6, 6, 'workspace://SpacesStore/12a37928-2803-42b6-ad1b-00eacd48b66d', 1232992887, 'TestDoc', '', '', '', '2009-01-26T17:42:56.080Z', 'admin', '2009-01-26T17:44:27.502Z', 'admin') in C:\Inetpub\wwwroot\drupal\drupal-6.9\includes\common.inc on line 3425.

Caused by a non-US (UK) timezone/locale, perhaps?

CommentFileSizeAuthor
#3 alfresco-HEAD.datetime-parser.patch3.21 KBsmartinm

Comments

smartinm’s picture

smartinm commented

Hi Colin, thanks for bug report.

It seems to be a datetime parsing bug. I'll look into fixing this. What version of mysql server are you using?

colinah’s picture

colinah commented

MySQL is version 5.0.41 Community.
We've come across this issue with Alfresco elsewhere - they seem to like time strings with a 'Z' on the end.

smartinm’s picture

smartinm commented
Title: Error importing Alfresco item » Datetime parsing bug importing Alfresco item
Version: 6.x-1.0-beta1 » 6.x-1.x-dev
Assigned: Unassigned » smartinm
Status: Active » Needs review
StatusFileSize
new alfresco-HEAD.datetime-parser.patch3.21 KB

Attached patch should fix this issue.

smartinm’s picture

smartinm commented
Status: Needs review » Fixed

Committed.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.