[Tickets #11100] No Messages error caused by empty direction in sortpref

[bugs at horde.org]

BITTE NICHT AUF DIESE NACHRICHT ANTWORTEN. NACHRICHTEN AN DIESE  
E-MAIL-ADRESSE WERDEN NICHT GELESEN.

Ticket-URL: http://bugs.horde.org/ticket/11100
------------------------------------------------------------------------------
  Ticket           | 11100
  Erstellt Von     | Juergen.Obermann at hrz.uni-giessen.de
  Zusammenfassung  | No Messages error caused by empty direction in sortpref
  Warteschlange    | IMP
  Version          | 4.3.11
  Typ              | Bug
  Status           | Unconfirmed
  Priorität        | 2. Medium
  Milestone        |
  Patch            |
  Zuständige       |
------------------------------------------------------------------------------


Juergen.Obermann at hrz.uni-giessen.de (2012-03-23 11:21) hat geschrieben:

In the database table horde_prefs appear entries with sorting  
direction set to "" (an empty string), like that:
userxy  imp     sortpref         
a:1:{s:5:"INBOX";a:2:{s:1:"b";s:1:"2";s:1:"d";s:0:"";}}
In this case the user gets the message 'There are no messages in this  
mailbox.' in the inbox screen, even if the inbox contains seen or  
unseen messages. The virtual inbox shows the unseen messages, and  
after reading them they dissapear from the inbox. The user can not set  
the sorting for his inbox to correct this problem himself, because the  
title bar is not shown for an empty folder. Also setting the global  
sorting options does not help as long as the wrong sortpref entry for  
the mailbox exists. This is a serious deadlock situation. Only an  
database administrator can  delete the database entry of correct it by  
setting the value "0" or "1" for the sorting direction e.g.
userxy  imp     sortpref         
a:1:{s:5:"INBOX";a:2:{s:1:"b";s:1:"2";s:1:"d";s:1:"0";}}