View Issue Details

IDProjectCategoryView StatusLast Update
0004543SOGoBackend Calendarpublic2018-09-14 17:33
Reporterjisse44 Assigned Tofrancis  
PrioritynormalSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
PlatformLinuxOSDebianOS Version9
Product Version4.0.2 
Summary0004543: Cannot create event with Mysql backend
Description

I 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 Reproduce

Every time with MySQL backend (via Web interface, Thunderbird or DavDroid)

TagsNo tags attached.

Relationships

duplicate of 0004542 resolvedfrancis Unable to Log In After Upgrade 

Issue History

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