SOGo | BTS

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0004544SOGoBackend Address Bookpublic2018-09-14 09:162018-09-14 13:30
Reporterfsoyer 
Assigned Tofrancis 
PriorityhighSeveritymajorReproducibilityalways
StatusresolvedResolutionfixed 
Platform[Server] LinuxOSRHEL/CentOSOS Version7
Product Version 
Target VersionFixed in Version 
Summary0004544: enable to create new contacts list after upgrading from 3.2.10 to 4.0.2
DescriptionHi,
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 ReproduceCreate a mailing list from existing contacts
TagsNo tags attached.
Attached Files

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

-  Notes
(0013029)
fsoyer (reporter)
2018-09-14 09:30

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 ??...
User avatar (0013033)
francis (administrator)
2018-09-14 13:30

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

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


Copyright © 2000 - 2018 MantisBT Team
Powered by Mantis Bugtracker