View Issue Details

IDProjectCategoryView StatusLast Update
0004544SOGoBackend Address Bookpublic2018-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

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