From field missing in search results after import

[Former user]

I'm testing the import function using readpst and pilerimport.

I've run readpst -b -M -o /tmp/output pstfile.pst then pilerimport -d /tmp/output

The total number of processed items is consistent with the contents of the output directory. However, when searching for the message in the web ui, the "from" field is empty.

I've noticed that the from email address in the eml message file has escaped quotes in it, ie.

From: \"John Doe\ [e-mail] [e-mail]

[Andrew Borer]

Correction, from line of raw EML file created by readpst are:

From: "\"John Doe\" [e-mail]" [e-mail]

[Janos SUTO]

Please run pilertest against this message, and check the from line. Also check the metadata table's from column if it contains some address.

[Andrew Borer]

The from address running pilertest returns

from: * ()*

I'm working on checking the table, but I would assume it would contain nothing as well

[Andrew Borer]

from field in metadata table is empty for the messages in question

[Janos SUTO]

If there's some insensitive such email, can you send me that in a zip file to my address? (see piler -V). Btw. I replaced the From line what you typed here, and got the following:

from: *john doe [e-mail] jdoe mydomain com [e-mail]  (mydomain.com)*

[Andrew Borer]

I rebuilt my test server from scratch using ubuntu 14.04. The issue with the from field not parsing seems to have been resolved, ( i was using the OVA originally)

I did however run in to the issue here https://bitbucket.org/jsuto/piler/issue/463

Changing all instances of

$query = $this->sphx->query("SELECT id,

to

$query = $this->sphx->query("SELECT id,sent

resolved the issue where search results are blank.

I will continue to test the import process.

Thanks

[Janos SUTO]

I have a hard time to figure out why after changing something requires you to fix the sphinx query. Something must be broken, I guess.

[Janos SUTO]

It appears that the debian/ubuntu shipped version of sphinx (2.0.4) is not fully compatible with piler. Please use the latest stable (either deb package or source) from http://sphinxsearch.com/