On 11-03-11 2:58 PM, Allen Chen wrote:
Yes, I run sql-update-1.3.3_to_1.3.4-mysql.sh, and this script just
add c_categories to _quick tables.
I have 10 SOGo calendar users, and only one user has this problem
after upgraded. This user uses web GUI and BB to sync calendar.
On web GUI (SOGo 1.3.5a), when click 'calendar', you get nothing; but
on Thunderbird 2, some events show up and some are missing.
sogo.log(when access from web):
2011-03-10 11:49:11.075 sogod[4481] NGCalendarDateRange.m:37
Assertion failed in NGCalendarDateRange(instance), method
initWithStartDate:endDate:. *startDate MUST NOT be nil!*
EXCEPTION: <NSException: 0x90d09c8>
NAME:NSInternalInconsistencyException REASON:NGCalendarDateRange.m:37
Assertion failed in NGCalendarDateRange(instance), method
initWithStartDate:endDate:. *startDate MUST NOT be nil! INFO:(nil) *
Mar 10 11:49:11 sogod [4343]: <0x0x8d40e30[WOWatchDogChild]> child
4481 exited
so, the log says: "*startDate MUST NOT be nil!*", this should be
related to some events not formatted correctly, which were entered
from SOGo 1.3.3 web GUI or Blackberry(not from Thunderbird).
Is there a way to find these mal-formated events in the database?
You can likely find the culprit user from the logs (ie., the incoming
request - you might also want to set SOGoDebugRequests to YES).
Once the user is found, identify its calendar table{s} from
sogo_folder_info (where c_path2 == username) and then look at the quick
table, c_startdate. A little bit of SQL kungfu won't hurt anyone.
Regards,
--
Ludovic Marcotte
[email protected] :: +1.514.755.3630 :: www.inverse.ca
Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence
(www.packetfence.org)
--
[email protected]
https://inverse.ca/sogo/lists
