[imp] IMP shows mailbox as empty when sorted by date is required

[francis picabia]

On Sat, Nov 12, 2011 at 3:38 AM, nA ni sivAm <getnani at gmail.com> wrote:
>
> Hi Jean....
>
> I guess I am facing similar issue....
>
> I am not too sure what records I should delete with respect to deleting a
> user's pref in sql database...
> could you please let me know the sql script you used to get that done?
>
> nAni.
>
>
> Jean-Yves Avenard-2 wrote:
>>
>> Hello
>>
>> I have a horde installation which has been working fine for several years.
>>
>> I have one user with over 14,000 emails in his mailbox.
>>
>>>From time to time, its inbox will show no messages "There are no
>> messages in this mailbox." but will still report how many newor unread
>>  messages in this folder.
>>
>> I usually sort this issue by deleting the user preferences in the SQL
>> database.
>>
>> However, today I've been able to always reproduce that issue.
>>
>> By default, IMP will sort messages by message ID and it will be able
>> to display all the messages.
>>
>> However, if the sort order is changed in any ways, IMP will report
>> "There are no messages in this mailbox." and you can not change the
>> sorting options anymore and the inbox folder will stay forever empty.
>>
>> Changing the sorting order in the Options menus have no effect whatsoever.
>>
>> I have allocated 128MB to PHP in php.ini.
>>
>> I can not see any error messages in any logs.
>>
>> Any ideas what I could have been missing or what could be done to fix
>> this issue?
>>
>> Thank you
>> Jean-Yves
>> --
>> IMP mailing list - Join the hunt: http://horde.org/bounties/#imp
>> Frequently Asked Questions: http://horde.org/faq/
>> To unsubscribe, mail: imp-unsubscribe at lists.horde.org
>>

This is a known bug with IMP prior to version 5. It relates to a
library they use to implement IMAP outside of the IMP project.  In
version 5 IMP it is rewritten to not depend on the outside library.

Here is a workaround solution which worked for us with older IMP
version installed:

User must login using dynamic mode.  Click on the column title (I
think it shows #) to cause the inbox to sort by the message number
(starts at 1).  This is roughly the same as by date.  Logout and login
again with traditional view.  Now all messages should show up, but
user should not attempt to re-sort by anything unless the user wants
to clean out their mailbox first.

A better solution is to plan for IMP 5 upgrade, or provide an
alternate solution like roundcube until you are ready to upgrade to
IMP 5 (e.g. basic Roundcube install and configure is very quick)