sph_index table not populated after imap import

[Cristiano Manzoni]

Hi Janos,
we've a strange situation here, after import all user's email via imap, the
sph_index table is not populated and so the search doesn't show results.
I've to stop cron jobs and manually rerun a reindex -a to see results of
search.
After the reindex command I can see results for a search but all the email
with attachments don't show attach in the preview, btw if I download the
eml the attachments are there.

1.2.0-master build 919
Sphinx 2.2.10

thanks,
Cristiano

Re: sph_index table not populated after imap import

[Janos SUTO]

Hello Cristiano,

On 2015-09-21 10:00, Cristiano Manzoni wrote:

we've a strange situation here, after import all user's email via
imap, the sph_index table is not populated and so the search doesn't
show results.


is there any error message on stdout or in mail log?


I've to stop cron jobs and manually rerun a reindex -a to see results
of search.
After the reindex command I can see results for a search but all the
email with attachments don't show attach in the preview, btw if I
download the eml the attachments are there.


check if the matching entry in the metadata table has attachment > 0


1.2.0-master build 919
Sphinx 2.2.10


was it an upgrade? If so have you run the database schema upgrade 
script?


Janos