Zimbra Calendar Corruption?

[MoreDakka]

So I've got a new server with Zimbra installed (v6.x) There is one user that if he has an appointment on any day for even 15 minutes it shows him as booked for the entire day.

Is there an option to do that or is it calendar corruption? Is there a way to fix it if it's corrupted?

Thanks.

[MoreDakka]

Actually I found he has three appointments not showing on his calendar but are showing under schedule while creating an appointment:

Jan 11 12am -> Jan 12 12am
Jan 12 7am -> Jan 14 8pm
Jan 25 8am -> Jan 26 6pm

I'm not sure if he added then removed them or what. Is there a way to remove appointments that are "Unknown" (When you mouse over the appointment in the schedule it will show the appointment title, these are showing as Unknown)

[MoreDakka]

Anyone have an idea on this one?

[uxbod]

su - zimbra
mysql
use zimbra
select id from mailbox where comment = 'user@domain';
use <id from the select>;
select * from appointment;

you should see lots of appointments; whittle down the correct date range and using the item_it you can do

su - zimbra
zmmailbox -z -m user@domain deleteitem <id from the sql>

to remove the bogus entries.

[MoreDakka]

Originally Posted by uxbod

su - zimbra
mysql
use zimbra
select id from mailbox where comment = 'user@domain';
use <id from the select>;
select * from appointment;

you should see lots of appointments; whittle down the correct date range and using the item_it you can do

su - zimbra
zmmailbox -z -m user@domain deleteitem <id from the sql>

to remove the bogus entries.

Perfect, so I can remove them that's really all I need. However is there a way to find out why there ended up in here?

(Also, it should be:
use mboxgroup<id from the select>;
)

Thanks.

[uxbod]

Are you using zimbra mobile or Funambol ?

[MoreDakka]

I haven't setup or used either. That Funambol looks pretty cool though.