Results 1 to 5 of 5

Thread: mail.NO_SUCH_ITEM (Constant reminder of non-existant calendar-item

Hybrid View

  1. #1
    Join Date
    Mar 2009
    Location
    Oslo, Norway
    Posts
    47
    Rep Power
    6

    Default mail.NO_SUCH_ITEM (Constant reminder of non-existant calendar-item

    An element (An ivitation sent by an external user) in my colleagues Calendar is impossible to delete, due to the fact that it does not exist. (Even though it shows up in his Calendar. -But when we want to view it (or delete it) through the reminder, or click on the calendar-element, we get the following error message:
    Code:
    Element "72053" finnes ikke.
    #(Element "72053" does not exist) 
    method:	GetMsgRequest
    msg:	no such item: 72053
    code:	mail.NO_SUCH_ITEM
    detail:	soap:Sender
    trace:	btpool0-79://mail.server.com/service/soap/GetMsgRequest:1274270660045:2175379101ce4287
    request:	
    
    Body: {
      GetMsgRequest: {
        _jsns: "urn:zimbraMail",
        m: {
          html: 1,
          id: "72053-72052",
          max: 100000
         }
       }
     },
    Header: {
      context: {
        _jsns: "urn:zimbra",
        account: {
          _content: "colleague@company.com",
          by: "name"
         },
        authToken: "(removed)",
        notify: {
          seq: 3
         },
        session: {
          _content: 14203,
          id: 14203
         },
        userAgent: {
          name: "ZimbraWebClient - FF3.0 (Win)",
          version: "6.0.5_GA_2213.UBUNTU8"
         }
       }
     }
    I have tried to run zmprov rim, and I have tried to run repair on the database, with no luck. I have also done a search through his .msg-files, without finding the missing item.

    Since this appointment is set with a reminder, it is extremely annoying for my colleague.

    My question is: How do I delete something that is not there, but still shows up in my colleagues web-client?

    Thanks upfront for any help.
    Last edited by primaxx; 05-19-2010 at 06:23 AM.

  2. #2
    Join Date
    Jul 2007
    Location
    Baltimore
    Posts
    1,649
    Rep Power
    11

    Default

    you might have to remove it from the database. you can see if its in there

    first you have to get the mailbox id of the account

    Code:
    zmprov gmi <accout>
    it will return the mailbox id, a number, lets say for example its 187. to find out the mboxgroup just do

    Code:
    expr 187 % 100
    this would return '87'. so the database is in mboxgroup87. now do

    Code:
    /opt/zimbra/mysql/bin/mysql mboxgroup87
    mysql> select * from mail_item where mailbox_id=187 and id=72053;
    see what that gives you. the 3rd column 'type' will identify the type of item it is, like 5 is message, 6 is a contact, 11 is an appointment i think.

    if this looks like hte offending item, you can do

    Code:
    mysql> delete from mail_item where mailbox_id=187 and id=72053;

  3. #3
    Join Date
    Mar 2009
    Location
    Oslo, Norway
    Posts
    47
    Rep Power
    6

    Default

    Thank you very much Bdial!

    Unfortunately the problem still exists, due to the fact that there is no element in the database with the ID 72053. (I also tried the query without the mailbox_id, but got empty set as a result in both queries.)

    I must admit though, that I took a slightly different approach than what you described. I had to do like this:
    Code:
    mysql
    mysql> use mboxgroup41;
    mysql> select * from mail_item where mailbox_id=41 and id=72053;
    mysql> Empty set (0.15 sec)
    
    
    mysql> select * from mail_item where id=72053;
    mysql> Empty set (0.15 sec)
    -But Zimbra's webUI is obviously getting this information from somewhere. Which other table could it be?
    (I am, by the way, 100 % sure mboxgroup41 is the correct one. I have tried, and found, other elements in that base.)

    Thanks again for any help, I really appretiate it!

  4. #4
    Join Date
    Mar 2009
    Location
    Oslo, Norway
    Posts
    47
    Rep Power
    6

    Default Bump

    Bump...

  5. #5
    Join Date
    Mar 2009
    Location
    Oslo, Norway
    Posts
    47
    Rep Power
    6

    Default

    Bump again...

Similar Threads

  1. Extend reminder times for the Calendar?
    By jreinhart in forum Administrators
    Replies: 1
    Last Post: 10-08-2008, 04:42 PM
  2. how to get calendar item Id?
    By fisch09 in forum Administrators
    Replies: 1
    Last Post: 09-04-2007, 11:45 AM
  3. Calendar Item that is Read Only
    By phingers in forum Developers
    Replies: 6
    Last Post: 02-18-2007, 10:45 PM
  4. Calendar appointment Reminder
    By miguel in forum Users
    Replies: 13
    Last Post: 12-16-2006, 02:52 AM
  5. Share Calendar Menu Item doesn't show up
    By kiwicmc in forum Administrators
    Replies: 3
    Last Post: 04-17-2006, 07:15 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •