Pages

Wednesday 15 August 2012

Horde is not showing inbox messages!!!

Following steps will solve the issue:


1) Take the backup of horde database (/hordebackup.sql).
mysqldump -uadmin -p'cat /etc/psa/.psa.shadow' horde > horde_backup.sql



2) Run the below mysql queries for horde database.
mysql> select * from horde_prefs where pref_uid='abc@xyz.com' and pref_name='sortpref';
mysql> delete from horde_prefs where pref_uid='abc@xyz.com' and pref_name='sortpref';




Issue fixed :)

5 comments:

  1. Nice fix, but do you also know how to reproduce this error?

    ReplyDelete
    Replies
    1. Some time due to some database inconsistencies in horde db, users are not able to view the inbox contents. This may occurs due to some upgrade failure. In this case this fix will work.

      Delete
  2. Replies
    1. Hey Miguel, It feels nice to know that the post helped you. :)

      Delete
  3. Cool post Jyoti bhaiya, I got this link today in search of a fix. Didn't fix my issue though

    ReplyDelete