Relationship Graph

View IssueDependency GraphShow Summary
Relationship Graph
related to related to child of child of duplicate of duplicate of

View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0004544SOGoBackend Address Bookpublic2018-09-14 13:162018-09-14 17:30
Reporterfsoyer Assigned Tofrancis  
PriorityhighSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
Platform[Server] LinuxOSRHEL/CentOSOS Version7
Summary0004544: enable to create new contacts list after upgrading from 3.2.10 to 4.0.2
Description

Hi,
Sogo 3.2.10 just upgraded to 4.0.2, script /usr/share/doc/sogo-4.*/sql-update-3.2.10_to_4.0.0-mysql.sh correctly applied without error, sogo and memcached restarted.
When creating a list in the GUI, there are no errors but the list isn't created.
Putting Mysql on debug mode show this :
INSERT INTO sogo_quick_contact (c_name, c_cn, c_component, c_folder_id) VALUES ('10AD-5B9BB200-1-17C54B00.vcf', 'Liste perso', 'vlist');
ERROR: Column count doesn't match value count at row 1

so : yes, 4 columns for only 3 values. Where can I search for solved this ?
Thanks

Steps To Reproduce

Create a mailing list from existing contacts

TagsNo tags attached.

Relationships

Relationship GraphDependency Graph
duplicate of 0004542 resolvedfrancis Unable to Log In After Upgrade 

Activities

fsoyer

fsoyer

2018-09-14 13:30

reporter   ~0013029

Sorry : this append for all. I had not created a simple contact before trying a list, but it is not created either.
Mysql debug :

2018-09-14 15:26:40.907 sogod[4268] <MySQL4Channel[0x0x55fd2d295ce0] connection=0x0x55fd2e611eb8> SQL: BEGIN;
2018-09-14 15:26:40.908 sogod[4268] <MySQL4Channel[0x0x55fd2d295ce0] connection=0x0x55fd2e611eb8> query has no results.
2018-09-14 15:26:40.908 sogod[4268] <MySQL4Channel[0x0x55fd2d6627c0] connection=0x0x55fd2d59e968> SQL: BEGIN;
2018-09-14 15:26:40.908 sogod[4268] <MySQL4Channel[0x0x55fd2d6627c0] connection=0x0x55fd2d59e968> query has no results.
Sep 14 15:26:40 sogod [4268]: [ERROR] <0x0x55fd2d5baf00[GCSFolder]> -[GCSFolder _generateInsertStatementForRow:adaptor:tableName:]: no type found for column name c_folder_id
2018-09-14 15:26:40.909 sogod[4268] <MySQL4Channel[0x0x55fd2d295ce0] connection=0x0x55fd2e611eb8> SQL: INSERT INTO sogo_quick_contact (c_folder_id, c_cn, c_component, c_screenname, c_sn, c_name, c_hascertificate, c_categories, c_ou, c_o, c_mail, c_givenName) VALUES (, 'machin', 'vcard', '', '', '10AD-5B9BB700-F-17C54B00.vcf', 0, null, '', '', 'machin@truc.com', 'machin');
2018-09-14 15:26:40.909 sogod[4268] <MySQL4Channel[0x0x55fd2d295ce0] connection=0x0x55fd2e611eb8> ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' 'machin', 'vcard', '', '', '10AD-5B9BB700-F-17C54B00.vcf', 0, null, '', '', 'ma' at line 1
2018-09-14 15:26:40.909 sogod[4268] <MySQL4Channel[0x0x55fd2d6627c0] connection=0x0x55fd2d59e968> SQL: ROLLBACK;

Is the database completly desynchronized with sogo 4 ??...
francis

francis

2018-09-14 17:30

administrator   ~0013033

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

Issue History

Date Modified Username Field Change
2018-09-14 13:16 fsoyer New Issue
2018-09-14 13:30 francis Relationship added duplicate of 0004542
2018-09-14 13:30 fsoyer Note Added: 0013029
2018-09-14 17:30 francis Note Added: 0013033
2018-09-14 17:30 francis Status new => resolved
2018-09-14 17:30 francis Resolution open => fixed
2018-09-14 17:30 francis Assigned To => francis