is pilerexport compatiable with manticore RT?

[lhy-sky]

Hi:
I am using piler 1.4.4 with manticore RT. it works great. today I want to use "pilerexport" to dump some mails like this:
"pilerexport -r me@example.com" but nothing happens. I try to figure out the parameters like:
"pilerexport -i note1,piler1,tag1 -r me@example.com" but still got nothing.
however "pilerexport -A" works so there is something wrong but I don't know what.
I don't know if I can use pilerexport with manticore RT. do I need to reindex to old traditional way?
I download piler 1.4.7 and check pilerexport.c. it is almost the same as 1.4.4.
thanks a lot for help.

[jsuto]

Hello, what emails do you want to export? What's the search criteria?

[lhy-sky]

Hi:
fortunately after upgrade my production machine, I still have an old piler 1.3.11 machine and a testing new 1.4.4 machine(both pilerexport are working). so I can compare what happen to my production machine.

after some strace and compare, I understand when the production machine upgrade from 1.3.11 to 1.4.4, the sql structure is broken.

although there are many db-upgrade*.sql in the source util directory, there is at least one thing missing. the "v_messages" view is different between 1.3.11 and 1.4.4.

I assume I only need to run "db-upgrade.sql" when I upgrade from 1.3.11 to 1.4.4. but that is not enough. the "v_messages" at 1.4.4 add a column "metadata.attachments AS attachments".

pilerexport works fine after I recreate the "v_messages" view. is there any other thing I should fix after upgrade from 1.3.11 to 1.4.4?