Notice: this is a static mirror for historical purposes.

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
194Source IntegrationGitHubpublic2011-01-31 22:092011-01-31 22:09
Assigned To 
PrioritynormalSeveritycrashReproducibilityhave not tried
Product Version 
Target VersionFixed in Version 
Summary194: Unable to import Github changesets
DescriptionWhen importing changeset script fails with message:


Database query failed. Error received from database was #1292: Incorrect datetime value: '2011-01-18T16:55:27-08:00' for column 'timestamp' at row 1 for the query: INSERT INTO mantis_plugin_Source_changeset_table ( repo_id, revision, parent, branch, user_id,
timestamp, author, message, info, ported, author_email, committer, committer_email, committer_id
) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ).

Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.
Additional InformationThe Github json api is returning authored_date in the format 2011-01-18T16:55:27-08:00

It needs to be converted into a format compatible with the MySQL datetime field 2011-01-18 16:55:27 before being inserted into the database.
TagsNo tags attached.
Attached Files

- Relationships

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2011-01-31 22:09 Jonathan New Issue
2011-01-31 22:09 Jonathan File Added: date_format.patch

Copyright © 2000 - 2012 MantisBT Group
Time: 0.1269 seconds.
memory usage: 8,319 KB
Powered by Mantis Bugtracker

hosted with