[Bug 257804] New: mail indexing: invalid dates are not caught

[Will Stephenson]

https://bugs.kde.org/show_bug.cgi?id=257804

           Summary: mail indexing: invalid dates are not caught
           Product: Akonadi
           Version: unspecified
          Platform: Unlisted Binaries
        OS/Version: Linux
            Status: NEW
          Severity: normal
          Priority: NOR
         Component: Nepomuk Feeder Agents
        AssignedTo: tokoe at kde.org
        ReportedBy: wstephenson at kde.org
                CC: vkrause at kde.org, kdepim-bugs at kde.org


Created an attachment (id=53699)
 --> (http://bugs.kde.org/attachment.cgi?id=53699)
indexed mail

Version:           unspecified
OS:                Linux

The attached, apparently valid, mail is displayed with an Unknown date.

In addition, the email feeder attempts to index the unknown date value, giving
an error from Virtuoso. .This probably means that the indexer isn't aware the
insert failed, so the indexed data may be incomplete or inconsistent.

Nepomuk/Virtuoso output:
[/usr/bin/nepomukservicestub] "/usr/bin/nepomukservicestub(31493)" Soprano:
"SQLExecDirect failed on query 'sparql insert into graph
<urn:nepomuk:local:ce2333bd-b888-4eb6-ac3a-81377019fa16> { <akonadi:?item=1143>
<http://www.semanticdesktop.org/ontologies/2007/03/22/nmo#sentDate>
"-4713-01-01TZ"^^<http://www.w3.org/2001/XMLSchema#dateTime> . }' (iODBC Error:
[OpenLink][Virtuoso iODBC Driver][Virtuoso Server]SQ074: Line 1: DT006: Cannot
convert -4713-01-01TZ to datetime : Incorrect month field length)"


Reproducible: Didn't try

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.