View Issue Details

IDProjectCategoryView StatusLast Update
0005760SOGoBackend Generalpublic2023-05-04 09:37
Reporterperkinma Assigned Tosebastien  
Status resolvedResolutionno change required 
PlatformRocky LinuxOS Version8.7 
Product Version5.8.2 
Summary0005760: sogo_sessions_folder in DB not updating resulting in sessions expiring rapidly

SQL error on insert into sogo_sessions_folder results in session table not populating and sessions expiring on next cron run.

SQL: INSERT INTO sogo_sessions_folder (c_lastseen, c_creationdate, c_value, c_id) VALUES (1682747516, 1682747516, 'aV+4......
ti4=', 'CNzDzQQEOOqw4iSp');
ERROR: Data too long for column 'c_value' at row 1

Resolved for me by:
ALTER TABLE sogo_sessions_folder MODIFY COLUMN c_value varchar(16383);

It looks like this might have been occuring for others as well for a while:

Does there need to be a small tweak to the schema?

Steps To Reproduce

1) Turn on database debugging
2) Log into SOGo
3) insert into session table fails.

TagsNo tags attached.




2023-04-29 15:34

administrator   ~0016917

If you update, did read 5.6.0 ?




2023-05-04 06:47

reporter   ~0016943

Thanks Sebastien you are correct I missed that. My apologies that is most likely the issue thank you for the pointer!



2023-05-04 09:37

administrator   ~0016945

No problem ;)


Issue History

Date Modified Username Field Change
2023-04-29 06:44 perkinma New Issue
2023-04-29 15:34 sebastien Note Added: 0016917
2023-04-29 20:02 sebastien Assigned To => sebastien
2023-04-29 20:02 sebastien Status new => feedback
2023-05-04 06:47 perkinma Note Added: 0016943
2023-05-04 06:47 perkinma Status feedback => assigned
2023-05-04 09:37 sebastien Note Added: 0016945
2023-05-04 09:37 sebastien Status assigned => resolved
2023-05-04 09:37 sebastien Resolution open => no change required