View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0005928SOGoBackend Generalpublic2024-02-21 15:182024-04-08 20:01
Reportermurksmax Assigned Tosebastien  
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionno change required 
Product Version5.10.0 
Summary0005928: GCSAdminFolder recordForEntryWithKey - MySQL4Exception: NAME:ExecutionFailed REASON:Unknown column 't1.c_content' in 'field list
Description

Using the web-interface and logging out, there is a ERROR-line in sogo.log for MySQL not finding specified column t1.c_content in db.

Feb 21 15:48:45 sogod [20491]: SOGoUserHomePage user 'max@domain.tld' logged off
Feb 21 15:48:45 sogod [20491]: IP-ADDRESS "GET /SOGo/so/max@domain.tld/logoff HTTP/1.0" 302 0/0 0.024 - - 0 - 13
Feb 21 15:48:45 sogod [20491]: [ERROR] <0x0x56468528a570[GCSAdminFolder]> -[GCSAdminFolder recordForEntryWithKey:]:                             cannot execute fetch: <MySQL4Exception: 0x56468480eef0> NAME:ExecutionFailed REASON:Unknown column 
    't1.c_content'  in 'field list'
Feb 21 15:48:45 sogod [20491]: IP-ADDRESS "GET /SOGo/so/ HTTP/1.0" 200 11853/0 0.042 45008 73% 0 - 12

Afterwards the login-page loads regular.

Steps To Reproduce
  • Call the login page
  • Login as a simple user
  • Logout the user
Additional Information

Version 5.10.0 (@sogo-build.alinto.int 202402210802)
DB: MySQL with schema 5.9.0
Ubuntu 20.04 LTS w. nginx/php7.4

TagsNo tags attached.

Activities

sebastien

sebastien

2024-02-26 08:40

administrator   ~0017596

Hi,

There is a new admin table since SOGo 5.10.
Do you have OCSAdminURL set in your sogo.conf ?
If yes, can you provide the SQL schema of this table ?

Sebastien
murksmax

murksmax

2024-04-08 19:32

reporter   ~0017693

I've set the correct values in sogo.conf, now the message has gone!
Thanks for your help!

Issue History

Date Modified Username Field Change
2024-02-21 15:18 murksmax New Issue
2024-02-26 08:40 sebastien Note Added: 0017596
2024-02-26 08:40 sebastien Assigned To => sebastien
2024-02-26 08:40 sebastien Status new => feedback
2024-04-08 19:32 murksmax Note Added: 0017693
2024-04-08 19:32 murksmax Status feedback => assigned
2024-04-08 20:01 sebastien Status assigned => resolved
2024-04-08 20:01 sebastien Resolution open => no change required