Unexpected exception 26 when I set a series with a date prior to today

[comunelevico]

Hi,

I have a problem when I set a series with a date prior to today.

When i select "Save" get the following error message:

------------------------------------------------------------------------------------------------
1. 09/11/2011 06:49 GMT
Errore: Unexpected exception 26! (APP-0007, 366751917-2583)

Date: Wed Nov 09 2011 07:51:56 GMT+0100 (CET)
Host: http://srvopenexchange.dominio.locale/ox6/ox.html
Version: 6.20.0 Rev30 (UI), 6.20.0-Rev30 (Server)
Browser: Mozilla/5.0 (X11; Linux i686) AppleWebKit/534.30 (KHTML, like Gecko) Ubuntu/10.04 Chromium/12.0.742.112 Chrome/12.0.742.112 Safari/534.30

Module: calendar, View: calendar/calendar/workweek, Folder: 37, Default folders: infostore=40tasks=39contacts=38calendar=37, Landing page: portal, Tree: New, Expert: No, Language: it_IT

Loaded modules: calendar, com.openexchange.extras, com.openexchange.group, com.openexchange.mail.filter, com.openexchange.publish, com.openexchange.resource, com.openexchange.secret.recovery, com.openexchange.subscribe, com.openexchange.user.passwordchange, com.openexchange.user.personaldata, com.openexchange.wizard, comune.levico.sms, contacts, folder, infostore, interfaces, mail, mailaccount, messaging, olox20, portal, tasks, themes, uwaWidgets
------------------------------------------------------------------------------------------------

To reproduce the anomaly:
- today I create an appointment (date of creation today)
- tomorrow I set a series (for example every day)
- when I select save I get the error

So instead of all works:
- today I create an appointmente whit date yesterday
- today I set a series (for example every day)
- when I select save all works correctly

I can not tell if the problem is due to the exact date of creation.

In addition I can say:
- Yesterday I made the appointment that is giving me problems
- Yesterday I postponed several times by appointment (the first time of 4 hours and the second time in 6 hours)


Thanks and goog work ;-)

[Martin Heiland]

Hi,

i was able to create an appointment series starting tomorrow or yesterday. Can you please post the exception from the server log file and describe in detail what you're doing?

Thanks

[comunelevico]

Hi,
i was able to create an appointment series starting tomorrow or yesterday.
Thanks

Yes, me too.

I have these problem only with a specific appointment ! (if you want I can post the record present on mysql):
- yesterday I made an appointment
- yesterday I postponed several times by appointment (the first time of 4 hours and the second time in 6 hours)
- today, if I set a series (for example every day) for that specific appointment i get the error

These is the content of my /var/log/open-xchange/open-xchange.log.0

9-nov-2011 9.29.50 com.openexchange.log.internal.LoggerTask call
GRAVE: Logged at: com.openexchange.ajax.Appointment.doPut(Appointmen t.java:174)
APP-0007 Category=7 Message=Unexpected exception 26! exceptionID=366751917-2737
com.openexchange.ajp13.remoteAddress=127.0.0.1
com.openexchange.session.contextId=1
com.openexchange.session.userId=5
APP-0007 Category=7 Message=Unexpected exception 26! exceptionID=366751917-2737
at com.openexchange.calendar.CalendarSql.updateAppoin tmentObject(CalendarSql.java:653)
at com.openexchange.calendar.CalendarSql.updateAppoin tmentObject(CalendarSql.java:107)
at com.openexchange.ajax.request.AppointmentRequest.a ctionUpdate(AppointmentRequest.java:293)
at com.openexchange.ajax.request.AppointmentRequest.a ction(AppointmentRequest.java:189)
at com.openexchange.ajax.Appointment.doPut(Appointmen t.java:150)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:730)
at com.openexchange.ajax.AJAXServlet.service(AJAXServ let.java:417)
at com.openexchange.ajax.SessionServlet.service(Sessi onServlet.java:247)
at com.openexchange.ajax.PermissionServlet.service(Pe rmissionServlet.java:82)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:820)
at com.openexchange.ajp13.coyote.AjpProcessor.process (AjpProcessor.java:805)
at com.openexchange.ajp13.coyote.sockethandler.Coyote Task.call(CoyoteTask.java:184)
at java.util.concurrent.FutureTask$Sync.innerRun(Futu reTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.jav a:138)
at com.openexchange.threadpool.internal.CustomThreadP oolExecutor$Worker.runTask(CustomThreadPoolExecuto r.java:750)
at com.openexchange.threadpool.internal.CustomThreadP oolExecutor$Worker.run(CustomThreadPoolExecutor.ja va:776)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.NullPointerException
at com.openexchange.calendar.CalendarMySQL.updatePart icipants(CalendarMySQL.java:3246)
at com.openexchange.calendar.CalendarMySQL.updateAppo intment(CalendarMySQL.java:2518)
at com.openexchange.calendar.CalendarMySQL.updateAppo intment(CalendarMySQL.java:2207)
at com.openexchange.calendar.CalendarSql.updateAppoin tmentObject(CalendarSql.java:586)
... 16 more

[comunelevico]

These is the content of mysql:

INSERT INTO `prg_dates` (`creating_date`, `created_from`, `changing_date`, `changed_from`, `fid`, `pflag`, `cid`, `timestampfield01`, `timestampfield02`, `timezone`, `intfield01`, `intfield02`, `intfield03`, `intfield04`, `intfield05`, `intfield06`, `intfield07`, `intfield08`, `field01`, `field02`, `field04`, `field06`, `field07`, `field08`, `field09`, `uid`, `organizer`, `sequence`) VALUES
('2011-11-07 08:05:37', 5, 1320827286306, 5, 0, 0, 1, '2011-11-08 09:00:00', '2011-11-08 10:00:00', 'Europe/Rome', 18, 18, 0, NULL, 0, 1, 0, 0, 'liberare spazio disco bagheera', NULL, NULL, NULL, NULL, NULL, NULL, '41610a46-0634-4a05-a87c-80558f76ada6', NULL, 13);