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

[nA ni sivAm]

Sorry about that..... I guess even reply all doesn't include the list!! had to manually include... gotta remember that!!

anyways....
will try connecting via thunderbird or so and see if it helps...

The same inbox when shared works fine with other accounts...

Jan was pointing out that the imap index could be corrupt as well!!

I assume (keeping both possibilities in mind) it can be resolved by either deleting all user specific data from horde database (or) rebuiling cyrus.index etc if that is corrupt.

wrt deleting all user specific data from database, can we use the shell script by Jacques (not the PHP one!!) shown in http://wiki.horde.org/DatabaseCleanup

I am kinda nervous!!!

On 14/11/2011, at 6:44 PM, francis picabia wrote:

> Hi,
> 
> You should reply to the list as well.  It first sounded like a problem
> we've seen here before, but now it sounds worse.  I suggest attempting
> to connect to the mailbox with a regular IMAP client like Thunderbird
> and see what happens.  If there is still a problem, then the issue
> isn't with IMP but with the IMAP server or the particular mailbox
> within the IMAP server.
> 
> When the IMP problem shows, the mailbox is fine in other clients, but
> the message list won't appear in IMP for certain users.  It has
> nothing to do with quota, and
> it can impact only certain users, seemingly randomly.  I suspect there
> are certain email headers for some messages which trigger this problem
> as using the same IMP for years it only started to appear early this year.
> 
> Cheers
> 
> On Sun, Nov 13, 2011 at 2:49 AM, nA ni sivAm <getnani at gmail.com> wrote:
>> Thanks Francis...
>> 
>> I tried it, but it didn't work though.... :'(
>> 
>> The exact problem is that only one of the users have this issue. all the other 90+ users are fine!!!
>> 
>> Incidentally on that particular day when this problem started for this user, the mysql server stopped due to lack of space on the volume!!
>> I am not sure if that had anything to do with this issue. I am also not sure how/ why just that user just got affected.
>> 
>> FYI - That particular user is using well below his quota of mails.
>> 
>> Also, just to point out, the mail/ inbox icon on the sidebar doesn't show the total/unread mails - just for this user/account!!
>> 
>> Is there anyway I can delete all the user related data for this user wrt horde/imp and start fresh for this userid?
>> 
>> PS: I am actually planning for a total server upgrade which will happen by feb-mar 2012, hopefully!!
>> 
>> Thanks for helping me out, nAni.
>> 
>> 
>> On 13/11/2011, at 8:10 AM, francis picabia wrote:
>> 
>>> 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)
>>> --
>>> IMP mailing list
>>> Frequently Asked Questions: http://horde.org/faq/
>>> To unsubscribe, mail: imp-unsubscribe at lists.horde.org
>> 
>>