Hi list
I upgraded my sogo from 2.1.1 to the latest git build. it first didn't
work as expected, so I tried to rum mysql update scripts. that didn't
work either. so I dumped the DB and recreated it, created my user, and
did a sogo-tool restore. now the contacts and events are there and seem
to be ok, even thunderbird works ok, but I cannot get the calendar "tab"
to load in the browser. mail/address book/settings/contacts all work,
but when I switch to calendar, it starts these never ending queries in
mysql:
2015-11-21 11:43:01.398 sogod[400] <MySQL4Channel[0x0xb7524e20]
connection=0x0xb7534fc0> SQL: SELECT
b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_description,a.c_uid,a.c_startdate,a.c_enddate
FROM sogohugo0010a880c16_quick a, sogohugo0010a880c16 b WHERE
((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <=
1448233199)) AND ((c_cycleenddate IS NULL) OR (c_cycleenddate >=
1447628400)) AND (c_iscycle = 1)) AND a.c_name = b.c_name AND (c_deleted
!= 1 OR c_deleted IS NULL);
2015-11-21 11:43:01.398 sogod[400] <MySQL4Channel[0x0xb7524e20]
connection=0x0xb7534fc0> query has results, entering fetch-mode.
Nov 21 11:43:01 sogod [4712]: |SOGo| starting method 'GET' on uri
'/SOGo/so/hugo/Calendar/UIxCalMainFrame'
2015-11-21 11:43:01.404 sogod[4712] <MySQL4Channel[0x0xb74c1e70]
connection=0x0xb74ce7d0> SQL: SELECT c_path4 FROM sogo_folder_info WHERE
c_path2 = 'hugo' AND c_folder_type = 'Appointment';
2015-11-21 11:43:01.405 sogod[4712] <MySQL4Channel[0x0xb74c1e70]
connection=0x0xb74ce7d0> query has results, entering fetch-mode.
Nov 21 11:43:01 sogod [4712]: |SOGo| request took 0.006723 seconds to
execute
Nov 21 11:43:01 sogod [4712]: 79.197.74.192 "GET
/SOGo/so/hugo/Calendar/UIxCalMainFrame HTTP/1.1" 404 208/0 0.009 - - 0
Nov 21 11:43:01 sogod [400]: |SOGo| request took 0.030983 seconds to execute
Nov 21 11:43:01 sogod [400]: 79.197.74.192 "GET
/SOGo/so/hugo/Calendar/eventsblocks?ed=20151122&sd=20151116&view=weekview HTTP/1.1"
200 448/0 0.035 - - 0
Nov 21 11:43:01 sogod [400]: |SOGo| starting method 'GET' on uri
'/SOGo/so/hugo/Calendar/UIxCalMainFrame'
2015-11-21 11:43:01.427 sogod[400] <MySQL4Channel[0x0xb74df968]
connection=0x0xb722be48> SQL: SELECT c_path4 FROM sogo_folder_info WHERE
c_path2 = 'hugo' AND c_folder_type = 'Appointment';
2015-11-21 11:43:01.428 sogod[400] <MySQL4Channel[0x0xb74df968]
connection=0x0xb722be48> query has results, entering fetch-mode.
Nov 21 11:43:01 sogod [400]: |SOGo| request took 0.006718 seconds to execute
Nov 21 11:43:01 sogod [400]: 79.197.74.192 "GET
/SOGo/so/hugo/Calendar/UIxCalMainFrame HTTP/1.1" 404 208/0 0.009 - - 0
Nov 21 11:43:01 sogod [400]: |SOGo| starting method 'GET' on uri
'/SOGo/so/hugo/Calendar/UIxCalMainFrame'
2015-11-21 11:43:01.450 sogod[400] <MySQL4Channel[0x0xb7524e20]
connection=0x0xb7534fc0> SQL: SELECT c_path4 FROM sogo_folder_info WHERE
c_path2 = 'hugo' AND c_folder_type = 'Appointment';
2015-11-21 11:43:01.450 sogod[400] <MySQL4Channel[0x0xb7524e20]
connection=0x0xb7534fc0> query has results, entering fetch-mode.
Nov 21 11:43:01 sogod [400]: |SOGo| request took 0.006516 seconds to execute
Nov 21 11:43:01 sogod [400]: 79.197.74.192 "GET
/SOGo/so/hugo/Calendar/UIxCalMainFrame HTTP/1.1" 404 208/0 0.009 - - 0
Nov 21 11:43:01 sogod [400]: |SOGo| starting method 'GET' on uri
'/SOGo/so/hugo/Calendar/UIxCalMainFrame'
I tried the query on the DB and it returns this:
mysql> SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'hugo' AND
c_folder_type = 'Appointment';
+-------------------------+
| c_path4 |
+-------------------------+
| F88-51B47200-1-2DFCE500 |
| personal |
+-------------------------+
2 rows in set (0.00 sec)
what should I try next?
thanks,
hugo.-
--
[email protected]
https://inverse.ca/sogo/lists
