Re: [SOGo] Unknown column 'c_hascertificate' in 'field list'

[Michael Doerner | Technologywise]

Thanks a lot for your help with this. It is now fixed although I am
still a little surprised to find this being added without announcement
(?) or I am searching for documentation in the wrong areas.

Thanks again.

On 09/01/18 00:40, "MicTieMix" (mictie...@gmail.com) wrote:
> Had the same issue a couple of days ago...
>
> It seems that a new column 'c_hascertificate' was added to the 
> SoGo-mysql-database around Dec 25th.
>
> I was able to resolve this issue by manually adding a column 
> 'c_hascertificate' (as INT) to the relevant database.
>
> Hope it helps!
>
>
> -Original Message-
> From: users-requ...@sogo.nu [mailto:users-requ...@sogo.nu] On Behalf Of 
> Michael Doerner | Technologywise
> Sent: Monday, 8 January 2018 04:56
> To: users@sogo.nu
> Subject: [SOGo] Unknown column 'c_hascertificate' in 'field list'
>
> Hi all
>
> I have just updated our SOGo to the very latest SOGo nightly build (for 
> CentOS6), 3.2.10.20180107, hoping to fix a problem that must have started 
> recently but I am unsure when exactly.
>
> When trying to look at the address book in the SOGo web interface (tested 
> with various users), the screen will show you the total amount of contacts 
> but underneath, where the list of contacts should be seen, it looks like it 
> is trying to refresh but not been able to show any entry.
>
> The SOGo log shows the following:
>
> Jan 08 09:47:03 sogod [3637]: [ERROR] <0x0x7fa98f65f468[GCSFolder]> 
> -[GCSFolder fetchFields:fetchSpecification:ignoreDeleted:]: cannot execute 
> quick-fetch SQL 'SELECT c_name, c_cn, c_givenname, c_sn, c_screenname, c_o, 
> c_mail, c_telephonenumber, c_categories, c_component, c_hascertificate FROM 
> . (cut)...
> ExecutionFailed REASON:Unknown column 'c_hascertificate' in 'field list'
>
> We have not in any way tried to do something manually with the MySQL database 
> so I wonder what might be the reason for this?
>
> Any idea or help?
>
> Thanks, Michael
> --
> users@sogo.nu
> https://inverse.ca/sogo/lists
>

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

[SOGo] Unknown column 'c_hascertificate' in 'field list'

[Michael Doerner | Technologywise]

Hi all

I have just updated our SOGo to the very latest SOGo nightly build (for
CentOS6), 3.2.10.20180107, hoping to fix a problem that must have
started recently but I am unsure when exactly.

When trying to look at the address book in the SOGo web interface
(tested with various users), the screen will show you the total amount
of contacts but underneath, where the list of contacts should be seen,
it looks like it is trying to refresh but not been able to show any entry.

The SOGo log shows the following:

Jan 08 09:47:03 sogod [3637]: [ERROR] <0x0x7fa98f65f468[GCSFolder]>
-[GCSFolder fetchFields:fetchSpecification:ignoreDeleted:]: cannot
execute quick-fetch SQL 'SELECT c_name, c_cn, c_givenname, c_sn,
c_screenname, c_o, c_mail, c_telephonenumber, c_categories, c_component,
c_hascertificate FROM
. (cut)...
ExecutionFailed REASON:Unknown column 'c_hascertificate' in 'field list'

We have not in any way tried to do something manually with the MySQL
database so I wonder what might be the reason for this?

Any idea or help?

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

[SOGo] Trying to remove a task's Start (From) or Due date

[Michael Doerner - Technologywise]

Hi all

using SOGo 3.2.9 (201705140155). When trying to remove either a due date
for a task or its start date through the web gui, the field is removed
but the "save" button stays light grey hence I cannot save the change.

I can achieve however the result that I need (to remove a date) with a
little trick: First I make a change to the date (i.e.e change it one
hour or one day), that will activate the "change" button. Rather making
that change, I then can remove the date and the change button will stay
active and then I can click the change button and SOGo accepts that
change (remove of date).

Am I doing something wrong?

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