SOGo | BTS

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0004543SOGoBackend Calendarpublic2018-09-14 06:002018-09-14 13:33
Reporterjisse44 
Assigned Tofrancis 
PrioritynormalSeveritymajorReproducibilityalways
StatusresolvedResolutionfixed 
PlatformLinuxOSDebianOS Version9
Product Version4.0.2 
Target VersionFixed in Version 
Summary0004543: Cannot create event with Mysql backend
DescriptionI have nightly version 4.0.2.20180914-1

When I want to create an event, nothing happens.

The logs show an Error:

Sep 14 11:29:57 sogod [29785]: [ERROR] <0x0x55ef6925b010[GCSFolder]> -[GCSFolder _generateInsertStatementForRow:adaptor:tableName:]: no type found for column name c_folder_id
Sep 14 11:29:57 sogod [29785]: <0x0x55ef6925b010[GCSFolder]> ERROR(-[GCSFolder writeContent:fromComponent:container:toName:baseVersion:]): cannot insert content : <MySQL4Exception: 0x55ef69545770> NAME:ExecutionFailed REASON:Column count doesn't match value count at row 1
Sep 14 11:29:57 sogod [29785]: [ERROR] <0x55ef69291d80[SOGoAppointmentObject]:7459-5B9B7F80-1-1F1B07A0.ics> write failed: <MySQL4Exception: 0x55ef69545770> NAME:ExecutionFailed REASON:Column count doesn't match value count at row 1

When I set 'MySQL4DebugEnabled = YES;', logs are:

INSERT INTO sogo_quick_appointment (c_iscycle, c_orgmail, c_uid, c_nextalarm, c_name, c_priority, c_category, c_sequence, c_folder_id, c_isallday, c_title, c_description, c_status, c_classification, c_startdate, c_component, c_partstates, c_location, c_isopaque, c_enddate) VALUES (0, '', '58e7a57c-85a1-4c4d-b4d1-9bbc151ba526', 1536847800, '58e7a57c-85a1-4c4d-b4d1-9bbc151ba526.ics', 0, null, 0, 0, 'Test2', '', 1, 0, 1536848100, 'vevent', '', '', 1, 1536849900);


It seems that 'c_folder_id' is missing.


when I restored an older version of Sogo libs (/usr/lib/sogo/) it worked again
Steps To ReproduceEvery time with MySQL backend (via Web interface, Thunderbird or DavDroid)
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
duplicate of 0004542resolvedfrancis Unable to Log In After Upgrade 

-  Notes
User avatar (0013035)
francis (administrator)
2018-09-14 13:33

https://github.com/inverse-inc/sogo/commit/d05e1fed5de900640a7383f269c9d29e87b3b278 [^]

- Issue History
Date Modified Username Field Change
2018-09-14 06:00 jisse44 New Issue
2018-09-14 13:33 francis Relationship added duplicate of 0004542
2018-09-14 13:33 francis Note Added: 0013035
2018-09-14 13:33 francis Status new => resolved
2018-09-14 13:33 francis Resolution open => fixed
2018-09-14 13:33 francis Assigned To => francis


Copyright © 2000 - 2018 MantisBT Team
Powered by Mantis Bugtracker