Issue with adding (event) with Attendees!

[szafar]

Hi Team,

I have deployed TINE20 on APACHE/Window Server 2003. Proper SSL certificate is also deployed there as well. Calendar/Contact and Mail solution. I have HMAILServer as mail solution on backend. Everything , and every device(IPHONE, IPAD, Android Device) is working fine. Contact, and Mails are working perfectly all right and SYNC across all devices. there is one issue coming up with Calendar EVENTS.

There is one strange issue coming up when i tired to add a Event (calendar event with attende) via IPOHONE, Andriod its added to TINE20, and everytime i SYNC my andrioid, and Iphone account (refresh, and resync mobile account), its add a duplicate entry into TINE20. Thunderbird with Lightning is not duplicating the entry as only one entry added to tine20 but throwing this error when i submit the event.

screen shot of THUNDERBIRD is attached with the POST.

I am facing this issue only when any attende selected, if there is no attendee there is no issue, no error/warning.

this is the exact message i am getting on THUNDERBIRDS (lightning)

"An error occurred when writing to the calendar Sajad Zafar!

Error code: MODIFICATION_FAILED
Status Code: 412, Precondition failed.

<?xml version="1.0" encoding="utf-8"?>
<d:error xmlns:d="DAV:" xmlns:s="http://sabredav.org/ns">
<s:exception>Sabre_DAV_Exception_PreconditionFailed</s:exception>
<s:message>An If-None-Match header was specified, but the ETag matched (or * was specified).</s:message>
<s:sabredav-version>1.5.4</s:sabredav-version>
<s:header>If-None-Match</s:header>
</d:error>"

[szafar]

i got it working now, but still there is one issue with Delete. its not throwing any error, or warning.


on delete, any client not deleting the event on server. its still there.

[ph_il]

could you please add a bugreport for this?

edit: please attach a logfile of the delete request.

[szafar]

Thanks for the response Philipp.

i got it working. Issue was with table 'message's body column. data was increasing in length on submission. i change it to 'TEXT', and its working as beauty for me.

[ph_il]

could you please show us the alter table statement which you used to fix this?

[szafar]

Hi Philipp,

issue was with the size of 'body' column. it was varchar [8192], and look like while sync data was exceeded. event was added, but exception was there trough by system. it was causing issue like IPHONE keep adding same event on every refresh. Thunderbird Lightning behaving differently, through an error i posted, but event add. this small thing fix the issue.

Table Structure of MESSAGE TABLE after alteration:

CREATE TABLE `message` (
`message_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`queue_id` int(10) unsigned NOT NULL,
`handle` char(32) DEFAULT NULL,
`body` text,
`md5` char(32) DEFAULT NULL,
`timeout` decimal(14,4) unsigned DEFAULT NULL,
`created` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`message_id`),
UNIQUE KEY `message_handle` (`handle`),
KEY `message_queueid` (`queue_id`),
CONSTRAINT `message_ibfk_1` FOREIGN KEY (`queue_id`) REFERENCES `queue` (`queue_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1925 DEFAULT CHARSET=utf8;