Comment 1 for bug 1387081
Revision history for this message
| Holger Schletz (holger-schletz) wrote | #1 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
1b1ed1a
(Get the code!)
The date reported by the agent is generally unreliable. It can have various formats like Y/m/d or m/d/Y (on the same system) or contain garbage like "0000//0/0/00". The server passes this value directly to MySQL which silently accepts any invalid date input and turns it into... a different kind of garbage (0000-00-00).
The agent should try to validate the value and either convert it to a unified format (preferrably ISO8601) or discard unparseable input so that the XML file is consistent.