[SOGo] bug in nightly build?

[Patrick Westenberg]

Hi everyone,

I installed the nighty build 2.2.17a.20150524-1 on a new installed 
jessie vm using nginx but with my postgres database which I used with 
the 2.2.17a version on my wheezy server.


During login (which succeeds) this error occurs:

May 24 10:21:04 sogod [19434]: [ERROR] <0x0x7fda07995360[SQLSource]> 
could not run SQL 'SELECT * FROM sogo_auth WHERE ( = '') AND ((c_uid = 
'm...@example.com') OR (mail = 'm...@example.com'))': 
 NAME:PostgreSQL72FatalError 
REASON:fatal pgsql error 
(channel=<0x0x7fda07bc7850[PostgreSQL72Channel]: 
connection=<0x0x7fda0795e2c0[PGConnection]: 
connection=0x0x7fda0783a4b0>>): ERROR:  syntax error at or near "="

LINE 1: SELECT * FROM sogo_auth WHERE ( = '') AND ((c_uid = 'mail@..



Opening the calender (succeeds) or saving a new appointment (fails) 
produces this error:


May 24 10:21:51 sogod [19434]: [ERROR] <0x0x7fda07bc2f40[GCSFolder]> 
-[GCSFolder fetchFields:fetchSpecification:ignoreDeleted:]: cannot 
execute quick-fetch 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 sogocacertse00140f56399_quick a, sogocacertse00140f56399 b WHERE 
((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 
1432504799)) AND ((c_enddate IS NULL) OR (c_enddate >= 143190)) AND 
(c_iscycle = 0)) AND a.c_name = b.c_name AND (c_deleted != 1 OR 
c_deleted IS NULL)':  
NAME:PostgreSQL72FatalError REASON:fatal pgsql error 
(channel=<0x0x7fda07f46490[PostgreSQL72Channel]: 
connection=<0x0x7fda07f46b60[PGConnection]: 
connection=0x0x7fda07e4a9f0>>): ERROR:  column a.c_description does not 
exist

LINE 1: ..._priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_descri...

Is there a database upgrade neccessary even the version number is the same?

Regards
Patrick
--
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] No calendar and adressbook after sql-update-3.0.0-to-combined.sh

[Patrick Westenberg]

Hi everyone,

after executing sql-update-3.0.0-to-combined.sh my calendar and
adressbooks are gone.

Mar 12 13:41:41 sogod [279]: <0x0x55a7d821d890[GCSFolderManager]>
ERROR(-[GCSFolderManager folderForRecord:]): missing folder location in
record: {"c_acl_location" = ""; "c_folder_id" = 9; "c_folder_type"
= Appointment; "c_location" = ""; "c_path" =
"/Users/m...@example.com/Calendar/personal"; "c_quick_location" =
""; }

Is this a bug in the script?

Regards
Patrick
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] No calendar and adressbook after sql-update-3.0.0-to-combined.sh

[Patrick Westenberg]

What changes?

The script added these URLs

OCSStoreURL
OCSAclURL
OCSCacheFolderURL

Changing the database layout has no documentation ..

Regards
Patrick



Christian Mack (christian.m...@uni-konstanz.de) schrieb:
> Am 12.03.2018 um 13:47 schrieb Patrick Westenberg (p...@wk-serv.de):
>> Hi everyone,
>>
>> after executing sql-update-3.0.0-to-combined.sh my calendar and
>> adressbooks are gone.
>>
>> Mar 12 13:41:41 sogod [279]: <0x0x55a7d821d890[GCSFolderManager]>
>> ERROR(-[GCSFolderManager folderForRecord:]): missing folder location in
>> record: {"c_acl_location" = ""; "c_folder_id" = 9; "c_folder_type"
>> = Appointment; "c_location" = ""; "c_path" =
>> "/Users/m...@example.com/Calendar/personal"; "c_quick_location" =
>> ""; }
>>
>> Is this a bug in the script?
>>
> 
> Did you adjust your sogo.conf for 9 tables layout?
> 
> 
> Kind regards,
> Christian Mack
> 

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] No calendar and adressbook after sql-update-3.0.0-to-combined.sh

[Patrick Westenberg]

It was my fault.
I forgot to stop memcached during update.


Regards
Patrick
-- 
users@sogo.nu
https://inverse.ca/sogo/lists