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

[primaxx]

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:

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.

[bdial]

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

zmprov gmi <accout>

it will return the mailbox id, a number, lets say for example its 187. to find out the mboxgroup just do

expr 187 % 100

this would return '87'. so the database is in mboxgroup87. now do

/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

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

[primaxx]

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:

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!

[primaxx]

Bump...

[primaxx]

Bump again...