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